Jump to content

Help : failed to call 'mysql:lazyQuery'


randomlx

Recommended Posts

Hello 

i have this problem on my server

 

server.log

[2018-03-22 10:04:44] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:04:50] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:06:14] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:06:24] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:06:36] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:06:55] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:07:20] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:07:41] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:08:13] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:08:29] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:08:44] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:08:50] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:08:59] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:09:05] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:09:10] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:09:28] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:09:28] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:09:36] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:10:50] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:10:59] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:11:22] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:11:40] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:11:43] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:11:50] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:11:50] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:12:05] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:12:14] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:12:20] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:12:20] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:12:27] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:12:27] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:12:33] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:12:48] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:13:07] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:13:09] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:13:26] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:14:14] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:14:28] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:15:02] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:15:21] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:16:58] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:17:39] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:17:45] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:18:16] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:18:28] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:18:34] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:18:40] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:18:48] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:18:49] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:18:59] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:19:05] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:19:15] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:19:22] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:19:33] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:19:43] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:19:49] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:20:02] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:20:30] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:20:45] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:20:52] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:20:56] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:21:02] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:21:10] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:21:25] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:21:41] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:21:48] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:21:57] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:22:29] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:22:31] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:22:37] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:22:38] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:22:44] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:22:46] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:22:52] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:22:56] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:23:18] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:23:59] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:25:03] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:25:16] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:25:30] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:26:00] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:27:15] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:29:54] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
[2018-03-22 10:31:14] ERROR: logs/s_logs.lua:105: call: failed to call 'mysql:lazyQuery' [string "?"]
 

running on linux 64bit

 

How i can fix it ?

Link to comment

    local r = getRealTime()
    
    local timeString = ("%04d-%02d-%02d %02d:%02d:%02d"):format(r.year+1900, r.month + 1, r.monthday, r.hour,r.minute, r.second)
    exports.mysql:lazyQuery("INSERT INTO `owl_logs` VALUES ('"..timeString.."', '".. exports.mysql:escape_string(tostring(actionStr) or "") .."', '".. exports.mysql:escape_string(tostring(sourceStr) or "").."', '".. exports.mysql:escape_string(tostring(affectedStr) or "").."', '".. exports.mysql:escape_string(tostring(data) or "").."')")
    
    --[[local timeString = ("%04d-%02d-%02d %02d:%02d:%02d"):format(r.year+1900, r.month + 1, r.monthday, r.hour,r.minute, r.second)
    exports.mysql:lazyQuery("INSERT INTO `logtable` VALUES ('"..timeString.."', '".. exports.mysql:escape_string(actionStr) .."', '".. exports.mysql:escape_string(sourceStr).."', '".. exports.mysql:escape_string(affectedStr).."', '".. exports.mysql:escape_string(data).."')") -- you should have used here query_free!!!]]

You can check file here ===> https://transfer.sh/WLhg5/s_logs.lua

Link to comment

I dont know what she do this function 

i think she save logs of table connecting on server

lazyQuery connecting with this database "owl_logs"  (already exist on phpmyadmin)

When we see the setting here /mods/deathmatch/resources/settings.xml

    <setting name="@mysql.logs_database" value="owl_logs" />
    <setting name="@mysql.logs_username" value="root" />
    <setting name="@mysql.logs_password" value="mtaservx654" />
    <setting name="@mysql.logs_hostname" value="localhost" />
    <setting name="@mysql.logs_port" value="3306" />

The server working correclty i would like to make it start or to desactivate it , i dont like to see this message on my server.log

 

Edited by randomlx
Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...