[Blog] Blog database error, when replying to a post in forums

[gamerzhope]

When you reply to a post in a thread you get a database error!

Database error in vBulletin 4.1.3:

Invalid SQL:

                SELECT COUNT(*) AS blogcomment
                FROM [COLOR=#ff0000]*****[/COLOR]blog_text
                WHERE blogtextid NOT IN(SELECT firstblogtextid FROM *****blog)
                    AND userid =;

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 '' at line 4
Error Number  : 1064
Request Date  : Thursday, June 9th 2011 @ 10:03:39 PM
Error Date    : Thursday, June 9th 2011 @ 10:03:39 PM
Script        : http://www.callmegamer.com/newreply.php?do=postreply&t=178
Referrer      : http://www.callmegamer.com/newreply.php?do=postreply&t=178
IP Address    : *********
Username      : Unistic
Classname     : vB_Database
MySQL Version : 5.1.52

I disabled all my plugins/products and still got the same error. Then I disabled the blog and the error was gone. Reactivated all my mods without the blog and it worked fined. I think enabled the blog and got the error again!

The thing is you get an error if you use quick reply or advanced reply. But after the error if you hit refresh the message you type will still appear in the thread as if nothing happened?

Also I just purchased the CMS and updated my forums to the cms.. from forum 4.1.3 to suite 4.1.3


Suggestions??? Thanks

[Steve Machol]

Run 'Suspect File Version' in Diagnostics and report back the results.

Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

[gamerzhope]

Thanks but that did nothing. I still get the same error and its because of the blog? The CMS is fine the forum is fine everything is up to date, with or without the other products on if the blog is on i receive the database error everytime. Any other ideas thanks

[Trevor Hannant]

Can you try re-downloading the ZIP file from the Members Area and re-upload all files (except install/install.php and includes/config.php.new) making sure you overwrite all files currently on your server.

Does this resolve the problem?

[gamerzhope]

Didn't work either it keeps saying the same error and all my users are getting when they try to reply to a post.

[Trevor Hannant]

Please fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Please include a complete description of the problem and be sure to include the login info to your Admin CP, phpMyAdmin and FTP in the 'Sensitive Data' field.

[Steve Machol]

Thanks but that did nothing.

What do you mean it 'did nothing'? I asked for the results from that test.

[gamerzhope]

What do you mean it 'did nothing'? I asked for the results from that test.

Diagnostics  Help Suspect File Versions Scanned 106 files ./ ajax_competitions.php     File not recognized as part of vBulletin albumall.php     File not recognized as part of vBulletin application-edit.php     File not recognized as part of vBulletin application-form.php     File not recognized as part of vBulletin application-forms.php     File not recognized as part of vBulletin application-types.php     File not recognized as part of vBulletin articles.php     File not recognized as part of vBulletin clanmembers.php     File not recognized as part of vBulletin clanwars.php     File not recognized as part of vBulletin competitions.php     File not recognized as part of vBulletin gxboxlive.php     File not recognized as part of vBulletin ladders.php     File not recognized as part of vBulletin market.php     File not recognized as part of vBulletin market_bank.php     File not recognized as part of vBulletin market_convert.php     File not recognized as part of vBulletin media.php     File not recognized as part of vBulletin media_ajax.php     File not recognized as part of vBulletin picall.php     File not recognized as part of vBulletin raffles.php     File not recognized as part of vBulletin showroster.php     File not recognized as part of vBulletin tab_blog.php     File not recognized as part of vBulletin tabindex.php     File not recognized as part of vBulletin tournaments.php     File not recognized as part of vBulletin vbactivity.php     File not recognized as part of vBulletin Scanned 100 files ./admincp advappadmin.php     File not recognized as part of vBulletin ajax.php     File not recognized as part of vBulletin clanmembers.php     File not recognized as part of vBulletin clanwars.php     File not recognized as part of vBulletin egr.php     File not recognized as part of vBulletin evbs_sstabs.php     File not recognized as part of vBulletin force_read_thread.php     File not recognized as part of vBulletin glowhostspamomatic.php     File not recognized as part of vBulletin market.php     File not recognized as part of vBulletin market_bank.php     File not recognized as part of vBulletin market_bank_donate.php     File not recognized as part of vBulletin market_bank_paycheck.php     File not recognized as part of vBulletin market_converter.php     File not recognized as part of vBulletin market_coupons.php     File not recognized as part of vBulletin market_gifts.php     File not recognized as part of vBulletin market_items.php     File not recognized as part of vBulletin market_lottery.php     File not recognized as part of vBulletin market_maintenance.php     File not recognized as part of vBulletin market_stats.php     File not recognized as part of vBulletin market_store.php     File not recognized as part of vBulletin raffleadmin.php     File not recognized as part of vBulletin tfh.php     File not recognized as part of vBulletin tfh_fixes.php     File not recognized as part of vBulletin tfh_impex.php     File not recognized as part of vBulletin tfh_modules.php     File not recognized as part of vBulletin ucash_admin.php     File not recognized as part of vBulletin vba_cmps_admin.php     File not recognized as part of vBulletin vbactivity.php     File not recognized as part of vBulletin vbactivityimport.php     File not recognized as part of vBulletin Scanned 3 files ./archive Scanned 103 files ./clientscript javascript_competitions.js     File not recognized as part of vBulletin vba_cmps_admin.js     File not recognized as part of vBulletin vba_cmps_admin_dd.js     File not recognized as part of vBulletin vba_cmps_dd.js     File not recognized as part of vBulletin Scanned 2 files ./clientscript/ie7 Scanned 2 files ./clientscript/ie8 Scanned 8 files ./clientscript/jquery Scanned 2 files ./clientscript/libraries DD_belatedPNG_0.0.8a.js     File does not contain expected contents Scanned 2 files ./clientscript/yui Scanned 2 files ./clientscript/yui/animation Scanned 23 files ./clientscript/yui/assets/skins/sam Scanned 1 files ./clientscript/yui/colorpicker Scanned 1 files ./clientscript/yui/colorpicker/assets Scanned 2 files ./clientscript/yui/colorpicker/assets/skins/sam Scanned 3 files ./clientscript/yui/combo Scanned 3 files ./clientscript/yui/connection Scanned 3 files ./clientscript/yui/container Scanned 2 files ./clientscript/yui/container/assets Scanned 2 files ./clientscript/yui/container/assets/skins/sam Scanned 2 files ./clientscript/yui/dragdrop Scanned 1 files ./clientscript/yui/element Scanned 2 files ./clientscript/yui/history Scanned 2 files ./clientscript/yui/history/assets blank.html     File does not contain expected contents Scanned 1 files ./clientscript/yui/json Scanned 2 files ./clientscript/yui/menu Scanned 3 files ./clientscript/yui/menu/assets Scanned 3 files ./clientscript/yui/menu/assets/skins/sam Scanned 2 files ./clientscript/yui/reset-fonts Scanned 1 files ./clientscript/yui/slider Scanned 2 files ./clientscript/yui/slider/assets Scanned 2 files ./clientscript/yui/slider/assets/skins/sam Scanned 2 files ./clientscript/yui/treeview Scanned 3 files ./clientscript/yui/treeview/assets Scanned 2 files ./clientscript/yui/treeview/assets/css/folders Scanned 3 files ./clientscript/yui/treeview/assets/skins/sam Scanned 2 files ./clientscript/yui/uploader Scanned 1 files ./clientscript/yui/utilities Scanned 2 files ./clientscript/yui/yahoo-dom-event Scanned 2 files ./clientscript/yui/yuiloader-dom-event Scanned 2 files ./cpstyles Scanned 2 files ./images/regimage/fonts Scanned 218 files ./includes class_dm_media.php     File not recognized as part of vBulletin class_dm_media_category.php     File not recognized as part of vBulletin class_dm_media_comment.php     File not recognized as part of vBulletin class_dm_media_playlist.php     File not recognized as part of vBulletin class_dm_media_rating.php     File not recognized as part of vBulletin class_dm_media_service.php     File not recognized as part of vBulletin class_dm_media_tag.php     File not recognized as part of vBulletin class_dm_media_tag_content.php     File not recognized as part of vBulletin class_dm_tabs.php     File not recognized as part of vBulletin class_yui.php     File not recognized as part of vBulletin functions_application-form.php     File not recognized as part of vBulletin functions_application-forms.php     File not recognized as part of vBulletin functions_ghsom.php     File not recognized as part of vBulletin functions_gxboxlive.php     File not recognized as part of vBulletin functions_raffles.php     File not recognized as part of vBulletin functions_tal.php     File not recognized as part of vBulletin functions_ucash.php     File not recognized as part of vBulletin vba_cmps_adminfunctions.php     File not recognized as part of vBulletin vba_cmps_global.php     File not recognized as part of vBulletin vba_cmps_include_bottom.php     File not recognized as part of vBulletin vba_cmps_include_template.php     File not recognized as part of vBulletin vba_cmps_include_top.php     File not recognized as part of vBulletin Scanned 4 files ./includes/api Scanned 191 files ./includes/api/1 Scanned 22 files ./includes/api/2 Scanned 1 files ./includes/api/3 Scanned 7 files ./includes/block Scanned 31 files ./includes/cron media_sitemap.php     File not recognized as part of vBulletin miner.gxboxlive.php     File not recognized as part of vBulletin pointmarket.php     File not recognized as part of vBulletin pointmarket_bank.php     File not recognized as part of vBulletin pointmarket_expire.php     File not recognized as part of vBulletin raffledraw.php     File not recognized as part of vBulletin Scanned 2 files ./includes/facebook Scanned 8 files ./includes/paymentapi Scanned 56 files ./includes/xml bitfield_application-form.xml     File not recognized as part of vBulletin bitfield_clanmembers.xml     File not recognized as part of vBulletin bitfield_clanwars.xml     File not recognized as part of vBulletin bitfield_dbtech_vbactivity.xml     File not recognized as part of vBulletin bitfield_dbtech_vbactivity_pro.xml     File not recognized as part of vBulletin bitfield_fci.xml     File not recognized as part of vBulletin bitfield_medialibrary.xml     File not recognized as part of vBulletin bitfield_pointmarket.xml     File not recognized as part of vBulletin bitfield_raffles.xml     File not recognized as part of vBulletin bitfield_tournament2008.xml     File not recognized as part of vBulletin cpnav_abe1_forceusersreadthread.xml     File not recognized as part of vBulletin cpnav_advapp.xml     File not recognized as part of vBulletin cpnav_clanmembers.xml     File not recognized as part of vBulletin cpnav_clanwars.xml     File not recognized as part of vBulletin cpnav_dbtech_vbactivity.xml     File not recognized as part of vBulletin cpnav_dbtech_vbactivity_pro.xml     File not recognized as part of vBulletin cpnav_egr.xml     File not recognized as part of vBulletin cpnav_evbs_sstab.xml     File not recognized as part of vBulletin cpnav_glowhostspamomatic.xml     File not recognized as part of vBulletin cpnav_pointmarket.xml     File not recognized as part of vBulletin cpnav_raffles.xml     File not recognized as part of vBulletin cpnav_tfh.xml     File not recognized as part of vBulletin cpnav_ucash.xml     File not recognized as part of vBulletin cpnav_vbacmps.xml     File not recognized as part of vBulletin hooks_dbtech_vbactivity.xml     File not recognized as part of vBulletin hooks_dbtech_vbactivity_pro.xml     File not recognized as part of vBulletin hooks_gxboxlive.xml     File not recognized as part of vBulletin hooks_tournament2008.xml     File not recognized as part of vBulletin hooks_vbacmps.xml     File not recognized as part of vBulletin Scanned 16 files ./install Scanned 3 files ./install/cmsdefaultdata Scanned 78 files ./install/includes Scanned 13 files ./modcp clanwars.php     File not recognized as part of vBulletin market.php     File not recognized as part of vBulletin vbactivity.php     File not recognized as part of vBulletin Scanned 5 files ./packages/skimlinks/hooks Scanned 2 files ./packages/vbattach Scanned 2 files ./packages/vbblog/attach Scanned 3 files ./packages/vbblog/search/indexcontroller Scanned 3 files ./packages/vbblog/search/result Scanned 2 files ./packages/vbblog/search/searchcontroller Scanned 3 files ./packages/vbblog/search/type Scanned 2 files ./packages/vbblog/taggablecontent Scanned 11 files ./packages/vbcms Scanned 2 files ./packages/vbcms/attach Scanned 3 files ./packages/vbcms/bbcode Scanned 2 files ./packages/vbcms/bbcodehelper Scanned 2 files ./packages/vbcms/bbcodehelper/table Scanned 4 files ./packages/vbcms/collection Scanned 5 files ./packages/vbcms/collection/content Scanned 5 files ./packages/vbcms/content Scanned 7 files ./packages/vbcms/controller Scanned 7 files ./packages/vbcms/dm Scanned 2 files ./packages/vbcms/editor Scanned 2 files ./packages/vbcms/exception Scanned 5 files ./packages/vbcms/item Scanned 5 files ./packages/vbcms/item/content Scanned 23 files ./packages/vbcms/item/widget Scanned 5 files ./packages/vbcms/route Scanned 3 files ./packages/vbcms/search/indexcontroller Scanned 4 files ./packages/vbcms/search/result Scanned 4 files ./packages/vbcms/search/searchcontroller Scanned 3 files ./packages/vbcms/search/type Scanned 2 files ./packages/vbcms/taggablecontent Scanned 6 files ./packages/vbcms/view Scanned 23 files ./packages/vbcms/widget Scanned 5 files ./packages/vbdbsearch Scanned 4 files ./packages/vbforum/attach Scanned 3 files ./packages/vbforum/collection Scanned 3 files ./packages/vbforum/item Scanned 6 files ./packages/vbforum/search/indexcontroller Scanned 10 files ./packages/vbforum/search/result Scanned 4 files ./packages/vbforum/search/searchcontroller Scanned 11 files ./packages/vbforum/search/type Scanned 3 files ./packages/vbforum/taggablecontent Scanned 25 files ./vb skin-tfh.css     File not recognized as part of vBulletin Scanned 3 files ./vb/cache Scanned 2 files ./vb/cache/observer Scanned 3 files ./vb/collection Scanned 3 files ./vb/controller Scanned 4 files ./vb/db Scanned 4 files ./vb/db/mysql Scanned 15 files ./vb/exception Scanned 3 files ./vb/item Scanned 11 files ./vb/legacy Scanned 3 files ./vb/route Scanned 11 files ./vb/search Scanned 4 files ./vb/search/indexcontroller Scanned 2 files ./vb/search/result Scanned 2 files ./vb/search/searchcontroller Scanned 2 files ./vb/search/type Scanned 2 files ./vb/templater Scanned 6 files ./vb/view  Powered by vBulletin™ Version 4.1.3 Patch Level 1 Copyright © 2011 vBulletin Solutions, Inc. All rights reserved.

[Steve Machol]

Thanks. I also notice you haven't filled out a support ticket yet as Trevor asked.

Run this and report back the results:

Admin CP -> Maintenance -> Diagnostics -> Problematic Webserver Modules

[gamerzhope]

Yeah, I just disabled the blog, I'm 100% sure its giving the error so forget it. Thanks for all the help though!