Jump to content

Problems with DB or other

Vegastr

By Vegastr
in Scripting

Recommended Posts

Vegastr Civilian

Vegastr

Posted
Posted 

  
================================================================== 
= Multi Theft Auto: San Andreas v1.5 
================================================================== 
= Server name      : Default MTA Server 
= Server IP address: 46.174.50.48 
= Server port      : 22082 
=  
= Log file         : /game/mods/deathmatch/logs/server.log 
= Maximum players  : 20 
= HTTP port        : 32082 
= Voice Chat       : Disabled 
= Bandwidth saving : Medium 
================================================================== 
[2016-03-24 20:02:24] Resource 'guieditor' requests some acl rights. Use the command 'aclrequest list guieditor' 
[2016-03-24 20:02:25] Resources: 169 loaded, 0 failed 
[2016-03-24 20:02:25] MODULE: Loaded "MySQL 5.0 database module" (0.50) by "Alberto Alonso <[email protected]>" 
[2016-03-24 20:02:25] Starting resources... 
[2016-03-24 20:02:25] INFO: --FORUMS DATABASE CREDENTIALS-- 
[2016-03-24 20:02:25] INFO: --HOST: Error 
[2016-03-24 20:02:25] INFO: --DB: Error 
[2016-03-24 20:02:25] INFO: --USER: Error 
[2016-03-24 20:02:25] INFO: --PW: Error 
[2016-03-24 20:02:25] INFO: --PORT: Error 
[2016-03-24 20:02:25] INFO: --RESULT:  
[2016-03-24 20:02:25] ERROR: mysql/connection.lua:92: bad argument #1 to 'mysql_connect' (string expected, got boolean) 
[2016-03-24 20:02:25] INFO: --FORUMS DATABASE CREDENTIALS-- 
[2016-03-24 20:02:25] INFO: --HOST: db2.myarena.ru 
[2016-03-24 20:02:25] INFO: --DB: ericstar_MTA 
[2016-03-24 20:02:25] INFO: --USER: ericstar_1 
[2016-03-24 20:02:25] INFO: --PW: *********** 
[2016-03-24 20:02:25] INFO: --PORT: 3306 
[2016-03-24 20:02:25] INFO: --RESULT:  
[2016-03-24 20:02:25] INFO: OK 
[2016-03-24 20:02:25] INFO: MYSQL ERROR 1305: FUNCTION ericstar_MTA.TO_SECONDS does not exist 
[2016-03-24 20:02:25] ERROR: mysql/connection.lua:224: exports: Call to non-running server resource (logs) [string "?"] 
[2016-03-24 20:02:25] ERROR: datetime/datetime_s.lua:5: attempt to index a boolean value 
[2016-03-24 20:02:26] SCRIPT ERROR: global/g_version_globals.lua:10: '=' expected near 'UCP' 
[2016-03-24 20:02:26] ERROR: Loading script failed: global/g_version_globals.lua:10: '=' expected near 'UCP' 
[2016-03-24 20:02:26] Server minclientversion is now 1.5.2-9.07838.0.000 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 14) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 15) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 16) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 17) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 18) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 20) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 21) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 22) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 23) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 24) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 45) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 46) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 47) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 48) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 49) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 50) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 51) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 52) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 53) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 54) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 55) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 56) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 57) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 58) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 59) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 60) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 61) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 62) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 63) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 64) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 75) 
[2016-03-24 20:02:26] ERROR: Bad 'model' id specified in <object> (line 80) 
[2016-03-24 20:02:26] ERROR: attempt to call a nil value 
[2016-03-24 20:02:26] ERROR: account/g_events.lua:24: call: failed to call 'global:getScriptVersion' [string "?"] 
[2016-03-24 20:02:26] ERROR: attempt to call a nil value 
[2016-03-24 20:02:26] ERROR: account/s_main.lua:29: call: failed to call 'global:getScriptVersion' [string "?"] 
[2016-03-24 20:02:26] WARNING: account/s_main.lua:29: Bad argument @ 'setRuleValue' [Expected string at argument 2, got boolean] 
[2016-03-24 20:02:26] Server password cleared 
[2016-03-24 20:02:29] ERROR: faction-system/s_faction_admin.lua:507: attempt to index local 'maxrow' (a nil value) 
[2016-03-24 20:02:29] Please wait... 
[2016-03-24 20:02:30] WARNING: item-texture/s_itemtexture.lua:44: Bad argument @ 'getElementsByType' [Expected element at argument 2, got boolean] 
[2016-03-24 20:02:30] ERROR: item-texture/s_itemtexture.lua:48: attempt to get length of local 'worldItems' (a boolean value) 
[2016-03-24 20:02:30] INFO: [iTEM WORLD] Loading 0 world items will be finished in approximately 0.05 seconds. 
[2016-03-24 20:02:30] INFO: [JOB-SYSTEM-TRUCKER] Fetched 0 actual orders sucessfully from SQL 
[2016-03-24 20:02:30] INFO: Loaded 0 pilot licenses in 34ms. 
[2016-03-24 20:02:31] INFO: Loaded 0 reports. 
[2016-03-24 20:02:33] INFO: MYSQL ERROR 1305: FUNCTION ericstar_MTA.TO_SECONDS does not exist 
[2016-03-24 20:02:33] INFO: MYSQL ERROR 1305: FUNCTION ericstar_MTA.TO_SECONDS does not exist 
[2016-03-24 20:02:33] INFO: MYSQL ERROR 1305: FUNCTION ericstar_MTA.TO_SECONDS does not exist 
[2016-03-24 20:02:34] INFO: MYSQL ERROR 1305: FUNCTION ericstar_MTA.TO_SECONDS does not exist 
[2016-03-24 20:02:34] INFO: MYSQL ERROR 1305: FUNCTION ericstar_MTA.TO_SECONDS does not exist 
[2016-03-24 20:02:34] INFO: MYSQL ERROR 1305: FUNCTION ericstar_MTA.TO_SECONDS does not exist 
[2016-03-24 20:02:34] INFO: MYSQL ERROR 1305: FUNCTION ericstar_MTA.TO_SECONDS does not exist 
[2016-03-24 20:02:34] INFO: MYSQL ERROR 1305: FUNCTION ericstar_MTA.TO_SECONDS does not exist 
[2016-03-24 20:02:34] INFO: MYSQL ERROR 1305: FUNCTION ericstar_MTA.TO_SECONDS does not exist 
 

