SQL Lite integrity check failed, disabling saving XP

kevlartester · Post by **kevlartester** » Sun Apr 27, 2008 3:04 pm

hey guys,
today our server crashed (i dont know why - some players told me) and after restart all xp seemed to be gone. the server was disableing save_xp by himself and i didnt know why till i found this in the wc3 error log file:

L 04/27/2008 - 11:20:27: ** Map de_aztec started, version: '3.0 RC10'
L 04/27/2008 - 11:51:30: [0] Invalid skill: -1 [3]
L 04/27/2008 - 11:51:36: ** Map 'de_aztec' ended
L 04/27/2008 - 11:51:37: ** Map cs_italy started, version: '3.0 RC10'
L 04/27/2008 - 12:04:34: [0] Invalid skill: -1 [3]
L 04/27/2008 - 12:21:27: ** Map 'cs_italy' ended
L 04/27/2008 - 12:21:28: ** Map de_nuke started, version: '3.0 RC10'
L 04/27/2008 - 12:40:37: Attempted to increase skill 32 to 4
L 04/27/2008 - 12:51:05: ** Map 'de_nuke' ended
L 04/27/2008 - 12:51:07: ** Map de_prodigy started, version: '3.0 RC10'
L 04/27/2008 - 13:07:56: ** Map 'de_prodigy' ended
L 04/27/2008 - 13:07:57: ** Map de_aztec started, version: '3.0 RC10'
L 04/27/2008 - 13:39:07: ** Map 'de_aztec' ended
L 04/27/2008 - 13:39:07: ** Map de_aztec3 started, version: '3.0 RC10'
L 04/27/2008 - 13:40:40: ** Map 'de_aztec3' ended
L 04/27/2008 - 13:40:41: ** Map de_nuke started, version: '3.0 RC10'
L 04/27/2008 - 14:10:08: ** Map 'de_nuke' ended
L 04/27/2008 - 14:10:09: ** Map de_dust started, version: '3.0 RC10'
L 04/27/2008 - 14:39:32: ** Map 'de_dust' ended
L 04/27/2008 - 14:39:32: ** Map de_dust2 started, version: '3.0 RC10'
L 04/27/2008 - 15:09:04: ** Map 'de_dust2' ended
L 04/27/2008 - 15:09:05: ** Map cs_assault started, version: '3.0 RC10'
L 04/27/2008 - 15:23:31: ** Map 'cs_assault' ended
L 04/27/2008 - 15:23:32: ** Map de_inferno started, version: '3.0 RC10'
L 04/27/2008 - 15:53:27: ** Map 'de_inferno' ended
L 04/27/2008 - 15:53:27: ** Map de_aztec started, version: '3.0 RC10'
L 04/27/2008 - 16:23:55: ** Map 'de_aztec' ended
L 04/27/2008 - 17:15:27: ** Map de_dust2 started, version: '3.0 RC10'
L 04/27/2008 - 17:45:12: ** Map 'de_dust2' ended
L 04/27/2008 - 17:45:13: ** Map de_nuke started, version: '3.0 RC10'
L 04/27/2008 - 18:23:37: ** Map de_dust2 started, version: '3.0 RC10'
L 04/27/2008 - 18:23:39: [SQLITE] SQL Lite integrity check failed, disabling saving XP.
L 04/27/2008 - 18:54:47: ** Map 'de_dust2' ended
L 04/27/2008 - 18:54:48: ** Map cs_italy started, version: '3.0 RC10'
L 04/27/2008 - 18:54:48: [SQLITE] SQL Lite integrity check failed, disabling saving XP.
L 04/27/2008 - 18:58:24: ** Map 'cs_italy' ended
L 04/27/2008 - 18:58:24: ** Map de_dust started, version: '3.0 RC10'
L 04/27/2008 - 18:58:25: [SQLITE] SQL Lite integrity check failed, disabling saving XP.
L 04/27/2008 - 19:04:32: ** Map 'de_dust' ended
L 04/27/2008 - 19:04:42: ** Map de_dust2 started, version: '3.0 RC10'
L 04/27/2008 - 19:04:44: [SQLITE] SQL Lite integrity check failed, disabling saving XP.
L 04/27/2008 - 19:06:08: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:06:21: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:08:25: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:08:32: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:08:49: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:09:37: ** Map 'de_dust2' ended
L 04/27/2008 - 19:09:48: ** Map de_dust2 started, version: '3.0 RC11'
L 04/27/2008 - 19:09:50: [SQLITE] SQL Lite integrity check failed, disabling saving XP.
L 04/27/2008 - 19:10:15: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:10:18: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:10:27: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:13:19: ** Map 'de_dust2' ended
L 04/27/2008 - 19:13:19: ** Map de_aztec started, version: '3.0 RC11'
L 04/27/2008 - 19:13:19: [SQLITE] SQL Lite integrity check failed, disabling saving XP.
L 04/27/2008 - 19:27:50: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:28:58: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:28:59: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:30:30: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:30:30: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:31:58: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:34:08: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:35:42: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:35:42: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:35:42: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:38:20: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:38:20: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:38:21: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:38:42: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:42:20: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:42:20: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:42:56: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:42:56: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:42:57: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:42:57: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:42:57: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:42:57: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:42:58: [0] Invalid skill: -1 [3]
L 04/27/2008 - 19:43:07: ** Map 'de_aztec' ended
L 04/27/2008 - 19:43:08: ** Map cs_office started, version: '3.0 RC11'
L 04/27/2008 - 19:43:08: [SQLITE] SQL Lite integrity check failed, disabling saving XP.
L 04/27/2008 - 20:13:21: ** Map 'cs_office' ended
L 04/27/2008 - 20:13:21: ** Map de_nuke started, version: '3.0 RC11'
L 04/27/2008 - 20:13:22: [SQLITE] SQL Lite integrity check failed, disabling saving XP.
L 04/27/2008 - 20:42:42: ** Map 'de_nuke' ended
L 04/27/2008 - 20:42:42: ** Map de_dust started, version: '3.0 RC11'
L 04/27/2008 - 20:42:43: [SQLITE] SQL Lite integrity check failed, disabling saving XP.
L 04/27/2008 - 21:12:28: ** Map 'de_dust' ended
L 04/27/2008 - 21:12:28: ** Map de_inferno started, version: '3.0 RC11'
L 04/27/2008 - 21:12:28: [SQLITE] SQL Lite integrity check failed, disabling saving XP.
L 04/27/2008 - 21:41:52: ** Map 'de_inferno' ended
L 04/27/2008 - 21:41:52: ** Map de_cbble started, version: '3.0 RC11'
L 04/27/2008 - 21:41:53: [SQLITE] SQL Lite integrity check failed, disabling saving XP.
L 04/27/2008 - 22:01:35: ** Map 'de_cbble' ended
L 04/27/2008 - 22:01:35: ** Map de_aztec started, version: '3.0 RC11'
L 04/27/2008 - 22:01:36: [SQLITE] SQL Lite integrity check failed, disabling saving XP.
L 04/27/2008 - 22:31:41: ** Map 'de_aztec' ended
L 04/27/2008 - 22:31:42: ** Map de_dust2 started, version: '3.0 RC11'
L 04/27/2008 - 22:31:42: [SQLITE] SQL Lite integrity check failed, disabling saving XP.

is there a possebility to repair the sql database? i uploaded an old backup now...and it seems to work now.
well at least this backup is 2 months old and so many xp are lost....would be much better if its possible to save the bugged database!
(i updated wc3 during the search of the error)

--- Please enter the following information for support ---
War3ft Version: 3.0 RC10 /RC11
Amxmodx Version: 1.8
Metamod Version: 1.19
amxx list:
amxx modules:
meta list:

Post by **YamiKaitou** » Sun Apr 27, 2008 9:11 pm

Nope. If a sqlite database is corrupt, your only choice is to restore an old backup or restart

kevlartester · Post by **kevlartester** » Mon Apr 28, 2008 4:18 am

damn....well thanks anyway