Archived copy of war3source.com, the War3Source forum (2009–2020), rebuilt from the Internet Archive by wc3mods.net. This page was captured on 2012-10-24 (original capture). Forum · All archived topics · Wiki · Bug tracker · Blog
Chat

War3:Source
October 24, 2012, 10:04:13 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?
Login with username, password and session length
News: Download: http://war3source.com/index.php?board=9.0
What is War3Source?: http://war3source.com/index.php?topic=200.0
Sample Stats: http://war3source.com/war3stats
Steam Community Group: http://steamcommunity.com/groups/war3source
War3Source SVN Checkout: http://ownageclan.com/svn/war3source/
War3Source servers: http://www.game-monitor.com/search.php?vars=war3_version= 		 
   Home   Help Search Login Register  
War3:Source > General Discussion > War3: Source - Support > debugging sql shit
Pages: [1]
« previous next »
  Print  
Author Topic: debugging sql shit  (Read 241 times)
[Oddity]TeacherCreature
Sr. Member
****
Posts: 463


View Profile
« on: July 02, 2010, 06:09:11 PM »
Figure this is a better forum for our discussion

Ok latest build with sql fix returned this log: I think it is working!

L 07/02/2010 - 18:07:11: [War3Source.smx] (0) SQL error: Lost connection to MySQL server during query
L 07/02/2010 - 18:07:11: [War3Source.smx] (0) SQL error: Lost connection to MySQL server during query
L 07/02/2010 - 18:07:11: [War3Source.smx] (0) SQL error: Lost connection to MySQL server during query
L 07/02/2010 - 18:07:11: [War3Source.smx] (0) SQL error: Lost connection to MySQL server during query
L 07/02/2010 - 18:07:11: [War3Source.smx] (0) SQL error: Lost connection to MySQL server during query
L 07/02/2010 - 18:07:11: [War3Source.smx] (0) SQL error: Lost connection to MySQL server during query
L 07/02/2010 - 18:07:11: [War3Source.smx] (0) SQL error: Lost connection to MySQL server during query
L 07/02/2010 - 18:07:11: [War3Source.smx] (0) SQL error: Lost connection to MySQL server during query
L 07/02/2010 - 18:07:17: [War3Source.smx] firsttimeplayer INSERT INTO war3source_undead (steamid,level,xp) VALUES ('STEAM_0:0:15732879','0','0')
L 07/02/2010 - 18:07:17: [War3Source.smx] firsttimeplayer INSERT INTO war3source_human (steamid,level,xp) VALUES ('STEAM_0:0:15732879','0','0')
L 07/02/2010 - 18:07:17: [War3Source.smx] firsttimeplayer INSERT INTO war3source_orc (steamid,level,xp) VALUES ('STEAM_0:0:15732879','0','0')
L 07/02/2010 - 18:07:17: [War3Source.smx] firsttimeplayer INSERT INTO war3source_nightelf (steamid,level,xp) VALUES ('STEAM_0:0:15732879','0','0')
L 07/02/2010 - 18:07:17: [War3Source.smx] firsttimeplayer INSERT INTO war3source_mage (steamid,level,xp) VALUES ('STEAM_0:0:15732879','0','0')
L 07/02/2010 - 18:07:17: [War3Source.smx] firsttimeplayer INSERT INTO war3source_hunter (steamid,level,xp) VALUES ('STEAM_0:0:15732879','0','0')
L 07/02/2010 - 18:07:17: [War3Source.smx] firsttimeplayer INSERT INTO war3source_warden (steamid,level,xp) VALUES ('STEAM_0:0:15732879','0','0')
L 07/02/2010 - 18:07:18: [War3Source.smx] firsttimeplayer INSERT INTO war3source_crypt (steamid,level,xp) VALUES ('STEAM_0:0:15732879','0','0')
L 07/02/2010 - 18:07:18: [War3Source.smx] firsttimeplayer INSERT INTO war3source_cd (steamid,level,xp) VALUES ('STEAM_0:0:15732879','0','0')
L 07/02/2010 - 18:07:18: [War3Source.smx] firsttimeplayer INSERT INTO war3source_sr (steamid,level,xp) VALUES ('STEAM_0:0:15732879','0','0')
L 07/02/2010 - 18:07:18: [War3Source.smx] firsttimeplayer INSERT INTO war3source_undead (steamid,level,xp) VALUES ('STEAM_0:1:25329736','0','0')
L 07/02/2010 - 18:07:18: [War3Source.smx] firsttimeplayer INSERT INTO war3source_human (steamid,level,xp) VALUES ('STEAM_0:1:25329736','0','0')
L 07/02/2010 - 18:07:18: [War3Source.smx] firsttimeplayer INSERT INTO war3source_orc (steamid,level,xp) VALUES ('STEAM_0:1:25329736','0','0')
L 07/02/2010 - 18:07:18: [War3Source.smx] firsttimeplayer INSERT INTO war3source_nightelf (steamid,level,xp) VALUES ('STEAM_0:1:25329736','0','0')
L 07/02/2010 - 18:07:18: [War3Source.smx] firsttimeplayer INSERT INTO war3source_mage (steamid,level,xp) VALUES ('STEAM_0:1:25329736','0','0')
L 07/02/2010 - 18:07:19: [War3Source.smx] firsttimeplayer INSERT INTO war3source_hunter (steamid,level,xp) VALUES ('STEAM_0:1:25329736','0','0')
L 07/02/2010 - 18:07:19: [War3Source.smx] firsttimeplayer INSERT INTO war3source_warden (steamid,level,xp) VALUES ('STEAM_0:1:25329736','0','0')
L 07/02/2010 - 18:07:19: [War3Source.smx] firsttimeplayer INSERT INTO war3source_crypt (steamid,level,xp) VALUES ('STEAM_0:1:25329736','0','0')
L 07/02/2010 - 18:07:19: [War3Source.smx] firsttimeplayer INSERT INTO war3source_cd (steamid,level,xp) VALUES ('STEAM_0:1:25329736','0','0')
L 07/02/2010 - 18:07:19: [War3Source.smx] firsttimeplayer INSERT INTO war3source_sr (steamid,level,xp) VALUES ('STEAM_0:1:25329736','0','0')
L 07/02/2010 - 18:07:19: [War3Source.smx] firsttimeplayer INSERT INTO war3source_undead (steamid,level,xp) VALUES ('STEAM_0:0:7832547','0','0')
L 07/02/2010 - 18:07:19: [War3Source.smx] firsttimeplayer INSERT INTO war3source_human (steamid,level,xp) VALUES ('STEAM_0:0:7832547','0','0')
L 07/02/2010 - 18:07:19: [War3Source.smx] firsttimeplayer INSERT INTO war3source_orc (steamid,level,xp) VALUES ('STEAM_0:0:7832547','0','0')
L 07/02/2010 - 18:07:19: [War3Source.smx] firsttimeplayer INSERT INTO war3source_nightelf (steamid,level,xp) VALUES ('STEAM_0:0:7832547','0','0')
L 07/02/2010 - 18:07:20: [War3Source.smx] firsttimeplayer INSERT INTO war3source_mage (steamid,level,xp) VALUES ('STEAM_0:0:7832547','0','0')
L 07/02/2010 - 18:07:20: [War3Source.smx] firsttimeplayer INSERT INTO war3source_hunter (steamid,level,xp) VALUES ('STEAM_0:0:7832547','0','0')
L 07/02/2010 - 18:07:20: [War3Source.smx] firsttimeplayer INSERT INTO war3source_warden (steamid,level,xp) VALUES ('STEAM_0:0:7832547','0','0')
L 07/02/2010 - 18:07:20: [War3Source.smx] firsttimeplayer INSERT INTO war3source_crypt (steamid,level,xp) VALUES ('STEAM_0:0:7832547','0','0')
L 07/02/2010 - 18:07:20: [War3Source.smx] firsttimeplayer INSERT INTO war3source_cd (steamid,level,xp) VALUES ('STEAM_0:0:7832547','0','0')
L 07/02/2010 - 18:07:20: [War3Source.smx] firsttimeplayer INSERT INTO war3source_sr (steamid,level,xp) VALUES ('STEAM_0:0:7832547','0','0')
L 07/02/2010 - 18:07:20: [War3Source.smx] firsttimeplayer INSERT INTO war3source_undead (steamid,level,xp) VALUES ('STEAM_0:1:1040525','0','0')
L 07/02/2010 - 18:07:20: [War3Source.smx] firsttimeplayer INSERT INTO war3source_human (steamid,level,xp) VALUES ('STEAM_0:1:1040525','0','0')
L 07/02/2010 - 18:07:20: [War3Source.smx] firsttimeplayer INSERT INTO war3source_orc (steamid,level,xp) VALUES ('STEAM_0:1:1040525','0','0')
L 07/02/2010 - 18:07:21: [War3Source.smx] firsttimeplayer INSERT INTO war3source_nightelf (steamid,level,xp) VALUES ('STEAM_0:1:1040525','0','0')
L 07/02/2010 - 18:07:21: [War3Source.smx] firsttimeplayer INSERT INTO war3source_mage (steamid,level,xp) VALUES ('STEAM_0:1:1040525','0','0')
L 07/02/2010 - 18:07:21: [War3Source.smx] firsttimeplayer INSERT INTO war3source_hunter (steamid,level,xp) VALUES ('STEAM_0:1:1040525','0','0')
L 07/02/2010 - 18:07:21: [War3Source.smx] firsttimeplayer INSERT INTO war3source_warden (steamid,level,xp) VALUES ('STEAM_0:1:1040525','0','0')
L 07/02/2010 - 18:07:21: [War3Source.smx] firsttimeplayer INSERT INTO war3source_crypt (steamid,level,xp) VALUES ('STEAM_0:1:1040525','0','0')
L 07/02/2010 - 18:07:21: [War3Source.smx] firsttimeplayer INSERT INTO war3source_cd (steamid,level,xp) VALUES ('STEAM_0:1:1040525','0','0')
L 07/02/2010 - 18:07:21: [War3Source.smx] firsttimeplayer INSERT INTO war3source_sr (steamid,level,xp) VALUES ('STEAM_0:1:1040525','0','0')
L 07/02/2010 - 18:07:25: [War3Source.smx] firsttimeplayer INSERT INTO war3source_undead (steamid,level,xp) VALUES ('STEAM_0:0:20600666','0','0')
L 07/02/2010 - 18:07:25: [War3Source.smx] firsttimeplayer INSERT INTO war3source_human (steamid,level,xp) VALUES ('STEAM_0:0:20600666','0','0')
L 07/02/2010 - 18:07:25: [War3Source.smx] firsttimeplayer INSERT INTO war3source_orc (steamid,level,xp) VALUES ('STEAM_0:0:20600666','0','0')
L 07/02/2010 - 18:07:25: [War3Source.smx] firsttimeplayer INSERT INTO war3source_nightelf (steamid,level,xp) VALUES ('STEAM_0:0:20600666','0','0')
L 07/02/2010 - 18:07:25: [War3Source.smx] firsttimeplayer INSERT INTO war3source_mage (steamid,level,xp) VALUES ('STEAM_0:0:20600666','0','0')
L 07/02/2010 - 18:07:25: [War3Source.smx] firsttimeplayer INSERT INTO war3source_hunter (steamid,level,xp) VALUES ('STEAM_0:0:20600666','0','0')
L 07/02/2010 - 18:07:25: [War3Source.smx] firsttimeplayer INSERT INTO war3source_warden (steamid,level,xp) VALUES ('STEAM_0:0:20600666','0','0')
L 07/02/2010 - 18:07:25: [War3Source.smx] firsttimeplayer INSERT INTO war3source_crypt (steamid,level,xp) VALUES ('STEAM_0:0:20600666','0','0')
L 07/02/2010 - 18:07:25: [War3Source.smx] firsttimeplayer INSERT INTO war3source_cd (steamid,level,xp) VALUES ('STEAM_0:0:20600666','0','0')
L 07/02/2010 - 18:07:26: [War3Source.smx] firsttimeplayer INSERT INTO war3source_sr (steamid,level,xp) VALUES ('STEAM_0:0:20600666','0','0')
L 07/02/2010 - 18:07:29: [War3Source.smx] firsttimeplayer INSERT INTO war3source_undead (steamid,level,xp) VALUES ('STEAM_0:1:27442812','0','0')
L 07/02/2010 - 18:07:29: [War3Source.smx] firsttimeplayer INSERT INTO war3source_human (steamid,level,xp) VALUES ('STEAM_0:1:27442812','0','0')
L 07/02/2010 - 18:07:29: [War3Source.smx] firsttimeplayer INSERT INTO war3source_orc (steamid,level,xp) VALUES ('STEAM_0:1:27442812','0','0')
L 07/02/2010 - 18:07:29: [War3Source.smx] firsttimeplayer INSERT INTO war3source_nightelf (steamid,level,xp) VALUES ('STEAM_0:1:27442812','0','0')
L 07/02/2010 - 18:07:29: [War3Source.smx] firsttimeplayer INSERT INTO war3source_mage (steamid,level,xp) VALUES ('STEAM_0:1:27442812','0','0')
L 07/02/2010 - 18:07:30: [War3Source.smx] firsttimeplayer INSERT INTO war3source_hunter (steamid,level,xp) VALUES ('STEAM_0:1:27442812','0','0')
L 07/02/2010 - 18:07:30: [War3Source.smx] firsttimeplayer INSERT INTO war3source_warden (steamid,level,xp) VALUES ('STEAM_0:1:27442812','0','0')
L 07/02/2010 - 18:07:30: [War3Source.smx] firsttimeplayer INSERT INTO war3source_crypt (steamid,level,xp) VALUES ('STEAM_0:1:27442812','0','0')
L 07/02/2010 - 18:07:30: [War3Source.smx] firsttimeplayer INSERT INTO war3source_cd (steamid,level,xp) VALUES ('STEAM_0:1:27442812','0','0')
L 07/02/2010 - 18:07:30: [War3Source.smx] firsttimeplayer INSERT INTO war3source_sr (steamid,level,xp) VALUES ('STEAM_0:1:27442812','0','0')
L 07/02/2010 - 18:07:34: [War3Source.smx] firsttimeplayer INSERT INTO war3source_undead (steamid,level,xp) VALUES ('STEAM_0:1:29322373','0','0')
L 07/02/2010 - 18:07:34: [War3Source.smx] firsttimeplayer INSERT INTO war3source_human (steamid,level,xp) VALUES ('STEAM_0:1:29322373','0','0')
L 07/02/2010 - 18:07:34: [War3Source.smx] firsttimeplayer INSERT INTO war3source_orc (steamid,level,xp) VALUES ('STEAM_0:1:29322373','0','0')
L 07/02/2010 - 18:07:34: [War3Source.smx] firsttimeplayer INSERT INTO war3source_nightelf (steamid,level,xp) VALUES ('STEAM_0:1:29322373','0','0')
L 07/02/2010 - 18:07:35: [War3Source.smx] firsttimeplayer INSERT INTO war3source_mage (steamid,level,xp) VALUES ('STEAM_0:1:29322373','0','0')
L 07/02/2010 - 18:07:35: [War3Source.smx] firsttimeplayer INSERT INTO war3source_hunter (steamid,level,xp) VALUES ('STEAM_0:1:29322373','0','0')
L 07/02/2010 - 18:07:35: [War3Source.smx] firsttimeplayer INSERT INTO war3source_warden (steamid,level,xp) VALUES ('STEAM_0:1:29322373','0','0')
L 07/02/2010 - 18:07:35: [War3Source.smx] firsttimeplayer INSERT INTO war3source_crypt (steamid,level,xp) VALUES ('STEAM_0:1:29322373','0','0')
L 07/02/2010 - 18:07:35: [War3Source.smx] firsttimeplayer INSERT INTO war3source_cd (steamid,level,xp) VALUES ('STEAM_0:1:29322373','0','0')
L 07/02/2010 - 18:07:35: [War3Source.smx] firsttimeplayer INSERT INTO war3source_sr (steamid,level,xp) VALUES ('STEAM_0:1:29322373','0','0')
L 07/02/2010 - 18:07:37: [War3Source.smx] firsttimeplayer INSERT INTO war3source_undead (steamid,level,xp) VALUES ('STEAM_0:0:12181208','0','0')
L 07/02/2010 - 18:07:37: [War3Source.smx] firsttimeplayer INSERT INTO war3source_human (steamid,level,xp) VALUES ('STEAM_0:0:12181208','0','0')
L 07/02/2010 - 18:07:37: [War3Source.smx] firsttimeplayer INSERT INTO war3source_orc (steamid,level,xp) VALUES ('STEAM_0:0:12181208','0','0')
L 07/02/2010 - 18:07:38: [War3Source.smx] firsttimeplayer INSERT INTO war3source_nightelf (steamid,level,xp) VALUES ('STEAM_0:0:12181208','0','0')
L 07/02/2010 - 18:07:38: [War3Source.smx] firsttimeplayer INSERT INTO war3source_mage (steamid,level,xp) VALUES ('STEAM_0:0:12181208','0','0')
Logged
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2045



