Revast
01-15-2010, 12:49 PM
I was directed here from the official vBulletin forums (http://www.vbulletin.com/forum/showthread.php?337307-Database-error-when-trying-to-view-any-user-profile&p=1905560).
Everyone on my forums is having this issue, we get a "Database Error" when trying to view a users profile. Here is my site, try it for youself: http://www.bladeandsouldojo.com/
I've searched everywhere, can't find anything on this problem. I posted on the vBulletin official forums (http://www.vbulletin.com/forum/showthread.php?337307-Database-error-when-trying-to-view-any-user-profile&p=1905560) and was directed here. They told me it was the arcade i installed, this problem did start happening after installed this arcade and worked with the v3arcade to ibProArcade converter.
<!--
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_wol AS phrasegroup_wol,
language.phrasegroup_user AS phrasegroup_user,
language.phrasegroup_messaging AS phrasegroup_messaging,
language.phrasegroup_cprofilefield AS phrasegroup_cprofilefield,
language.phrasegroup_infractionlevel AS phrasegroup_infractionlevel,
language.phrasegroup_posting AS phrasegroup_posting,
language.phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal,
language.phrasegroup_arcade AS phrasegroup_arcade,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
, 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, 2 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, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
LEFT JOIN blog_user AS bu ON (bu.bloguserid = user.userid)
LEFT JOIN blog_custom_block_parsed AS blockparsed ON
(blockparsed.userid = user.userid AND blockparsed.styleid = 2 AND blockparsed.languageid = IF(user.languageid = 0, 1, user.languageid))
LEFT JOIN blog_subscribeuser AS blog_subscribeuser ON (user.userid = blog_subscribeuser.bloguserid AND blog_subscribeuser.userid = 1)
LEFT JOIN blog_usercsscache AS blog_usercsscache ON (user.userid = blog_usercsscache.userid)
LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid)
WHERE user.userid = 1;
MySQL Error : Unknown column 'language.phrasegroup_arcade' in 'field list'
Error Number : 1054
Request Date : Friday, January 15th 2010 @ 06:44:14 AM
Error Date : Friday, January 15th 2010 @ 06:44:14 AM
Script : /forum/member.php?u=73
Referrer : /forum/showthread.php?t=146
IP Address : 99.173.153.118
Username :
Classname : vB_Database
MySQL Version :
-->
Thank you in advance (if there is a possible fix)! :D
--------------- Added 1263570001 at 1263570001 ---------------
Problem solved, disregard this thread.
Everyone on my forums is having this issue, we get a "Database Error" when trying to view a users profile. Here is my site, try it for youself: http://www.bladeandsouldojo.com/
I've searched everywhere, can't find anything on this problem. I posted on the vBulletin official forums (http://www.vbulletin.com/forum/showthread.php?337307-Database-error-when-trying-to-view-any-user-profile&p=1905560) and was directed here. They told me it was the arcade i installed, this problem did start happening after installed this arcade and worked with the v3arcade to ibProArcade converter.
<!--
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_wol AS phrasegroup_wol,
language.phrasegroup_user AS phrasegroup_user,
language.phrasegroup_messaging AS phrasegroup_messaging,
language.phrasegroup_cprofilefield AS phrasegroup_cprofilefield,
language.phrasegroup_infractionlevel AS phrasegroup_infractionlevel,
language.phrasegroup_posting AS phrasegroup_posting,
language.phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal,
language.phrasegroup_arcade AS phrasegroup_arcade,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
, 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, 2 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, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
LEFT JOIN blog_user AS bu ON (bu.bloguserid = user.userid)
LEFT JOIN blog_custom_block_parsed AS blockparsed ON
(blockparsed.userid = user.userid AND blockparsed.styleid = 2 AND blockparsed.languageid = IF(user.languageid = 0, 1, user.languageid))
LEFT JOIN blog_subscribeuser AS blog_subscribeuser ON (user.userid = blog_subscribeuser.bloguserid AND blog_subscribeuser.userid = 1)
LEFT JOIN blog_usercsscache AS blog_usercsscache ON (user.userid = blog_usercsscache.userid)
LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid)
WHERE user.userid = 1;
MySQL Error : Unknown column 'language.phrasegroup_arcade' in 'field list'
Error Number : 1054
Request Date : Friday, January 15th 2010 @ 06:44:14 AM
Error Date : Friday, January 15th 2010 @ 06:44:14 AM
Script : /forum/member.php?u=73
Referrer : /forum/showthread.php?t=146
IP Address : 99.173.153.118
Username :
Classname : vB_Database
MySQL Version :
-->
Thank you in advance (if there is a possible fix)! :D
--------------- Added 1263570001 at 1263570001 ---------------
Problem solved, disregard this thread.