Error on worldserver.connect

[lerxst2112]

Your database is all kinds of broken. Did you apply all of the updates in the trunk\EQEmuServer\utils\sql\svn directory that were newer than the database you started with?

[Sanayan]

Well I did have a problem with that. I tried applying updates from about 283 up but most of them ended saying

[Msg] Finished - Unsuccessfully

Like this

[Err] 1146 - Table 'peq.aa_effects' doesn't exist
[Err] -- Fix for Healing Gift AA line 

REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('1086', '1', '274', '2', '0');
[Err] 1146 - Table 'peq.aa_effects' doesn't exist
[Err] REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('1087', '1', '274', '4', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('1088', '1', '274', '6', '0');

REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('4779', '1', '274', '2', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('4780', '1', '274', '4', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('4781', '1', '274', '6', '0');

REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('5592', '1', '274', '1', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('5593', '1', '274', '2', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('5594', '1', '274', '3', '0');

REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('7590', '1', '274', '1', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('7591', '1', '274', '2', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('7592', '1', '274', '3', '0');

REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('12452', '1', '274', '1', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('12453', '1', '274', '2', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('12454', '1', '274', '3', '0');
[Msg] Finished - Unsuccessfully

Any idea why?

[c0ncrete]

[Err] 1146 - Table 'peq.aa_effects' doesn't exist

you can't update a table that doesn't exist.

[Sanayan]

Originally Posted by c0ncrete

you can't update a table that doesn't exist.

Ok so what am I doing wrong? Or is there another guide I can use to figure it out.

[Drajor]

I have an update to this issue. It seems that something has changed after rev2214 and 127.0.0.1 instead of localhost is required now.

Derision recently updated the source so this is now the default. See http://code.google.com/p/projecteqem.../detail?r=2497