1054 help

[Doomhead]

I've looked throughout the board and found nothing about the problem I am having.

This is with version 0.5.0DR2. I am able to compile with no problems. I can get to server select, I can get to character select, I can create a character, but when I try to enter world, I have problems.

The world.exe constantantly reports the following and this is probably why the zone won't boot. It even reports this with no clients connected.

[code]DB Query Error #1054: Unknown column 'timeleft' in 'where clause'
Error in UpdateTimeLeftWorldUpdate spawn2 set timeleft=(timeleft-300000) where t
imeleft>=300000'

[Merth]

This is likely a database problem. Which database are you using?

Try getting everything running using only the database in db.sql and see if that fixes it.

[Doomhead]

I tried to rebuild the database with db.sql and Drawde's Worlddata 1.1 final.

How do you delete the existing database so I can start from scratch and try with just db.sql?

go into mysql and type

drop database eq ;

to delete your db

[Doomhead]

aye thanks.