aciurczak
Wed 16th Aug '06, 9:59am
Hi -
Since upgrading to 3.6.0 and setting up a bunch of RSS feeds, I'm getting quite a few 2013 errors each day. Thinking it was because of too many feeds, I set the limit on each feed to "2". This did shorten the size of the query by quite a bit, but it still shows up as a mySQL error quite often. (I posted one of the first errors I got at: link to thread elsewhere on this site (http://www.vbulletin.com/forum/showthread.php?t=196240))
Here is an example error from last night:
Database error in vBulletin 3.6.0:
Invalid SQL:
SELECT * FROM rsslog
WHERE uniquehash IN ('3333bd995cc14a5d67068d32d49d5a75', '28f9d1b0cdf8915032c476f18d696b48', 'e6f69f11766b42b8aae7e932d197bd99', 'b4f142cc6a54e801dc54b2fcde5883e1', '42389eb46dca2b5b002174d09cd46d7f', '8aeb8299048cb10e77e7139ec00cfc23', 'c1ec177f622d2dfb32ec105f1fa4c4f6', 'dc7a8780c8908c73a96bf59ddfef163b', 'ed72583a2b8bcbec8f05e6506f213ff5', 'ae879e6d10e1cfeb0fe945f5f248f8bd', 'be28b54872a2f7f7fb46c0df4eba3095', 'b43f450248a54f80354f2e1b3896756b', 'b8b87a0b7d705ad471aaea82a0bd062b', 'd8d9ed2a1a79f859931e69e781fefe21', 'a5e512bf46e65de56a106c348a8f4ac5', '86e251867de0b3364b3f336529af8daa', '7ed0820311b2e4f17b60f089f4a05415', '2c5dab7c2de582b41128fb5438ddf816', 'f7682133e385404890e052625e64efdb', '169e2b0db4b57b7293a98811c586cdb8', '0abf39a37e979cfa57d19cce183f92f5', 'd827ea84fe4f973693d0c5738804454a', 'b5482d66606779eb3f459e7a0221d573', '86fa05e89cc5df59ddcaa49e6c023861', '1bb339cc2bca63a53ec563add12a14e5', '227505003768a44d89a8fc99116a74e3', 'b53eb00bc15d347209e4b6490c816458', '21fb92f659bfaa8faf05d0d9da5ac551', 'e05046f8c5bd5235b446c636fbc69eef', 'd81d81fcc7f15b3ece1298574211c255', '7860ad8565ad10adf70e69b31c731eac', '56fd43c7cd30b70aa9d267e28faf9aca', '9aca52916c74f30a1fdc38da9b94f316', '855eb842b618157b1591e632ff275d5a', '45891a36f5e998467c3d3bc1e157a61b', 'a9f8494211eb2fa7a64e65c8f55fd315', '9350d6798d7f3865b8bb1536b9866927', '0efab3fed2d4d45da1273ec1494fdc7a');
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Wednesday, August 16th 2006 @ 07:26:57 AM
Script : http://www.xxx.com/forums/cron.php?&rand=150170
Referrer : http://www.xxx.com/forums/showthread.php?t=6889
IP Address : xxx.xxx.xxx.xxx
Username : Unregistered
Classname : vb_database
The part where it says "Invalid SQL" is what worries me; looking at the query myself now that it is shorter, I can't see what is invalid about it. The bot is still posting RSS feeds, but I can't tell if it is posting all or just some of the ones it is supposed to. Any suggestions?
According to the admin control panel, PHP is at 4.3.10, and MySQL is 4.1.20-log. MySQL packet size is 1,023 KB. Any suggestions?
Since upgrading to 3.6.0 and setting up a bunch of RSS feeds, I'm getting quite a few 2013 errors each day. Thinking it was because of too many feeds, I set the limit on each feed to "2". This did shorten the size of the query by quite a bit, but it still shows up as a mySQL error quite often. (I posted one of the first errors I got at: link to thread elsewhere on this site (http://www.vbulletin.com/forum/showthread.php?t=196240))
Here is an example error from last night:
Database error in vBulletin 3.6.0:
Invalid SQL:
SELECT * FROM rsslog
WHERE uniquehash IN ('3333bd995cc14a5d67068d32d49d5a75', '28f9d1b0cdf8915032c476f18d696b48', 'e6f69f11766b42b8aae7e932d197bd99', 'b4f142cc6a54e801dc54b2fcde5883e1', '42389eb46dca2b5b002174d09cd46d7f', '8aeb8299048cb10e77e7139ec00cfc23', 'c1ec177f622d2dfb32ec105f1fa4c4f6', 'dc7a8780c8908c73a96bf59ddfef163b', 'ed72583a2b8bcbec8f05e6506f213ff5', 'ae879e6d10e1cfeb0fe945f5f248f8bd', 'be28b54872a2f7f7fb46c0df4eba3095', 'b43f450248a54f80354f2e1b3896756b', 'b8b87a0b7d705ad471aaea82a0bd062b', 'd8d9ed2a1a79f859931e69e781fefe21', 'a5e512bf46e65de56a106c348a8f4ac5', '86e251867de0b3364b3f336529af8daa', '7ed0820311b2e4f17b60f089f4a05415', '2c5dab7c2de582b41128fb5438ddf816', 'f7682133e385404890e052625e64efdb', '169e2b0db4b57b7293a98811c586cdb8', '0abf39a37e979cfa57d19cce183f92f5', 'd827ea84fe4f973693d0c5738804454a', 'b5482d66606779eb3f459e7a0221d573', '86fa05e89cc5df59ddcaa49e6c023861', '1bb339cc2bca63a53ec563add12a14e5', '227505003768a44d89a8fc99116a74e3', 'b53eb00bc15d347209e4b6490c816458', '21fb92f659bfaa8faf05d0d9da5ac551', 'e05046f8c5bd5235b446c636fbc69eef', 'd81d81fcc7f15b3ece1298574211c255', '7860ad8565ad10adf70e69b31c731eac', '56fd43c7cd30b70aa9d267e28faf9aca', '9aca52916c74f30a1fdc38da9b94f316', '855eb842b618157b1591e632ff275d5a', '45891a36f5e998467c3d3bc1e157a61b', 'a9f8494211eb2fa7a64e65c8f55fd315', '9350d6798d7f3865b8bb1536b9866927', '0efab3fed2d4d45da1273ec1494fdc7a');
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Wednesday, August 16th 2006 @ 07:26:57 AM
Script : http://www.xxx.com/forums/cron.php?&rand=150170
Referrer : http://www.xxx.com/forums/showthread.php?t=6889
IP Address : xxx.xxx.xxx.xxx
Username : Unregistered
Classname : vb_database
The part where it says "Invalid SQL" is what worries me; looking at the query myself now that it is shorter, I can't see what is invalid about it. The bot is still posting RSS feeds, but I can't tell if it is posting all or just some of the ones it is supposed to. Any suggestions?
According to the admin control panel, PHP is at 4.3.10, and MySQL is 4.1.20-log. MySQL packet size is 1,023 KB. Any suggestions?