Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 05-18-2016, 12:25 AM
cannon
Hill Giant
 
Join Date: Dec 2004
Location: Pittsburgh, PA
Posts: 128
Default Error in zone window

Code:
[MySQL Error] 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
 REPLACE INTO `character_bind` (id, zone_id, instance_id, x, y, z, heading, slot) VALUES (4111710024, 4111709984, 4111709944, 0.000000, -92559592117434152000000000000000000000000000000000000000000000.000000, 0.000000, 18.000000, 0), (0, 0, 0, -92559592124965292000000000000000000000000000000000000000000000.000000, -92559592117432622000000000000000000000000000000000000000000000.000000, 0.000000, -1023.000000, 0),
Reply With Quote
  #2  
Old 05-18-2016, 12:21 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

Is your database up-to-date?

https://github.com/EQEmu/Server/blob...ary_recall.sql
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #3  
Old 05-18-2016, 06:08 PM
cannon
Hill Giant
 
Join Date: Dec 2004
Location: Pittsburgh, PA
Posts: 128
Default

It was up to date a few days ago when i installed the server using the windows install guide. then i started getting this after activating bots and mercs. Seems to happen directly after an account and character are created. just seen your link to sql, i will give that a try
UPDATE: That table already has the columns and tables needed from the sql.

Code:
[Status] SoF Start zone query: SELECT x, y, z, heading, start_zone, bind_id FROM start_zones WHERE zone_id = 49 AND player_class = 1 AND player_deity = 396 AND player_race = 10

[Status] Found starting location in start_zones
[MySQL Error] 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
 REPLACE INTO `character_bind` (id, zone_id, instance_id, x, y, z, heading, slot) VALUES (4111710024, 4111709984, 4111709944, 0.000000, -92559592117434152000000000000000000000000000000000000000000000.000000, 0.000000, 18.000000, 0), (0, 0, 0, -92559592124965315000000000000000000000000000000000000000000000.000000, -92559592117432553000000000000000000000000000000000000000000000.000000, 0.000000, 71.000000, 0),
Reply With Quote
  #4  
Old 05-18-2016, 07:23 PM
cannon
Hill Giant
 
Join Date: Dec 2004
Location: Pittsburgh, PA
Posts: 128
Default

Not sure if the zone log has any clues.