View Profile WWW Email
« Reply #1 on: July 02, 2010, 06:10:14 PM »
Lost connection to MySQL server during query

was this on map start?
Logged
DarkEnergy
[Oddity]TeacherCreature
Sr. Member
****
Posts: 463


View Profile
« Reply #2 on: July 02, 2010, 06:17:54 PM »
this was server RESTART however despite that it still worked and is working

here was another restart

L 07/02/2010 - 18:12:45: Info (map "de_dust2") (file "errors_20100702.log")
L 07/02/2010 - 18:12:45: [War3Source.smx] (0) SQL error: Lost connection to MySQL server during query
L 07/02/2010 - 18:12:45: [War3Source.smx] (0) SQL error: Lost connection to MySQL server during query
L 07/02/2010 - 18:12:45: [War3Source.smx] (0) SQL error: Lost connection to MySQL server during query
L 07/02/2010 - 18:12:45: [War3Source.smx] (0) SQL error: Lost connection to MySQL server during query
L 07/02/2010 - 18:12:45: [War3Source.smx] (0) SQL error: Lost connection to MySQL server during query
L 07/02/2010 - 18:12:45: [War3Source.smx] (0) SQL error: Lost connection to MySQL server during query
L 07/02/2010 - 18:12:45: [War3Source.smx] (0) SQL error: Lost connection to MySQL server during query
L 07/02/2010 - 18:12:45: [War3Source.smx] (0) SQL error: Lost connection to MySQL server during query
L 07/02/2010 - 18:14:54: [War3Source.smx] firsttimeplayer INSERT INTO war3source_undead (steamid,level,xp) VALUES ('STEAM_0:1:22656715','0','0')
L 07/02/2010 - 18:14:54: [War3Source.smx] firsttimeplayer INSERT INTO war3source_human (steamid,level,xp) VALUES ('STEAM_0:1:22656715','0','0')
L 07/02/2010 - 18:14:54: [War3Source.smx] firsttimeplayer INSERT INTO war3source_orc (steamid,level,xp) VALUES ('STEAM_0:1:22656715','0','0')
L 07/02/2010 - 18:14:54: [War3Source.smx] firsttimeplayer INSERT INTO war3source_nightelf (steamid,level,xp) VALUES ('STEAM_0:1:22656715','0','0')
L 07/02/2010 - 18:14:55: [War3Source.smx] firsttimeplayer INSERT INTO war3source_mage (steamid,level,xp) VALUES ('STEAM_0:1:22656715','0','0')
L 07/02/2010 - 18:14:55: [War3Source.smx] firsttimeplayer INSERT INTO war3source_hunter (steamid,level,xp) VALUES ('STEAM_0:1:22656715','0','0')
L 07/02/2010 - 18:14:55: [War3Source.smx] firsttimeplayer INSERT INTO war3source_warden (steamid,level,xp) VALUES ('STEAM_0:1:22656715','0','0')
L 07/02/2010 - 18:14:55: [War3Source.smx] firsttimeplayer INSERT INTO war3source_crypt (steamid,level,xp) VALUES ('STEAM_0:1:22656715','0','0')
L 07/02/2010 - 18:14:55: [War3Source.smx] firsttimeplayer INSERT INTO war3source_cd (steamid,level,xp) VALUES ('STEAM_0:1:22656715','0','0')
L 07/02/2010 - 18:14:55: [War3Source.smx] firsttimeplayer INSERT INTO war3source_sr (steamid,level,xp) VALUES ('STEAM_0:1:22656715','0','0')
L 07/02/2010 - 18:14:55: [War3Source.smx] firsttimeplayer INSERT INTO war3source_undead (steamid,level,xp) VALUES ('STEAM_0:0:29657291','0','0')
L 07/02/2010 - 18:14:55: [War3Source.smx] firsttimeplayer INSERT INTO war3source_human (steamid,level,xp) VALUES ('STEAM_0:0:29657291','0','0')
L 07/02/2010 - 18:14:55: [War3Source.smx] firsttimeplayer INSERT INTO war3source_orc (steamid,level,xp) VALUES ('STEAM_0:0:29657291','0','0')
L 07/02/2010 - 18:14:56: [War3Source.smx] firsttimeplayer INSERT INTO war3source_nightelf (steamid,level,xp) VALUES ('STEAM_0:0:29657291','0','0')
L 07/02/2010 - 18:14:56: [War3Source.smx] firsttimeplayer INSERT INTO war3source_mage (steamid,level,xp) VALUES ('STEAM_0:0:29657291','0','0')
L 07/02/2010 - 18:14:56: [War3Source.smx] firsttimeplayer INSERT INTO war3source_hunter (steamid,level,xp) VALUES ('STEAM_0:0:29657291','0','0')
L 07/02/2010 - 18:14:56: [War3Source.smx] firsttimeplayer INSERT INTO war3source_warden (steamid,level,xp) VALUES ('STEAM_0:0:29657291','0','0')
L 07/02/2010 - 18:14:56: [War3Source.smx] firsttimeplayer INSERT INTO war3source_crypt (steamid,level,xp) VALUES ('STEAM_0:0:29657291','0','0')
L 07/02/2010 - 18:14:56: [War3Source.smx] firsttimeplayer INSERT INTO war3source_cd (steamid,level,xp) VALUES ('STEAM_0:0:29657291','0','0')
L 07/02/2010 - 18:14:56: [War3Source.smx] firsttimeplayer INSERT INTO war3source_sr (steamid,level,xp) VALUES ('STEAM_0:0:29657291','0','0')
Logged
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2045



View Profile WWW Email
« Reply #3 on: July 02, 2010, 06:19:08 PM »
i hope those missed queries do not break functionality
Logged
DarkEnergy
[Oddity]TeacherCreature
Sr. Member
****
Posts: 463


View Profile
« Reply #4 on: July 03, 2010, 09:12:26 AM »
they havent yet lmao
Logged
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!