Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Development > Archive::Bugs

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

Reply
 
Thread Tools Display Modes
  #1  
Old 06-13-2003, 09:56 PM
Velosity
Sarnak
 
Join Date: May 2003
Location: Rancho Cucamonga, Ca
Posts: 77
Default Items.sql error with the new binaries

new database using the new binaries released have made it so that the items.sql comes up with the column count doesnt match at row 1 . . .does anyone have a solution to this?

Ive tried the add ministatus, and all that but it still doesnt work . . .


grrr i get my server runnin usin the new binaries and i have no items because i started with a fresh new database. I am going to try to dump my items table from my old database and source it in that way

but sourcing items.sql from the worlddata1.1 after sourcing the new binaries causes mysql to come back with the column count error
Reply With Quote
  #2  
Old 06-13-2003, 11:58 PM
Bigpull
Discordant
 
Join Date: Feb 2003
Posts: 305
Default Argg!

When posting database errors like this it would really be helpful if you would include links to the database your using or the release posts for them. Anyways

If your item database doesn't have the minstatus field you need to remove it from the table before you can source in the old format items.
(from memory so it might be wrong there is a manual, look in it if this errors)

mysql> alter table items drop minstatus;

Now you can source in an old format database, but you'll have to update it before you can use it.

mysql> alter table items add minstatus tinyint(3) unsigned not null default '0';
Reply With Quote
  #3  
Old 06-16-2003, 12:26 PM
Velosity
Sarnak
 
Join Date: May 2003
Location: Rancho Cucamonga, Ca
Posts: 77
Default

yeah im usin drawdes and telmets databases, the worlddata1.1 and the eqemu 44dr1 + telmet
ill try that later on tonight, thanks alot
Reply With Quote
  #4  
Old 06-16-2003, 01:54 PM
varbuk
Fire Beetle
 
Join Date: May 2003
Posts: 7
Default

im having the same problem .... any help on this issue would be greatly appreciated
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 02:44 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