SQL and char creation issues/problems
Posted: Tue Jan 20, 2009 6:45 am
So i am having a few issues here.
First
From what i can tell part of the SQL is not updating or installing. i have tried to delete the EQ2 directory in SQL and recreated it only to have the same issue happen again. I don't know how big of an issue it is but it looks like some of the information is missing, as it loads no items or NPCs/Objects/Widgets/Etc.
According to the connection information that Navicat gives me it says that the SQL version is 5.1.30 community
EQ2Emu server is 6.0 - binary not self compiled - (I have downloaded and set up another copy of this as well thinking maybee that it had goten damaged somehow)
Game Version is 5343L
Windows XP SP3 - on both machines (Im running the server on one machine and the game on another, same network though)
Second
when i attempt to create a char it gives me an error
There was an error that prohibited the server from letting you play. please try again in a few minutes.
Server output - continued from top
When i look in the SQL table in the characters, it displays no information. I assume it failed gracefully, and recorded nothing. But im not sure how to fix this, or if its possible for me to fix this. Also i assume that most of the issues that im having are caused by the SQL information not loading properly when the server starts.
I did try and log into another server "TessEQ2", and was able to log and enter the world with no problems.
First
From what i can tell part of the SQL is not updating or installing. i have tried to delete the EQ2 directory in SQL and recreated it only to have the same issue happen again. I don't know how big of an issue it is but it looks like some of the information is missing, as it loads no items or NPCs/Objects/Widgets/Etc.
According to the connection information that Navicat gives me it says that the SQL version is 5.1.30 community
EQ2Emu server is 6.0 - binary not self compiled - (I have downloaded and set up another copy of this as well thinking maybee that it had goten damaged somehow)
Game Version is 5343L
Windows XP SP3 - on both machines (Im running the server on one machine and the game on another, same network though)
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: 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,tier,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,duration1,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 syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range,duration1,duration2,resistibility,hit_bonus,call_frequency) values(2,1,1,' at line 1
[Error] Attempting to update database table 'spell_tiers' data ... FAILED!
[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 character_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, radius, max_aoe_targets, req_concentration, range, duration1, duration2, resistibility, hp_upkeep, power_upkeep, duration_until_cancel, target_type, recovery, level, 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 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] 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..
<link2009>: Man, I never knew the internet could cause stress...
Starting factory Reader
Starting factory Writer
World server listening on: 98.166.58.168:9000
Connected to LoginServer: eq2emulator.net:9100
when i attempt to create a char it gives me an error
There was an error that prohibited the server from letting you play. please try again in a few minutes.
Server output - continued from top
Code: Select all
Starting factory Reader
Starting factory Writer
World server listening on: 98.166.58.168:9000
Connected to LoginServer: eq2emulator.net:9100
Delete char request: 3877 0
Name check on: Haha
Resp: 1
[Error] Error in SaveCharacter query 'Insert into characters (account_id, server_id, name, race, class, gender, diety, body_size, body_age, soga_wing_type, soga_chest_type, soga_legs_type, soga_hair_type, soga_race_type, legs_type, chest_type, wing_type, hair_type, race_type) values(3877, 1512, 'Haha', 2, 16, 2, 1, 0.800000, 0.040000, 0, 0, 0, 0, 5038, 5474, 5473, 0, 1127, 1478)': #1054: Unknown column 'diety' in 'field list'
[Error] Error in GetCharacterAdminStatus query 'SELECT admin_status from characters where account_id=3877 and id=0':
[Error] Error in GetCharacterName query 'SELECT name from characters where id=0':
Got signal 2I did try and log into another server "TessEQ2", and was able to log and enter the world with no problems.