Database error in vBulletin 4.1.7:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.prefixid, post.attach,
thread.postusername, thread.dateline, thread.lastpostid, thread.lastpost AS threadlastpost, thread.lastposterid, thread.lastposter, thread.replycount,
forum.forumid, forum.title_clean as forumtitle,
post.pagetext AS message, post.allowsmilie, post.postid,
user.*
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM thread AS thread
INNER JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (thread.postuserid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND thread.forumid IN(4,17,18,20,19,110,318,282,250,127,319,5,174,191 ,197,192,193,63,61,65,64,126,195,128,98,96,95,93,9 1,92,153,317,199,189,194,99,100,103,26,27,218,30,3 1,32,215,29,28,214,211,212,6,21,22,23,25,163,62,12 3,253,160,24,235,239,240,241,287,306,320,242,243,2 45,131,309,74,75,204,76,78,77,79,303,121,80,312,15 4,68,69,313,314,315,70,71,13,66,67,11,125,83,81,82 ,205,292,208,293,207,302,307,308,310,7,33,34,35,36 ,37,38,268,40,39,256,190,41,132,45,182,46,133,267, 47,42,134,181,105,107,294,295,297,298,296,299,300, 201,202,203,104,16,54,56,57,55,58,60,48,49,159,50, 221,275,276,277,186,220,274,271,272,278,263,264,26 5,8,84,209,138,136,88,87,137,89,86,142,255,257,141 ,144,85,139,258,140,143,247,248,259,260,261,262,90 ,200,15,53,52,51,291,101,233,246,234,244,238,289,2 90,316,120,124,117,130,165,145,164)
AND thread.visible = 1
AND post.visible = 1
AND open <> 10
AND thread.dateline > 1319299480


ORDER BY thread.dateline DESC
LIMIT 0,7;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, November 21st 2011 @ 11:04:40 AM
Error Date : Monday, November 21st 2011 @ 11:05:29 AM
Script :
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version :

That query does not appear anywhere in AJAX Threads so it is unrelated to this mod.

It means your MySQL has crashed, contact your host to have them advise you :)


Fillip

thank you it's fixed now and it's worked like u said

Ok I just went ahead and installed it. Got about 2000 people online now and haven't seen my server load go up at all (but then again I have only had it installed for an hour.)

Feature request: I would like to see the LIVE graphics only shown to threads which have been posted in in the last X number of minutes. :)

Thanks!

That'd be quite performance intensive to check :(


Fillip

Oh well, it was an idea. :)

I went ahead and purchased the pro version plus the new arcade. :) (I will try to install the arcade tonight.)

How do you disable the "LIVE" image?

Solution to my problem :)

The new version has created a problem. The first post in some threads will disappear after a few seconds.

That is not something I can replicate. Please ensure that you have not set the Post Cutoff to less than your Posts Per Page.

Fillip