eq.lootdrop_entries

[Casai]

Hi all.

First off, thank you guys for the emu. I hope I am finally getting a chance to play EQ the way I want on LAN with my brother once I have set everything up.

Anyways I have a problem when I try to source classic Kunark DB into my DB. I get an error when the file gets to eq.lootdrop_entries.

"ERROR 1146 (42S02) : Table 'eq.lootdrop_entries' doesn't exist"

I have no idea how to troubleshoot this since is the first time I ever used MySQL. I have read the guide a few time over now and still cant figure it out.

Any help is appreciated,

Casai

[Casai]

I've had some sleep and figured it out.

Here is what to do if you get any sort of error when sourcing the database. Uninstall MySQL go to their site and download version mysql-4.0.24-win-noinstall.zip and install it.


Then follow the guide. Basically
mysql -u root mysql
Create Database eq;
Use eq;
source peq_kunark.sql;


I've installed mysql-4.1.10a-win32.zip and it doesnt work. So don't install MySQL above version 4.0xxx!

Cheers,

Casai

[Casai]

also found this for those who feel comfortable with MySQL. Looks like 4.1 can be used after all.

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:

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:


PRIMARY KEY (lootdrop_id,item_id)