mysql help needed asap.

[k0ed298]

MYSQL wont work and i have done everything and i cant get the logs. It comes up with mysql errors in the console but doesnt show them in logs . But here are my mysql files. Tell me if ive missed anything ;

s_mysql file :

username = get( "username" ) or "root" 
password = get( "password" ) or "" 
db = get( "database" ) or "vgtest" 
host = get( "hostname" ) or "* my ip address.. Is acutally here but i dont want u to seee * " 
port = tonumber( get( "port" ) ) or 3306 
  
function getMySQLUsername(root) 
    return username 
end 
  
function getMySQLPassword() 
    return password 
end 
  
function getMySQLDBName() 
    return db 
end 
  
function getMySQLHost() 
    return host 
end 
  
function getMySQLPort() 
    return port 
end 
  
  
function lazyQuery(message) 
    local filename = "/lazyqueries.log" 
  
     
     
    local file = createFileIfNotExists(filename) 
    local size = fileGetSize(file) 
    fileSetPos(file, size) 
    fileWrite(file, message .. "\r\n") 
    fileFlush(file) 
    fileClose(file) 
     
    return true 
end 
  
function createFileIfNotExists(filename) 
    local file = fileOpen(filename) 
     
    if not (file) then 
        file = fileCreate(filename) 
    end 
     
    return file 
end 

connection file

-- connection settings 
local hostname = get( "hostname" ) or "localhost" 
local username = get( "username" ) or "root" 
local password = get( "password" ) or "" 
local database = get( "database" ) or "vgtest" 
local port = tonumber( get( "port" ) ) or 3306 
  
-- global things. 
local MySQLConnection = nil 
local resultPool = { } 
local queryPool = { } 
local sqllog = false 
local countqueries = 0 
  
-- connectToDatabase - Internal function, to spawn a DB connection 
function connectToDatabase(res) 
    MySQLConnection = mysql_connect(hostname, username, password, database, port) 
     
    if (not MySQLConnection) then 
        if (res == getThisResource()) then 
            cancelEvent(true, "Cannot connect to the database.") 
        end 
        return nil 
    end 
     
    return nil 
end 
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), connectToDatabase, false) 
     
-- destroyDatabaseConnection - Internal function, kill the connection if theres one. 
function destroyDatabaseConnection() 
    if (not MySQLConnection) then 
        return nil 
    end 
    mysql_close(MySQLConnection) 
    return nil 
end 
addEventHandler("onResourceStop", getResourceRootElement(getThisResource()), destroyDatabaseConnection, false) 
  
-- do something usefull here 
function logSQLError(str) 
    local message = str or 'N/A' 
    outputDebugString("MYSQL ERROR "..mysql_errno(MySQLConnection) .. ": " .. mysql_error(MySQLConnection)) 
    exports['logs']:logMessage("MYSQL ERROR [QUERY] " .. message .. " [ERROR] " .. mysql_errno(MySQLConnection) .. ": " .. mysql_error(MySQLConnection), 24) 
end 
  
function getFreeResultPoolID() 
    local size = #resultPool 
    if (size == 0) then 
        return 1  
    end 
    for index, query in ipairs(resultPool) do 
        if (query == nil) then 
            return index 
        end 
    end 
    return (size + 1) 
end 
  
------------ EXPORTED FUNCTIONS --------------- 
  
function ping() 
    if (mysql_ping(MySQLConnection) == false) then 
        -- FUU, NO MOAR CONNECTION 
        destroyDatabaseConnection() 
        connectToDatabase(nil) 
        if (mysql_ping(MySQLConnection) == false) then 
            logSQLError() 
            return false 
        end 
        return true 
    end 
  
    return true 
end 
  
function escape_string(str) 
    if (ping()) then 
        return mysql_escape_string(MySQLConnection, str) 
    end 
    return false 
end 
  
function query(str) 
    if sqllog then 
        exports['logs']:logMessage(str, 24) 
    end 
    countqueries = countqueries + 1 
     
    if (ping()) then 
        local result = mysql_query(MySQLConnection, str) 
        if (not result) then 
            logSQLError(str) 
            return false 
        end 
  
        local resultid = getFreeResultPoolID() 
        resultPool[resultid] = result 
        queryPool[resultid] = str 
        return resultid 
    end 
    return false 
end 
  
function unbuffered_query(str) 
    if sqllog then 
        exports['logs']:logMessage(str, 24) 
    end 
    countqueries = countqueries + 1 
     
    if (ping()) then 
        local result = mysql_unbuffered_query(MySQLConnection, str) 
        if (not result) then 
            logSQLError(str) 
            return false 
        end 
  
        local resultid = getFreeResultPoolID() 
        resultPool[resultid] = result 
        queryPool[resultid] = str 
        return resultid 
    end 
    return false 
end 
  
function query_free(str) 
    local queryresult = query(str) 
    if  not (queryresult == false) then 
        free_result(queryresult) 
        return true 
    end 
    return false 
end 
  
function rows_assoc(resultid) 
    if (not resultPool[resultid]) then 
        return false 
    end 
    return mysql_rows_assoc(resultPool[resultid]) 
end 
  
