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

PHP Code:

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: