Blogs causing database error

[readjono]

They have been working perfectly until recently. Now the index page does not load...

Database error
The [Site Name] database has encountered a problem.

When I disable blogs it, however, works. I got someone to reinstall them last time and that solved it. But they may have done something else to fix it. Can't get in touch with them so was throwing this out to you guys. It's obviously since I've upgraded but seems a common problem with all versions of the blog.

[Lynne]

When you get the database error page, view the page source and the actual database error will be shown. We can't suggest to you what a solution may be if you don't post the actual database error.

[readjono]

<!--
Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT user.username, blog.userid, blog.title, blog.blogid, blog.postedby_userid, blog.postedby_username, bu.title AS blogtitle
FROM blog AS blog
LEFT JOIN blog_user AS bu ON (blog.userid = bu.bloguserid)
LEFT JOIN user AS user ON (blog.userid = user.userid)

WHERE
state = 'visible' AND
dateline &lt;= 1233946749 AND
blog.pending = 0 AND
~blog.options &amp; 8 AND
bu.options_buddy &amp; 1 AND
bu.options_member &amp; 1
AND blog.userid &lt;&gt;
ORDER BY dateline DESC
LIMIT 1;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY dateline DESC
LIMIT 1' at line 14
Error Number : 1064
Request Date : Friday, February 6th 2009 @ 06:59:09 PM
Error Date : Friday, February 6th 2009 @ 06:59:09 PM
Script : ***********/index.php
Referrer :
IP Address : 92.20.224.143
Username : Guest
Classname : vB_Database
MySQL Version :
-->

[Lynne]

Try disabling your plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

[readjono]

Seemingly has no effect. Shall request paid services for this.

[puertoblack2003]

there's a temp fix go to vb.com freddie gave me a fix.I was having that issue too.It'll be nice if you also report it :up: