Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::General Support

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

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 02-26-2004, 03:41 AM
smogo
Discordant
 
Join Date: Jan 2004
Location: 47
Posts: 339
Default

Quote:
NPCs loaded - using old database format
this is from update_invis.sql not being sourced. You will also need the quest_globals.sql


Quote:
Error in FinishConnState2(): !dbaq[1]->GetAnswer(): #1054: Unknown column 'revok
ed' in 'field list'
you need to update your account table. Look at http://www.eqemulator.net/forums/vie...hlight=revoked


Quote:
[Error] Error Loading Objects from DB: #1054: Unknown column 'zoneid' in 'field
list'
Not sure what source you need, but the following works fine for me
Code:
CREATE TABLE object (
  id int(11) NOT NULL auto_increment,
  zoneid int(11) unsigned NOT NULL default '0',
  xpos float NOT NULL default '0',
  ypos float NOT NULL default '0',
  zpos float NOT NULL default '0',
  heading float NOT NULL default '0',
  itemid int(11) NOT NULL default '0',
  charges tinyint(3) unsigned NOT NULL default '0',
  objectname varchar(16) NOT NULL default '',
  type int(11) NOT NULL default '0',
  icon int(11) NOT NULL default '0',
  linked_list_addr_01 int(11) NOT NULL default '0',
  linked_list_addr_02 int(11) NOT NULL default '0',
  unknown08 mediumint(5) NOT NULL default '0',
  unknown10 mediumint(5) NOT NULL default '0',
  unknown20 int(11) NOT NULL default '0',
  unknown24 int(11) NOT NULL default '0',
  unknown60 int(11) NOT NULL default '0',
  unknown64 int(11) NOT NULL default '0',
  unknown68 int(11) NOT NULL default '0',
  unknown72 int(11) NOT NULL default '0',
  unknown76 int(11) NOT NULL default '0',
  unknown84 int(11) NOT NULL default '0',
  unknown88 int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
check if it is the same for you, and update as needed.


'hope this helps.
 


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 11:43 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