Nortonic Posted August 26, 2013 Posted August 26, 2013 Hello all. Im working on a Roleplay Server for MTA. Everything is going alright. Ive setup XAMPP, Edited the mysql resource to the connection info, But im getting this error... [2013-08-24 21:32:08] ERROR: mysql\connection.lua:16: attempt to call global 'mysql_connect' (a nil value)[2013-08-24 21:32:08] ERROR: mysql\connection.lua:62: attempt to call global 'mysql_ping' (a nil value) [2013-08-24 21:32:08] ERROR: call: failed to call 'mysql:query' [string "?"] [2013-08-24 21:32:08] ERROR: mysql\connection.lua:62: attempt to call global 'mysql_ping' (a nil value) [2013-08-24 21:32:08] ERROR: call: failed to call 'mysql:query' [string "?"] [2013-08-24 21:32:08] ERROR: mysql\connection.lua:62: attempt to call global 'mysql_ping' (a nil value) [2013-08-24 21:32:08] ERROR: call: failed to call 'mysql:query' [string "?"] [2013-08-24 21:32:08] ERROR: mysql\connection.lua:62: attempt to call global 'mysql_ping' (a nil value) [2013-08-24 21:32:08] ERROR: call: failed to call 'mysql:query' [string "?"] [2013-08-24 21:32:09] ERROR: mysql\connection.lua:62: attempt to call global 'mysql_ping' (a nil value) [2013-08-24 21:32:09] ERROR: call: failed to call 'mysql:query' [string "?"] [2013-08-24 21:32:09] ERROR: mysql\connection.lua:62: attempt to call global 'mysql_ping' (a nil value) [2013-08-24 21:32:09] ERROR: call: failed to call 'mysql:query' [string "?"] [2013-08-24 21:32:09] ERROR: mysql\connection.lua:62: attempt to call global 'mysql_ping' (a nil value) [2013-08-24 21:32:09] ERROR: call: failed to call 'mysql:query_fetch_assoc' [string "?"] [2013-08-24 21:32:09] ERROR: mysql\connection.lua:62: attempt to call global 'mysql_ping' (a nil value) [2013-08-24 21:32:09] ERROR: call: failed to call 'mysql:query' [string "?"] [2013-08-24 21:32:09] Please wait... [2013-08-24 21:32:09] ERROR: mysql\connection.lua:62: attempt to call global 'mysql_ping' (a nil value) [2013-08-24 21:32:09] ERROR: call: failed to call 'mysql:query' [string "?"] [2013-08-24 21:32:09] ERROR: mysql\connection.lua:62: attempt to call global 'mysql_ping' (a nil value) [2013-08-24 21:32:09] ERROR: call: failed to call 'mysql:query_free' [string "?"] [2013-08-24 21:32:09] ERROR: mysql\connection.lua:62: attempt to call global 'mysql_ping' (a nil value) [2013-08-24 21:32:09] ERROR: call: failed to call 'mysql:query' [string "?"] heres the SQL connection.lua -- connection settings local hostname = "localhost" local username = "root" local password = "" local database = "mta" local port = tonumber( get( "port" ) ) or 3306 Says the Error is in Line 62.. here it is.. 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 Any help is appriciated! Thanks in advance! Would it be the mysql module? Or.. MTA EXE or MTA's new DLL's?
BobSter Posted August 26, 2013 Posted August 26, 2013 If you got 64 bits. Go redownload the mta_mysql + lib_mysql and sha all .dll Then put it in modules folder, load@mtaconfig. Then, if you started server do /loadmodule sha.dll and then /loadmodule mta_mysql.dll /loadmodule lib_mysql.dll It should work then
Nortonic Posted August 29, 2013 Author Posted August 29, 2013 Solved. Just took alot of Trial and Error..
Nortonic Posted September 2, 2013 Author Posted September 2, 2013 Forgot to put the lib_mysql.dll's in the right places ect... noob mistake of mine
BobSter Posted September 4, 2013 Posted September 4, 2013 this is valhalla scripts, Noobs its the uG one. No need for saying noob. Facka noob =)
denny199 Posted September 4, 2013 Posted September 4, 2013 this is valhalla scripts, Noobs its the uG one. No need for saying noob. Facka noob =) LAL, uG = valhalla.
Recommended Posts