MySQL can't connect :S

[Razor Star]

Hey,
I'm starting my own ot with tut:

 How to setup a SQL server (TFS version) - OpenTibia Fans[/url]
I entered all things but I get this error when I try to start my server. :S
Screenshot:
[IMG]http://i33.tinypic.com/2vcgl04.jpg[/IMG]

How can I solve this ?

 

[Razor Star]

you could try replace the file with this errmsg.sys, However your SQL-install is somehow fucked up, i suggest you reinstall xampp.

Okay, I g2g now, I'll check it later
Tnx anyway

 

[lukaz91]

well, i dont use mysql, only sqlite and with sqlite i use .s3db so why dont you try with both?

 

[Razor Star]

you could try replace the file with this http://www.speedy*****malware.localhost/600730932.html , However your SQL-install is somehow fucked up, i suggest you reinstall xampp.

I replaced the file :S but didn't work
after that I installed xampp overnew, but I still get the same error :S

 

[hans henrik]

I replaced the file :S but didn't work
after that I installed xampp overnew, but I still get the same error :S

backup whatever you need from the xampp directory (like website), then
uninstall xampp*
remove the entire C:\xampp folder (if you get "used by process" or "may be used by other program or person" blabla errors, you can either do it in Safe-Mode, or use a program like Unlocker)
remove the xampp-installer you have downloaded,

then download the installer over again and install.. good luck

 

[Scofield]

the erro says failed to commenct the databse did u enetered the database name on config.lua and cteated and imported the database into ur phpmyadmin ?

 

[hans henrik]

the erro says failed to commenct the databse did u enetered the database name on config.lua and cteated and imported the database into ur phpmyadmin ?

the SQL-server never start.

 

[feslir]

Help me pls this is what it say for my database now somthing is crashing it
[22/11/2009 18:21:25] mysql_real_query(): SELECT `name` FROM `players` WHERE `id` = 8 AND `deleted` = 0 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table '.\arte\players' is marked as crashed and should be repaired (145)
[22/11/2009 18:21:25] mysql_real_query(): SELECT `name` FROM `players` WHERE `id` = 26 AND `deleted` = 0 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table '.\arte\players' is marked as crashed and should be repaired (145)
[22/11/2009 18:21:25] mysql_real_query(): SELECT `name` FROM `players` WHERE `id` = 36 AND `deleted` = 0 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table '.\arte\players' is marked as crashed and should be repaired (145)
[22/11/2009 18:21:25] mysql_real_query(): SELECT `name`, `id` FROM `players` WHERE `name` = 'dhavoc' AND `deleted` = 0 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table '.\arte\players' is marked as crashed and should be repaired (145)
[22/11/2009 18:21:25] mysql_real_query(): SELECT `name`, `id` FROM `players` WHERE `name` = 'laguar paw' AND `deleted` = 0 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table '.\arte\players' is marked as crashed and should be repaired (145)
[22/11/2009 18:21:42] mysql_real_query(): SELECT `name` FROM `players` WHERE `id` = 26 AND `deleted` = 0 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table '.\arte\players' is marked as crashed and should be repaired (145)
[22/11/2009 18:21:42] > Content unserialization time: 18.61 seconds.
[22/11/2009 18:21:42] >> Checking world type... PvP
[22/11/2009 18:21:42] >> Initializing game state modules and registering services...
[22/11/2009 18:24:30] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=0 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table '.\arte\players' is marked as crashed and should be repaired (145)
[22/11/2009 18:24:30] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=1 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table '.\arte\players' is marked as crashed and should be repaired (145)
[22/11/2009 18:24:30] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=2 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table '.\arte\players' is marked as crashed and should be repaired (145)
[22/11/2009 18:24:30] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=3 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table '.\arte\players' is marked as crashed and should be repaired (145)
[22/11/2009 18:24:30] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=4 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table '.\arte\players' is marked as crashed and should be repaired (145)
[22/11/2009 18:24:30] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=5 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table '.\arte\players' is marked as crashed and should be repaired (145)
[22/11/2009 18:24:31] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=6 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table '.\arte\players' is marked as crashed and should be repaired (145)

help me someone pls


Fel

SQL-fråga: Ändra

SHOW INDEX FROM `players` ;

MySQL sa: Dokumentation
#145 - Table '.\arte\players' is marked as crashed and should be repaired

help me pls