hey can some one help me plz?

Zulu Da Hunter · #1 05-22-2002, 03:17 PM

im new to this so plz dont flame me when i boot up eqemu 0.3.2/win32
i get this msg
LoginServer.ini read.
Using database 'eq' at localhost
Loading zone names & items...DB Query Error
Error #1054: Unknown column 'zoneidnumber' in 'field list'
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #1054: Unknown
column 'zoneidnumber' in 'field list'
done.

what am i doing wrong

i tried to log i and i got to my char but it said unknown zone then crash as i tried to enter the world

Hardy · #2 05-22-2002, 03:31 PM

I got that same error :(

Using database 'eq' at localhost
Loading zone names, items & NPCs...DB Query Error
Error #1054: Unknown column 'd_meele_texture1' in 'field list'
NPCs loaded - using old database format
done.
Spells loaded from 'spdat.eff'.
Loading guild ranks...done.
Loading faction data...done.
Connected to worldserver: 127.0.0.1:9000
Entering sleep mode

Shawn319 · #3 05-22-2002, 03:37 PM

you forgot to drop your database and start over using the 0.3.2 DB.

Hardy · #4 05-22-2002, 03:41 PM

did that....twice

Warhammer · #5 05-23-2002, 02:01 AM

I'm getting this too..installed fresh on a PC that didn't previously have EQEmu or MySQL installed installed, from the original zips too...
Did the repacked 3.2 have the wrong db?

Gonna redownload and reinstall both....bbiab

*******************
Updated
*******************

errrr-omg...

Seems (feels) like this db takes a lot longer for MySql to load...

I finally simply waited (after doing source db.sql) and made sure it finished before firing it up...

What a nutty step to mess up, I don't remember this long a wait but oh well..she works now...

bennu · #6 05-23-2002, 05:51 AM

I do the source db.sql thing and I get a lot of ERROR 1062: Duplicate entry '#' for key 1. and that keeps going. up to 500 now. before all the errors I got a lot of the usual 1 row affected stuff. I stopped it b4 it stopped once and logged in and when I made a char it said that the char was in an unknown zone. any help is appreciated

I also get the following upon world server boot up:
Loginserver.ini read.
Using database 'everquest' at localhost
Loading zone names & items...DB Query Error
Error #1054: unknown column 'zoneidnumber' in 'field list'
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #1054 Unknown column 'zoneidnumber' in 'field list'
done.
Loading guild ranks...done.
World server listening on: 192.168.x.x
Connected to LoginServer: 192.168.x.x

-Bennu

Aramus · #7 05-23-2002, 07:18 AM

I'm pretty sure the "ERROR 1602: Duplicate Entry" thing means you already tried to source from that db. Just drop your 'eq' database in mysql, then recreate it with the same name.. which is 'eq'. Then run mysql.exe in your mysql/bin folder. type in 'use eq' without the quotes, then type 'source db.sql' without the quotes. Now WAIT until it finishes scrolling. It might take over a minute or so, but wait until it's done. After it's done scrolling, type '\quit'.

I'm not one of the devs.. but I think I had the same problem as you. Hope this helps. If I'm wrong, someone feel free to correct me, as I'm still kinda new to these things =]

Lurker_005 · #8 05-23-2002, 08:26 AM

Bennu, your problem is definaly that you didn't drop your old database, and recreate it.

mysql>drop database everquest;
mysql>create database everquest;
mysql>use everquest;
mysql>source db.sql;

and optionally to add drawde's 0.95 DB

mysql>source rebuildbd.sql;

There should not be any errors loading the eqemu 3.2 db.sql file. Otherwise you have some problems.

On a side note, you might try Drawde's 0.95 database he just released for eqemu 3.2

*Edit: corected some syntax for sql commands and added command to add drawde's DB

bennu · #9 05-23-2002, 08:45 AM

cool thanks for the info Lurker =)

-Bennu

DeletedUser · #10 05-23-2002, 09:35 AM

for 0.3.2 your database must be completely dropped, then you must source db.sql before any addons! (Plus ive heard some addon db's are not working)

Hardy · #11 05-23-2002, 05:03 PM

I have dropped the database 2 differant times :( is there a certain way I need to drop it? I am going into winmysqladmin and right clicking on "eq" and click drop database. Then I re-create it, run mysql, type in use eq, then source db.sql, I don't add on any other database and I still get that error, I load in Drawdes 0.95 and still get that error

Shawn319 · #12 05-23-2002, 05:41 PM

Hardy, make sure you use 0.3.2 AND a 0.3.2 compatable database. Try using the default DB and see if that works. then try others. if others do not work then contact the maker and let him know his DB is outdated.

Hardy · #13 05-23-2002, 06:44 PM

Using Drawdes 0.95 World Data...I can run server with error, but it boots me alot :(

bennu · #14 05-24-2002, 01:29 AM

I also tried to use Drawde's .95 database and got that error. I dropped it and remade the database from scratch and it went away. perhaps his DB isn't working properly

-Bennu

geek312 · #15 05-28-2002, 12:59 PM

I've had the same problem. ive removed the original eq db, then once i've recreated it and set it up, i still get the same error. where could i find this Drawde's .95? maybe it'll work for me.