Page 1 of 3

2 errors in eq2world_x64

Posted: Mon May 21, 2018 3:40 pm
by Healingwind84
I get 2 errors when I try and launch.
Error 1054 running MySQL query: Unknown column 'data_version' in 'field list'
SELECT `name`,`version`,`data_version`
FROM `table_versions`

and I get Login Server returned a fatal error: Bad password
Disabling reconnect.

im 99% sure that im putting the password in correctly so im not sure whats going on any advice would help

# READ README.TXT

[LoginServer]
loginserver=eq2emulator.net
loginport=9100
worldname=Lightmare
worldaddress=127.0.0.1
#internalworldaddress= (If used, otherwise blank)
worldport=9000
locked=false
account=****
password=*****
autotableupdates=always
#autotableverbose displays detailed information about the updates; options=true or false
autotableverbose=true
#autotabledata retrieves the latest data for tables like the opcodes table; options=true or false
autotabledata=true

[WorldServer]
Defaultstatus=
Unavailzone=

[UpdateServer]
updateserveraddress=updates.eq2emulator.net
updateserverport=9104

[LoginConfig]
ServerMode=StandAlone
ServerPort=9100

Re: 2 errors in eq2world_x64

Posted: Mon May 21, 2018 3:50 pm
by Jabantiz
Healingwind84 wrote: Mon May 21, 2018 3:40 pm Error 1054 running MySQL query: Unknown column 'data_version' in 'field list'
SELECT `name`,`version`,`data_version`
FROM `table_versions`
This has been fixed and pushed to dev svn already, it may be on public svn by now in rev 2737

If it is not and you want to fix it yourself in source code find the query in worlddatabase.cpp and change data_version to download_version
Healingwind84 wrote: Mon May 21, 2018 3:40 pm and I get Login Server returned a fatal error: Bad password
Disabling reconnect.

im 99% sure that im putting the password in correctly so im not sure whats going on any advice would help
Did you set up a server account on the Account management page? This is different from the player account used to connect to login to play and different from the forum login.

Re: 2 errors in eq2world_x64

Posted: Mon May 21, 2018 4:02 pm
by Healingwind84
Yeah I even deleted the server and remade it just to make sure and its still giving me an error with the new login and password.

Re: 2 errors in eq2world_x64

Posted: Mon May 21, 2018 4:13 pm
by Cynnar
Link on Bad Password
See if anything there helps.

Re: 2 errors in eq2world_x64

Posted: Mon May 21, 2018 5:56 pm
by Healingwind84
Yeah I did take a lookthrough,

I've tried no password no username a combination of the two. resetting my password, checked my ports all the ports are forwarded.....so im at a bit of a loss

Re: 2 errors in eq2world_x64

Posted: Mon May 21, 2018 6:00 pm
by Jabantiz
Did your server account have special characters in the name or the password? I would try creating a simple account with a username like abcd and a password of 1234 and see if your server can log in that way.

Re: 2 errors in eq2world_x64

Posted: Mon May 21, 2018 6:07 pm
by Healingwind84
Ok that seemed to do the trick, I would add in on the wiki that adding a number or something at the end of the password is required. Added 12 at the end and that seemed to do the trick

Re: 2 errors in eq2world_x64

Posted: Mon May 21, 2018 6:12 pm
by Cynnar
It's probably case sensitive as well. Good to know and I will get that added to the wiki

Re: 2 errors in eq2world_x64

Posted: Mon May 21, 2018 6:14 pm
by Cynnar
What wiki page was it?

Re: 2 errors in eq2world_x64

Posted: Mon May 21, 2018 6:14 pm
by Jabantiz
I don't think we require any special characters, I thought special characters (like ā ) might have been causing the issue. It sounds to me like it might have been the size of the password that was the problem as I do believe there is a size requirement but I am not sure of the limit off hand.

Re: 2 errors in eq2world_x64

Posted: Mon May 21, 2018 6:36 pm
by Healingwind84
Well the password I used was a 9 letter password with a capital at the beginning so I dont think it was a length issue. Also on the side of the wiki for the windows setup I don't see anywhere I get the maps for the server folder...im assuming i just missed something.

