search

xbread / SantosRP

MIT License
7 stars 5 forks source link

stuck on read only #9

Closed julian12517 closed 3 years ago

julian12517 commented 3 years ago

says its in read only mode and wont write santos files to the db

xbread commented 3 years ago

Can you make a video of you doing some things then relogging. I havent had this issue and I used this gamemode within the last month.

julian12517 commented 3 years ago

`[SQL] Read-only database connected. [SQL] Write worker 1 connected. [SQL] Write worker 2 connected. [SQL] Write worker 3 connected. [SQL] Write worker 4 connected. [SQL] Write worker 5 connected. [SQL] Write worker 6 connected. [SQL] Write worker 7 connected. [SQL] Write worker 8 connected. [SQL] Initializing gamemode tables...

[ERROR] gamemodes/santosrp/gamemode/sv_mysql.lua:268: attempt to call method 'IsConnected' (a nil value)

  1. PooledQueryWrite - gamemodes/santosrp/gamemode/sv_mysql.lua:268
    1. InitGamemodeTables - gamemodes/santosrp/gamemode/sv_mysql_player.lua:35
    2. Connect - gamemodes/santosrp/gamemode/sv_mysql.lua:29
      1. unknown - gamemodes/santosrp/gamemode/init.lua:50`

thats the first sql related thing that comes up in server log

julian12517 commented 3 years ago

i honestly don't even know what the issue could possibly be i've been trying constantly to fix this issue over the past couple days and nothing

xbread commented 3 years ago

You are using TMYSQL4 correct also, have you checked if external connections are enabled on your database <- if not done by your host by default

Edit: ensure you're using this repo: https://github.com/bkacjios/gm_tmysql4 In the future I might update the gamemode to use MYSQLOO just never see anyone really use this gamemode that much tho

julian12517 commented 3 years ago

alright so using that got rid of the error but it still says read only

julian12517 commented 3 years ago

nevermind it's working now thanks man

julian12517 commented 3 years ago

would you happen to have a list of commands for whitelisting etc...

xbread commented 3 years ago

The command itself can be found in sv_jobs.lua also, add me on discord if you have any other questions bread#4487 A few commands: srp_admin_whitelist_player jobid srp_dev_give_money srp_dev_remove // removes the ent you're looking at srp_dev_change_player_name