Suite Error messages from the database

محروم.كوم · #1 04-27-2010, 05:50 PM

After the upgrade to vBulletin version 4.03 PL1 I receive hundreds of emails from database error messages with the following content:

Code:
Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight
, bu.bloguserid, bu.entries, bu.options AS blog_options, bu.subscribeown AS blog_subscribeown, bu.memberids, bu.memberblogids,
bu.subscribeothers AS blog_subscribeothers, bu.title AS blog_title, bu.description AS blog_description, bu.allowsmilie AS blog_allowsmilie, bu.draft AS blog_draft, bu.pending AS blog_pending, bu.options_member, bu.options_guest, bu.options_buddy, bu.options_ignore, bu.uncatentries, bu.moderation AS blog_moderation, bu.deleted AS blog_deleted, bu.akismet_key AS blog_akismet_key, isblogmoderator, bu.comments_moderation AS blog_comments_moderation, bu.lastblog, bu.lastblogid, bu.lastblogtitle, bu.categorycache, bu.tagcloud, bu.sidebar, bu.custompages, bu.customblocks, blockparsed.blocktext, 17 AS blogstyleid, 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, IF(blog_subscribeuser.blogsubscribeuserid, 1, 0) AS blogsubscribed, bu.bloguserid, bu.entries, bu.options AS blog_options, bu.subscribeown AS blog_s
ubscribeown, bu.memberids, bu.memberblogids,
bu.subscribeothers AS blog_subscribeothers, bu.title AS blog_title, bu.description AS blog_description, bu.allowsmilie AS blog_allowsmilie, bu.draft AS blog_draft, bu.pending AS blog_pending, bu.options_member, bu.options_guest, bu.options_buddy, bu.options_ignore, bu.uncatentries, bu.moderation AS blog_moderation, bu.deleted AS blog_deleted, bu.akismet_key AS blog_akismet_key, isblogmoderator, bu.comments_moderation AS blog_comments_moderation, bu.lastblog, bu.lastblogid, bu.lastblogtitle, bu.categorycache, bu.tagcloud, bu.sidebar, bu.custompages, bu.customblocks, blockparsed.blocktext, 17 AS blogstyleid, 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, IF(blog_subscribeuser.blogsubscribeuserid, 1, 0) AS blogsubscribed
FROM vbuluser AS user
LEFT JOIN vbuluserfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN vbulusertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vbulavatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vbulcustomavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN vbulcustomprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid)

LEFT JOIN vbulblog_user AS bu ON (bu.bloguserid = user.userid)
LEFT JOIN vbulblog_custom_block_parsed AS blockparsed ON (blockparsed.userid = user.userid AND blockparsed.styleid = 17 AND blockparsed.languageid = 5)

LEFT JOIN vbulblog_subscribeuser AS blog_subscribeuser ON (user.userid = blog_subscribeuser.bloguserid AND blog_subscribeuser.userid = 40)
LEFT JOIN vbulblog_usercsscache AS blog_usercsscache ON (user.userid = blog_usercsscache.userid)
LEFT JOIN vbulblog_user AS bu ON (bu.bloguserid = user.userid)
LEFT JOIN vbulblog_custom_block_parsed AS blockparsed ON (blockparsed.userid = user.userid AND blockparsed.styleid = 17 AND blockparsed.languageid = 5)
LEFT JOIN vbulblog_subscribeuser AS blog_subscribeuser ON (user.userid = blog_subscribeuser.bloguserid AND blog_subscribeuser.userid = 40)
LEFT JOIN vbulblog_usercsscache AS blog_usercsscache ON (user.userid = blog_usercsscache.userid)
WHERE user.userid = 40;

MySQL Error : Not unique table/alias: 'bu'
Error Number : 1066
Request Date : Tuesday, April 27th 2010 @ 03:06:18 PM
Error Date : Tuesday, April 27th 2010 @ 03:06:18 PM
Script : http://www.drylandmagazin.pl/forum/b...nd&language=es
Referrer :
IP Address : 66.249.65.58
Username : Niezarejestrowany
Classname : vB_Database
MySQL Version :

If anyone knows the solution to this problem I would be grateful for an indication of the solution to this problem. __DEFINE_LIKE_SHARE__