The Arcive of vBulletin Modifications Site. |
|
|
#1
|
|||
|
|||
|
Database error in vBulletin 3.7.2:
hello all, im getting this error when upgrading my forum from 3.6.8 to 3.7.2, anyone can help me fix it ? Code:
Invalid SQL:
SELECT album.*,
picture.pictureid, picture.extension, picture.idhash, album.moderation,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height
FROM album AS album
LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
WHERE album.userid = 45
AND album.state IN ('public', 'private', 'profile')
AND (album.visible > 0 OR album.moderation > 0)
ORDER BY album.lastpicturedate DESC
LIMIT 2;
MySQL Error : Unknown column 'album.userid' in 'where clause'
Error Number : 1054
Request Date : Wednesday, July 16th 2008 @ 01:11:38 AM
Error Date : Wednesday, July 16th 2008 @ 01:11:39 AM
|
|
#2
|
|||
|
|||
|
Did you run the upgrade script fully? It looks like it hasn't upgraded everything.
|
![]() |
|
|
| X vBulletin 3.8.12 by vBS Debug Information | |
|---|---|
|
|
More Information |
|
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|