Here is the link for the wiki page....It lists making a map folder but not how to populate it.

https://www.eq2emulator.net/wiki/index. ... ows_Server

Re: 2 errors in eq2world_x64

Posted: Mon May 21, 2018 6:42 pm
by Jabantiz
Healingwind84 wrote: Mon May 21, 2018 6:36 pm Well the password I used was a 9 letter password with a capital at the beginning so I dont think it was a length issue.
Thanks for informing me I will have to dig through the code to figure out the exact requirements so we can get it on the wiki.
Healingwind84 wrote: Mon May 21, 2018 6:36 pm Also on the side of the wiki for the windows setup I don't see anywhere I get the maps for the server folder...im assuming i just missed something
This is not officially released yet, there is one map posted here on the forums for testing but other then that nothing.

Re: 2 errors in eq2world_x64

Posted: Mon May 21, 2018 6:43 pm
by Healingwind84
So is there noway to actually play the game at all?

Re: 2 errors in eq2world_x64

Posted: Mon May 21, 2018 6:49 pm
by Cynnar
You can play. Map files are not needed to login and have zones. That is something Jabantiz is working on to fix some issues like NPC's walking through walls, etc.

Re: 2 errors in eq2world_x64

Posted: Mon May 21, 2018 6:50 pm
by Healingwind84
WEll maybe you can make sense of this than

19:48:00 I ZoneAuth: Access Key: 1526953679, Character Name: Iskiviuf, Account ID: 7183
19:48:00 I Zone: Loading new Zone 'QueensColony'
19:48:00 W SPGrid: SPGrid::Init() unable to open the map file for tutorial_island02. (zoneserver will continue to run fine without it)
19:48:00 I NPC: -Loading NPC data...
19:48:00 I NPC: --Loaded 0 NPC(s).
19:48:00 I NPC: --Loaded 0 NPC Spell(s).
19:48:00 I NPC: --Loaded 0 NPC Skill(s).
19:48:00 I NPC: --Loaded 0 NPC Equipment Piece(s).
19:48:00 I NPC: --Loaded 0 NPC Appearance(s).
19:48:00 I NPC: --Loaded 0 NPC Equipment Appearance(s).
19:48:00 I NPC: -Load NPC data complete!
19:48:00 I Object: -Loading Object data...
19:48:00 I Object: -Load Object data complete!
19:48:00 I Sign: -Loading Sign data...
19:48:00 I Sign: -Load Sign data complete!
19:48:00 I Widget: -Loading Widget data...
19:48:00 I Widget: -Load Widget data complete!
19:48:00 I GSpawn: -Loading Groundspawn data...
19:48:00 I GSpawn: -Load Groundspawn data complete!
19:48:00 I Pet: -Loading Pet data...
19:48:00 I Pet: -Load Pet data complete!
19:48:00 I Loot: -Loading Spawn loot data...
19:48:00 I Loot: -Loading Global loot data...
19:48:00 I Loot: -Loading Spawn loot data complete!
19:48:00 I Transport: -Loading Transporters...
19:48:00 I Transport: -Loading Transporters complete!
19:48:00 I Spawn: Loaded for zone 'QueensColony' (253):
0 NPC(s), 0 Object(s), 0 Widget(s)
0 Sign(s), 0 Ground Spawn(s), 0 Spawn Group(s)
0 Spawn Group Association(s), 0 Spawn Group Chance(s)
19:48:00 E LUA: Error loading cannot open ZoneScripts/QueensColony.lua: No such file or directory (file name: 'ZoneScripts/QueensColony.lua')
19:48:00 E LUA: Error LUA Zone Script 'ZoneScripts/QueensColony.lua'
19:48:00 W Client: Player has no items - reloading starting items: 'Iskiviuf' (107)
19:48:59 I Zone: Scheduling client 'Iskiviuf' for removal.
19:49:00 I Zone: Starting zone shutdown timers...


than the game just errors out. I dont get past the character screen once it starts to load.

Also looking through the DB the database is there but every single one is empty nothing in it. Did I miss something? No items spells nothin lol