Help me pls. On local pc(Windows) server work perfectly. Im upload this on hosting with Linux and script do this.

Link to comment
Vegastr Civilian

Vegastr

Posted
  • Author
Posted
mysql/connection.lua:92: bad argument #1 to 'mysql_connect' (string expected, got boolean)

Show the code

its external not use db, i want repair DB Errors

This code:

datelime_c

addEventHandler("onClientResourceStart", resourceRoot, function() 
    serverCurrentTimeSec = 0 
    lastTime = getRealTime().timestamp 
    triggerServerEvent("getServerCurrentTimeSec", localPlayer) 
end) 
  
function setServerCurrentTimeSec(serverTimeSec) 
    serverCurrentTimeSec = serverTimeSec 
end 
addEvent("setServerCurrentTimeSec", true) 
addEventHandler("setServerCurrentTimeSec", root, setServerCurrentTimeSec) 
  
function getNow() 
    outputChatBox("[Client] "..now()) 
end 
addCommandHandler("now", getNow)

datetime_s

--MAXIME 
  
addEventHandler("onResourceStart", resourceRoot, function() 
    lastTime = getRealTime().timestamp 
    serverCurrentTimeSec = tonumber(exports.mysql:query_fetch_assoc("SELECT TO_SECONDS(NOW()) AS `timesec` ")['timesec']) 
end) 
  
function getServerCurrentTimeSec() 
    triggerClientEvent(source, "setServerCurrentTimeSec", source, now()) 
