Bug

[Onyx]

I received this SQL error today: I am running 1.0.4

Database error in vBulletin 3.6.9:

Invalid SQL:

SELECT blog.blogid, lastblogtextid AS blogtextid, blog_text.userid, blog_text.state, IF(blog_text.userid = 0, blog_text.username, user.username) AS username, blog.blogid, blog.title
FROM vbulletin_blog AS blog
LEFT JOIN vbulletin_blog_text AS blog_text ON (blog.lastblogtextid = blog_text.blogtextid)
LEFT JOIN vbulletin_user AS user ON (blog_text.userid = user.userid)
WHERE blog.userid =
AND blog_text.blogtextid <> blog.firstblogtextid
AND blog_text.state IN ('visible')
AND blog.state IN ('visible')
AND blog.dateline <= 1208302965
AND blog.pending = 0
ORDER BY blog.lastcomment DESC
LIMIT 5;

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 'AND blog_text.blogtextid <> blog.firstblogtextid
AND blog_text.state IN ('vis' at line 6 Error Number : 1064
Date : Tuesday, April 15th 2008 @ 05:42:46 PM
Script : http://www.dogtrickacademy.com/members/forum/blog_inlinemod.php
Referrer : http://www.dogtrickacademy.com/members/forum/blog.php?do=list&blogtype=latest
IP Address : 99.224.86.34
Username : bekah1001
Classname : vB_Database

[Jose Amaral Rego]

Try reuploading all original vB non-image files (except install.php). Use ASCII format mode when using FTP client to overwrite files on server side. You should add same information to specific fileds in config.php, but try to edit though host side.

If you do not see this error no-longer, then the following steps need not apply.

Next run Admin Control Panel > Maintenance > Diagnostics > Suspect File Versions
And list all custum .xml files from host side folder includes/xml/... or just remove or moved them.

Then if you have an other installed modification, you do the following to disable your products and plugins to get your issue resolved.

Note: To temporarily disable all modification addons, edit config.php and add this on next new line right under <?php

define('DISABLE_HOOKS', true);



Plugin/Hook System (http://www.vbulletin.com/docs/html/vboptions_group_plugin_hook_system)
Temporarily Deactivating a Product (http://www.vbulletin.com/docs/html/disable_product)