PDA

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.