SQL and char creation issues/problems

[aeco]

Ok so i tried to use an older version of MySQL 5.0.64 i think it was. that did not turn out well at all - lots of issues with the Op codes.

went back to the version i was using before 5.1.30-community. and tried what Bion suggested. that didnt seem to work either. same thing happened again. although i saved the codes into a file with an SQL extension and ran them as a batch file. it looked as if there was information in it and after looking at the error msg it looks like its trying to execute for some reason the same table. /sigh maybe i should stand on my head with my left leg at a 34 degree angle. my right leg at a 28 degree angel and a slight pitch outwards. and see if that works any better.

[John Adams]

Normally I lose interest in these sorts of total catastrophes, but for some reason you have me hoping for the best this time =)

Attached is the ENTIRE 0.6-Dev database, as you would receive if you fully connected and downloaded the updates from the LoginServer (Port 9102).

Last chance; create an empty DB (or empty your current one), source this SQL file into it, point your world_db.ini to the new DB, and everything will work perfectly (right? hah)

If not, may god have mercy on your soul.

[aeco]

Thank you so much... that removed that issue. there is still one more issue though the "Error Loading Spells" line. and i cant help but wonder, why it is that i was not able to download up to this point? or get that part of the table? and if the DB that you just gave me was complete and i assume working fine why is it not loading spells correctly?

Code: Select all

[Status] Using database 'eq2' at 127.0.0.1
[Status] CURRENT_WORLD_VERSION:EQ2EMu 0.6.0 Developer Alpha
[Status] ./LoginServer.ini read.
[Status] Connecting to Update Server..
[Status] 	Connected to Update Server: updates.eq2emulator.net:9101
[Status] 	Checking for updates.
[Status] 	Server is already up-to-date.
[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_skill, mastery_skill, tier, hp_req, power_req, cast_time, recast, radius, max_aoe_targets, req_concentration, range, duration1, duration2, resistibility, hp_upkeep, power_upkeep, duration_until_cancel, target_type, recovery, power_req_percent, hp_req_percent, icon, icon2, icontype, success_message, fade_message, cast_type, lua_script, call_frequency, interruptable, spell_visual, effect_message, min_range, can_effect_raid, affect_only_group_members, hit_bonus, spell_text_color from spells, spell_tiers where spells.id = spell_tiers.spell_id order by tier, Error: #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, 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..
I'm counting how many times you've opened this...
Starting factory Reader
Starting factory Writer
World server listening on: 98.166.58.168:9000
World server listening on: 192.168.1.103:9000
Starting static zones...
Connected to LoginServer: eq2emulator.net:9100

[John Adams]

Welp, unfortunately I think this is all you my friend =) I just ran the SVN version of EQ2World.exe (SVN version 200) connecting to the database I just sent you, and it works perfectly.

I don't know what to tell you. I'm sure you'll get it sorted out eventually... but all things have been eliminated on our side. DB is right, EXE is right, structs are right...

[John Adams]

Ahem.. See this?

Code: Select all

[Status]    Connected to Update Server: updates.eq2emulator.net:9101

You are NOT connecting to the right DB update port. Please check again, and double check all your config files. There is no way it would say 9101 if you were pointing to 9102. Though if you sourced my database, even 9101 should not be screwing you up.

[aeco]

lol .. haha i had changed that at one point to test an idea .. but i changed it back after trying the db you gave me. sorry i should have changed it before posting the output. thank you very kindly for all of your help and every one else who has pitched in to this point. thank you all very much so.

[yoyu007]

It is a big problem

I got the same wrong,and i tried many times followed the above suggest,but it failed many times

[Aescleal]

Hmm.
I have followed all that was suggested as well. Here is my last screen copy after loading fresh from Johns attached db zip.

Code: Select all

[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: updates.eq2emulator.net:9102
[Status]        Checking for updates.
[Status]        Server is already up-to-date.
[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..
Please stand behind the yellow line before I start chopping off heads.
Starting factory Reader
Starting factory Writer
World server listening on: localhost:9000
Connected to LoginServer: eq2emulator.net:9100

I'm not sure what to do from here.'
I should mention that I haven't compiled, I am simply running the win32binary version EQ2Emulator0.6.0_Win32Binary.
I'll add these, as maybe it will help someone tell me what a duh I am.
LoginServer

Code: Select all

[LoginServer]
loginserver=eq2emulator.net
loginport=9100
worldname=CORE
worldaddress=localhost
#internalworldaddress=  (If used, otherwise blank)
worldport=9000
locked=false
account=CoreAdmin
password=********
#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=updates.eq2emulator.net
updateserverport=9102

[LoginConfig]
ServerMode=StandAlone
ServerPort=9100

world_db

Code: Select all

[Database]
host=localhost
user=root
password=********
database=EQ2

[yoyu007]

good ,after the Update Server Changed,the problem is finished