server setup question

[Aescleal]

Hi, I've taken the plunge and i'm setting up a server to test.
I get the following message in the server window.
But first I'll comment that I'm running Vista Ultimate x64 as my server (hw/sw info below), with the lastest emu download and followed the server setup instructions on this site. I just want to be sure i'm getting as few error messages as possible from the server. So i'm not even connecting a client to it yet.

Here's the copy/paste:

[Status] Using database 'EQ2' at localhost
[Status] CURRENT_WORLD_VERSION:EQ2EMu 0.6.0 Developer Alpha
[Status] ./LoginServer.ini read.
[Status] Connecting to Update Server..
[Status] Connected to Update Server: eq2emulator.net:9101
[Status] Checking for updates.
[Status] Found Updates.
[Status] Processing Updates.
[Error] Error in updating tables query 'replace into spell_tiers (id,spell_id,ti
er,hp_req,hp_req_percent,hp_upkeep,power_req,power_req_percent,power_upkeep,req_
concentration,cast_time,recovery,recast,radius,max_aoe_targets,min_range,range,d
uration1,duration2,resistibility,hit_bonus,call_frequency) values(2,1,1,0,0,0,0
,10,0,0,0,50,5,0,0,0,2,600,600,0,0,30)': #1064: You have an error in your SQL sy
ntax; check the manual that corresponds to your MySQL server version for the rig
ht syntax to use near 'range,duration1,duration2,resistibility,hit_bonus,call_fr
equency) values(2,1,1,' at line 1
[Error] Attempting to update database table 'spell_tiers' data ... FAILE
D!
[Status] Update complete.
[Status] Loading opcodes..
[Status] Loading structs..
[Status] Loading command list..
[Status] Loaded 21 entity command lists.
[Status] Loaded 0 NPC(s).
[Status] Loaded 0 Object(s).
[Status] Loaded 0 Widget(s).
[Status] Loaded 0 Sign(s).
[Status] Loaded global variables list..
[Status] Loaded visual states list..
[Status] Loading World Time..
[Status] Loading items.. (this might take a few minutes)
[Status] Loaded 0 Bag(s)
[Status] Loaded 0 Food(s)
[Status] Loaded 0 Weapon(s)
[Status] Loaded 0 Armor Piece(s)
[Status] Loaded 0 Skill Item(s)
[Status] Loaded 0 Regular Items
[Error] Error in LoadNextUniqueItemID query 'SELECT max(unique_id) from characte
r_items': #1054: Unknown column 'unique_id' in 'field list'
[Status] Loading spells..
Error Loading Spells, Query: select id, name, description, version, sub_version,
type, class_skill, mastery_skill, tier, hp_req, power_req, cast_time, recast, r
adius, max_aoe_targets, req_concentration, range, duration1, duration2, resistib
ility, hp_upkeep, power_upkeep, duration_until_cancel, target_type, recovery, le
vel, power_req_percent, hp_req_percent, icon, icon2, icontype, success_message,
fade_message, cast_type, lua_script, call_frequency, interruptable, spell_visual
, effect_message from spells, Error: #1064: You have an error in your SQL syntax
; check the manual that corresponds to your MySQL server version for the right s
yntax to use near 'range, duration1, duration2, resistibility, hp_upkeep, power_
upkeep, duration_un' at line 1
[Status] Loading LUA spells..
[Status] Loaded 2 LUA Spell(s)
[Status] Loaded 2 LUA Spawn Script(s)
[Status] Loading factions..
[Status] Loaded 48 Factions
[Status] Loading skills..
[Status] Loaded 129 Skills
[Status] Loading loot data..
[Status] Loaded 0 loot tables.
[Status] Loaded 0 loot drops.
[Status] Loaded 0 spawn loot lists.
[Status] Loading EQ time of day..
I'm counting how many times you've opened this...
Starting factory Reader
Starting factory Writer
World server listening on: localhost:9000
Connected to LoginServer: eq2emulator.net:9100

I've restarted the EQ2WORLD.exe several times as instructed.
Does this info help troubleshoot any? If not I'll try to get more somehow.
Hardware is Intel 3.0ghz dualcore, 8gb ram, ati 3870 w/512mb ram, 250gb hdd.
Vista is fully patched up to date as of yesterday, excluding language packs.
Internet is Cable, 15mb down, 1mb up.
I'm behind a Linksys router.
I'm not trying to connect yet, just to get the server patching smoothly.
I'm going one step at a time.
Oh, and I'm using all the current versions in the instructions. MySQL 5.1, Heidi, etc.

Thanks for any pointers.

[John Adams]

That is a better start to information than most, so I give you credit

But see that little search feature up top? I found this by entering 'replace into spell.tiers' Hope it helps.

[Aescleal]

That is a better start to information than most, so I give you credit

But see that little search feature up top? I found this by entering 'replace into spell.tiers' Hope it helps.

Haha!
Thanks and Thanks!
I wouldn't have known what part to search on. That's partly why I asked in here!
I'll try this tonight.
Thanks John,
Aes

[John Adams]

Just make sure you read that entire 3-page thread, because what we couldn't seem to emphasize enough was the difference between update port 9101 and 9102, when using release vs development (svn) binaries.

[Aescleal]

Just make sure you read that entire 3-page thread, because what we couldn't seem to emphasize enough was the difference between update port 9101 and 9102, when using release vs development (svn) binaries.

Hi again John,
Man, I sure am sorry, but even though I think I've covered all the steps, I can't get the server to run without errors.
Is it maybe the EQ2Emulator0.6.0_Win32Binary?
I posted on the other thread.

[Aescleal]

I've set up the server, multiple times now from scratch. Tonight I grabbed 0.6.5 and set that up. Every time I still get these errors.
Are there supposed to be extra ports open for the server?

I've set up the minilogin so I can see if the server will drop me after a short time still.

Any suggestions?

Aes

[LethalEncounter]

You can copy/paste the output from 0.6.5 and the associated LoginServer.ini file (without your username/pass)?

[Aescleal]

You can copy/paste the output from 0.6.5 and the associated LoginServer.ini file (without your username/pass)?

Sure thing.

LoginServer

Code: Select all

[LoginServer]
loginserver=eq2emulator.net
loginport=9100
worldname=CORE
worldaddress=localhost
#internalworldaddress=INTERNAL_IP_HERE (If used, otherwise blank)
worldport=9000
locked=false
account=myaccountname
password=mypassword
#autotableupdates retrieves the latest table updates and applies them to your database
#autotableupdates valid options=always, ask, and never
autotableupdates=always
#autotableverbose displays detailed information about the updates; options=true or false
autotableverbose=false
#autotabledata retrieves the latest data for tables like the opcodes table; options=true or false
autotabledata=true

[WorldServer]
Defaultstatus=
Unavailzone=

[UpdateServer]
updateserveraddress=eq2emulator.net
updateserverport=9103

[LoginConfig]
ServerMode=StandAlone
ServerPort=9100

Output from 0.6.5

Code: Select all

[Status] Using database 'EQ2' at localhost
[Status] CURRENT_WORLD_VERSION:EQ2EMu 0.6.5 Developer Alpha
[Status] ./LoginServer.ini read.
[Status] Connecting to Update Server..
[Status]        Connected to Update Server: eq2emulator.net:9103
[Status]        Checking for updates.
[Status]        Processing Data Updates.
[Error] Error in updating tables query 'replace into spell_tiers (id,spell_id,ti
er,hp_req,hp_req_percent,hp_upkeep,power_req,power_req_percent,power_upkeep,req_
concentration,cast_time,recovery,recast,radius,max_aoe_targets,min_range,range,d
uration1,duration2,resistibility,hit_bonus,call_frequency,unknown9)  values(2,1,
1,0,0,0,0,10,0,0,0,50,5,0,0,0,2,600,600,0,0,30,0)': #1064: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'range,duration1,duration2,resistibility,hit_bo
nus,call_frequency,unknown9)  valu' at line 1
[Error]         Attempting to update database table 'spell_tiers' data ... FAILE
D!
[Status]        Data Update complete.
[Status] Loading opcodes..
[Status] Loading structs..
[Status] Loading command list..
[Status] Loaded 21 entity command lists.
[Status] Loaded 0 NPC(s).
[Status] Loaded 0 Object(s).
[Status] Loaded 0 GroundSpawn(s).
[Status] Loaded 0 Widget(s).
[Status] Loaded 0 Sign(s).
[Status] Loading ground spawn items..
[Status] Loading loot data..
[Status]        Loaded 0 loot tables.
[Status]        Loaded 0 loot drops.
[Status]        Loaded 0 spawn loot lists.
[Status] Loading Transporter Information..
[Status]        Loaded 0 Teleporter(s)
[Status] Loaded global variables list..
[Status] Loaded visual states list..
[Status] Loading World Time..
[Status] Loading items.. (this might take a few minutes)
[Status]        Loaded 0 Bag(s)
[Status]        Loaded 0 Food(s)
[Status]        Loaded 0 Weapon(s)
[Status]        Loaded 0 Armor/Shield Piece(s)
[Status]        Loaded 0 Skill Item(s)
[Status]        Loaded 0 Regular Items
[Status] Loading spells..
Error Loading Spells, Query: select spells.id, name, description, type, class_sk
ill, mastery_skill, tier, hp_req, power_req, cast_time, recast, radius, max_aoe_
targets, req_concentration, range, duration1, duration2, resistibility, hp_upkee
p, power_upkeep, duration_until_cancel, target_type, recovery, power_req_percent
, hp_req_percent, icon, icon2, icontype, success_message, fade_message, cast_typ
e, lua_script, call_frequency, interruptable, spell_visual, effect_message, min_
range, can_effect_raid, affect_only_group_members, hit_bonus, spell_text_color,
display_spell_tier, friendly_spell, group_spell from spells, spell_tiers where s
pells.id = spell_tiers.spell_id order by tier, Error: #1064: You have an error i
n your SQL syntax; check the manual that corresponds to your MySQL server versio
n for the right syntax to use near 'range, duration1, duration2, resistibility,
hp_upkeep, power_upkeep, duration_un' at line 1
[Status] Loading LUA spells..
[Status]        Loaded 2 LUA Spell(s)
[Status] Loading factions..
[Status]        Loaded 48 Factions
[Status] Loading skills..
[Status]        Loaded 129 Skills
[Status] Loading Quests..
[Status]        Loaded 0 Quest(s)
[Status] Loading Merchant Information..
[Status]        Loaded 0 Merchant List(s)
[Status]        Loaded 0 Merchant Multiplier(s)
[Status] Loading Spawn Script Information..
[Status] Loading EQ time of day..
Breaking your databases!!
Starting factory Reader
Starting factory Writer
World server listening on: localhost:9000
Starting static zones...
Connected to LoginServer: eq2emulator.net:9100

