Jump to content

Help : failed to call 'mysql:lazyQuery'


randomlx

Recommended Posts

Posted

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 ?

Posted

    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

Posted (edited)

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
  • 6 years later...
Posted
On 22/03/2018 at 17:26, Skully said:

Stop using stolen scripts and make your own so you understand how to fix it.

owl gaming is not a stole script lol

 

Posted
11 hours ago, xkr4nxz said:

owl gaming is not a stole script lol

 

It would have been at the time, as was Valhalla still considered stolen, but that too has since been open sourced.

But the post you dug up is 6 years old lol.

  • Like 1
  • IIYAMA locked this topic
Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

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