search

Newcomer1989 / TSN-Ranksystem

A PHP Bot that assigns time based server groups on TeamSpeak3.
https://ts-ranksystem.com
GNU General Public License v3.0
144 stars 60 forks source link

Multiple Instances running at same time #15

Closed zanhk closed 8 years ago

zanhk commented 8 years ago

After a little bit that the Query is connected to the TS, it disconnect automatically and the function check doesn't work. When i try to start it with php worker.php start it say that it's already running. php worker.php status The Ranksystem seems to be running. (but it doesn't work on ts, there is no query) For make it work I must restart it. and when i restart it say: php worker.php restart Stopping the Ranksystem Bot. Wait until Bot is down...... [Failed] Starting the Ranksystem Bot. [OK] Common problem? Thanks Zank

Newcomer1989 commented 8 years ago

You checked the ranksystem logfile? Per default it lies in logs/ranksystem.log Please post, what stands there at the time, the ranksystem disconnects automatically.

zanhk commented 8 years ago

last 8 lines:

your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'm noob"; [C++]')' at line 1 ) 2016-04-23 14:06:37.330069 Download new ServerIcon 2016-04-23 14:06:39.422630 Download new ServerIcon 2016-04-23 14:06:41.509953 Download new ServerIcon 2016-04-23 14:06:43.564059 Download new ServerIcon 2016-04-23 14:06:47.211229 Download new ServerIcon 2016-04-23 14:06:49.222627 Download new ServerIcon 2016-04-23 14:06:51.445401 Download new ServerIcon 2016-04-23 14:06:53.567620 Download new ServerIcon 2016-04-23 14:06:55.256544 Download new ServerIcon 2016-04-23 14:06:57.487315 Download new ServerIcon 2016-04-23 14:06:59.700136 Download new ServerIcon 2016-04-23 14:07:02.244595 Download new ServerIcon 2016-04-23 14:07:04.029733 Download new ServerIcon 2016-04-23 14:07:06.159904 Download new ServerIcon 2016-04-23 14:07:08.436008 Download new ServerIcon 2016-04-23 14:07:10.527917 Download new ServerIcon 2016-04-23 14:07:12.667623 Download new ServerIcon 2016-04-23 14:07:14.255707 Download new ServerIcon 2016-04-23 14:07:16.555624 Download new ServerIcon 2016-04-23 14:07:18.647879 Download new ServerIcon 2016-04-23 14:07:20.656112 Download new ServerIcon 2016-04-23 14:07:22.999086 Download new ServerIcon 2016-04-23 14:07:25.210539 Download new ServerIcon 2016-04-23 14:07:27.655490 Download new ServerIcon 2016-04-23 14:07:29.855630 Download new ServerIcon 2016-04-23 14:07:32.128378 Download new ServerIcon 2016-04-23 14:07:34.163256 Download new ServerIcon 2016-04-23 14:07:36.357659 Download new ServerIcon 2016-04-23 14:07:38.588193 Download new ServerIcon 2016-04-23 14:07:40.423147 Download new ServerIcon 2016-04-23 14:07:42.283804 Download new ServerIcon 2016-04-23 14:07:44.286492 Download new ServerIcon 2016-04-23 14:07:46.350361 Download new ServerIcon 2016-04-23 14:07:48.922536 Download new ServerIcon 2016-04-23 14:07:51.015035 Download new ServerIcon 2016-04-23 14:07:53.196045 Download new ServerIcon 2016-04-23 14:07:55.384384 Download new ServerIcon 2016-04-23 14:07:56.734995 calc_userstats 13:Array ( [0] => 42000 [1] => 1064 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'era un sogno che era Roma...')' at line 1 ) 1 Array ( [0] => 42000 [1] => 1064 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'era un sogno che era Roma...')' at line 1 ) 2016-04-23 14:07:57.908888 Download new ServerIcon 2016-04-23 14:07:59.847224 Download new ServerIcon 2016-04-23 14:08:02.212177 Download new ServerIcon 2016-04-23 14:08:04.614050 Download new ServerIcon 2016-04-23 14:08:06.611085 Download new ServerIcon 2016-04-23 14:08:08.775079 Download new ServerIcon 2016-04-23 14:08:11.436525 Download new ServerIcon 2016-04-23 14:08:13.533248 Download new ServerIcon 2016-04-23 14:08:15.607463 Download new ServerIcon 2016-04-23 14:08:18.387217 Download new ServerIcon 2016-04-23 14:08:19.522477 calc_userstats 13:Array ( [0] => 42000 [1] => 1064 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'm noob"; [C++]')' at line 1 ) 1 Array ( [0] => 42000 [1] => 1064 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'm noob"; [C++]')' at line 1 ) 2016-04-23 14:08:20.409428 Download new ServerIcon 2016-04-23 14:08:22.486533 Download new ServerIcon 2016-04-23 14:08:24.743333 Download new ServerIcon 2016-04-23 14:08:26.926788 Download new ServerIcon 2016-04-23 14:08:28.967371 Download new ServerIcon 2016-04-23 14:08:31.043711 Download new ServerIcon 2016-04-23 14:08:33.138617 Download new ServerIcon 2016-04-23 14:08:34.997540 Download new ServerIcon 2016-04-23 14:08:36.893723 Download new ServerIcon 2016-04-23 14:08:38.923053 Download new ServerIcon 2016-04-23 14:08:40.392382 Download new ServerIcon 2016-04-23 14:08:42.068742 Download new ServerIcon 2016-04-23 14:08:44.101553 Download new ServerIcon 2016-04-23 14:08:45.873260 Download new ServerIcon 2016-04-23 14:08:47.509258 Download new ServerIcon 2016-04-23 14:08:49.215142 Download new ServerIcon 2016-04-23 14:08:50.899325 Download new ServerIcon 2016-04-23 14:08:53.280798 Download new ServerIcon 2016-04-23 14:08:55.211968 Download new ServerIcon 2016-04-23 14:08:56.948018 Download new ServerIcon 2016-04-23 14:08:58.839121 Download new ServerIcon 2016-04-23 14:09:00.612141 Download new ServerIcon 2016-04-23 14:09:02.923749 Download new ServerIcon 2016-04-23 14:09:04.712017 Download new ServerIcon 2016-04-23 14:09:06.439335 Download new ServerIcon 2016-04-23 14:09:08.403827 Download new ServerIcon 2016-04-23 14:09:10.381424 Download new ServerIcon 2016-04-23 14:09:12.220560 Download new ServerIcon 2016-04-23 14:09:14.352258 Download new ServerIcon 2016-04-23 14:09:16.277341 Download new ServerIcon 2016-04-23 14:09:18.195234 Download new ServerIcon 2016-04-23 14:09:20.093357 Download new ServerIcon 2016-04-23 14:09:21.903057 Download new ServerIcon 2016-04-23 14:09:23.458963 Download new ServerIcon 2016-04-23 14:09:25.527308 Download new ServerIcon 2016-04-23 14:09:27.447844 Download new ServerIcon 2016-04-23 14:09:29.174442 Download new ServerIcon 2016-04-23 14:09:30.454502 calc_userstats 13:Array ( [0] => 42000 [1] => 1064 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'era un sogno che era Roma...')' at line 1 ) 1 Array ( [0] => 42000 [1] => 1064 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'era un sogno che era Roma...')' at line 1 ) 2016-04-23 14:09:31.170946 Download new ServerIcon 2016-04-23 14:09:33.047650 Download new ServerIcon 2016-04-23 14:09:35.023779 Download new ServerIcon 2016-04-23 14:09:36.735464 Download new ServerIcon 2016-04-23 14:09:38.536094 Download new ServerIcon 2016-04-23 14:09:40.200183 Download new ServerIcon 2016-04-23 14:09:42.320716 Download new ServerIcon 2016-04-23 14:09:44.310911 Download new ServerIcon 2016-04-23 14:09:46.200420 Download new ServerIcon 2016-04-23 14:09:48.162637 Download new ServerIcon 2016-04-23 14:09:49.681743 calc_userstats 13:Array ( [0] => 42000 [1] => 1064 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'm noob"; [C++]')' at line 1 ) 1 Array ( [0] => 42000 [1] => 1064 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'm noob"; [C++]')' at line 1 ) 2016-04-23 14:09:50.435118 Download new ServerIcon 2016-04-23 14:09:52.467098 Download avatar: /avatar_mcgefdlndbleonhhemnobmdcnhmegocaljkeefli 2016-04-23 14:09:52.639471 Download new ServerIcon 2016-04-23 14:09:54.496894 Download new ServerIcon 2016-04-23 14:09:56.427511 Download new ServerIcon 2016-04-23 14:09:58.379703 Download new ServerIcon 2016-04-23 14:10:00.520008 Download new ServerIcon 2016-04-23 14:10:02.403298 Download new ServerIcon 2016-04-23 14:10:04.425129 Download new ServerIcon

