View Single Post
  #9  
Old 04-08-2002, 07:03 AM
Shawn319
Demi-God
 
Join Date: Jan 2002
Posts: 2,073
Default

Quote:
Error #1054: Unknown column 'zonename' in 'field list'
Error in GetCharSelectInfo query 'SELECT name,profile,zonename FROM character_ W
HERE account_id=2 order by name' #1054: Unknown column 'zonename' in 'field list
'
theres your problem. must have a bad DB.

Open up mysql.exe and type "drop database eq;" without the quotes and hit enter.

then type "create database eq;" and hit enter

then type "source db.sql" and hit enter (with the db.sql file from 0.3.0 zip in the mysql/bin folder)
__________________
Shawn319
Semi-Retired EQ Addict

(Retired)EQEmu Lead Tester
(Retired)EQEmu Tech Support

(Retired)Host/ServerOP - [LIVE] Official EQEmu Test Server
(Retired)Host/ServerOP - Shawn319's All-GM Dev Test Server
(Retired)ServerOP - EQEmu Beta Server
(Retired)ServerOP - GuildWars Server
(Retired)ServerOP - Raid Addicts
--------------------------
Reply With Quote