Database broken??

[papi2k]

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.6
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
Error in GetItemsCount query 'SELECT MAX(id),count(*) FROM items' #1146: Table '
eq.items' doesn't exist
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data. But ignoring
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Breaking bards...done
TCP listening on: 80.62.225.221:9000
World server listening on: 80.62.225.221:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997


Zones are down, and i cant start the server anymore.. all i did was open for 2 additional ports (zones) and this happend..

I added a item from mangoo editor to kerafyrm aswell (homemade item)

[Derision]

The error message is indicating that the eq.items table cannot be found. To check if your items table is really still there:

start/run/cmd

mysql -u root

use eq;
select * from items;

[You should get a load of output listing all the items in the db]

If your table is still there, did you edit your db.ini file ? Do you have

database=eq

in your db.ini ?

[papi2k]

db is gone :(


Microsoft Windows XP [version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

E:\Documents and Settings\Papi>c:

C:\>mysql -u root

C:\>cd\mysql\bin

C:\mysql\bin>mysql -u root mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use eq;
Database changed
mysql> select * from items;
ERROR 1146: Table 'eq.items' doesn't exist
mysql>

[papi2k]

so now i should start over?

[Monrezz]

Source the items table from MW.

Or, just re-source the whole thing (Drop & Recreate).

[mikenune]

If you choose to recreate, you can find a current version of the (complete) db with all the patches (door update, MW_alphas, loottable, etc.) already in it.

It's a 5MB file that can be downloaded from http://www.raskii.net/eqemu\eqemu055.sql.gz.

NOTE: You have to right-click on the link and select the "save as" option. Otherwise, your browser will open it up in a new window and try to print out the entire contents of the SQL file!

[Shawn319]

http://eqemulator.net/dumpeditems.sql.gz