Announcement

Collapse
No announcement yet.

after upgrade 3.6.2 when click forumdisplay get this error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Q8vbhacks
    replied
    thank u very much now all is ok great support

    Leave a comment:


  • Marco van Herwaarden
    replied
    Run the following query:
    Code:
    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:
    Code:
    ALTER TABLE subscription ADD COLUMN `adminoptions` int(10) unsigned NOT NULL default '0';

    Leave a comment:


  • Q8vbhacks
    replied
    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

    Leave a comment:


  • Q8vbhacks
    replied
    also when click to any user this error :

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

    Leave a comment:


  • Q8vbhacks
    replied
    Originally posted by Marco van Herwaarden View Post
    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';

    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

    Leave a comment:


  • Marco van Herwaarden
    replied
    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';

    Leave a comment:


  • Q8vbhacks
    replied
    Originally posted by Marco van Herwaarden View Post
    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

    Leave a comment:


  • Q8vbhacks
    replied
    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

    Leave a comment:


  • Marco van Herwaarden
    replied
    Did you run upgrade.php again, and did you get any messages while running it?

    Leave a comment:


  • Q8vbhacks
    replied
    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
    Last edited by Q8vbhacks; Wed 8 Nov '06, 2:43am.

    Leave a comment:


  • Marco van Herwaarden
    replied
    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.

    Leave a comment:


  • Q8vbhacks
    replied
    now is open install page from where i beging ?

    re install only upgrade.php or upgrade_303.php ?

    Leave a comment:


  • Marco van Herwaarden
    replied
    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.

    Leave a comment:


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

    Leave a comment:


  • Marco van Herwaarden
    replied
    Did you follow my instruction in post http://www.vbulletin.com/forum/showp...85&postcount=8

    And what was the result of that?

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X