mysql_ping error

[DevGutter]

Dear Scripters, and helpers.

I have been reading through all the mysql_ping error files and searching, and searching. I'ts about time this was resolved once and for all. I have done, with many other people the mysql module, and set it up. I know most of you have the same issue and it's not just me. So, could a scripter please make a very detailed (if time) explanation on how to fix this error.

I would be willing to pay someone for a detailed response on how to fix this error, or donate to the community if the response is detailed and good for others to understand. Thanks so much for reading this.

Regards,

DevGutter Gaming Network.

EDIT: (There is an edit with an extract of the console error)

[2013-01-28 21:28:01] ERROR: account-system\s_news.lua:12: attempt to concatenate local 'date' (a nil value) 
[2013-01-28 21:28:01] ERROR: mysql\connection.lua:63: attempt to call global 'mysql_ping' (a nil value) 
[2013-01-28 21:28:01] ERROR: call: failed to call 'mysql:query' [string "?"] 
[2013-01-28 21:28:01] ERROR: mysql\connection.lua:63: attempt to call global 'mysql_ping' (a nil value) 
[2013-01-28 21:28:01] ERROR: call: failed to call 'mysql:query' [string "?"] 
[2013-01-28 21:29:00] ERROR: apps-system\s_apps.lua:15 mysql\connection.lua:63: attempt to call global 'mysql_ping' (a nil value) 
[2013-01-28 21:29:00] ERROR: call: failed to call 'mysql:query_fetch_assoc' [string "?"] 
[2013-01-28 21:30:00] ERROR: apps-system\s_apps.lua:15 mysql\connection.lua:63: attempt to call global 'mysql_ping' (a nil value) 
[2013-01-28 21:30:00] ERROR: call: failed to call 'mysql:query_fetch_assoc' [string "?"] 
[2013-01-28 21:30:19] ERROR: mysql\connection.lua:210: attempt to call global 'mysql_escape_string' (a nil value) 
[2013-01-28 21:30:19] ERROR: mysql\connection.lua:210: attempt to call global 'mysql_escape_string' (a nil value) 
[2013-01-28 21:30:19] ERROR: call: failed to call 'mysql:escape_string' [string "?"] 
[2013-01-28 21:30:19] ERROR: admin-system\Player\s_ban.lua:400: attempt to concatenate a boolean value 
[2013-01-28 21:31:00] ERROR: apps-system\s_apps.lua:15 mysql\connection.lua:63: attempt to call global 'mysql_ping' (a nil value) 
[2013-01-28 21:34:03] ERROR: account-system\s_news.lua:12: attempt to concatenate local 'date' (a nil value) 
[2013-01-28 21:34:03] ERROR: mysql\connection.lua:63: attempt to call global 'mysql_ping' (a nil value) 
[2013-01-28 21:34:03] ERROR: call: failed to call 'mysql:query' [string "?"] 
[2013-01-28 21:34:03] ERROR: mysql\connection.lua:63: attempt to call global 'mysql_ping' (a nil value) 

Edited January 30, 2013 by Guest

[uhm]

Hi, can you describe the exact error message? Or the issue?

And generally I don't think you would need this ping feature since you shouldn't keep the connection alive anyway and therefore don't need the ping function. Just open it to execute a series of queries, or to even execute just one. Especially when the MySQL connection is on the same server, the overhead of the connection data is very low.

In PHP the connection is opened and closed every page request.

Edited January 30, 2013 by Guest

[DevGutter]

This issue is based on the "Roleplay" game mode.

[uhm]

What exactly goes wrong then? Is there any error in the server console? Please provide more details!

[DevGutter]

[2013-01-28 21:28:01] ERROR: account-system\s_news.lua:12: attempt to concatenate local 'date' (a nil value) 
[2013-01-28 21:28:01] ERROR: mysql\connection.lua:63: attempt to call global 'mysql_ping' (a nil value) 
[2013-01-28 21:28:01] ERROR: call: failed to call 'mysql:query' [string "?"] 
[2013-01-28 21:28:01] ERROR: mysql\connection.lua:63: attempt to call global 'mysql_ping' (a nil value) 
[2013-01-28 21:28:01] ERROR: call: failed to call 'mysql:query' [string "?"] 
[2013-01-28 21:29:00] ERROR: apps-system\s_apps.lua:15 mysql\connection.lua:63: attempt to call global 'mysql_ping' (a nil value) 
[2013-01-28 21:29:00] ERROR: call: failed to call 'mysql:query_fetch_assoc' [string "?"] 
[2013-01-28 21:30:00] ERROR: apps-system\s_apps.lua:15 mysql\connection.lua:63: attempt to call global 'mysql_ping' (a nil value) 
[2013-01-28 21:30:00] ERROR: call: failed to call 'mysql:query_fetch_assoc' [string "?"] 
[2013-01-28 21:30:19] ERROR: mysql\connection.lua:210: attempt to call global 'mysql_escape_string' (a nil value) 
[2013-01-28 21:30:19] ERROR: mysql\connection.lua:210: attempt to call global 'mysql_escape_string' (a nil value) 
[2013-01-28 21:30:19] ERROR: call: failed to call 'mysql:escape_string' [string "?"] 
[2013-01-28 21:30:19] ERROR: admin-system\Player\s_ban.lua:400: attempt to concatenate a boolean value 
[2013-01-28 21:31:00] ERROR: apps-system\s_apps.lua:15 mysql\connection.lua:63: attempt to call global 'mysql_ping' (a nil value) 
[2013-01-28 21:34:03] ERROR: account-system\s_news.lua:12: attempt to concatenate local 'date' (a nil value) 
[2013-01-28 21:34:03] ERROR: mysql\connection.lua:63: attempt to call global 'mysql_ping' (a nil value) 
[2013-01-28 21:34:03] ERROR: call: failed to call 'mysql:query' [string "?"] 
[2013-01-28 21:34:03] ERROR: mysql\connection.lua:63: attempt to call global 'mysql_ping' (a nil value) 

[Castillo]

We don't give support with leaked scripts ( valhalla game mode ).

Topic locked.