haothiencz
07-16-2008, 06:13 AM
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 ?
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
hello all, im getting this error when upgrading my forum from 3.6.8 to 3.7.2, anyone can help me fix it ?
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