EQEmulator Forums - ALTER TABLE variables ADD COLUMN ts timestamp NULL;

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)

- - ALTER TABLE variables ADD COLUMN ts timestamp NULL; (https://www.eqemulator.org/forums/showthread.php?t=5208)

ALTER TABLE variables ADD COLUMN ts timestamp NULL;

** Added 12:55am 2/15/2003**
If you are upgrading your server, do not forget to run this command in mysql:

ALTER TABLE variables ADD COLUMN ts timestamp NULL;

This will update your table structure to work with the new files.

--------------------------------------------------------------------------------

A little feed back from my server. I upgraded from 4.1 without doing a rebuild put this SQL command in, and all of my NPC disappeared. Went back to a db without the alter table in there and i got a few errors on server boot, but now all my npc's are back. Is this a bug or just issues with my server/sql?

wow 52 views and not an ounce of help? that sucks yall....:(

Hmm.. All i can say is that I havent expereinced this issue..

Not sure why adding the column would screw you up.

Did you resource your npc's back in after altering the table? You might want to try that..

Ill try that :) thanks. Ill get back to ya.