MySQLOO error (Need help ASAP)

***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.

Line 159



            hook.Call("DatabaseInitialized", GAMEMODE)


Line 294



        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
            );
        ]])


ULib error



                    a, b, c, d, e, f = v.fn( ... )


Any help is greatly appreciated :smiley:

If you need to contact me, either add me on Steam and send me a message.

You should have posted that in the “Developer” section.
When you query something with SQLite, you use “AUTOINCREMENT”.
With MySQL, you have to use “AUTO_INCREMENT” instead.
Try to change that line (try to remove NOT NULL because it can’t anyway)

I can’t seem to find the line. Could you possibly help me out over steam?

[editline]26th January 2016[/editline]

This seems to be a DarkRP Problem.
Did you installed the newest Version of DarkRP?

try:

Download DarkRP from: https://github.com/FPtje/DarkRP and upload it to your Server (Remove the other darkrp from gamemodes folder!)

Change rename to darkrp (if it is not)

I cant reproduce this error.

Greets
SeaLife