Database error when clicking "Find latest posts" on some profile pages

[zykron]

There seems to be a bug with THE MAD HATTER's profile page.
So I just came online to see hatter's thread "should I go"

http://theync.com/forum/showthread.p...43-should-i-go

...so I wanted to check out what happened, so I went to THE MAD HATTER's profile page:

http://theync.com/forum/member.php?97365-THE-MAD-HATTER

...and clicked "Find latest posts."


Unfortunately, I could not retrieve his posts, because I got a database error message:

	Database error
The The YNC forum database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the theync.com home page, then try to open another page.
Click the Back button to try another link.
The theync.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.

Immediately below this message was a text box indicating the database error in vBulletin due to "Invalid SQL." Unfortunately, I cannot copy and paste the whole error message, because it is literally over 100 pages long, so here is some of it:

Database error in vBulletin 4.1.5:

Invalid SQL:

			UPDATE searchlog
			SET results = 'a:4:{i:0;a:18305:{i:0;a:3:{i:0;s:1:\"1\";i:1;s:7:\"5763080\";i:2;s:7:\"2990543\";}i:1;a:3:{i:0;s:1:\"1\";i:1;s:7:\"5762971\";i:2;s:5:\"20338\";}i:2;a:3:{i:0;s:1:\"1\";i:1;s:7:\"5762948\";i:2;s:5:\"13494\";}i:3;a:3:{i:0;s:1:\"1\";i:1;s:7:\"5762747\";i:2;s:7:\"2990841\";}i:4;a:3:{i:0;s:1:\"1\";i:1;s:7:\"5761842\";i:2;s:7:\"2990543\";}i:5;a:3:{i:0;s:1:\"1\";i:1;s:7:\"5760740\";i:2;s:7:\"2945313\";}i:6;a:3:{i:0;s:1:\"1\";i:1;s:7:\"5760689\";i:2;s:7:\"2750502\";}i:7;a:3:{i:0;s:1:\"1\";i:1;s:7:\"5760679\";i:2;s:5:\"29081\";}i:8;a:3:{i:0;s:1:\"1\";i:1;s:7:\"5760667\";i:2;s:5:\"14782\";}i:9;a:3:{i:0;s:1:\"1\";i:1;s:7:\"5760664\";i:2;s:5:\"14782\";}i:10;a:3:{i:0;s:1:\"1\";i:1;s:7:\"5760658\";i:2;s:5:\"14782\";}i:11;a:3:{i:0;s:1:\"1\";i:1;s:7:\"5760655\";i:2;s:5:\"14782\";}i:12;a:3:{i:0;s:1:\"1\";i:1;s:7:\"5760646\";i:2;s:5:\"13494\";}i:13;a:3:{i:0;s:1:\"1\";i:1;s:7:\"5760636\";i:2;s:5:\"20338\";}i:14;a:3:{i:0;s:1:\"1\";i:1;s:7:\"5760360\";i:2;s:7:\"2988391\";}i:15;a:3:{i:0;s:1:\"1\";i:1;s:7:\"5758046\";i:2;s:7:\"2988391\";}i:16
...
100 pages of random crap later
...
i:0;s:1:\"1\";i:1;s:7:\"1037096\";i:2;s:5:\"35337\";}i:18303;a:3:{i:0;s:1:\"1\";i:1;s:7:\"1034020\";i:2;s:5:\"34146\";}i:18304;a:3:{i:0;s:1:\"1\";i:1;s:7:\"1032637\";i:2;s:5:\"35136\";}}i:1;i:-1;i:2;N;i:3;N;}'
			WHERE searchlogid = 50238;

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Monday, April 23rd 2012 @ 10:05:34 AM
Error Date    : Monday, April 23rd 2012 @ 10:05:35 AM
Script        : http://theync.com/forum/search.php?do=finduser&userid=97365&contenttype=vBForum_Post&showposts=1
Referrer      : http://theync.com/forum/member.php?97365-THE-MAD-HATTER
IP Address    : 72.227.97.207
Username      : zykron
Classname     : vB_Database
MySQL Version :

This problem occurs regardless of whether or not I have logged in.

This problem occurs both on Safari and Firefox...

...except on Firefox, when the database error page loads, Firefox goes into an infinite loop and I have to force-quit the browser.
In other words, clicking his "Find latest posts" sometimes crashes my browser!

This doesn't happen to anyone else's profile/latest posts link.

What the hell is going on????

[Badger]

I don't get it useing IE or AOL!

[zykron]

UPDATE: Problem has resurfaced


After Legion had his account closed, I wanted to search his posts to find out why.

So, when I clicked on "Find latest posts" on his profile page: http://theync.com/forum/member.php?76540-Legion

I received a similar database error message...

Database error in vBulletin 4.1.5:

Invalid SQL:

			UPDATE searchlog
			SET results = 'a:4:{i:0;a:16416:{i:0;a:3:{i:0;s:1:\"1\";i:1;s:7:\"6075442\";i:2;s:6:\"107055\";}i:1;a:3:{i:0;s:1:\"1\";i:1;s:7:\"6075390\";i:2;s:6:\"107055\";}i:2;a:3:{i:0;s:1:\"1\";i:1;s:7:\"6075303\";i:2;s:6:\"107055\";}i:3;a:3:{i:0;s:1:\"1\";i:1;s:7:\"6075263\";i:2;s:6:\"107055\";}i:4;a:3:{i:0;s:1:\"1\";i:1;s:7:\"6075228\";i:2;s:6:\"107055\";}i:5;a:3:{i:0;s:1:\"1\";i:1;s:7:\"6070314\";i:2;s:6:\"107055\";}i:6;a:3:{i:0;s:1:\"1\";i:1;s:7:\"6068921\";i:2;s:7:\"1661595\";}i:7;a:3:{i:0;s:1:\"1\";i:1;s:7:\"6068895\";i:2;s:7:\"1661595\";}i:8;a:3:{i:0;s:1:\"1\";i:1;s:7:\"6068714\";i:2;s:7:\"1661595\";}i:9;a:3:{i:0;s:1:\"1\";i:1;s:7:\"6068674\";i:2;s:7:\"1661595\";}i:10;a:3:{i:0;s:1:\"1\";i:1;s:7:\"6068607\";i:2;s:7:\"1661595\";}i:11;a:3

[etc. etc. etc.]

using Firefox 13

[Badger]

Chaos_Beer has been getting some error messages, perhaps he has a similar problem?

[zykron]

His find latest posts works fine.

[Blakpoetry]

mine is broken now too

[Badger]

Dan is aware of this and has passed the problem over to his programmer. I will keep you posted.

[Blakpoetry]

it used to be just Legion...i think its contagious

[CHODA]

I get that message on some walls and not on others.

[True North]

Yeah - that sucks.

[Blakpoetry]

you two are next

[rapewolf]

it used to be just Legion...i think its contagious

LEGION gave me one of his little problems. We're in marital therapy now.






Some of my posts keep going missing.