[John Adams]

Code: Select all

updateserveraddress=eq2emulator.net

Shouldn't this be:

Code: Select all

updateserveraddress=updates.eq2emulator.net

???

I thought I posted a complete example in the Update Server announcement thread.

[LethalEncounter]

Both resolve to the same address so that line although not preferred, is fine. What version of mysql are you running? Could you run this query on your db and tell me the result:

select VERSION()

[LethalEncounter]

I bet you are using 5.1 as apparently in 5.1 mysql added a range function of some sorts which explains why it wouldn't work after that column. I'll try to change the update server to enclose the columns in ticks to hopefully fix this problem and prevent further problems.

[John Adams]

You know, LE... I have been holding back some serious bitching about our column names being function/reserved names.

But yes, ticks will help. When we're all done here, I'll get on you about changing all the column names globally. HAHA.

[Aescleal]

Code: Select all

updateserveraddress=eq2emulator.net

Shouldn't this be:

Code: Select all

updateserveraddress=updates.eq2emulator.net

???

I thought I posted a complete example in the Update Server announcement thread.

Hi John, good catch! When I was changing things to see if it would help, and I removed updates just to test. I guess I forgot to put it back.

Both resolve to the same address so that line although not preferred, is fine. What version of mysql are you running? Could you run this query on your db and tell me the result:

select VERSION()

I get back... 5.1.30-community

[LethalEncounter]

Try to update now. I changed the update server to use ticks around the column names.

[Zcoretri]

Both resolve to the same address so that line although not preferred, is fine. What version of mysql are you running? Could you run this query on your db and tell me the result:

select VERSION()

I get back... 5.1.30-community[/quote]

As LE suspected

I guess you can either install a 5.0.xx version or wait for LE to fix, LOL, he posted a fix as I was writing this.