Db error crash my server

Read log files for errors! If this fails, come here for help

Moderator: Forum Moderator

Post Reply
jp777cmoe
Peon
Posts: 18
Joined: Sun Dec 17, 2006 10:19 pm

Db error crash my server

Post 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:
User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Re: Db error crash my server

Post 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.
Image

No support via PM or Email
jp777cmoe
Peon
Posts: 18
Joined: Sun Dec 17, 2006 10:19 pm

Post 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.
User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post 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.
Image

No support via PM or Email
jp777cmoe
Peon
Posts: 18
Joined: Sun Dec 17, 2006 10:19 pm

Post by jp777cmoe »

what config?
User avatar
Geesu
<b>King of the world!</b>
Posts: 3164
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu »

lols

amxmodx/configs/war3ft/war3ft.cfg
No Support via PM
jp777cmoe
Peon
Posts: 18
Joined: Sun Dec 17, 2006 10:19 pm

Post by jp777cmoe »

wc3_save_xp_db 0 so its SQlite
User avatar
Geesu
<b>King of the world!</b>
Posts: 3164
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu »

linux server? My guess is hlds process doesn't have write permissions to the directory
No Support via PM
jp777cmoe
Peon
Posts: 18
Joined: Sun Dec 17, 2006 10:19 pm

Post by jp777cmoe »

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