Bug mysql help plx

[Anillka]

i have problem in mysql data base my server runing for two days and then stop when i try to start it again with same data i have problem with player_items TABLE .. when server start it not load player_items and then crash :-
[04/03/2010 15:00:18] >> Loading config (config.lua)
[04/03/2010 15:00:18] > Using plaintext passwords
[04/03/2010 15:00:18] >> Checking software version... outdated, please consider updating!
[04/03/2010 15:00:19] > Current version information - version: 0.3.5, patch: 0, build: 2564, timestamp: 1249584126.
[04/03/2010 15:00:19] > Latest version information - version: 0.3.6, patch: 0, build: 3293, timestamp: 1260652199.
[04/03/2010 15:00:19] >> Fetching blacklist
[04/03/2010 15:00:20] >> Loading RSA key
[04/03/2010 15:00:20] >> Starting SQL connection
[04/03/2010 15:00:22] >> Running Database Manager
[04/03/2010 15:00:30] > Optimizing table: account_viplist... [success]
[04/03/2010 15:00:30] > Optimizing table: accounts... [success]
[04/03/2010 15:00:30] > Optimizing table: bans... [success]
[04/03/2010 15:00:31] > Optimizing table: environment_killers... [success]
[04/03/2010 15:00:31] > Optimizing table: forums... [success]
[04/03/2010 15:00:31] > Optimizing table: global_storage... [success]
[04/03/2010 15:00:31] > Optimizing table: guild_invites... [success]
[04/03/2010 15:00:31] > Optimizing table: guild_ranks... [success]
[04/03/2010 15:00:31] > Optimizing table: guilds... [success]
[04/03/2010 15:00:32] > Optimizing table: house_auctions... [success]
[04/03/2010 15:00:32] > Optimizing table: house_data... [success]
[04/03/2010 15:00:32] > Optimizing table: house_lists... [success]
[04/03/2010 15:00:32] > Optimizing table: houses... [success]
[04/03/2010 15:00:32] > Optimizing table: killers... [success]
[04/03/2010 15:00:32] > Optimizing table: player_deaths... [success]
[04/03/2010 15:00:33] > Optimizing table: player_depotitems... [success]

the last thing loaded is player_depotitems.. then server crash :/
i try to repair all tables and nothing else

can any one help me please ?

 

[Anillka]

Bump

No One can help me ?

 

[Diazapam]

Noob!

Don't bump after 30 f*cking minutes.

 

[Anillka]

Noob!

Don't bump after 30 f*cking minutes.

ok am sorry but you not know how that problem annoying me i lost days of my detected and cant fix it to run my ot

if you can help try to help me please ;/

 

[Rozinx]

Of course you did lose days, and will lose more if you don't follow these steps :

1- Download a clean installation of your ot version
2- Test is, if it runs, then just keep adding stuff so you can check where it is buggy.

like this : Install movements, try again
Talkactions, try again
and so on.
Not so hard is it

If doesn't work try setting OptimizeDatabaseOnStartup to false.

 

[Anillka]

Of course you did lose days, and will lose more if you don't follow these steps :

1- Download a clean installation of your ot version
2- Test is, if it runs, then just keep adding stuff so you can check where it is buggy.

like this : Install movements, try again
Talkactions, try again
and so on.
Not so hard is it

If doesn't work try setting OptimizeDatabaseOnStartup to false.

i try the first solution not work .. where can i find setting OptimizeDatabaseOnStartup ?? .. on my localhost/phpmyadmin ! ..where ? thx for reply hope u can help me ;/

 

[Cykotitan]

i try the first solution not work .. where can i find setting OptimizeDatabaseOnStartup ?? .. on my localhost/phpmyadmin ! ..where ? thx for reply hope u can help me ;/

config.lua (it's in the same folder as your server's .exe)

	optimizeDatabaseAtStartup = false