|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Support::Windows Servers Support forum for Windows EQEMu users. |
05-18-2016, 12:25 AM
|
|
Hill Giant
|
|
Join Date: Dec 2004
Location: Pittsburgh, PA
Posts: 128
|
|
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),
|
05-18-2016, 12:21 PM
|
 |
Developer
|
|
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
|
|
__________________
Uleat of Bertoxxulous
Compilin' Dirty
|
 |
|
 |
05-18-2016, 06:08 PM
|
|
Hill Giant
|
|
Join Date: Dec 2004
Location: Pittsburgh, PA
Posts: 128
|
|
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),
|
 |
|
 |
|
|
|
05-18-2016, 07:23 PM
|
|
Hill Giant
|
|
Join Date: Dec 2004
Location: Pittsburgh, PA
Posts: 128
|
|
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)
|
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Hybrid Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 07:11 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
