Hey guys,

when starting up world i have been getting an error from the visual_states table for the last week. Here is the error:



In my database the visual_states table already exists, with over 8800 entries. Any ideas?

Somehow your table_versions table was modified incorrectly. Run this query:

delete from table_versions where name='visual_states';

LE, I reported this soon after the emotes were released. There is no way to fix this yourself on the admin end, the queries are just wrong coming from Update. You can delete and refetch all day, you still get dropped columns out of order.

http://eq2emulator.net/phpBB3/viewtopic ... 9956#p9956


I have gone as far as completely wiping my DB and restarting world a few times, I continuously get an error on visual_states.

I wind up manually fixing it by getting as many updates as I can, then copying visual_states and table_versions from Tess to my dev DB to stop the updates.

Oops, yah you are right John When I read your previous error report I looked at the queries and I didn't see how they could be causing a problem so I just assumed you modified your table manually because of a post on the forums. But yah I see the issue now and it should be fixed.

Heh, I would have fixed it but with my stupid ass IP changing, I keep losing access. Don't bother fixing me unless you can automate it. I learned my particular account type is ineligible for static IP... which is why Qwest is getting fired when I get my business-class service from Cox again.