function fetch_assoc(resultid) 
    if (not resultPool[resultid]) then 
        return false 
    end 
    return mysql_fetch_assoc(resultPool[resultid]) 
end 
  
function free_result(resultid) 
    if (not resultPool[resultid]) then 
        return false 
    end 
    mysql_free_result(resultPool[resultid]) 
    table.remove(resultPool, resultid) 
    table.remove(queryPool, resultid) 
    return nil 
end 
  
-- incase a nub wants to use it, FINE 
function result(resultid, row_offset, field_offset) 
    if (not resultPool[resultid]) then 
        return false 
    end 
    return mysql_result(resultPool[resultid], row_offset, field_offset) 
end 
  
function num_rows(resultid) 
    if (not resultPool[resultid]) then 
        return false 
    end 
    return mysql_num_rows(resultPool[resultid]) 
     
end 
  
function insert_id() 
    return mysql_insert_id(MySQLConnection) or false 
end 
  
function query_fetch_assoc(str) 
    local queryresult = query(str) 
    if  not (queryresult == false) then 
        local result = fetch_assoc(queryresult) 
        free_result(queryresult) 
        return result 
    end 
    return false 
end 
  
function query_rows_assoc(str) 
    local queryresult = query(str) 
    if  not (queryresult == false) then 
        local result = rows_assoc(queryresult) 
        free_result(queryresult) 
        return result 
    end 
    return false 
end 
  
function query_insert_free(str) 
    local queryresult = query(str) 
    if  not (queryresult == false) then 
        local result = insert_id() 
        free_result(queryresult) 
        return result 
    end 
    return false 
end 
  
function escape_string(str) 
    return mysql_escape_string(MySQLConnection, str) 
end 
  
function debugMode() 
    if (sqllog) then 
        sqllog = false 
    else 
        sqllog = true 
    end 
    return sqllog 
end 
  
function returnQueryStats() 
    return countqueries 
    -- maybe later more 
end 
  
function getOpenQueryStr( resultid ) 
    if (not queryPool[resultid]) then 
        return false 
    end 
     
    return queryPool[resultid] 
end 

[Wei]

try replacing hostname to localhost and show us error...

[k0ed298]

try replacing hostname to localhost and show us error...

i changed it but it comes up with

MODULE: Unable to load modules/libmysql.dll 
ERROR: exports: Call to non-running server resource <mysql> [string]] 
Error: unable to connect to mysql: <1044> Access denied for user"@' localhost to database 'mta' 

And the database isnt "mta" is vgtest . Do you have skype ?

[Anderl]

MODULE: Unable to load modules/libmysql.dll

ERROR: exports: Call to non-running server resource [string]]

Can't you understand this? lol

[k0ed298]

MODULE: Unable to load modules/libmysql.dll

ERROR: exports: Call to non-running server resource [string]]

Can't you understand this? lol

Nope. Thats why im asking for help. Obviously.

[k0ed298]

Someone help ? .

[Anderl]

lolz, You don't understand english? THE FUCKING DLL libmysql.dll NOT FOUND, INSTALL THE MODULE CORRECTLY.

https://wiki.multitheftauto.com/wiki/Mysql

[k0ed298]

lolz, You don't understand english? THE DLL libmysql.dll NOT FOUND, INSTALL THE MODULE CORRECTLY.

https://wiki.multitheftauto.com/wiki/Mysql

Its there. I will download it again .

[k0ed298]

lolz, You don't understand english? THE DLL libmysql.dll NOT FOUND, INSTALL THE MODULE CORRECTLY.

https://wiki.multitheftauto.com/wiki/Mysql

that error still comes up and these still come up .

ERROR: exports: Call to non-running server resource <mysql> [string]] 
Error: unable to connect to mysql: <1044> Access denied for user"@' localhost to database 'mta' 

[Anderl]

If it appears, it's because you didn't install the module correctly, no?

[k0ed298]

If it appears, it's because you didn't install the module correctly, no?

How do u install it ? My friend did it for me . And he wont help me . Do you have skype ? .

[Wei]

put the

username: root

password:

database: test

and it will work

[k0ed298]

put the

username: root

password:

database: test

and it will work

Why "test" ? the database is called vgtest D:

[k0ed298]

put the

username: root

password:

database: test

and it will work

And nope doesnt work. Can one of yous add me on skype ? deroboyy97 , and team viewer me ?

[k0ed298]

[Anderl]

Dafuq. Triple post

Can't you wait for someone to help you?

[k0ed298]

i fixed it. But i need to know how to get information from one sql to another. :l

[Castillo]

In MySQL you can export the table and import it back with PHPMyAdmin.

[k0ed298]

i figured it out.

[k0ed298]

i figured out the mysql problem in the console i just need help on moving tables and that from one sql to another threw phpmyadmin

[Castillo]

Export the table with phpMyAdmin, then import it back.

[k0ed298]

Export the table with phpMyAdmin, then import it back.

but when i do that. It overwrites the whole sql or it doesnt work. How do i just export a table like eg " accounts " and import it into a another sql . Without whiping everything.

[Castillo]

Go to the desired table and click "Export"?

[k0ed298]

Go to the desired table and click "Export"?

Done. What now ?

[Castillo]

Go to your database and click "Import", then select the file you exported and it'll create the table with the name of the file.