EQEmulator Forums - Can not connect to server [Private Server]

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Can not connect to server [Private Server] (https://www.eqemulator.org/forums/showthread.php?t=32677)

Can not connect to server [Private Server]

So, I'm getting this error in World.exe after I click Play to log in to my server:

Code:



[12.12. - 12:31:40] [NET__IDENT_TRACE] 127.0.0.1:52710: First opcode 0x6c3c did not match expected 0x2792

[12.12. - 12:31:40] [NET__IDENT_TRACE] 127.0.0.1:52710: Tried patch 6.2_world, and it did not match.

[12.12. - 12:31:40] [NET__IDENT_TRACE] 127.0.0.1:52710: First opcode 0x6c3c did not match expected 0x2ec9

[12.12. - 12:31:40] [NET__IDENT_TRACE] 127.0.0.1:52710: Tried patch 6.2_zone, and it did not match.

[12.12. - 12:31:40] [NET__IDENT_TRACE] 127.0.0.1:52710: First opcode 0x6c3c did not match expected 0x4dd0

[12.12. - 12:31:40] [NET__IDENT_TRACE] 127.0.0.1:52710: Tried patch Titanium_world, and it did not match.

[12.12. - 12:31:40] [NET__IDENT_TRACE] 127.0.0.1:52710: First opcode 0x6c3c did not match expected 0x7213

[12.12. - 12:31:40] [NET__IDENT_TRACE] 127.0.0.1:52710: Tried patch Titanium_zone, and it did not match.

[12.12. - 12:31:40] [NET__IDENT_TRACE] 127.0.0.1:52710: First opcode matched 0x6c3c and length matched 464

[12.12. - 12:31:40] [NET__IDENTIFY] Identified stream 127.0.0.1:52710 with signature SoF_world

[12.12. - 12:31:40] [WORLD__CLIENT] Checking inbound connection 127.0.0.1 against BannedIPs table

[12.12. - 12:31:40] [WORLD__CLIENT] Connection 127.0.0.1 PASSED banned IPs check.  Processing connection.

[12.12. - 12:31:40] [WORLD__CLIENTLIST_ERR] 

Error in CreateAccount query 'INSERT INTO account SET name='[login name]', status=0, lsaccount_id=1, 

time_creation=UNIX_TIMESTAMP();' #1054: Unknown column 'time_creation' in 'field_list'

Error adding local account for LS login: '[login name]', duplicate name?

[12.12. - 12:31:40] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '1'

I'm using a freshly installed Secrets of Faydwer client and a freshly installed server using the database rev1751. I've noticed that if I use these opcodes (in login_opcodes_sod.conf)

Code:

#EQEmu Public Login Server OPCodes

OP_SessionReady=0x0001

OP_Login=0x0002

OP_ServerListRequest=0x0004

OP_PlayEverquestRequest=0x000d

OP_PlayEverquestResponse=0x0022

OP_ChatMessage=0x0017

OP_LoginAccepted=0x0018

OP_ServerListResponse=0x0019

OP_Poll=0x0029

OP_EnterChat=0x000f

OP_PollResponse=0x0011

my server doesn't show up on server select, but if I change them to this (found in login_opcodes.conf):

Code:

#EQEmu Public Login Server OPCodes

OP_SessionReady=0x0001

OP_Login=0x0002

OP_ServerListRequest=0x0004

OP_PlayEverquestRequest=0x000d

OP_PlayEverquestResponse=0x0021

OP_ChatMessage=0x0016

OP_LoginAccepted=0x0017

OP_ServerListResponse=0x0018

OP_Poll=0x0029

OP_EnterChat=0x000f

OP_PollResponse=0x0011

My server shows up but I get these errors and EQ just hangs on a black screen.

Not sure what else would be useful info. Thanks for any help.

Quote:

Originally Posted by Chanus (Post 195078)

[12.12. - 12:31:40] [WORLD__CLIENTLIST_ERR]
Error in CreateAccount query 'INSERT INTO account SET name='[login name]', status=0, lsaccount_id=1,
time_creation=UNIX_TIMESTAMP();' #1054: Unknown column 'time_creation' in 'field_list'
Error adding local account for LS login: '[login name]', duplicate name?

In the source download, is the folder \EQEmuServer\utils\sql\svn\ which has all the sql changes for the database. You said you downloaded version 1751 of the database. That sql folder at the time of this post has 4 newer sql files than 1751. If you have the latest source, you will need all 4 files sourced into your database.

I'm not sure exactly how to do that.

I'm guessing you mean these four files:

1753_optional_haste_cap_rule.sql
1753_required_sql_healing_adept_aa.sql
1754_required_sql_healing_adept_aa_fix.sql
1755_required_sql_fear_resist_aas.sql

?

Do I just "source 1753_optional_haste_cap_rule.sql;"
etc for all four of them?

Thanks

yes, but I just realized that your error is for time_creation column in the account table. This change came in 1711_account_restricted_aa.sql.
You may have more database issues than you know.

Well crap, that's not promising.

I just realized the server zip comes with an "sql_updates" folder. The first file in it is 1711_account_restricted_aa.sql

I tried sourcing it, but I get ERROR 1060 (42S21): Duplicate column name 'account_time_required'

Am I on the right track here?

At this point, you should just start over unless you want to go through every file and verify what is and isn't updated. The readme.txt files in the db file you downloaded should help.

Is there an archive of previous databases or something?

Using the SVN or a direct download, I get the same one (peqdb_rev1751.sql) and I'm getting the same errors, so I assume it's a problem with the current rev?

Okay, so in a last ditch effort I just sourced all the files in sql_updates and ignored the errors and apparently it works now.

So... fair enough.

Thanks for the help pointing me in the direction I needed to go!

I am having the exact same problem. When I click play on the client I get this error in the World.exe window:

Code:

Error in CreateAccount query 'INSERT INTO account SET name='[login name]', status=0, lsaccount_id=1, 

time_creation=UNIX_TIMESTAMP();' #1054: Unknown column 'time_creation' in 'field_list'

So I found the "sql_updates" folder and tried this:

Quote:

Originally Posted by Chanus (Post 195086)

Okay, so in a last ditch effort I just sourced all the files in sql_updates and ignored the errors and apparently it works now.

...but I still have the error. When I sourced those SQL updates I did get errors which I ignored same as Chanus, but with different results.

So I am just wondering if anyone has any other thoughts or ideas on this. Thanks.

I got it thanks to this thread: http://www.eqemulator.org/forums/sho...d.php?p=194732

Here's what I did:

In the folder I unzipped "EQEmu-Rev1741-Bots" there is a folder called "sql_updates"
The first file in there is 1711_account_restricted_aa.sql which did not run correctly as I previously noted.
I commented out the first line which was the culprit so the rest of the script could run, which adds the missing column in the account table so that accounts can be created.

Viola everything works. Thanks Huppy (in the other thread) for the info.