A problem with exporting mySQL connection

[jingzhi]

Hello,

I have a problem with exporting the mySQL connection into the login script, the error is: "failed to call 'mySQL:dbConnection' [string'?']"

Here are the codes

mySQL.lua

local dbType="mysql" 
local dbName="mta" 
local dbHost="127.0.0.1" 
local dbUsername="jingzhi" 
local dbPassword="" 
local dbConnection = dbConnect(dbType,"dbname="..dbName..";"..dbHost.."",dbUsername,dbPassword) 
  
if dbConnection then 
    outputDebugString("MySQL has been successfuly connected!") 
else 
    outputDebugString("Failed to connect to MySQL!") 
end 
  
function dbConnection() 
    return dbConnection 
end 
  

meta.xml

    "JingZhi" type="script" /> 
    

login.lua

local dbConnection = exports["mySQL"]:dbConnection() 

[jingzhi]

Hello,

I have a problem with exporting the mySQL connection into the login script, the error is: "failed to call 'mySQL:dbConnection' [string'?']"

Here are the codes

mySQL.lua

local dbType="mysql" 
local dbName="mta" 
local dbHost="127.0.0.1" 
local dbUsername="jingzhi" 
local dbPassword="" 
local dbConnection = dbConnect(dbType,"dbname="..dbName..";"..dbHost.."",dbUsername,dbPassword) 
  
if dbConnection then 
    outputDebugString("MySQL has been successfuly connected!") 
else 
    outputDebugString("Failed to connect to MySQL!") 
end 
  
function dbConnection() 
    return dbConnection 
end 
  

meta.xml

    "JingZhi" type="script" /> 
    

login.lua

local dbConnection = exports["mySQL"]:dbConnection() 

C'mon guys! need help!

[SpecT]

You forgot to put host= ...

local dbType="mysql" 
local dbName="mta" 
local dbHost="127.0.0.1" 
local dbUsername="jingzhi" 
local dbPassword="" 
local dbConnection = dbConnect(dbType,"dbname="..dbName..";host="..dbHost.."",dbUsername,dbPassword) 
  
if dbConnection then 
    outputDebugString("MySQL has been successfuly connected!") 
else 
    outputDebugString("Failed to connect to MySQL!") 
end 
  
function dbConnection() 
    return dbConnection 
end 

[jingzhi]

You forgot to put host= ...

local dbType="mysql" 
local dbName="mta" 
local dbHost="127.0.0.1" 
local dbUsername="jingzhi" 
local dbPassword="" 
local dbConnection = dbConnect(dbType,"dbname="..dbName..";host="..dbHost.."",dbUsername,dbPassword) 
  
if dbConnection then 
    outputDebugString("MySQL has been successfuly connected!") 
else 
    outputDebugString("Failed to connect to MySQL!") 
end 
  
function dbConnection() 
    return dbConnection 
end 

dbConnect(dbType,"dbname="..dbName..";host="..dbHost.."",dbUsername,dbPassword) 

I think I put....

[jingzhi]

Hello,

I have a problem with exporting the mySQL connection into the login script, the error is: "failed to call 'mySQL:dbConnection' [string'?']"

Here are the codes

mySQL.lua

local dbType="mysql" 
local dbName="mta" 
local dbHost="127.0.0.1" 
local dbUsername="jingzhi" 
local dbPassword="" 
local dbConnection = dbConnect(dbType,"dbname="..dbName..";"..dbHost.."",dbUsername,dbPassword) 
 Need help! 
if dbConnection then 
    outputDebugString("MySQL has been successfuly connected!") 
else 
    outputDebugString("Failed to connect to MySQL!") 
end 
  
function dbConnection() 
    return dbConnection 
end 
  

meta.xml

    "JingZhi" type="script" /> 
    

login.lua

local dbConnection = exports["mySQL"]:dbConnection() 

[ALw7sH]

The script name is mySQL?

Also check the debug if there's any errors

[SpecT]

Well then update the code you post here (edit button). How could I know you made it right?

As alw7sh said post here if there are any errors from debugscript 3.

[jingzhi]

Well then update the code you post here (edit button). How could I know you made it right?

As alw7sh said post here if there are any errors from debugscript 3.

Thats all code

[jingzhi]

The script name is mySQL?

Also check the debug if there's any errors

Script name is mySQL and no error in debugscript 3 except for the one i showed there

[ALw7sH]

Your function name is like your dbConnect varb name

change one of them