Quote:
Originally Posted by DragonByte Tech
Just as a test, set all of the counts for threads and blogs, etc., to 0 and see if it still does it. It shouldn't matter, but just trying to see if its getting hung up in some other way.
|
Well now, that's very interesting. Turning it on for forumhome and setting all the counts to 0 stops the eternal loading....and instead gives me a mySQL error.
Code:
Database error in vBulletin 4.1.10:
Invalid SQL:
SELECT blog.blogid, blog.title, blog.dateline AS publishdate, blog_text.blogtextid, blog_text.pagetext AS message, attachment.attachmentid as previewimage, contenttype.class
FROM blog AS blog
INNER JOIN blog_text AS blog_text ON (blog_text.blogtextid = blog.firstblogtextid)
LEFT JOIN blog_categoryuser AS cu ON (cu.blogid = blog.blogid)
LEFT JOIN contenttype as contenttype ON (contenttype.class = 'BlogEntry')
LEFT JOIN attachment AS attachment ON ( attachment.contentid = blog.blogid ) AND ( contenttype.contenttypeid = attachment.contenttypeid )
WHERE 1=1
AND blog.dateline <= 1327205138
AND thread.postuserid NOT IN (427,6970,6593,13617,13616,13633,14112,14113,22403,24657,25946,26114,26491,27774,27895,36854,39776,44671,44662,44323,45801,45838,45939)
GROUP BY blog.blogid
ORDER BY blog.dateline DESC
LIMIT 0,0;
MySQL Error : Unknown column 'thread.postuserid' in 'where clause'
Error Number : 1054
Request Date : Sunday, January 22nd 2012 @ 04:05:38 AM
Error Date : Sunday, January 22nd 2012 @ 04:05:38 AM
Script : (URLTOTESTFORUMREMOVED)/forum.php
Referrer : (URLTOTESTFORUMREMOVED)/admincp/index.php?do=head
IP Address : 186.32.167.66
Username : (USERNAMEREMOVED)
Classname : vB_Database
MySQL Version : 5.0.92-community-log
Quote:
Originally Posted by DragonByte Tech
Without having access to the site, I doubt I can help unfortunately.
|
I can arrange access if you think it would assist.