Db error crash my server

jp777cmoe · Post by **jp777cmoe** » Mon Feb 18, 2008 2:50 pm

Something about my database is crashing the server and i cant even start it back.

here is the log of the error:

L 02/18/2008 - 15:23:20: -------- Mapchange to fy_pool_day --------
L 02/18/2008 - 15:42:05: [mapchooser.amxx] Vote: Voting for the nextmap started
L 02/18/2008 - 15:42:20: [mapchooser.amxx] Vote: Voting for the nextmap finished. The nextmap will be scoutzknivez
L 02/18/2008 - 15:44:09: [war3ft.amxx] [MYSQLX] Error in querying database, location: 6
L 02/18/2008 - 15:44:09: [war3ft.amxx] [MYSQLX] Message: unable to open database file (14)
L 02/18/2008 - 15:44:09: [war3ft.amxx] [MYSQLX] Query statement: REPLACE INTO `wc3_player_race` ( `player_id` , `race_id` , `race_xp` ) VALUES ( '33', '7', '188');

i ll post the amxx list and others as soon as i can.
edit: forgot to add, im using sqlite to save the xp

--- Please enter the following information for support ---
War3ft Version: warcraft 3 ft rc 9.0
Amxmodx Version: lastest
Metamod Version: lastest
amxx list:
amxx modules:
meta list:

Post by **YamiKaitou** » Mon Feb 18, 2008 3:35 pm

jp777cmoe wrote:--- Please enter the following information for support ---
Amxmodx Version: lastest
Metamod Version: lastest

I should close this for "Failure to provide required info", but I will be nice. DO NOT SAY LATEST. GIVE VERSION NUMBERS

Also, are you using SQLite or MySQL to save? I know the error says MySQL, but I have noticed with SQLite that sometimes it says MySQL instead.

jp777cmoe · Post by **jp777cmoe** » Mon Feb 18, 2008 9:46 pm

amxx version: 1.8.0 (linux)
metamod version: 1.19 (linux)

i enabled SQlite in my modules.ini so i use SQlite to save xp.

Post by **YamiKaitou** » Mon Feb 18, 2008 10:39 pm

FYI, wc3ft autoloads both MySQL and SQLite. Look in your config and tell me please. I have a feeling that it is SQLite, but I want to make sure.

jp777cmoe · Post by **jp777cmoe** » Tue Feb 19, 2008 12:04 am

what config?

Post by **Geesu** » Tue Feb 19, 2008 12:01 pm

lols

amxmodx/configs/war3ft/war3ft.cfg

jp777cmoe · Post by **jp777cmoe** » Tue Feb 19, 2008 1:14 pm

wc3_save_xp_db 0 so its SQlite

Post by **Geesu** » Wed Feb 20, 2008 12:44 pm

linux server? My guess is hlds process doesn't have write permissions to the directory

jp777cmoe · Post by **jp777cmoe** » Wed Feb 20, 2008 3:02 pm

yes linux server
its wierd because it crash randomly and rarely.

Warcraft 3 MODs

Db error crash my server

Db error crash my server

Re: Db error crash my server