Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::Windows Servers

Archive::Windows Servers Archive area for Windows Servers's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-15-2003, 12:55 AM
Damilis's Avatar
Damilis
Hill Giant
 
Join Date: Dec 2002
Location: Nottingham!!
Posts: 217
Default 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?
Reply With Quote
  #2  
Old 02-16-2003, 01:52 AM
Damilis's Avatar
Damilis
Hill Giant
 
Join Date: Dec 2002
Location: Nottingham!!
Posts: 217
Default

wow 52 views and not an ounce of help? that sucks yall....:(
Reply With Quote
  #3  
Old 02-16-2003, 02:02 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

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..
__________________
Quitters never win, and winners never quit, but those who never win and never quit are idiots.
Reply With Quote
  #4  
Old 02-16-2003, 02:05 AM
Damilis's Avatar
Damilis
Hill Giant
 
Join Date: Dec 2002
Location: Nottingham!!
Posts: 217
Default

Ill try that thanks. Ill get back to ya.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:30 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3