Jump to content

HELP My_SQL


K4stic

Recommended Posts

WARNING: @mysql.lua:5: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]

WARNING: @mysql.lua:4: Bad argument @ 'dbQuery' [Expected string at argument 2, got nil]

-- Exported functions 
function query( ... ) 
    if connection then 
        local qh = dbQuery( connection, ... ) 
        local result = dbPoll( qh, -1 ) 
        return result 
    else 
        return false 
    end 
end 
  
-- DB exec as used 
function exec( str, ... ) 
    if connection then 
        local qh = dbExec( connection, str, ... ) 
        return qh 
    else 
        return false 
    end 
end 

i use the My_SQL with this method the dbExec:

exports.SCGmysql:exec( "INSERT INTO `groups` (`name`, `leader`, `groupinfo`, `active`) VALUES (?, ?, ?, ?)", group, account, "This group has no info", 1)

exports.SCGmysql:exec( "UPDATE `users` SET `group` =? WHERE `account` =?", group, account)

exports.SCGmysql:exec( "UPDATE `users` SET `groupL` =? WHERE `account` =?", 2, account)

and it output me error :/ => WARNING: @mysql.lua:15: dbExec failed; Table 'db_945.groups' doesn't exist

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...