Py mysql connect has no connection refresh?

Subject: Py mysql connect has no connection refresh? Sat Apr 21, 2007 7:48 pm

I noticed after a while the py mysql reports it lost the connection to the MYSQL server. Funny , thought it had a querie it would run like Luddy when inactive for long periods of time..

Senior Member Number of posts : 133 Registration date : 2006-11-28

yeh i noticed this too when the server has been empty for few hours it looses connection and mobs woun't drop anything anymore only thing left is to restart

Number of posts : 23 Registration date : 2006-12-24

well i have some problem on server maybe it is what about you are talking.

Code:: 24 17:00:24 V loot: Generate: creature[Young Panther] loot size[291]
24 17:00:24 V loot: Generate: WorldDrops: creature[Young Panther] size[0]
24 17:00:24 E Python: OnGMCommand has errors, skipping execution...
24 17:00:24 E Python: Traceback (most recent call last):
E Python:
24 17:00:24 E Python: File "scripts\creature_class.py", line 1114, in Generate
E Python: Loot_Base
E Python:
24 17:00:24 E Python:
24 17:00:24 E Python: cursor.execute ("SELECT `item_id`, `chance` FROM `creature
E Python: s_loot` WHERE `creature_id` = " + str(self_entry))
E Python:
24 17:00:24 E Python: File "scripts\MySQLdb\cursors.py", line 166, in execute
E Python:
24 17:00:24 E Python:
24 17:00:24 E Python: self.errorhandler(self, exc, value)
E Python:
24 17:00:24 E Python: File "scripts\MySQLdb\connections.py", line 35, in defau
E Python: lterrorhandler
E Python:
24 17:00:24 E Python:
24 17:00:24 E Python: raise errorclass, errorvalue
E Python:
24 17:00:24 E Python: _mysql_exceptions
24 17:00:24 E Python: .
24 17:00:24 E Python: OperationalError
24 17:00:24 E Python: :
24 17:00:24 E Python: (2006, 'MySQL server has gone away')
24 17:00:24 S OnDeath-AI: victim[Young Panther] killer[Wenator]
24 17:00:24 S OnUnitDeath-Class: victim[Young Panther] killer[Wenator]
24 17:00:24 S Python: OnUnitDeath: unit[Young Panther] killer[Wenator]

somebody know what it means? thx Smile

Senior Member Number of posts : 133 Registration date : 2006-11-28

means the loot gen script can't generate lot becouse it can't contact mysql anymore becouse it lost connection.
that's the problem we are talking about