[ HELP ] Server isn't connecting 2nd connection to 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: [ HELP ] Server isn't connecting 2nd connection to mySQL (/showthread.php?tid=553959)
+- 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: [ HELP ] Server isn't connecting 2nd connection to mySQL (/showthread.php?tid=553959)
[ HELP ] Server isn't connecting 2nd connection to mySQL - SpikY_ - 01.01.2015
Hellu all,
My Gamemode having two connections to mysql!
first connect and second connect!
my Server connect to first connection but isn't connecting to second connection !
why?
here are the codes and Server_log!
Код:
[12:01:45] [12:01:45] [12:01:46] 24424 Dynamic Objects Loaded [12:01:46] 17 Bars Loaded [12:01:46] 559 Vehicles Loaded [12:01:46] -1218878512 [12:01:46] [MYSQL]:first Connection to `DATABASE` successful! || 1 [12:01:46] EEEEEEEEEEEE XXX XXX SSSSSSSSSSSSSSS [12:01:46] EEEEEEEEEEEE XXX XXX SSSSSSSSSSSSSSS [12:01:46] EEE XXX XXX SSS [12:01:46] EEE XXX XXX SSS [12:01:46] EEE XXX XXX SSS [12:01:46] EEEEEEEEE XXXXXXXXX SSSSSSSSSSSSSSS [12:01:46] EEEEEEEEE XXXXXXXXX SSSSSSSSSSSSSSS [12:01:46] EEE XXX XXX SSS [12:01:46] EEE XXX XXX SSS [12:01:46] EEEEEEEEEEEE XXX XXX SSSSSSSSSSSSSSS by SpikY_™ [12:01:46] EEEEEEEEEEEE XXX XXX SSSSSSSSSSSSSSS [12:01:46] Number of vehicle models: 179
pawn Код:
forward ConnectMySQL();
public ConnectMySQL()
{
eXs=mysql_connect("localhost","******", "*******", "******");
//example eXs=mysql_connect("127.0.0.1","*******", "******", "*********");
printf("%d",mysql_errno(eXs));
if(mysql_errno() == 0)
{
mysql_close(eXs);
printf("[MYSQL]: [ERROR]:first Connection to `DATABASE` failed!");
eXs=mysql_connect("localhost","********", "****", "***");
//example eXs=mysql_connect("127.0.0.1","********", "******", "*******");
printf("%d",mysql_errno(eXs));
if(mysql_errno() == 0)
{
mysql_close(eXs);
printf("[MYSQL]: [ERROR]:Second Connection to `DATABASE` failed!");
}
else
{
//mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG);
printf("[MYSQL]:second Connection to `DATABASE` successful! || %d",eXs);
con=2;
}
}
else
{
//mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG);
printf("[MYSQL]:first Connection to `DATABASE` successful! || %d",eXs);
con=1;
}
return 1;
}
Re: [ HELP ] Server isn't connecting 2nd connection to mySQL - SpikY_ - 01.01.2015
ok but if its connected to first connection then why the register dialog isn't loaded! and many other datas? e.g /stats isn't working !
Re: [ HELP ] Server isn't connecting 2nd connection to mySQL - SpikY_ - 02.01.2015
Here are the mysql error :
Код:
[02:11:13] [WARNING] CMySQLHandler::FreeResult() - The result is already empty. [02:11:13] [ERROR] >> mysql_query_callback() - Invalid connection handle. (ID = 1). [02:11:13] [ERROR] >> mysql_query_callback() - Invalid connection handle. (ID = 1). [02:11:13] [ERROR] >> mysql_query_callback() - Invalid connection handle. (ID = 1). [02:11:13] [ERROR] >> mysql_query_callback() - Invalid connection handle. (ID = 1). [02:11:13] [ERROR] >> mysql_query_callback() - Invalid connection handle. (ID = 1). [02:11:13] [ERROR] >> mysql_query_callback() - Invalid connection handle. (ID = 1). [02:11:13] [ERROR] >> mysql_query_callback() - Invalid connection handle. (ID = 1). [02:11:13] [ERROR] >> mysql_query_callback() - Invalid connection handle. (ID = 1). [02:11:13] [ERROR] >> mysql_query_callback() - Invalid connection handle. (ID = 1). [02:11:13] [ERROR] >> mysql_query_callback() - Invalid connection handle. (ID = 1). [02:11:13] [ERROR] >> mysql_query_callback() - Invalid connection handle. (ID = 1). [02:11:14] [ERROR] >> mysql_query_callback() - Invalid connection handle. (ID = 1). [02:11:14] [ERROR] >> mysql_query_callback() - Invalid connection handle. (ID = 1).
Re: [ HELP ] Server isn't connecting 2nd connection to mySQL - SpikY_ - 03.01.2015
Quote:
|
Originally Posted by ******
 pawn Код:
|
So should i need to change 0 to 1?
like this
pawn Код:
if(mysql_errno() == 1)