search

FPtje / DarkRP

DarkRP, a non-serious roleplay gamemode for Garry's Mod.
https://darkrp.miraheze.org
MIT License
462 stars 707 forks source link

MySQL not creating/updating tables in Database. #1530

Closed ghost closed 10 years ago

ghost commented 10 years ago

This is what I get when I use MySQL with my DarkRP Server...

Couldn't include file 'libraries\database.lua' (File not found) (@gamemodes/dark rp/gamemode/init.lua (line 31))

[ERROR] gamemodes/darkrp/gamemode/modules/fadmin/fadmin/motd/sv_init.lua:13: att empt to index global 'MySQLite' (a nil value)

  1. unknown - gamemodes/darkrp/gamemode/modules/fadmin/fadmin/motd/sv_init.lua: 13
    1. include - [C]:-1
    2. AddCSLuaFolder - gamemodes/darkrp/gamemode/modules/fadmin/sv_fadmin.lua:3 2
      1. unknown - gamemodes/darkrp/gamemode/modules/fadmin/sv_fadmin.lua:41
      2. include - [C]:-1
      3. unknown - gamemodes/darkrp/gamemode/init.lua:56

[ERROR] gamemodes/darkrp/gamemode/init.lua:65: attempt to index global 'MySQLite ' (a nil value)

  1. unknown - gamemodes/darkrp/gamemode/init.lua:65

Couldn't Load Init Script: 'darkrp/gamemode/init.lua'

When Player is connecting/connected...

[ERROR] gamemodes/darkrp/gamemode/modules/fadmin/fadmin/access/sv_init.lua:83: a ttempt to index global 'MySQLite' (a nil value)

  1. SetUserGroup - gamemodes/darkrp/gamemode/modules/fadmin/fadmin/access/sv_in it.lua:83
    1. fn - lua/includes/extensions/player_auth.lua:90
    2. unknown - addons/ulib/lua/ulib/shared/hook.lua:183
      1. oldUID - [C]:-1
      2. UniqueID - gamemodes/darkrp/gamemode/modules/workarounds/sh_workarounds .lua:137
      3. query - addons/ulib/lua/ulib/shared/sh_ucl.lua:48
      4. echoToAdmins - addons/ulx/lua/ulx/log.lua:164
        1. fn - addons/ulx/lua/ulx/log.lua:196
        2. unknown - addons/ulib/lua/ulib/shared/hook.lua:183

[ERROR] Unauthed player

  1. query - [C]:-1
    1. echoToAdmins - addons/ulx/lua/ulx/log.lua:164
    2. fn - addons/ulx/lua/ulx/log.lua:196
      1. unknown - addons/ulib/lua/ulib/shared/hook.lua:183

[ERROR] addons/ulx/lua/ulx/modules/uteam.lua:23: attempt to index a nil value

  1. fn - addons/ulx/lua/ulx/modules/uteam.lua:23
    1. unknown - addons/ulib/lua/ulib/shared/hook.lua:183

[Hazard|2|STEAM_0:1:20608063] Lua Error:

[ERROR] Unauthed player

  1. query - [C]:-1
    1. refresh - addons/ulx/lua/ulx/xgui/commands.lua:299
    2. unknown - addons/ulx/lua/ulx/xgui/commands.lua:388
      1. include - [C]:-1
      2. fn - addons/ulx/lua/ulx/modules/cl/xgui_client.lua:114
      3. Call - addons/ulib/lua/ulib/shared/hook.lua:183
      4. fn - addons/ulib/lua/ulib/cl_init.lua:54
        1. func - addons/ulib/lua/ulib/client/cl_util.lua:22
        2. unknown - lua/includes/modules/net.lua:32

[Hazard|2|STEAM_0:1:20608063] Lua Error:

[ERROR] Unauthed player

  1. query - [C]:-1
    1. processModules - addons/ulx/lua/ulx/modules/cl/xgui_client.lua:205
    2. fn - addons/ulx/lua/ulx/modules/cl/xgui_client.lua:162
      1. Call - addons/ulib/lua/ulib/shared/hook.lua:183
      2. fn - addons/ulib/lua/ulib/cl_init.lua:54
      3. func - addons/ulib/lua/ulib/client/cl_util.lua:22
      4. unknown - lua/includes/modules/net.lua:32

[Hazard|2|STEAM_0:1:20608063] Lua Error:

[ERROR] lua/autorun/workshop.lua:5: attempt to call field 'AddWorkshop' (a nil v alue)

  1. unknown - lua/autorun/workshop.lua:5

[Hazard|2|STEAM_0:1:20608063] Lua Error:

[ERROR] gamemodes/darkrp/gamemode/modules/base/sh_createitems.lua:591: attempt t o index global 'disjoint' (a nil value)

  1. AddAgenda - gamemodes/darkrp/gamemode/modules/base/sh_createitems.lua:591
    1. unknown - gamemodes/darkrp/gamemode/config/jobrelated.lua:230
    2. include - [C]:-1
      1. unknown - gamemodes/darkrp/gamemode/cl_init.lua:36

[ERROR] Unauthed player

  1. query - [C]:-1
    1. sendDataTable - addons/ulx/lua/ulx/modules/xgui_server.lua:153
    2. unknown - addons/ulx/lua/ulx/modules/xgui_server.lua:74
      1. unknown - addons/ulx/lua/ulx/modules/xgui_server.lua:53
      2. unknown - lua/includes/modules/concommand.lua:69

MDLCache: TDMCars\bmwm3e92.mdl needs to be recompiled

[ERROR] gamemodes/darkrp/gamemode/modules/doorsystem/sv_doors.lua:59: attempt to perform arithmetic on field 'OwnedNumz' (a nil value)

  1. keysOwn - gamemodes/darkrp/gamemode/modules/doorsystem/sv_doors.lua:59
    1. SpawnVehicle - addons/npcardealer/lua/npcshop/server.lua:142
    2. unknown - addons/npcardealer/lua/npcshop/server.lua:196
      1. unknown - lua/includes/modules/concommand.lua:69

The Only tables I have in my MySQL database is "commands". I had an autodonation script that requiered MySQL. It works BUT the actual DarkRP Gamemode does not work with MySQL, unauthing players and nothing works like Jobs, Salary and Money, Models going full reatarded etc...

I have the latest versions of MySQLOO and libMySQL, the AutoDonation script is connecting with the MySQL database so I used the EXACT same information for the DarkRP MySQL connection information, but does not work.

I've been googilin' and everythin'. No luck and now im so sick of it.

Only table is this one...

http://i.imgur.com/XhYOdp4.png

FPtje commented 10 years ago

Bad install, not my problem.

ghost commented 10 years ago

What is the bad install, MySQL or DarkRP

Bo98 commented 10 years ago

This happens if you enabled MySQL but do not have MySQLOO installed (or haven't installed it correctly).

ghost commented 10 years ago

I have it installed correctly, some scripts in the servers that need MySQL connection connects but the actual DarkRP gamemode is not.

ghost commented 10 years ago

I just update to the latest DarkRP verusion, doubt the file is corrupt, still trying on fresh. Just for you.

ghost commented 10 years ago

Seems to be working.

Thanks for the very quick response.

ghost commented 10 years ago

Nevermind, it's back with the exact same error. Even on the latest version...

I tried even without MySQL and it fuck't up again.

ghost commented 10 years ago

Do I need to make some lua script for this MySQLOO module in the Lua folder?