Pruning WC3FT Database

slmclarengt · Post by **slmclarengt** » Sun Oct 21, 2007 2:26 pm

L 10/21/2007 - 00:17:12: [war3ft.amxx] [MYSQLX] Error in querying database, location: 11
L 10/21/2007 - 00:17:12: [war3ft.amxx] [MYSQLX] Message: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE() (1064)
L 10/21/2007 - 00:17:12: [war3ft.amxx] [MYSQLX] Query statement: DELETE FROM wc3_player_race  WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE(), INTERVAL 14 DAY) > time ) );

War3ft Version: 3.0 RC8
Amxmodx Version: 1.76d
Metamod Version: P28
amxx list:

Code: Select all

Currently loaded plugins:
name version author file status
[ 1] AMXBans 5.0 YoMama/Lux & lan amxbans.amxx debug
[ 2] AmxBans Admin Base 1.76 AMXX Dev Team admin_amxbans.a running
[ 3] Admin Commands 1.76d AMXX Dev Team admincmd.amxx running
[ 4] Admin Help 1.76d AMXX Dev Team adminhelp.amxx running
[ 5] Multi-Lingual System 1.76d AMXX Dev Team multilingual.am running
[ 6] Menus Front-End 1.76d AMXX Dev Team menufront.amxx running
[ 7] Commands Menu 1.76d AMXX Dev Team cmdmenu.amxx running
[ 8] Players Menu 1.76d AMXX Dev Team plmenu.amxx running
[ 9] Teleport Menu 1.76d AMXX Dev Team telemenu.amxx running
[ 10] Maps Menu 1.76d AMXX Dev Team mapsmenu.amxx running
[ 11] Admin Chat 1.76d AMXX Dev Team adminchat.amxx running
[ 12] Anti Flood 1.76d AMXX Dev Team antiflood.amxx running
[ 13] Scrolling Message 1.76d AMXX Dev Team scrollmsg.amxx running
[ 14] Info. Messages 1.76d AMXX Dev Team imessage.amxx running
[ 15] Admin Votes 1.76d AMXX Dev Team adminvote.amxx running
[ 16] NextMap 1.76d AMXX Dev Team nextmap.amxx running
[ 17] TimeLeft 1.76d AMXX Dev Team timeleft.amxx running
[ 18] Pause Plugins 1.76d AMXX Dev Team pausecfg.amxx running
[ 19] Stats Configuration 1.76d AMXX Dev Team statscfg.amxx running
[ 20] Restrict Weapons 1.76d AMXX Dev Team restmenu.amxx running
[ 21] StatsX 1.76d AMXX Dev Team statsx.amxx running
[ 22] CS Misc. Stats 1.76d AMXX Dev Team miscstats.amxx running
[ 23] Warcraft 3 Frozen Thro 3.0 RC8 Geesu & Avanderi war3ft.amxx debug
[ 24] AMX Super 3.1 Bmann_420 & Bo0m amx_super.amxx running
[ 25] Bad Camper 1.3b Brad Jones bad_camper.amxx running
[ 26] Grenade Spam Punish 1.3 [gOf]-Soul grenspampunish. running
[ 27] Admin Spectator ESP 1.3 KoST admin_spec_esp. running
[ 28] AMX Toggle Immunity 3.12 slmclarengt amx_toggleimmun running
[ 29] DeagsMapManager 2.40 Deags/JTP10181 deagsmapmanager running
[ 30] Descriptive 'Fire in t 0.1 VEN descriptive_fir running
[ 31] No Rush 2.0 GHW_Chronic GHW_No_Rush.amx running
[ 32] List Maps 1.0 stupok69 listmaps.amxx running
[ 33] Advanced Roll The Dice v2.5 RC Striker roll_the_dice.a running
[ 34] Spawn Protection 7.0 Peli spawnprotection running
[ 35] AdThemes 1.6 Vet(3TT3V) adthemes.amxx running
[ 36] FakeFull Original 1.7.6 JTP10181/Freecod fakefull_origin running
[ 37] Server redirect 0.9.1 x0R serverredirect. running
[ 38] Map Spawns Editor 1.0.16 iG_os Map_Spawns_Edit running
[ 39] Knife Only on Bridge i 1.0 xx_sirhc_xx amx_deagle5_kni running
39 plugins, 39 running

amxx modules:

Code: Select all

Currently loaded modules:
name version author status
[ 1] MySQL 1.76b AMX Mod X Dev Team running
[ 2] Fun 1.76 AMX Mod X Dev Team running
[ 3] Engine 1.76 AMX Mod X Dev Team running
[ 4] FakeMeta 1.76d AMX Mod X Dev Team running
[ 5] CStrike 1.76 AMX Mod X Dev Team running
[ 6] CSX 1.76c AMX Mod X Dev Team running
[ 7] SQLite 1.76b AMX Mod X Dev Team running
[ 8] Sockets 1.76 HLSW Dev Team running
8 modules, 8 correct

meta list:

Code: Select all

Currently loaded plugins:
description stat pend file vers src load unlod
[ 1] AMX Mod X RUN - amxmodx_mm.dll v1.76d ini ANY ANY
[ 2] SBSRV RUN - sbsrv_mm.dll v3.5.2 ini Start Never
[ 3] MySQL RUN - mysql_amxx.dll v1.76b pl1 ANY ANY
[ 4] Fun RUN - fun_amxx.dll v1.76 pl1 ANY ANY
[ 5] Engine RUN - engine_amxx.dll v1.76 pl1 ANY ANY
[ 6] FakeMeta RUN - fakemeta_amxx.dl v1.76d pl1 ANY ANY
[ 7] CStrike RUN - cstrike_amxx.dll v1.76 pl1 ANY ANY
[ 8] CSX RUN - csx_amxx.dll v1.76c pl1 ANY ANY
[ 9] SQLite RUN - sqlite_amxx.dll v1.76b pl1 ANY ANY
9 plugins, 9 running

Code: Select all

//	Warcraft 3 Frozen Throne Configuration File


// Saving Options

wc3_save_xp		1		// Enables saving of experience (default is 0)
wc3_save_xp_db		1 //TESTING	// How should we save XP? (0 = SQLite, 1 = MySQL)

wc3_save_by		0		// What should I save this as?  steam id = 0, IP = 1, name = 2 (default is 0)
wc3_save_pruning	1		// Automatically prunes the database of old users at a mapchange (default is 0)
wc3_days_before_delete	14		// However many days before deleting XP or pruning from the database (default is 31)
wc3_save_end_round	1		// Save xp at the end of each round (may cause lag, default is 1)

I'm trying to force my database to prune because all together my WC3 database has well over 60,000 rows (yes 60K) with every table included. I continue to receive that error in my logs and I believe lag is also attributed to this problem or having too many rows in my DB to begin with.

MySQL version: 4.0.25

Slmclarengt