Code:
[05-16-2016 :: 17:20:46] [Zone Server] CURRENT_VERSION: 1.1.3
[05-16-2016 :: 17:20:46] [Zone Server] Mapping Incoming Opcodes
[05-16-2016 :: 17:20:46] [Zone Server] Loading Variables
[05-16-2016 :: 17:20:46] [Zone Server] Loading zone names
[05-16-2016 :: 17:20:46] [Zone Server] Loading items
[05-16-2016 :: 17:20:46] [Zone Server] Loading npc faction lists
[05-16-2016 :: 17:20:46] [Zone Server] Loading loot tables
[05-16-2016 :: 17:20:46] [Zone Server] Loading skill caps
[05-16-2016 :: 17:20:46] [Zone Server] Loading spells
[05-16-2016 :: 17:20:46] [Zone Server] Loading base data
[05-16-2016 :: 17:20:46] [Zone Server] Loading guilds
[05-16-2016 :: 17:20:46] [Zone Server] Loading factions
[05-16-2016 :: 17:20:46] [Zone Server] Loading titles
[05-16-2016 :: 17:20:46] [Zone Server] Loading tributes
[05-16-2016 :: 17:20:46] [Zone Server] Loading corpse timers
[05-16-2016 :: 17:20:46] [Zone Server] Loading commands
[05-16-2016 :: 17:20:47] [Zone Server] 255 commands loaded
[05-16-2016 :: 17:20:47] [Zone Server] Loaded default rule set 'default'
[05-16-2016 :: 17:20:47] [Zone Server] Loading bot commands
[05-16-2016 :: 17:20:47] [Zone Server] 98 bot commands loaded
[05-16-2016 :: 17:20:47] [Zone Server] Loading Perl Event Export Settings...
[05-16-2016 :: 17:20:47] [Zone Server] Loading quests
[05-16-2016 :: 17:20:47] [Quests] Tying perl output to eqemu logs
[05-16-2016 :: 17:20:47] [Quests] Creating EQEmuIO=HASH(0x1da5aae15c8)
[05-16-2016 :: 17:20:47] [Quests] Creating EQEmuIO=HASH(0x1da5aae1be0)
[05-16-2016 :: 17:20:47] [Quests] Loading perlemb plugins.
[05-16-2016 :: 17:20:47] [Quests] Unquoted string "false" may clash with future reserved word at plugins/Expeditions.pl line 375.
[05-16-2016 :: 17:20:47] [Quests] Subroutine Cwd::fastcwd redefined at C:/Perl64/lib/Cwd.pm line 824.
[05-16-2016 :: 17:20:47] [Quests] Subroutine Cwd::getcwd redefined at C:/Perl64/lib/Cwd.pm line 824.
[05-16-2016 :: 17:20:47] [Quests] Subroutine Cwd::abs_path redefined at C:/Perl64/lib/Cwd.pm line 824.
[05-16-2016 :: 17:20:47] [Quests] Subroutine CalcDestFromHeading redefined at plugins/path_tools.pl line 221.
[05-16-2016 :: 17:20:47] [Quests] "my" variable $Item1 masks earlier declaration in same scope at plugins/quest_handin.pl line 19.
[05-16-2016 :: 17:20:47] [Quests] "my" variable $Item2 masks earlier declaration in same scope at plugins/quest_handin.pl line 21.
[05-16-2016 :: 17:20:47] [Quests] "my" variable $Item3 masks earlier declaration in same scope at plugins/quest_handin.pl line 23.
[05-16-2016 :: 17:20:47] [Quests] "my" variable $Item4 masks earlier declaration in same scope at plugins/quest_handin.pl line 25.
[05-16-2016 :: 17:20:47] [Quests] Subroutine GetReverseHeading redefined at plugins/spawn_utils.pl line 456.
[05-16-2016 :: 17:20:47] [Quests] Subroutine ConvertHeadingToDegrees redefined at plugins/spawn_utils.pl line 477.
[05-16-2016 :: 17:20:47] [Quests] Subroutine MakeTempPet redefined at (eval 54) line 1.
[05-16-2016 :: 17:20:47] [Quests] Subroutine MakeTempPet redefined at (eval 54) line 1.
[05-16-2016 :: 17:20:47] [Quests] Subroutine GetSkill redefined at (eval 54) line 1.
[05-16-2016 :: 17:20:47] [Quests] Subroutine SignalClient redefined at (eval 54) line 1.
[05-16-2016 :: 17:20:47] [Quests] Subroutine MakeTempPet redefined at (eval 54) line 1.
[05-16-2016 :: 17:20:47] [Quests] Subroutine MakeTempPet redefined at (eval 54) line 1.
[05-16-2016 :: 17:20:47] [Zone Server] Entering sleep mode
[05-16-2016 :: 17:20:47] [Zone Server] Starting EQ Network server on port 7002
[05-16-2016 :: 17:20:47] [Quests] Terminating on signal SIGHUP(1)
[05-16-2016 :: 17:24:26] [Zone Server] CURRENT_VERSION: 1.1.3
[05-16-2016 :: 17:24:26] [Zone Server] Mapping Incoming Opcodes
[05-16-2016 :: 17:24:26] [Zone Server] Loading Variables
[05-16-2016 :: 17:24:26] [Zone Server] Loading zone names
[05-16-2016 :: 17:24:26] [Zone Server] Loading items
[05-16-2016 :: 17:24:26] [Zone Server] Loading npc faction lists
[05-16-2016 :: 17:24:26] [Zone Server] Loading loot tables
[05-16-2016 :: 17:24:26] [Zone Server] Loading skill caps
[05-16-2016 :: 17:24:26] [Zone Server] Loading spells
[05-16-2016 :: 17:24:26] [Zone Server] Loading base data
[05-16-2016 :: 17:24:26] [Zone Server] Loading guilds
[05-16-2016 :: 17:24:26] [Zone Server] Loading factions
[05-16-2016 :: 17:24:26] [Zone Server] Loading titles
[05-16-2016 :: 17:24:26] [Zone Server] Loading tributes
[05-16-2016 :: 17:24:26] [Zone Server] Loading corpse timers
[05-16-2016 :: 17:24:26] [Zone Server] Loading commands
[05-16-2016 :: 17:24:26] [Zone Server] 255 commands loaded
[05-16-2016 :: 17:24:26] [Zone Server] Loaded default rule set 'default'
[05-16-2016 :: 17:24:26] [Zone Server] Loading bot commands
[05-16-2016 :: 17:24:26] [Zone Server] 98 bot commands loaded
[05-16-2016 :: 17:24:26] [Zone Server] Loading Perl Event Export Settings...
[05-16-2016 :: 17:24:26] [Zone Server] Loading quests
[05-16-2016 :: 17:24:26] [Quests] Tying perl output to eqemu logs
[05-16-2016 :: 17:24:26] [Quests] Creating EQEmuIO=HASH(0x1204eb75608)
[05-16-2016 :: 17:24:26] [Quests] Creating EQEmuIO=HASH(0x1204eb75c20)
[05-16-2016 :: 17:24:26] [Quests] Loading perlemb plugins.
[05-16-2016 :: 17:24:26] [Quests] Unquoted string "false" may clash with future reserved word at plugins/Expeditions.pl line 375.
[05-16-2016 :: 17:24:26] [Quests] Subroutine Cwd::fastcwd redefined at C:/Perl64/lib/Cwd.pm line 824.
[05-16-2016 :: 17:24:26] [Quests] Subroutine Cwd::getcwd redefined at C:/Perl64/lib/Cwd.pm line 824.
[05-16-2016 :: 17:24:26] [Quests] Subroutine Cwd::abs_path redefined at C:/Perl64/lib/Cwd.pm line 824.
[05-16-2016 :: 17:24:26] [Quests] Subroutine CalcDestFromHeading redefined at plugins/path_tools.pl line 221.
[05-16-2016 :: 17:24:26] [Quests] "my" variable $Item1 masks earlier declaration in same scope at plugins/quest_handin.pl line 19.
[05-16-2016 :: 17:24:26] [Quests] "my" variable $Item2 masks earlier declaration in same scope at plugins/quest_handin.pl line 21.
[05-16-2016 :: 17:24:26] [Quests] "my" variable $Item3 masks earlier declaration in same scope at plugins/quest_handin.pl line 23.
[05-16-2016 :: 17:24:26] [Quests] "my" variable $Item4 masks earlier declaration in same scope at plugins/quest_handin.pl line 25.
[05-16-2016 :: 17:24:26] [Quests] Subroutine GetReverseHeading redefined at plugins/spawn_utils.pl line 456.
[05-16-2016 :: 17:24:26] [Quests] Subroutine ConvertHeadingToDegrees redefined at plugins/spawn_utils.pl line 477.
[05-16-2016 :: 17:24:26] [Quests] Subroutine MakeTempPet redefined at (eval 54) line 1.
[05-16-2016 :: 17:24:26] [Quests] Subroutine MakeTempPet redefined at (eval 54) line 1.
[05-16-2016 :: 17:24:26] [Quests] Subroutine GetSkill redefined at (eval 54) line 1.
[05-16-2016 :: 17:24:26] [Quests] Subroutine SignalClient redefined at (eval 54) line 1.
[05-16-2016 :: 17:24:26] [Quests] Subroutine MakeTempPet redefined at (eval 54) line 1.
[05-16-2016 :: 17:24:26] [Quests] Subroutine MakeTempPet redefined at (eval 54) line 1.
[05-16-2016 :: 17:24:26] [Zone Server] Entering sleep mode
[05-16-2016 :: 17:24:26] [Zone Server] Starting EQ Network server on port 7000
[05-16-2016 :: 17:33:53] [Quests] Terminating on signal SIGHUP(1)
[05-18-2016 :: 01:01:00] [Zone Server] CURRENT_VERSION: 1.1.3
[05-18-2016 :: 01:01:00] [Zone Server] Mapping Incoming Opcodes
[05-18-2016 :: 01:01:00] [Zone Server] Loading Variables
[05-18-2016 :: 01:01:00] [Zone Server] Loading zone names
[05-18-2016 :: 01:01:00] [Zone Server] Loading items
[05-18-2016 :: 01:01:00] [Zone Server] Loading npc faction lists
[05-18-2016 :: 01:01:00] [Zone Server] Loading loot tables
[05-18-2016 :: 01:01:00] [Zone Server] Loading skill caps
[05-18-2016 :: 01:01:00] [Zone Server] Loading spells
[05-18-2016 :: 01:01:00] [Zone Server] Loading base data
[05-18-2016 :: 01:01:00] [Zone Server] Loading guilds
[05-18-2016 :: 01:01:00] [Zone Server] Loading factions
[05-18-2016 :: 01:01:01] [Zone Server] Loading titles
[05-18-2016 :: 01:01:01] [Zone Server] Loading tributes
[05-18-2016 :: 01:01:01] [Zone Server] Loading corpse timers
[05-18-2016 :: 01:01:01] [Zone Server] Loading commands
[05-18-2016 :: 01:01:01] [Zone Server] 255 commands loaded
[05-18-2016 :: 01:01:01] [Zone Server] Loaded default rule set 'default'
[05-18-2016 :: 01:01:01] [Zone Server] Loading bot commands
[05-18-2016 :: 01:01:01] [Zone Server] 98 bot commands loaded
[05-18-2016 :: 01:01:01] [Zone Server] Loading Perl Event Export Settings...
[05-18-2016 :: 01:01:01] [Zone Server] Loading quests
[05-18-2016 :: 01:01:01] [Quests] Tying perl output to eqemu logs
[05-18-2016 :: 01:01:01] [Quests] Creating EQEmuIO=HASH(0x1acf59025d8)
[05-18-2016 :: 01:01:01] [Quests] Creating EQEmuIO=HASH(0x1acf5902bf0)
[05-18-2016 :: 01:01:01] [Quests] Loading perlemb plugins.
[05-18-2016 :: 01:01:01] [Quests] Unquoted string "false" may clash with future reserved word at plugins/Expeditions.pl line 375.
[05-18-2016 :: 01:01:01] [Quests] Subroutine Cwd::fastcwd redefined at C:/Perl64/lib/Cwd.pm line 824.
[05-18-2016 :: 01:01:01] [Quests] Subroutine Cwd::getcwd redefined at C:/Perl64/lib/Cwd.pm line 824.
[05-18-2016 :: 01:01:01] [Quests] Subroutine Cwd::abs_path redefined at C:/Perl64/lib/Cwd.pm line 824.
[05-18-2016 :: 01:01:01] [Quests] Subroutine CalcDestFromHeading redefined at plugins/path_tools.pl line 221.
[05-18-2016 :: 01:01:01] [Quests] "my" variable $Item1 masks earlier declaration in same scope at plugins/quest_handin.pl line 19.
[05-18-2016 :: 01:01:01] [Quests] "my" variable $Item2 masks earlier declaration in same scope at plugins/quest_handin.pl line 21.
[05-18-2016 :: 01:01:01] [Quests] "my" variable $Item3 masks earlier declaration in same scope at plugins/quest_handin.pl line 23.
[05-18-2016 :: 01:01:01] [Quests] "my" variable $Item4 masks earlier declaration in same scope at plugins/quest_handin.pl line 25.
[05-18-2016 :: 01:01:01] [Quests] Subroutine GetReverseHeading redefined at plugins/spawn_utils.pl line 456.
[05-18-2016 :: 01:01:01] [Quests] Subroutine ConvertHeadingToDegrees redefined at plugins/spawn_utils.pl line 477.
[05-18-2016 :: 01:01:01] [Quests] Subroutine MakeTempPet redefined at (eval 54) line 1.
[05-18-2016 :: 01:01:01] [Quests] Subroutine MakeTempPet redefined at (eval 54) line 1.
[05-18-2016 :: 01:01:01] [Quests] Subroutine GetSkill redefined at (eval 54) line 1.
[05-18-2016 :: 01:01:01] [Quests] Subroutine SignalClient redefined at (eval 54) line 1.
[05-18-2016 :: 01:01:01] [Quests] Subroutine MakeTempPet redefined at (eval 54) line 1.
[05-18-2016 :: 01:01:01] [Quests] Subroutine MakeTempPet redefined at (eval 54) line 1.
[05-18-2016 :: 01:01:01] [Zone Server] Entering sleep mode
[05-18-2016 :: 01:01:01] [Zone Server] Starting EQ Network server on port 7004
[05-18-2016 :: 07:12:29] [Status] Booting tutorialb (189:0)
[05-18-2016 :: 07:12:29] [Status] Loading spawn conditions...
[05-18-2016 :: 07:12:30] [Status] Loading static zone points...
[05-18-2016 :: 07:12:30] [Status] Loading spawn groups...
[05-18-2016 :: 07:12:30] [Status] Loading spawn2 points...
[05-18-2016 :: 07:12:30] [Status] Loading player corpses...
[05-18-2016 :: 07:12:30] [Status] Loading traps...
[05-18-2016 :: 07:12:30] [Status] Loading adventure flavor text...
[05-18-2016 :: 07:12:30] [Status] Loading ground spawns...
[05-18-2016 :: 07:12:30] [Status] Loading Ground Spawns from DB...
[05-18-2016 :: 07:12:30] [Status] Loading World Objects from DB...
[05-18-2016 :: 07:12:30] [Status] Loading Objects from DB...
[05-18-2016 :: 07:12:30] [Status] Flushing old respawn timers...
[05-18-2016 :: 07:12:30] [Status] Loading doors for tutorialb ...
[05-18-2016 :: 07:12:31] [Status] Loading Doors from database...
[05-18-2016 :: 07:12:32] [Status] Loading Alternate Advancement Data...
[05-18-2016 :: 07:12:32] [Status] Loading Alternate Advancement Abilities...
[05-18-2016 :: 07:12:32] [Status] Loaded 1567 Alternate Advancement Abilities
[05-18-2016 :: 07:12:32] [Status] Loading Alternate Advancement Ability Ranks...
[05-18-2016 :: 07:12:32] [Status] Loaded 6651 Alternate Advancement Ability Ranks
[05-18-2016 :: 07:12:32] [Status] Loading Alternate Advancement Ability Rank Effects...
[05-18-2016 :: 07:12:32] [Status] Loaded Alternate Advancement Ability Rank Effects
[05-18-2016 :: 07:12:32] [Status] Loading Alternate Advancement Ability Rank Prereqs...
[05-18-2016 :: 07:12:32] [Status] Loaded Alternate Advancement Ability Rank Prereqs
[05-18-2016 :: 07:12:32] [Status] Processing Alternate Advancement Data...
[05-18-2016 :: 07:12:32] [Status] Loaded Alternate Advancement Data
[05-18-2016 :: 07:12:32] [Status] Loading Merchant Lists...
[05-18-2016 :: 07:12:32] [Status] Loading Temporary Merchant Lists...
[05-18-2016 :: 07:12:32] [Status] Successfully loaded Zone Config.
[05-18-2016 :: 07:12:32] [Status] Loading timezone data...
[05-18-2016 :: 07:12:32] [Status] Init Finished: ZoneID = 189, Time Offset = 0
[05-18-2016 :: 07:12:32] [Error] Path File ./Maps/tutorialb.path not found.
[05-18-2016 :: 07:12:32] [Normal] ---- Zone server tutorialb, listening on port:7004 ----
[05-18-2016 :: 07:12:32] [Status] Zone Bootup: tutorialb (189: 0)
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 03:44 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3