Announcement

Collapse
No announcement yet.

Database error in 2.0.2

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error in 2.0.2

    Hello guys,

    I've upgraded from 2.0.0 to 2.0.2 version and getting this nice error:

    Database error in vBulletin 3.8.2:

    Invalid SQL:

    SELECT blog.*, blog.options AS blogoptions, blog_text.pagetext, blog_text.allowsmilie, blog_text.ipaddress, blog_text.reportthreadid,
    blog_text.ipaddress AS blogipaddress,
    blog_editlog.userid AS edit_userid, blog_editlog.dateline AS edit_dateline, blog_editlog.reason AS edit_reason, blog_editlog.username AS edit_username,
    blog_textparsed.pagetexthtml, blog_textparsed.hasimages,
    user.*, userfield.*, usertextfield.*,
    blog.userid AS userid, bu.categorycache, bu.sidebar, bu.memberids, bu.memberblogids, bu.custompages,
    bu.title AS blog_title, bu.description AS blog_description, bu.allowsmilie AS blog_allowsmilie, bu.akismet_key AS akismet_key, bu.tagcloud,
    bu.options_member, bu.options_guest, bu.options_buddy, bu.options_ignore, bu.entries, bu.isblogmoderator, bu.comments_moderation AS blog_comments_moderation,
    bu.draft AS blog_draft, bu.pending AS blog_pending, bu.uncatentries, bu.moderation AS blog_moderation, bu.deleted AS blog_deleted, bu.customblocks,
    customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid,
    blog_usercsscache.csscolors AS blog_csscolors, blog_usercsscache.cachedcss AS blog_cachedcss, IF(blog_usercsscache.cachedcss IS NULL, 0, 1) AS blog_hascachedcss, blog_usercsscache.buildpermissions AS blog_cssbuildpermissions
    , blockparsed.blocktext
    , gm.permissions as grouppermissions, blog_rate.vote,ignored.relationid AS ignoreid, buddy.relationid AS buddyid, IF(blog_subscribeuser.blogsubscribeuserid, 1, 0) AS blogsubscribed, IF(blog_subscribeentry.blogsubscribeentryid, 1, 0) AS entrysubscribed, blog_subscribeentry.type AS emailupdate
    , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight
    , '' AS field3, '' AS field4
    , blog_read.readtime AS blogread, blog_userread.readtime AS bloguserread
    ,blog_deletionlog.moddelete AS del_moddelete, blog_deletionlog.userid AS del_userid, blog_deletionlog.username AS del_username, blog_deletionlog.reason AS del_reason

    FROM forum_blog AS blog
    INNER JOIN forum_blog_text AS blog_text ON (blog_text.blogtextid = blog.firstblogtextid)
    LEFT JOIN forum_user AS user ON (blog.userid = user.userid)
    LEFT JOIN forum_userfield AS userfield ON(userfield.userid = user.userid)
    LEFT JOIN forum_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
    LEFT JOIN forum_blog_editlog AS blog_editlog ON (blog_editlog.blogtextid = blog.firstblogtextid)
    LEFT JOIN forum_blog_textparsed AS blog_textparsed ON (blog_textparsed.blogtextid = blog.firstblogtextid AND blog_textparsed.styleid = 2 AND blog_textparsed.languageid = 16)
    LEFT JOIN forum_blog_user AS bu ON (bu.bloguserid = user.userid)
    LEFT JOIN forum_customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid)
    LEFT JOIN forum_blog_usercsscache AS blog_usercsscache ON (user.userid = blog_usercsscache.userid)
    LEFT JOIN forum_blog_custom_block_parsed AS blockparsed ON (blockparsed.userid = user.userid AND blockparsed.styleid = 2 AND blockparsed.languageid = 16)

    LEFT JOIN forum_blog_read AS blog_read ON (blog_read.blogid = blog.blogid AND blog_read.userid = 19475)
    LEFT JOIN forum_blog_userread AS blog_userread ON (blog_userread.bloguserid = blog.userid AND blog_userread.userid = 19475)


    LEFT JOIN forum_userlist AS ignored ON (ignored.userid = blog.userid AND ignored.relationid = 19475 AND ignored.type = 'ignore')
    LEFT JOIN forum_userlist AS buddy ON (buddy.userid = blog.userid AND buddy.relationid = 19475 AND buddy.type = 'buddy')

    LEFT JOIN forum_blog_subscribeentry AS blog_subscribeentry ON (blog.blogid = blog_subscribeentry.blogid AND blog_subscribeentry.userid = 19475)
    LEFT JOIN forum_blog_subscribeuser AS blog_subscribeuser ON (blog.userid = blog_subscribeuser.bloguserid AND blog_subscribeuser.userid = 19475)
    LEFT JOIN forum_avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN forum_customavatar AS customavatar ON (customavatar.userid = user.userid)
    LEFT JOIN forum_blog_rate AS blog_rate ON (blog_rate.blogid = blog.blogid AND blog_rate.userid = 19475)
    LEFT JOIN forum_blog_groupmembership AS gm ON (blog.userid = gm.bloguserid AND gm.userid = 19475)
    LEFT JOIN forum_blog_deletionlog AS blog_deletionlog ON (blog.blogid = blog_deletionlog.primaryid AND blog_deletionlog.type = 'blogid')


    WHERE blog.blogid = 49;

    MySQL Error : Unknown column 'blog_usercsscache.csscolors' in 'field list'
    Error Number : 1054
    Request Date : Tuesday, May 5th 2009 @ 08:09:22 AM
    Error Date : Tuesday, May 5th 2009 @ 08:09:22 AM
    Script : http://www.gday.ru/forum/blogs/roo/49-%DD%F5-%ED%E5-%E2-%F2%EE%E9-%F1%F2%F0%E0%ED%E5-%E6%E8%E2%E5%EC.html
    Referrer : http://www.gday.ru/forum/blogs/all/
    IP Address : 210.84.9.215
    Username : Roo
    Classname : vB_Database
    MySQL Version :

  • #2
    To troubleshoot this, first reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

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

    [Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

    Next, disable all plugins except vBulletin Blog via the Product Manager. you will also need to completely disable vBSEO including the htaccess file for this.

    Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it.

    Do you have the same problem?
    Kerry-Anne :)

    Twitter Blog

    www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

    Comment


    • #3
      Originally posted by Kerry-Anne View Post
      To troubleshoot this, first reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

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

      [Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

      Next, disable all plugins except vBulletin Blog via the Product Manager. you will also need to completely disable vBSEO including the htaccess file for this.

      Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it.

      Do you have the same problem?
      Ok. Here is how i fixed this error;

      I noticed that developers did not refresh/upload vBBlogs.xml file into admincp -> Products after they copied all files.
      I have performed product upgrade with restart option and it fixed the problem.
      Please make a note of it for future cases.

      Thank you for your assistance anyway.

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X