This is also ticket vBulletin Issue - mysql error: Unknown column 'tCustom.type' in 'where clause' [SID-259168-8ddcfc43], but it looks like I'm toast until this gets resolved.
Right after doing the upgrade from beta to 3.0.3, I went to 'find updated tempates' like the manual says. I get this mysql error:
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT tCustom.templateid, tCustom.title, tCustom.styleid,
tCustom.username AS customuser, tCustom.dateline AS customdate,
tGlobal.username AS globaluser, tGlobal.dateline AS globaldate
FROM template AS tCustom
INNER JOIN template AS tGlobal ON (tGlobal.styleid = -1 AND tGlobal.title = tCustom.title)
WHERE tCustom.styleid <> -1
AND tCustom.type = TEMPLATETYPE_TEMPLATE
ORDER BY tCustom.title
mysql error: Unknown column 'tCustom.type' in 'where clause'
mysql error number: 1054
and it looks to me like that table does not exist:
mysql> show tables;
+-------------------------+
| Tables_in_**** |
+-------------------------+
| access |
| adminhelp |
| administrator |
| adminlog |
| adminutil |
| announcement |
| attachment |
| attachmenttype |
| attachmentviews |
| avatar |
| bbcode |
| calendar |
| calendarcustomfield |
| calendarmoderator |
| calendarpermission |
| cpsession |
| cron |
| cronlog |
| customavatar |
| customprofilepic |
| datastore |
| deletionlog |
| editlog |
| event |
| faq |
| forum |
| forumpermission |
| holiday |
| icon |
| imagecategory |
| imagecategorypermission |
| language |
| mailqueue |
| moderation |
| moderator |
| moderatorlog |
| passwordhistory |
| phrase |
| phrasetype |
| pm |
| pmreceipt |
| pmtext |
| poll |
| pollvote |
| post |
| post_parsed |
| posthash |
| postindex |
| profilefield |
| ranks |
| regimage |
| reminder |
| reputation |
| reputationlevel |
| search |
| session |
| setting |
| settinggroup |
| smilie |
| stats |
| strikes |
| style |
| subscribeevent |
| subscribeforum |
| subscribethread |
| subscription |
| subscriptionlog |
| template |
| thread |
| threadrate |
| threadviews |
| upgradelog |
| user |
| useractivation |
| userban |
| userfield |
| usergroup |
| usergroupleader |
| usergrouprequest |
| usernote |
| userpromotion |
| usertextfield |
| usertitle |
| word |
+-------------------------+
84 rows in set (0.00 sec)
mysql> quit
I assume I'm wedged and can't revert to the beta version, since tables have been ALTERed. Help, anyone?
Ed, [email protected]
Right after doing the upgrade from beta to 3.0.3, I went to 'find updated tempates' like the manual says. I get this mysql error:
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT tCustom.templateid, tCustom.title, tCustom.styleid,
tCustom.username AS customuser, tCustom.dateline AS customdate,
tGlobal.username AS globaluser, tGlobal.dateline AS globaldate
FROM template AS tCustom
INNER JOIN template AS tGlobal ON (tGlobal.styleid = -1 AND tGlobal.title = tCustom.title)
WHERE tCustom.styleid <> -1
AND tCustom.type = TEMPLATETYPE_TEMPLATE
ORDER BY tCustom.title
mysql error: Unknown column 'tCustom.type' in 'where clause'
mysql error number: 1054
and it looks to me like that table does not exist:
mysql> show tables;
+-------------------------+
| Tables_in_**** |
+-------------------------+
| access |
| adminhelp |
| administrator |
| adminlog |
| adminutil |
| announcement |
| attachment |
| attachmenttype |
| attachmentviews |
| avatar |
| bbcode |
| calendar |
| calendarcustomfield |
| calendarmoderator |
| calendarpermission |
| cpsession |
| cron |
| cronlog |
| customavatar |
| customprofilepic |
| datastore |
| deletionlog |
| editlog |
| event |
| faq |
| forum |
| forumpermission |
| holiday |
| icon |
| imagecategory |
| imagecategorypermission |
| language |
| mailqueue |
| moderation |
| moderator |
| moderatorlog |
| passwordhistory |
| phrase |
| phrasetype |
| pm |
| pmreceipt |
| pmtext |
| poll |
| pollvote |
| post |
| post_parsed |
| posthash |
| postindex |
| profilefield |
| ranks |
| regimage |
| reminder |
| reputation |
| reputationlevel |
| search |
| session |
| setting |
| settinggroup |
| smilie |
| stats |
| strikes |
| style |
| subscribeevent |
| subscribeforum |
| subscribethread |
| subscription |
| subscriptionlog |
| template |
| thread |
| threadrate |
| threadviews |
| upgradelog |
| user |
| useractivation |
| userban |
| userfield |
| usergroup |
| usergroupleader |
| usergrouprequest |
| usernote |
| userpromotion |
| usertextfield |
| usertitle |
| word |
+-------------------------+
84 rows in set (0.00 sec)
mysql> quit
I assume I'm wedged and can't revert to the beta version, since tables have been ALTERed. Help, anyone?
Ed, [email protected]
Comment