So it seems as if my DarkRP 2.5 server is empty for a long period of time, it will just randomly disconnect the database, or timeout or something.. so things that require databases will stop working.
For instance, my Gang/Organization mod will just disconnect from its database and say that I am not in a gang when I really am.
Any ideas?
Database is very vague...(sqllite, mysql, JSON)
[QUOTE=Ludicium;44345594]Database is very vague...(sqllite, mysql, JSON)[/QUOTE]
MySQL.
Mysqloo or tmysql?
I've only ever seen TMySQL disconnect when there was a syntax error in the sql. Same with oo. I've left my server open for over a week with no issues with loss of service.
Alternatively, you can do a check to see if the database hook is still running when you run a query. If not, restart the hook / db connection.
mysqloo follows standard database rules and if the connection is not used after x time, the server will close the connection. If it's a database you host specifically you can edit the timeout.
tmysql (to my knowledge at least) keeps the connection 'refreshed' and as a result it never actually closes (until specified).
Sorry, you need to Log In to post a reply to this thread.
