SA-MP Forums Archive
My MySQL database are deleting ... - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: My MySQL database are deleting ... (/showthread.php?tid=368786)


My MySQL database are deleting ... - Edvin - 14.08.2012

Hey

I have a big problem with my mysql database. Few days ago, it starts to auto-deleting, and I don't know the reason. I don't gave to anyone database infos, like: password, databasename and host.

I don't use any syntaxes like: "DROP", or something to affect tables.

What can cause this?

Re: My MySQL database are deleting ... - doreto - 14.08.2012

Did you have mysql log from this days were you thing is deleting ? that really will help solve the problem

Re: My MySQL database are deleting ... - playbox12 - 14.08.2012

Change the password to your database and see if it happens again. There is not such thing as auto deletion, it must be caused by someone deliberately executing a delete query.

Re: My MySQL database are deleting ... - Edvin - 14.08.2012

@doreto i have logs, when this think happen' i put mysql_debug, and i found something ... suspect?
Код:
mysql_query( "DELETE FROM `DM_Event`", THREAD_NONE );
And when this query have been actioned, in debug.txt show me this:
Код:
[10:39:50] CMySQLHandler::Query(DELETE FROM `DM_Event`) - An error has occured. (Error ID: 1146, Table 'zp_26221.DM_Event' doesn't exist)
... This can cause that? I don't know, but ...

@playbox12 Yes, now i changed my DB password, hope this problem stop now ...