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 :
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 :
Comment