Mysql Database Connection

[Bonsai]

Hey Peeps,

I'm having a little problem with my Mysql Database connection.

If the server just started, it works fine. But if I restart my database resource, it won't connect anymore.

I'm also using destroyElement on the connection in the onResourceStop event of that resource.

Does anyone know what the problem is?

Bonsai

[xXMADEXx]

Could you post the code, please?

[Bonsai]

function Database.main() 
  
    Database.connection = dbConnect("mysql", "dbname=**;host=**" ,"**", "**") 
  
    if not Database.connection then 
     
        Database.connection = dbConnect("mysql", "dbname=**;host=**" ,"**", "**") 
         
        if not Database.connection then 
     
            outputDebugString("Database Connection failed!") 
             
        end 
         
    else 
         
        outputDebugString("Database Connection successful!") 
         
    end 
     
end 
addEventHandler("onResourceStart", resourceRoot, Database.main) 
  
  
function Database.kill() 
  
    if isElement(Database.connection) then destroyElement(Database.connection) end 
  
    outputDebugString("Database Connection killed!") 
     
end 
addEventHandler("onResourceStop", resourceRoot, Database.kill) 
  
  
function getConnection() 
     
    return Database.connection 
     
end 

Thats all.

The last function is exported to be used by other resources.

[roaddog]

My guess is you need to put share param to 1.

options : List of key=value pairs separated by semicolons. Supported keys are:

share which can be set to 0 or 1. (Default value for SQLite is "share=1", for MySQL is "share=0"). When set to 1, the connection is shared and will be used by other calls to dbConnect with the same host string.

[Bonsai]

dbConnect is only used once by that resource. Other resources just use the connection.

But I discovered another problem with this now.

After some hours, the queries started to fail and the Error was "Expected db-connection, got marker".

I have no idea how that could happen...

Bonsai

[roaddog]

I tried the code its working just fine, maybe you have other element rather than the db assigned to it. Its weird.

[Anubhav]

Weird. Really very weird.

  
function Database.main() 
  
    Database.connection = dbConnect("mysql", "dbname=**;host=**" ,"**", "**") 
  
    if not Database.connection then 
    
        Database.connection = dbConnect("mysql", "dbname=**;host=**" ,"**", "**") 
        
        if not Database.connection then 
    
            outputDebugString("Database Connection failed!") 
            
        end 
        
    else 
        
        outputDebugString("Database Connection successful!") 
        
    end 
    
end 
addEventHandler("onResourceStart", resourceRoot, Database.main) 
  
  
function Database.kill() 
  
    if isElement(Database.connection) then destroyElement(Database.connection) Database.connection = nil end 
  
    outputDebugString("Database Connection killed!") 
    
end 
addEventHandler("onResourceStop", resourceRoot, Database.kill) 
  
  
function getConnection() 
    
    return Database.connection 
    
end 
  

Try this tho

[Rataj]

After some hours, the queries started to fail and the Error was "Expected db-connection, got marker".

That will be problem in another script where you set exported database connection to variable, you probably assigned marker to that variable.

[Bonsai]

I wish

The connection is only used for some db functions in other resources.

But by now I think the error message was just wrong.

There is no way it can become a marker by script.

Bonsai

[Noki]

https://wiki.multitheftauto.com/wiki/Sc ... ing_Reused

Far fetched, but you shouldn't leave any stone unturned.

It's a possibility that there's some other referencing error in one of your scripts, like others have suggested.