after upgrade 3.6.2 when click forumdisplay get this error

[Q8vbhacks]

hi all

after upgrade need help please when click forumdisplay get this error :

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,28424,28409,28338,28384,28376,28391,28362,28060,26234,28232,28294,27895,28043,28368,283 51,28148,28274,28315,25863,28269,14366,14819,21175)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Unknown column 'hiddencount' in 'field list'
Error Number : 1054
Date : Friday, November 3rd 2006 @ 01:19:04 PM

[Marco van Herwaarden]

This is very likely caused by a modification you have installed.

To troubleshoot this, please remove any hacks and disable your plugins, then see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

[Q8vbhacks]

we but
define('DISABLE_HOOKS', true);
in config file and reubload all in ASCII format still this error

MySQL Error : Unknown column 'hiddencount' in 'field list'
Error Number : 1054

[Q8vbhacks]

also when click to any user get this error

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

[Marco van Herwaarden]

Did you receive any errors during upgrade.php?

[Q8vbhacks]

no

i but install.php + init.php to upgrade again and go to

http://www/myforum.com/install/upgrade.php i get blank page ?

hope fix that problem and i dont have any backup

[Q8vbhacks]

also go to maintenanse to
Rebuild Thread Information

i get this error also :

Database error in vBulletin 3.6.2:
Invalid SQL:
UPDATE thread SET
firstpostid = 4,
postuserid = 2,
postusername = 'ÃÈæ ÚÈÏÇáÑÍãä',
lastpost = 988628802,
replycount = 0,
hiddencount = 0,
deletedcount = 0,
attach = 0,
dateline = 988628802,
lastposter = 'ÃÈæ ÚÈÏÇáÑÍãä',
lastpostid = 4,
votenum = 0,
votetotal = 0
WHERE threadid = 4;
MySQL Error : Unknown column 'hiddencount' in 'field list'
Error Number : 1054

[Marco van Herwaarden]

To troubleshoot this, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

Ones all files have been reuploaded, try to run install/upgrade.php again.

[Colin F]

This error is caused by a modification, follow the instructions Marco gave you in his first post.

[Q8vbhacks]

This error is caused by a modification, follow the instructions Marco gave you in his first post.

thank you for replay

but how we do that and where ?

[Colin F]

With which step are you having problems?

[Q8vbhacks]

not for step all forum

when click to any forum i get this error

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,22438,22341)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Unknown column 'hiddencount' in 'field list'
Error Number : 1054


also when i click to any user i get this error :

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 = 1;
MySQL Error : Unknown column 'customavatar.width' in 'field list'
Error Number : 1054

when i Rebuild Thread Information

i get this error also :

Database error in vBulletin 3.6.2:
Invalid SQL:
UPDATE thread SET
firstpostid = 4,
postuserid = 2,
postusername = 'ÃÈæ ÚÈÏÇáÑÍãä',
lastpost = 988628802,
replycount = 0,
hiddencount = 0,
deletedcount = 0,
attach = 0,
dateline = 988628802,
lastposter = 'ÃÈæ ÚÈÏÇáÑÍãä',
lastpostid = 4,
votenum = 0,
votetotal = 0
WHERE threadid = 4;
MySQL Error : Unknown column 'hiddencount' in 'field list'
Error Number : 1054

[Marco van Herwaarden]

What is the version you upgraded from?

[Q8vbhacks]

from 3.0.3

[Marco van Herwaarden]

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

And what was the result of that?