View Full Version : Quick Question :on a error:
Producer
05-16-2008, 10:38 AM
where is this and can i delete it ? out
[05.14. - 14:21:30] Starting Log: logs/eqemu_error_zone_4080.log
[05.14. - 14:21:30] Error in LoadSwarmSpells query 'SELECT spell_id,count,npc_id,duration FROM aa_swarmpets': #1146: Table 'peq.aa_swarmpets' doesn't exist
where can I find that mother fucker and delete it ////\\\\
Theeper
05-16-2008, 12:22 PM
You need to add in the aa_swarmpets table with this (I believe it's current) ..
CREATE TABLE `aa_swarmpets` (
`spell_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
`count` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`npc_id` int(11) NOT NULL DEFAULT '0',
`duration` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`spell_id`)
) TYPE=MyISAM;
Also, you should post support questions in the support sections. That's why it says Do not post support topics here.
Producer
05-16-2008, 03:15 PM
I would but ...
It says i dont have rights to be able too
and where do I put this thing you just showed me
Theeper
05-16-2008, 04:19 PM
You need to run that SQL against your DB with whatever tool you use. You can use Navicat, PHPMyAdmin, command prompt or whatever method you choose.
cavedude
05-16-2008, 05:37 PM
aa_swarmpets isn't used anymore, its function has been merged into the standard pets and npc_types tables. If you're getting an error complaining that it is missing, than you are using an old version of EQEmu with a current database.
vBulletin® v3.8.11, Copyright ©2000-2025, vBulletin Solutions Inc.