EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Error updating LFP for character 1 : #1054: Unknown column 'firstlogon' in 'field lis (https://www.eqemulator.org/forums/showthread.php?t=36060)

revloc02c 11-29-2012 08:32 PM

Error updating LFP for character 1 : #1054: Unknown column 'firstlogon' in 'field lis
 
I can get to char selection, but when I try to enter the world it logs me out.

Code:

[Debug] [WORLD__CLIENT] revloc02: Logged in. Mode=(CharSel)
[Debug] [WORLD__CLIENT] revloc02: LS Account #xxxxxx
[Error] Error updating LFP for character 1 : #1054: Unknown column 'firstlogon'
in 'field list'
[Debug] [WORLD__CLIENT] revloc02: Attempting autobootup of guildlobby (344:0)
[Debug] [WORLD__ZONE] [5] Setting to 'guildlobby' (344:0)
[Debug] [WORLD__CLIENT] revloc02: Entering zone guildlobby (344:0)
[Debug] [WORLD__ZONE] [5] [guildlobby] Broadcasting a world time update
[Debug] [WORLD__ZONE] [5] [guildlobby] Setting to 'guildlobby' (344:0)
[Debug] [WORLD__CLIENT] revloc02: Sending client to zone guildlobby (344:0) at 1
92.168.0.100:7004
[Debug] [WORLD__CLIENT] revloc02: Client disconnected (not active in process)

What did I do wrong?

c0ncrete 11-29-2012 09:14 PM

you didn't source in utils\sql\svn\2268_required_updates.sql

revloc02c 11-29-2012 09:32 PM

Yup, that was it, thank you so much.

So I expected those kinds of updates to be here:
C:\EQEmu\PEQDB\updates

(or the equivalent directory where the DB info resides from svn: https://projecteqdb.googlecode.com/s...tabase/updates)

...am I mistaken? Or was there an oversight on someone else's part (not complaining, just trying to clarify and understand).

Uleat 11-29-2012 09:35 PM

Gotta remember there are two sides to this - the Server and the Database. Both are kept by different groups and updates can come from either one.

c0ncrete 11-29-2012 09:36 PM

if it's a server update that requires a change to the database, the script is generally in utils\sql\svn.

revloc02c 11-29-2012 09:41 PM

Oh wow. I didn't know that. Thanks guys. That's very helpful to know.

Amazing. As much as I've learned about all this, there's still tons more for me to still learn.


All times are GMT -4. The time now is 05:19 PM.

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