Announcement

Collapse
No announcement yet.

Also, after migration: Invalid SQL: SELECT blog.*, blog.options AS blogoptions...

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

  • Also, after migration: Invalid SQL: SELECT blog.*, blog.options AS blogoptions...

    Also, a database error on the new server:

    Database error in vBulletin 3.8.1:

    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 field7
    , 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 blog AS blog
    INNER JOIN blog_text AS blog_text ON (blog_text.blogtextid = blog.firstblogtextid)
    LEFT JOIN user AS user ON (blog.userid = user.userid)
    LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
    LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
    LEFT JOIN blog_editlog AS blog_editlog ON (blog_editlog.blogtextid = blog.firstblogtextid)
    LEFT JOIN blog_textparsed AS blog_textparsed ON (blog_textparsed.blogtextid = blog.firstblogtextid AND blog_textparsed.styleid = 23 AND blog_textparsed.languageid = 1)
    LEFT JOIN blog_user AS bu ON (bu.bloguserid = user.userid)
    LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid)
    LEFT JOIN blog_usercsscache AS blog_usercsscache ON (user.userid = blog_usercsscache.userid)
    LEFT JOIN blog_custom_block_parsed AS blockparsed ON (blockparsed.userid = user.userid AND blockparsed.styleid = 23 AND blockparsed.languageid = 1)

    LEFT JOIN blog_read AS blog_read ON (blog_read.blogid = blog.blogid AND blog_read.userid = 3628)
    LEFT JOIN blog_userread AS blog_userread ON (blog_userread.bloguserid = blog.userid AND blog_userread.userid = 3628)


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

    LEFT JOIN blog_subscribeentry AS blog_subscribeentry ON (blog.blogid = blog_subscribeentry.blogid AND blog_subscribeentry.userid = 3628)
    LEFT JOIN blog_subscribeuser AS blog_subscribeuser ON (blog.userid = blog_subscribeuser.bloguserid AND blog_subscribeuser.userid = 3628)
    LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
    LEFT JOIN blog_rate AS blog_rate ON (blog_rate.blogid = blog.blogid AND blog_rate.userid = 3628)
    LEFT JOIN blog_groupmembership AS gm ON (blog.userid = gm.bloguserid AND gm.userid = 3628)
    LEFT JOIN blog_deletionlog AS blog_deletionlog ON (blog.blogid = blog_deletionlog.primaryid AND blog_deletionlog.type = 'blogid')


    WHERE blog.blogid = 69;

    MySQL Error : Unknown column 'blog_usercsscache.csscolors' in 'field list'
    Error Number : 1054
    Request Date : Friday, February 20th 2009 @ 02:18:42 PM
    Error Date : Friday, February 20th 2009 @ 02:18:42 PM
    Script : http://forums.XXXXXXXXXXXX.com/blogs...difficult.html
    Referrer : http://forums.XXXXXXXXXXXXX.com/
    IP Address : 32.133.169.69
    Username : zmiller4
    Classname : vB_Database

  • #2
    Try reimporting the blog product. First reupload the blog files. Then import the XML with Allow Overwrite set to Yes:

    Admin CP -> Plugins & Products -> Manage Products -> [Add/Import Product]

    Import this file:

    ./includes/xml/product-vbblog.xml

    Comment


    • #3
      Worked. Gracias!

      Comment


      • #4
        Ah!

        Worked for me too! (search is a wonderful thing!)

        My blog 'comments' are backgrounded (but not quotes) in "pink" now?

        Comment


        • #5
          Excellent, the reimport of product-vbblog.xml fixed this same bug for me too in 3.8.4 after upgrading the blog to 2.0.2 from 2.0.0 I believe it was. The internet is amazing, all I did was copy and paste some of the error text into google and this was the top result, and had the fix immediately listed.

          Code:
          Database error in vBulletin 3.8.4:
          
          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
          				
          				
          				,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 blog AS blog
          			INNER JOIN blog_text AS blog_text ON (blog_text.blogtextid = blog.firstblogtextid)
          			LEFT JOIN user AS user ON (blog.userid = user.userid)
          			LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
          			LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
          			LEFT JOIN blog_editlog AS blog_editlog ON (blog_editlog.blogtextid = blog.firstblogtextid)
          			LEFT JOIN blog_textparsed AS blog_textparsed ON (blog_textparsed.blogtextid = blog.firstblogtextid AND blog_textparsed.styleid = 5 AND blog_textparsed.languageid = 1)
          			LEFT JOIN blog_user AS bu ON (bu.bloguserid = user.userid)
          			LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid)
          			LEFT JOIN blog_usercsscache AS blog_usercsscache ON (user.userid = blog_usercsscache.userid)
          			LEFT JOIN blog_custom_block_parsed AS blockparsed ON (blockparsed.userid = user.userid AND blockparsed.styleid = 5 AND blockparsed.languageid = 1)
          			
          			
          			LEFT JOIN userlist AS ignored ON (ignored.userid = blog.userid AND ignored.relationid = 1 AND ignored.type = 'ignore')
          			LEFT JOIN userlist AS buddy ON (buddy.userid = blog.userid AND buddy.relationid = 1 AND buddy.type = 'buddy')
          			
          			LEFT JOIN blog_subscribeentry AS blog_subscribeentry ON (blog.blogid = blog_subscribeentry.blogid AND blog_subscribeentry.userid = 1)
          			LEFT JOIN blog_subscribeuser AS blog_subscribeuser ON (blog.userid = blog_subscribeuser.bloguserid AND blog_subscribeuser.userid = 1)
          			LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) 
          			LEFT JOIN blog_rate AS blog_rate ON (blog_rate.blogid = blog.blogid AND blog_rate.userid = 1)
          			LEFT JOIN blog_groupmembership AS gm ON (blog.userid = gm.bloguserid AND gm.userid = 1)
          			LEFT JOIN blog_deletionlog AS blog_deletionlog ON (blog.blogid = blog_deletionlog.primaryid AND blog_deletionlog.type = 'blogid')
          			
          			
          			WHERE blog.blogid = 3;
          
          MySQL Error   : Unknown column 'blog_usercsscache.csscolors' in 'field list'
          Error Number  : 1054
          Request Date  : Friday, October 30th 2009 @ 10:27:42 PM
          Error Date    : Friday, October 30th 2009 @ 10:27:42 PM
          Script        : http://ozscience.com/forums/blog.php?b=3
          Referrer      : 
          IP Address    : 127.0.0.1
          Username      : porcupine73
          Classname     : vB_Database_MySQLi
          Last edited by porcupine73; Fri 30 Oct '09, 6:59pm. Reason: add info

          Comment

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