{"action":"created","issue":{"url":"https://api.github.com/repos/ThrivingVentures/ServerGuard/issues/387","repository_url":"https://api.github.com/repos/ThrivingVentures/ServerGuard","labels_url":"https://api.github.com/repos/ThrivingVentures/ServerGuard/issues/387/labels{/name}","comments_url":"https://api.github.com/repos/ThrivingVentures/ServerGuard/issues/387/comments","events_url":"https://api.github.com/repos/ThrivingVentures/ServerGuard/issues/387/events","html_url":"https://github.com/ThrivingVentures/ServerGuard/issues/387","id":162219621,"number":387,"title":"[MYSQL] Issue","user":{"login":"Corvezeo","id":11237919,"avatar_url":"https://avatars.githubusercontent.com/u/11237919?v=3","gravatar_id":"","url":"https://api.github.com/users/Corvezeo","html_url":"https://github.com/Corvezeo","followers_url":"https://api.github.com/users/Corvezeo/followers","following_url":"https://api.github.com/users/Corvezeo/following{/other_user}","gists_url":"https://api.github.com/users/Corvezeo/gists{/gist_id}","starred_url":"https://api.github.com/users/Corvezeo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Corvezeo/subscriptions","organizations_url":"https://api.github.com/users/Corvezeo/orgs","repos_url":"https://api.github.com/users/Corvezeo/repos","events_url":"https://api.github.com/users/Corvezeo/events{/privacy}","received_events_url":"https://api.github.com/users/Corvezeo/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ThrivingVentures/ServerGuard/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/ThrivingVentures/ServerGuard/labels/error","name":"error","color":"0e8a16"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":16,"created_at":"2016-06-24T19:56:33Z","updated_at":"2016-06-25T01:44:56Z","closed_at":null,"body":"Serverguard: version 1.7.5\r\n\r\nHello, for some reason Serverguard isn't showing the ranks in game when I start the server up. it's saying its connecting to the database and its not throwing any errors. \r\n\r\nINFORMATION\r\n\r\nAll information listed as [redacted] below has been removed for obvious reasons, however I have double checked all the information, and its 100% correct. I can clearly see its connecting to the database, I have also checked my mysql database to make sure the tables are there, and they are with all of the correct information. But when I start up my server, its using a completely different database, I think its defaulting to text file format, as it uses the default set ranks that come with server guard.\r\n\r\nIMAGES\r\nServerguard tables in correct datebase\r\nhttps://gyazo.com/74beb7621686349d66637e80a6996518 = Tables\r\nhttps://gyazo.com/743020ee7c9d915bf6505a38e2a16202 = Ranks table\r\nhttps://gyazo.com/efe37e1ec6c828bd171539a957c2d950 = Ranks that are showing up.\r\n\r\n\r\n\"mysql\"\r\n{\r\n    \"enabled\"       1\r\n    \"username\"      \"redacted\"\r\n    \"password\"      \"redacted\"\r\n    \"database\"      \"redacted\"\r\n    \"host\"          \"redacted\"\r\n    \"unixsocket\"    \"example_socket\"\r\n    \"module\"\t\t\"tmysql4\"\r\n}\r\n\r\nWhen I start the server up I get no errors, I do get the following message from serverguard.\r\n[15:53][ServerGuard] [mysql] Connected to the database!\r\n\r\nBut as you can see, it's not connecting as I do not see any of my custom ranks. It was working fine, and then I updated, and now its not, I do not have an older version to go back too.\r\n"},"comment":{"url":"https://api.github.com/repos/ThrivingVentures/ServerGuard/issues/comments/228500420","html_url":"https://github.com/ThrivingVentures/ServerGuard/issues/387#issuecomment-228500420","issue_url":"https://api.github.com/repos/ThrivingVentures/ServerGuard/issues/387","id":228500420,"user":{"login":"meepdarknessmeep","id":6186313,"avatar_url":"https://avatars.githubusercontent.com/u/6186313?v=3","gravatar_id":"","url":"https://api.github.com/users/meepdarknessmeep","html_url":"https://github.com/meepdarknessmeep","followers_url":"https://api.github.com/users/meepdarknessmeep/followers","following_url":"https://api.github.com/users/meepdarknessmeep/following{/other_user}","gists_url":"https://api.github.com/users/meepdarknessmeep/gists{/gist_id}","starred_url":"https://api.github.com/users/meepdarknessmeep/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/meepdarknessmeep/subscriptions","organizations_url":"https://api.github.com/users/meepdarknessmeep/orgs","repos_url":"https://api.github.com/users/meepdarknessmeep/repos","events_url":"https://api.github.com/users/meepdarknessmeep/events{/privacy}","received_events_url":"https://api.github.com/users/meepdarknessmeep/received_events","type":"User","site_admin":false},"created_at":"2016-06-25T01:44:56Z","updated_at":"2016-06-25T01:44:56Z","body":"It seems it's a problem with the gmod modules themselves for mysql. It seems to run our query fine when running directly in the non-gmod console. \r\n\r\n```sql\r\nALTER TABLE `serverguard_ranks` ADD `targetable` INT(11) NOT NULL DEFAULT 0;\r\nUPDATE `serverguard_ranks` SET `targetable` = `immunity`;\r\nREPLACE INTO `serverguard_schema` (`id`, `version`) VALUES (\"serverguard_ranks\", 1);\r\n```\r\n\r\nYou can run this to fix it. I will see if we can get the modules updated."}}
{"actor":{"display_login":"meepdarknessmeep"}}