Objects fail to load

[Topgun1969]

Been trying to search for a fix on this. Everytime i update to the 1106 it gives me an error in my logs.

[04.20. - 19:29:04] Starting Log: logs/eqemu_error_zone_12216.log
[04.20. - 19:29:04] Error Loading Objects from DB: #1146: Table 'peq.object' doesn't exist
[04.20. - 19:29:04] Loading World Objects failed. continuing.

But i check there and the table is there. Anyone else having a issue like this?
My apologies if this has been overlooked but i am usually very fluent on searches. Stumped on this one. Anyone?

[trevius]

Maybe try removing the table and sourcing in a backup? Sounds like there may be an issue with the table itself. I haven't tried running 1106 yet, but 1104 seems fine.

[Topgun1969]

i have tried resourcing in the table with no luck. I am sorry but i did not state the outcome of this. The NPC'S and Merchants etc are disappeared. Ty for the quick response.

[Aramid]

Did YOU add these SQL additions into your database?


Required SQL:
ALTER TABLE npc_types ADD ATK MEDIUMINT NOT NULL DEFAULT '0';
ALTER TABLE npc_types ADD Accuracy MEDIUMINT NOT NULL DEFAULT '0';

[Topgun1969]

Yes, i have tried that as well and i always get this error....

ERROR 1060 : Duplicate column name 'ATK'
ERROR 1060 : Duplicate column name 'Accuracy'

I have been wanting to pin it on this as i can't get these in.

[Aramid]

Yes, i have tried that as well and i always get this error....

ERROR 1060 : Duplicate column name 'ATK'
ERROR 1060 : Duplicate column name 'Accuracy'

I have been wanting to pin it on this as i can't get these in.

That is telling you they exist....

[Jason1983]

Yes, guess i will drop back to the 1104, i cannot seem to get the 1106 to work. It is strange. Maybe some quest are not showing up in Perl.