Sourcing problems (lootdrop_entries)

mrea · #1 03-12-2005, 03:25 PM

Couldn't find an answer anywhere. I searched many, many times. Also, I don't even know if this will be answered due to PEQ's separation from EQEmulator.. BUT when I source any of the PEQ DB's (velious or kunark) I get an error saying that table (lootdrop_entries) doesn't exist.

RangerDown · #2 03-12-2005, 05:12 PM

There was a mistake in its primary key definition -- the same field being listed twice -- and mysql 4 doesn't like that.

The primary key definition for that table has been corrected and should show up in the Sourceforge on the next beta release. If you're keen with editing the SQL file you can go ahead and edit what you have to fix the error.

Go to the lines that read:

Code:

CREATE TABLE lootdrop_entries (
  lootdrop_id int(11) unsigned NOT NULL default '0',
  item_id int(11) NOT NULL default '0',
  item_charges tinyint(2) unsigned NOT NULL default '1',
  equip_item tinyint(2) unsigned NOT NULL default '0',
  chance tinyint(2) unsigned NOT NULL default '1',
  PRIMARY KEY  (lootdrop_id,item_id,lootdrop_id)
) TYPE=MyISAM;

Change that PRIMARY KEY line so that the lootdrop_id field is listed only once in it. Should then read:

Code:

  PRIMARY KEY  (lootdrop_id,item_id)

mrea · #3 03-13-2005, 12:30 AM

thanks a bunch, I'll give that a shot