I keep getting this error:
[code]PointShop MySQL: Query Failed: MySQL server has gone away (INSERT INTO `pointshop_data` (uniqueid, points, items) VALUES ('1809792006', '20060', '{\"bombhead\":{\"Equipped\":false,\"Modifiers\":[]},\"spy\":{\"Equipped\":true,\"Modifiers\":[]},\"afro\":{\"Equipped\":false,\"Modifiers\":[]},\"texthat\":{\"Equipped\":true,\"Modifiers\":{\"text\":\"Baron Island Best Admin/Mod EU 2\",\"color\":{\"r\":255,\"b\":0,\"a\":255,\"g\":0}}}}') ON DUPLICATE KEY UPDATE points = VALUES(points), items = VALUES(items))[/code]
I set up the database as you should and started with a fresh table with it all set up by the SQL given in the pointshop_mysql folder.
Is there any way to fix this error that keeps occuring? Thanks :)
[url]http://dev.mysql.com/doc/refman/5.0/en/gone-away.html[/url]
First link in Google.
I'm sorry but to me, it may as well be written in Arabic since I don't understand it :P
Then I don't think anyone can explain it to you, if you can't understand official English documentation.
Ahhhhh I see. I am beginning to understand it now :P Thank you :)
Don't worry about Robot, he can be some what of a dick when it comes to helping people. Just send an empty query (or something that doesn't do anything, maybe retrieving a list) every 2 minutes or so (how ever long you have set your connection to time out for minus a few seconds).
*Retard alert* How would I go about doing this? :)
Shameless bump
They're not errors, just messages to alert you that the server is reconnecting to the MySQL database. If you don't want them, remove the "MsgN" functions in the mysql.lua file in the addon.
They wouldn't be showing up if something wasn't wrong though. I'd rather fix the issue at hand than just hide it.
Sorry, you need to Log In to post a reply to this thread.
