Posts: 14
Threads: 4
Joined: Sep 2017
Reputation:
0
I am running a roleplay gamemode everything works smoothly for around day or even two and the suddenly there is no register no login n0 IG commands and players cannot log in, I tried to check the MySQL files and I've spotted that thre are no datafiles anymore! I tried to check up the MySQL logs of the server and it showed up several #1146 - Table 'xxx.xxxxx' doesn't exist errors, i even tried to change MySQL's I tried to re-install files, I tried to change functions in many ways nothing helped! I really need help I am using hosted server also, I need someone to be close to me and explain me step by step how to solve it.
Posts: 266
Threads: 22
Joined: Jan 2017
Reputation:
0
which mysql version are you using?
Posts: 266
Threads: 22
Joined: Jan 2017
Reputation:
0
try to restart the mysql server
Posts: 889
Threads: 4
Joined: Mar 2013
Reputation:
0
If it worked before, then your db is fucked.
Posts: 14
Threads: 4
Joined: Sep 2017
Reputation:
0
dude it worked only for a day and half and then just stopped working suddenly/
Posts: 373
Threads: 59
Joined: Jun 2014
Reputation:
0
1. Go and check your database host if is working or not.
2. Recomplie your gamemode.
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation:
0
Make sure any input to database by player is escaped, otherwise they can drop your tables (SQL Injection).
Posts: 249
Threads: 56
Joined: Jun 2013
Reputation:
0
if you took someone elses gamemode maybe they are trolling you like with a timer to drop your tables? i did that to my friend before which just in 2 hours drops the tables. Also if its not trolling maybe you didnt use mysql_escape_strings and when someone types like mysql drop into your password area it just drops your tables? ever thought about those? theres no reason to get tables deleted out of nowhere. No mysql server does that without a command to do so.