Page 1 of 1

Db error crash my server

Posted: Mon Feb 18, 2008 2:50 pm
by jp777cmoe
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:

Re: Db error crash my server

Posted: Mon Feb 18, 2008 3:35 pm
by YamiKaitou
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.

Posted: Mon Feb 18, 2008 9:46 pm
by jp777cmoe
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.

Posted: Mon Feb 18, 2008 10:39 pm
by YamiKaitou
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.

Posted: Tue Feb 19, 2008 12:04 am
by jp777cmoe
what config?

Posted: Tue Feb 19, 2008 12:01 pm
by Geesu
lols

amxmodx/configs/war3ft/war3ft.cfg

Posted: Tue Feb 19, 2008 1:14 pm
by jp777cmoe
wc3_save_xp_db 0 so its SQlite

Posted: Wed Feb 20, 2008 12:44 pm
by Geesu
linux server? My guess is hlds process doesn't have write permissions to the directory

Posted: Wed Feb 20, 2008 3:02 pm
by jp777cmoe
yes linux server
its wierd because it crash randomly and rarely.