zanhk commented 8 years ago

It continue go down and the check option doesn't work

zanhk commented 8 years ago

The query is not in TS now but when I ask for status it say that is running

php worker.php status
The Ranksystem seems to be running.
zanhk commented 8 years ago

And in the stat page there is:

The Informations on this site could be outdated! It seems the Ranksystem is no more connected to the TeamSpeak.

Newcomer1989 commented 8 years ago

I would like to see it live.. Can you contact me on my TS (address: ts-n.net)?

zanhk commented 8 years ago

And this for every 10-15 min idk exactly. I change the cronjob to php worker.php restart but this create others problems (as the boost, every time boost restart from 0; and every time I save on core setting the query connect again http://hydrake.eu/files/public-docs/rank/log.png

zanhk commented 8 years ago

@Newcomer1989 sure

MadMarco97 commented 8 years ago

Same Problem here.

You found a solution for this?

zanhk commented 8 years ago

Seem to be fixed @MadMarco97 try put Slowmode high delay (1s).

Newcomer1989 commented 8 years ago

A crash could happens due ressources poverty. For this use the slowmode, for example with a high delay. That multiple Bots / Processes run at the same time is a problem by the restart function of worker.php. A fix of that will come with Release 1.0.1 (enable the update check inside the webinterface to get notified when it gets published).

MadMarco97 commented 8 years ago

I tried it with Slowmode many times, seems not working...

The bot connects, after about 20-30min -> "TS3 Rankingsystem timed out" "Connection lost"

But in the logfile there are only these "Downloading Icon..." Messages, no Error or something