after upgrade 3.6.2 when click forumdisplay get this error

[Q8vbhacks]

we do that but now in install/upgrade.php i get blank page .

[Marco van Herwaarden]

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.

[Q8vbhacks]

now is open install page from where i beging ?

re install only upgrade.php or upgrade_303.php ?

[Marco van Herwaarden]

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.

[Q8vbhacks]

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

[Marco van Herwaarden]

Did you run upgrade.php again, and did you get any messages while running it?

[Q8vbhacks]

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

[Q8vbhacks]

Did you run upgrade.php again, and did you get any messages while running it?

yes and i did not get any error mesaages in 3.6.2 upgrade .

thanks

[Marco van Herwaarden]

Seems you have missed one or more upgrade steps. Try running the following query:

ALTER TABLE customavatar ADD COLUMN `width` smallint(5) unsigned NOT NULL default '0';

[Q8vbhacks]

Seems you have missed one or more upgrade steps. Try running the following query:

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

[Q8vbhacks]

also when click to any user this error :

Unknown column 'customprofilepic.width' in 'field list'

[Q8vbhacks]

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

[Marco van Herwaarden]

Run the following query:

ALTER TABLE subscription ADD COLUMN `displayorder` smallint(5) unsigned NOT NULL default '1';

And you will probably run into an error about a missing adminoptions column. If that happens, also run the following:

ALTER TABLE subscription ADD COLUMN `adminoptions` int(10) unsigned NOT NULL default '0';

[Q8vbhacks]

thank u very much now all is ok great support