DarkRP Fails to create mySQL tables.

[AuroraEN]

I have entered all my details in correctly as well as installing mySQLoo modules without error. All my other addons that utilize MySQL are working well. It's just the DarkRP gamemode itself.

I am using the latest commit of the gamemode.

Here are the error logs:

Table 'darkrp_stats.darkrp_levels' doesn't exist (SELECT level,xp FROM darkrp_levels WHERE uid = "2492929737";)
Table 'darkrp_stats.darkrp_levels' doesn't exist (SELECT level,xp FROM darkrp_levels WHERE uid = "2492929737";)
L 07/04/2014 - 17:24:34: Lua Error: Table 'darkrp_stats.playerinformation' doesn't exist (REPLACE INTO playerinformation VALUES("2492929737", "STEAM_0:0:7193");)

Table 'darkrp_stats.playerinformation' doesn't exist (REPLACE INTO playerinformation VALUES("2492929737", "STEAM_0:0:7193");)
Table 'darkrp_stats.playerinformation' doesn't exist (REPLACE INTO playerinformation VALUES("2492929737", "STEAM_0:0:7193");)
L 07/04/2014 - 17:24:34: Lua Error: Table 'darkrp_stats.darkrp_player' doesn't exist (SELECT rpname, wallet, salary FROM darkrp_player WHERE uid = 2492929737;)

Table 'darkrp_stats.darkrp_player' doesn't exist (SELECT rpname, wallet, salary FROM darkrp_player WHERE uid = 2492929737;)
Table 'darkrp_stats.darkrp_player' doesn't exist (SELECT rpname, wallet, salary FROM darkrp_player WHERE uid = 2492929737;)
L 07/04/2014 - 17:24:34: Lua Error: Table 'darkrp_stats.playerinformation' doesn't exist (REPLACE INTO playerinformation VALUES("2492929737", "STEAM_0:0:7193");)

Table 'darkrp_stats.playerinformation' doesn't exist (REPLACE INTO playerinformation VALUES("2492929737", "STEAM_0:0:7193");)
Table 'darkrp_stats.playerinformation' doesn't exist (REPLACE INTO playerinformation VALUES("2492929737", "STEAM_0:0:7193");)
L 07/04/2014 - 17:24:34: Lua Error: Table 'darkrp_stats.darkrp_player' doesn't exist (SELECT rpname, wallet, salary FROM darkrp_player WHERE uid = 2492929737;)

Table 'darkrp_stats.darkrp_player' doesn't exist (SELECT rpname, wallet, salary FROM darkrp_player WHERE uid = 2492929737;)
Table 'darkrp_stats.darkrp_player' doesn't exist (SELECT rpname, wallet, salary FROM darkrp_player WHERE uid = 2492929737;)
L 07/04/2014 - 17:24:34: Lua Error: Table 'darkrp_stats.playerinformation' doesn't exist (REPLACE INTO playerinformation VALUES("2492929737", "STEAM_0:0:7193");)

Table 'darkrp_stats.playerinformation' doesn't exist (REPLACE INTO playerinformation VALUES("2492929737", "STEAM_0:0:7193");)
Table 'darkrp_stats.playerinformation' doesn't exist (REPLACE INTO playerinformation VALUES("2492929737", "STEAM_0:0:7193");)
L 07/04/2014 - 17:24:34: Lua Error: Table 'darkrp_stats.darkrp_player' doesn't exist (SELECT rpname, wallet, salary FROM darkrp_player WHERE uid = 2492929737;)

Table 'darkrp_stats.darkrp_player' doesn't exist (SELECT rpname, wallet, salary FROM darkrp_player WHERE uid = 2492929737;)
Table 'darkrp_stats.darkrp_player' doesn't exist (SELECT rpname, wallet, salary FROM darkrp_player WHERE uid = 2492929737;)
L 07/04/2014 - 17:24:34: Lua Error: Table 'darkrp_stats.playerinformation' doesn't exist (REPLACE INTO playerinformation VALUES("2492929737", "STEAM_0:0:7193");)

Table 'darkrp_stats.playerinformation' doesn't exist (REPLACE INTO playerinformation VALUES("2492929737", "STEAM_0:0:7193");)
Table 'darkrp_stats.playerinformation' doesn't exist (REPLACE INTO playerinformation VALUES("2492929737", "STEAM_0:0:7193");)
gamemodes/darkrp/gamemode/modules/base/sv_data.lua:289: Failed to retrieve player information from MySQL server

[AuroraEN]

I believe I just solved it myself. It's still a bug, however. FAdmin is required to be enabled, else it'll reproduce those errors above. I need FAdmin to stay disabled since it has some minor conflicts with ULX.

[FPtje]

I probably would have closed the issue if you didn't give me that last bit of information. Seriously thanks.

[FPtje]

Alright I just tried the following:

• clear MySQL table
• disable FAdmin
• start a server

All tables were created just fine. I've got a couple of ideas that might be causing your problem:

• The table darkrp_levels doesn't exist in DarkRP, at least not the latest.
• You might have a mod that uses DarkRP tables to get/insert information before DarkRP actually creates these tables. Tell the author of that mod to use the DarkRPDBInitialized hook. If this is the case you'll never see these errors again until you empty your MySQL Database.