EQEmulator Forums - Database broken??

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)

- - Database broken?? (https://www.eqemulator.org/forums/showthread.php?t=13196)

Database broken??

Quote:

[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)

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 ?

db is gone :(

Quote:

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>

so now i should start over?

Source the items table from MW.

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

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!