Log in

View Full Version : Error updating LFP for character 1 : #1054: Unknown column 'firstlogon' in 'field lis


revloc02c
11-29-2012, 08:32 PM
I can get to char selection, but when I try to enter the world it logs me out.

[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/svn/trunk/peqdatabase/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.