mySQL problem - Printable Version

mySQL problem - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: mySQL problem (/showthread.php?tid=170638)

mySQL problem - Andrus - 23.08.2010

Hello,

I have a problem with mySQL.Well, I start my server, mySQL plugin loads, then it starts loading cars from mySQL database and then, the server just crashes.

Here is the server-log:

Code:

SA-MP Dedicated Server
----------------------
v0.3b R2,  2005-2010 SA-MP Team

[16:58:56] 
[16:58:56] Server Plugins
[16:58:56] --------------
[16:58:56]  Loading plugin: mysql
[16:58:56]  SA:MP MySQL Plugin v2.0 Loaded.
[16:58:56]   Loaded.
[16:58:56]  Loading plugin: streamer
[16:58:56] [MySQL] Thread running. Threadsafe: Yes.
[16:58:56]  *** Streamer Plugin v2.3.8 by Incognito loaded *** 
[16:58:56]   Loaded.
[16:58:56]  Loaded 2 plugins.

[16:58:56] 
[16:58:56] Filter Scripts
[16:58:56] ---------------
[16:58:56]   Loaded 0 filter scripts.

[16:58:56] [MySQL] Connected   to sampi @ 127.0.0.1 via TCP/IP.
[16:58:56] [MySQL] Version 5.1.36-community-log.
[16:58:56] [MySQL] Connected (1) to sampi @ 127.0.0.1 via TCP/IP.
[16:58:56] [MySQL] Version 5.1.36-community-log.
[16:58:56] [MySQL] Connected (2) to sampi @ 127.0.0.1 via TCP/IP.
[16:58:56] [MySQL] Version 5.1.36-community-log.

mySQL log:

Code:

[Mon Aug 23 16:58:56 2010] -------------------------
[Mon Aug 23 16:58:56 2010]      Logging Started
[Mon Aug 23 16:58:56 2010] -------------------------
[Mon Aug 23 16:58:56 2010] Function: mysql_init executed with result: "0".
[Mon Aug 23 16:58:56 2010] Connected (0) to sampi @ 127.0.0.1 via TCP/IP.
[Mon Aug 23 16:58:56 2010] MySQL Version 5.1.36-community-log.
[Mon Aug 23 16:58:56 2010] Function: mysql_ping executed with result: "0".
[Mon Aug 23 16:58:56 2010] Function: mysql_query executed: "SELECT COUNT(*) FROM donatorcars" with result: "0".
[Mon Aug 23 16:58:56 2010] Function: mysql_store_result executed with result: "1"
[Mon Aug 23 16:58:56 2010] Function: mysql_fetch_row executed with result: "1".
[Mon Aug 23 16:58:56 2010] Function: mysql_free_result executed.
[Mon Aug 23 16:58:56 2010] Function: mysql_query executed: "SELECT * FROM donatorcars WHERE id=1" with result: "0".
[Mon Aug 23 16:58:56 2010] Function: mysql_store_result executed with result: "1"
[Mon Aug 23 16:58:56 2010] Function: mysql_fetch_row executed with result: "1|461|5.77700|120.44323|24.65400|180.00000|123.00000|11.00654|154.12300|0.16500|1|0|0|No-one|0".
[Mon Aug 23 16:58:56 2010] Function: mysql_init executed with result: "1".
[Mon Aug 23 16:58:56 2010] Connected (1) to sampi @ 127.0.0.1 via TCP/IP.
[Mon Aug 23 16:58:56 2010] MySQL Version 5.1.36-community-log.
[Mon Aug 23 16:58:56 2010] Function: mysql_ping executed with result: "0".
[Mon Aug 23 16:58:56 2010] Function: mysql_query executed: "SELECT COUNT(*) FROM donatorcars" with result: "0".
[Mon Aug 23 16:58:56 2010] Function: mysql_store_result executed with result: "1"
[Mon Aug 23 16:58:56 2010] Function: mysql_fetch_row executed with result: "1".
[Mon Aug 23 16:58:56 2010] Function: mysql_free_result executed.
[Mon Aug 23 16:58:56 2010] Function: mysql_query executed: "SELECT * FROM donatorcars WHERE id=1" with result: "0".
[Mon Aug 23 16:58:56 2010] Function: mysql_store_result executed with result: "1"
[Mon Aug 23 16:58:56 2010] Function: mysql_fetch_row executed with result: "1|461|5.77700|120.44323|24.65400|180.00000|123.00000|11.00654|154.12300|0.16500|1|0|0|No-one|0".
[Mon Aug 23 16:58:56 2010] Function: mysql_init executed with result: "2".
[Mon Aug 23 16:58:56 2010] Connected (2) to sampi @ 127.0.0.1 via TCP/IP.
[Mon Aug 23 16:58:56 2010] MySQL Version 5.1.36-community-log.
[Mon Aug 23 16:58:56 2010] Function: mysql_ping executed with result: "0".

Re: mySQL problem - WackoX - 23.08.2010

Why did you made 3 of the same connections?

Re: mySQL problem - Sergei - 23.08.2010

Why don't you ask in plugin's topic?

Re: mySQL problem - Andrus - 23.08.2010

Quote:

Originally Posted by WackoX

Why did you made 3 of the same connections?

There is actually one connection, the server automatically connects 3 times.

Re: mySQL problem - Andrus - 24.08.2010

Bring
Up
My
Post