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

That is exactly what the problem was, thanks.

Hi,
how CPU intensive is this modification?

2%.

;) no but seriously, it is impossible to answer such a question. Even if it doesn't make any impact on one CPU, it may very well make an impact on a much lower-grade CPU. Et cetera.

We have had few to no reports of server load increasing, plus this version is free so you can check it out and monitor server load for yourself :)


Fillip

Fillip,
sorry for bothering, but does the server load depend on the number of replies in the thread? I have multiple very long threads on my forum (10.000 posts long threads) - would that have an impact on my load?

Cheers
Jan

That shouldn't have an impact, but we do not have access to a test board with that number of replied so it is impossible to say.

Fillip

Dupe posts still appear from time to time, other than that this is just about perfect.

I haven't installed this, but I have an idea (probably not an original one). You know the "latest posts" forum block? It'd be pretty cool if someone could ajax that bad boy to see new posts fade in along the same manner.

Mods for that exist already.

For 4.1.x? Link?

great mod, but how do I remove that large LIVE button next to every thread?

Edit: I disabled threadbit_display . Seems to have worked.

How do I change the color of this text?

"Thread automatically updated every 5 second(s). "

Edit the template dbtech_ajaxthreads_bar :)


Fillip

I have a problem gettng all [DBTECH] MOD'S TO WORK. the reason for this is thee upload folders inside the zip is a file upload. : I KNOW IT SAyS LOAD WHATS INSIDE UPLOAD TO FORUM HOME." bu every time i upload all the folders and files th mod seems not to work. the thrree files are admincp,dbtech,and includes. also a php file. it confusses me because im unsure if i should uploaf the files inside admincp to that directory anf includes to that directory but what do i do with the dbtech folder? i should just highlight all the files and folders and upload all of them to the public_html folder in my ftp? but when i do that the mod just wont work. can someone explain what i am doing wrong? thank you in advance.

This still has the problem of double posts showing up from time to time. A refresh fixes it but I wonder why the double posting is such a big issue with this and it can't seem to be eliminated.

Problem is it couldn't be reliably reproduced. If you found out the way that always reproduces such behavior, it would be fixed. :)

For example only once I have seen double posts. After that never again. It seems that it may be related to something specific to your server, or mods you use, whatever.

Ever considered adding Ajax to member profile comments, articles comments and blog comments?

They're much less used than threads so it might be a bit of a waste of server resources if I'm honest.

Fillip

It suddenly stopped working after I installed this: https://vborg.vbsupport.ru/showthread.php?t=232048

It's a really popular feature on my forum, so yeah, uhmm, would there be a fix for that?~

It happens on vB4.1.10

Another one: http://prntscr.com/61yrt <- it's normally what you'd see after clicking Reply with quote. But when the mod is enabled, it takes me to a new page: http://prntscr.com/61yu4

This was handled at our forum, but for posterity: Mods that don't work with Quick Edit will also not work with AJAX Threads :(


Fillip

I'm still getting double posts with latest version on 4.1.10 forum.

As has been stated previously in the thread, it's pointless to report this without a clear way of reproducing it. I am unable to replicate it and nobody has provided a method to replicate it 100% of the time, which means I can't fix it :(


Fillip

Oh, >_<. Seemed to happen in every thread for me, it's a new board and I was just testing it.

Bought and installed Pro version

Works fine

My only gripe is that the "Live" logo is practically spammed by every thread title.

You can disable the threadbit_display plugin to get rid of that - we'll release an update in the future that'll let you disable it via a vBOption :)


Fillip

It works with this mod (iquote) which is actually better than that one: https://vborg.vbsupport.ru/showthread.php?t=248504

It's inconsistent so a problem but whatever you guys did earlier to fix or lessen double posting, maybe take a second look at it?

When i reply to new ajax posts the editor say :

Leave this page - Stay on page

That can happen if you have a PHP error during the quick reply, it's sadly impossible for me to assist without actually seeing it happen and be able to reproduce it 100% of the time :(


Fillip

This browser is AJAX compatible
vbulletin-core.js:11Firing System Init
vbulletin-core.js:11Fire vB_XHTML_Ready
vbulletin-core.js:11Fetch Cookie :: vbulletin_collapse (null)
vbulletin-core.js:11Fetch Cookie :: vbulletin_multiquote (null)
vbulletin-core.js:11Fetch Cookie :: vbulletin_inlinepost (null)
40event.layerX and event.layerY are broken and deprecated in WebKit. They will be removed from the engine in the near future.
ajaxthreads.js:182ajax_last_post = 1333016350
vbulletin-core.js:11PostBit Init: 211593
vbulletin-core.js:11Fetch Cookie :: vbulletin_multiquote (null)
vbulletin-core.js:11Fetch Cookie :: vbulletin_collapse (null)
[164] event.layerX and event.layerY are broken and deprecated in WebKit. They will be removed from the engine in the near future.
ajaxthreads.js:56 Pausing AJAX Threads...
ajaxthreads.js:73 Un-pausing AJAX Threads...

After this the editor say :

Leave this page - Stay on page

If i click stay on page nothing happen .

If i click leave this page page will be refresh and post will be submit.