EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)
-   -   1054 help (https://www.eqemulator.org/forums/showthread.php?t=9199)

Doomhead 08-22-2003 08:47 AM

1054 help
 
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 08-22-2003 09:05 AM

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 08-22-2003 09:19 AM

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?

08-22-2003 09:39 AM

go into mysql and type

drop database eq ;

to delete your db

Doomhead 08-22-2003 09:52 AM

aye thanks.


All times are GMT -4. The time now is 01:42 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.