• Mysql problem
    8 replies, posted
Hello, I would need help because I have a problem with mysql, I can not include the module without my server crash My code works locally, but as soon as I put it on my public server (linux) my server does not start / crash There is no error in my console. Thank you in advance to those who will help me :)
Do you have the latest module of mysqloo?
[QUOTE=Richtofen;52354898]Do you have the latest module of mysqloo?[/QUOTE] Yes
Is your MySQL server hosted locally or online? Does it allow external connections?
[QUOTE=Richtofen;52355215]Is your MySQL server hosted locally or online? Does it allow external connections?[/QUOTE] I tested with both...
[QUOTE=SlownLS;52355223]I tested with both...[/QUOTE] Did you install the correct bin for mysqloo? Windows servers require a different file than linux. Sorry if I'm assuming thoughtlessness, but It's ensuring I can narrow down the issue.
[QUOTE=Richtofen;52355244]Did you install the correct bin for mysqloo? Windows servers require a different file than linux. Sorry if I'm assuming thoughtlessness, but It's ensuring I can narrow down the issue.[/QUOTE] Yes
Saying "it does not crash" "with no errors" doesn't give anyone enough details to go on. Write the exact way in which you installed it, for example - putting x file to y directory. Which distro are you using too? I've never had this issue unfortunately.
There is nothing detailed, I installed mysql correctly, it told me in the console that I have the right version, but when I try to put this code: [QUOTE]require( "mysqloo" ) local queue = {} local db = mysqloo.connect( "123.456.789.0", "drake", "abc123", "database_name", 3306 ) function db:onConnected() for k, v in pairs( queue ) do query( v[ 1 ], v[ 2 ] ) end queue = {} end function db:onConnectionFailed( err ) print( "Connection to database failed!" ) print( "Error:", err ) end db:connect() function query( sql, callback ) local q = db:query( sql ) function q:onSuccess( data ) callback( data ) end function q:onError( err ) if db:status() == mysqloo.DATABASE_NOT_CONNECTED then table.insert( queue, { sql, callback } ) db:connect() return end print( "Query Errored, error:", err, " sql: ", sql ) end q:start() end[/QUOTE] My server will not start anymore ...
Sorry, you need to Log In to post a reply to this thread.