***If you are getting this error, go to darkrpmodification-master/lua/darkrp_config/mysql.lua and on the enable line, change it to true. ***
I keep getting the same error. I have asked a few people and they all said that I should not be getting this error.
[ERROR] gamemodes/darkrp/gamemode/libraries/mysqlite/mysqlite.lua:294: near "AUTO_INCREMENT": syntax error ( CREATE TABLE IF NOT EXISTS darkrp_stats( id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, uid VARCHAR(45) NOT NULL, stat VARCHAR(32) NOT NULL, value int(11) NOT NULL ); ) 1. error - [C]:-1 2. query - gamemodes/darkrp/gamemode/libraries/mysqlite/mysqlite.lua:294 3. fn - addons/mvloading/lua/darkrp_modules/mvloading/sv_stats.lua:3 4. Call - addons/ulib/lua/ulib/shared/hook.lua:179 5. unknown - gamemodes/darkrp/gamemode/libraries/mysqlite/mysqlite.lua:159 Timer Failed! [Simple][@gamemodes/darkrp/gamemode/libraries/mysqlite/mysqlite.lua (line 157)]
I installed the libmysql.so.16 file in the root of the server and the gmsv_mysqloo_linux.dll file in (server root)/lua/bin/gmsv_mysqloo_linux.dll
I entered the MySQL database information correctly. I have tested a database from my webhost (hosting24.com) and a database from 000webhost.com. I still can’t figure out what this error is because it points to seemingly random lines.
if not supp then error(err .. " (" .. sqlText .. ")") end
MVLoading Error On Line 3 (Lines 1-10)
function DarkRPInit() //Create the stats table if it is needed MySQLite.query([[ CREATE TABLE IF NOT EXISTS darkrp_stats( id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, uid VARCHAR(45) NOT NULL, stat VARCHAR(32) NOT NULL, value int(11) NOT NULL ); ]])
a, b, c, d, e, f = v.fn( ... )
Any help is greatly appreciated
If you need to contact me, either add me on Steam and send me a message.