we do that but now in install/upgrade.php i get blank page .
Announcement
Collapse
No announcement yet.
after upgrade 3.6.2 when click forumdisplay get this error
Collapse
X
-
If everything was uploaded correct, then you should not get a blank page. Please verify all is uploaded correctly.
If that doesn't help, please open a support ticket with all relevant details.Want to take your board beyond the standard vBulletin features?
Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org
Comment
-
After the first time you should never need to run install.php again.
Also you only need to run upgrade.php, you never run any of the other upgrade scripts directly.Want to take your board beyond the standard vBulletin features?
Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org
Comment
-
also same promlem
when i click to any forum i get
Database error in vBulletin 3.6.2:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
WHERE thread.threadid IN (0,28419,27968,26624,21562,23340,27345,26669,28032,22729,19065,28339,28278,28030,12804,281 14,25274,25275,28150,28149,27894,14374,20302)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Unknown column 'hiddencount' in 'field list'
Error Number : 1054Last edited by Q8vbhacks; Wed 8 Nov '06, 2:43am.
Comment
-
Did you run upgrade.php again, and did you get any messages while running it?Want to take your board beyond the standard vBulletin features?
Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org
Comment
-
only i get above message and when i click to any user i get :
Database error in vBulletin 3.6.2:
Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
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, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight
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 avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN sigpic AS sigpic ON (user.userid = sigpic.userid)
WHERE user.userid = 14015;
MySQL Error : Unknown column 'customavatar.width' in 'field list'
Error Number : 1054
Comment
-
Seems you have missed one or more upgrade steps. Try running the following query:
Code:ALTER TABLE customavatar ADD COLUMN `width` smallint(5) unsigned NOT NULL default '0';
Want to take your board beyond the standard vBulletin features?
Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org
Comment
-
Originally posted by Marco van Herwaarden View PostSeems you have missed one or more upgrade steps. Try running the following query:
Code:ALTER TABLE customavatar ADD COLUMN `width` smallint(5) unsigned NOT NULL default '0';
thanks now this error :
Database error in vBulletin 3.6.2:
Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 2)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 1 AND sigparsed.languageid = 2)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
WHERE post.postid IN (0,159420,159423,165821,165949,168089,168156)
ORDER BY post.dateline;
MySQL Error : Unknown column 'customavatar.height' in 'field list'
Error Number : 1054
Date : Tuesday, November 14th 2006 @ 10:43:03 AM
Comment
-
now everthing ok but in admincp when click to edit user i get this error :
Database error in vBulletin 3.6.3:
Invalid SQL:
SELECT * FROM subscription ORDER BY displayorder;
MySQL Error : Unknown column 'displayorder' in 'order clause'
Error Number : 1054
Date : Tuesday, November 14th 2006 @ 11:54:47 AM
Comment
-
Run the following query:
Code:ALTER TABLE subscription ADD COLUMN `displayorder` smallint(5) unsigned NOT NULL default '1';
Code:ALTER TABLE subscription ADD COLUMN `adminoptions` int(10) unsigned NOT NULL default '0';
Want to take your board beyond the standard vBulletin features?
Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org
Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment