Problem with mysql - Printable Version

Problem with mysql - 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: Problem with mysql (/showthread.php?tid=389553)

Problem with mysql - thefatshizms - 02.11.2012

Hi, my server was working perfectly fine yesterday has no error's in the script nethier warnings. Ive had restore my pc to its default setting due to some issues. Ive set everything back up the mysql database plugins etc but when i enter the server it says 'Server closed connection'. When i check the mysql debug i can see its not even ettempting to connect to the database can someone help?

mysql debug:

Код:

[15:33:31] ---------------------------

[15:33:31] MySQL Debugging activated (11/02/12)

[15:33:31] ---------------------------

[15:33:31]

Re: Problem with mysql - doreto - 02.11.2012

Did you have mysql host on your pc (such us XAMPP) ?

Re: Problem with mysql - thefatshizms - 02.11.2012

Yes, as ive said the server was working fine before i restored it.

I have both apache and mysql turned on

Re: Problem with mysql - Lorrden - 02.11.2012

use mysql_ping()

Re: Problem with mysql - thefatshizms - 02.11.2012

Код:

[22:03:04] >> mysql_ping( Connection handle: 1 )

[22:03:04] CMySQLHandler::Ping() - Connection is still alive.

This is the only thing thats in my mysql log there should be something like "connected to localhost" but it wont show 0.o

Re: Problem with mysql - Lorrden - 02.11.2012

Make sure no permissions has been changed.

Re: Problem with mysql - ReneG - 02.11.2012

Are you SURE your credentials match your database?

Re: Problem with mysql - thefatshizms - 02.11.2012

I'm sure. The database was working perfectly before i restored my pc. When i got my gm back from a backup i set up the database and imported a table sql dumb that i made before the restore

Re: Problem with mysql - thefatshizms - 04.11.2012

Bump

Re: Problem with mysql - Hiddos - 04.11.2012

Quote:

Originally Posted by thefatshizms

when i enter the server it says 'Server closed connection'

debug OnPlayerConnect in every script (including filterscripts if you have any, you might also decide to turn them off for debugging)