2 errors in eq2world_x64

[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

[Jabantiz]

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

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.

[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.

[Cynnar]

Link on Bad Password
See if anything there helps.

[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

[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.

[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

[Cynnar]

It's probably case sensitive as well. Good to know and I will get that added to the wiki

[Cynnar]

What wiki page was it?

[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.

[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

[Jabantiz]

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.

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.

[Healingwind84]

So is there noway to actually play the game at all?

[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.

[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