end 
addEvent("getServerCurrentTimeSec", true) 
addEventHandler("getServerCurrentTimeSec", root, getServerCurrentTimeSec) 
  
function getNow(player) 
    outputChatBox("[server] "..now(), player) 
    local serverSec = tonumber(exports.mysql:query_fetch_assoc("SELECT TO_SECONDS(NOW()) AS `timesec` ")['timesec']) 
    outputChatBox("[sql] "..serverSec, player) 
    outputChatBox("------------------------", player) 
end 
addCommandHandler("now", getNow)

datetime_g

  
function now() 
    local timePassed = math.floor((getRealTime().timestamp - lastTime)) 
    --outputChatBox(timePassed) 
    return serverCurrentTimeSec + timePassed 
end 
  
function formatTimeInterval( timeInseconds ) 
    if type( timeInseconds ) ~= "number" then 
        return timeInseconds, 0 
    end 
     
    local seconds = now()-timeInseconds 
    if seconds < 1 then 
        return "Just now", 0 
    end 
     
    if seconds < 60 then 
        return formatTimeString( seconds, "second" ).." ago", seconds 
    end 
     
    local minutes = math.floor( seconds / 60 ) 
    if minutes < 60 then 
        return formatTimeString( minutes, "m" ) .. " " .. formatTimeString( seconds - minutes * 60, "s" ).." ago" , seconds 
    end 
     
    local hours = math.floor( minutes / 60 ) 
    if hours < 48 then 
        return formatTimeString( hours, "h" ) .. " " .. formatTimeString( minutes - hours * 60, "m" ).." ago", seconds 
    end 
     
    local days = math.floor( hours / 24 ) 
    return formatTimeString( days, "day" ).." ago", seconds 
end 
  
function formatFutureTimeInterval( timeInseconds ) 
    if type( timeInseconds ) ~= "number" then 
        return timeInseconds, 0 
    end 
     
    local seconds = timeInseconds-now() 
    if seconds < 0 then 
        return "0s", 0 
    end 
     
    if seconds < 60 then 
        return formatTimeString( seconds, "second" ), seconds 
    end 
     
    local minutes = math.floor( seconds / 60 ) 
    if minutes < 60 then 
        return formatTimeString( minutes, "m" ) .. " " .. formatTimeString( seconds - minutes * 60, "s" ), seconds 
    end 
     
    local hours = math.floor( minutes / 60 ) 
    if hours < 48 then 
        return formatTimeString( hours, "h" ) .. " " .. formatTimeString( minutes - hours * 60, "m" ), seconds 
    end 
     
    local days = math.floor( hours / 24 ) 
    return formatTimeString( days, "day" ), seconds 
end 
  
function formatTimeString( time, unit ) 
    if time == 0 then 
        return "" 
    end 
    if unit == "day" or unit == "hour" or unit == "minute" or unit == "second" then 
        return time .. " " .. unit .. ( time ~= 1 and "s" or "" ) 
    else 
        return time .. "" .. unit-- .. ( time ~= 1 and "s" or "" ) 
    end 
end 
  
function minutesToDays(minutes)  
    local oneDay = minutes*60*24 
    return math.floor(minutes/oneDay) 
end  
  
function formatSeconds(seconds) 
    if type( seconds ) ~= "number" then 
        return seconds 
    end 
     
    if seconds <= 0 then 
        return "Now" 
    end 
     
    if seconds < 60 then 
        return formatTimeString( seconds, "second" ) 
    end 
     
    local minutes = math.floor( seconds / 60 ) 
    if minutes < 60 then 
        return formatTimeString( minutes, "minute" ) .. " " .. formatTimeString( seconds - minutes * 60, "second" ) 
    end 
     
    local hours = math.floor( minutes / 60 ) 
    if hours < 48 then 
        return formatTimeString( hours, "hour" ) .. " " .. formatTimeString( minutes - hours * 60, "minute" ) 
    end 
     
    local days = math.floor( hours / 24 ) 
    return formatTimeString( days, "day" ) 
end

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
Go to topic listing

  • Recently Browsing   0 members

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