PDA

View Full Version : Picture Upload fails => DB Error


drknickel
Wed 30th Jan '08, 7:07am
Hello everyone,

when i upload a picture into an album the picture does not show up and i get an error:

Database error in vBulletin 3.7.0 Beta 4:
Invalid SQL:
SELECT picture.pictureid, picture.userid,picture.extension, picture.idhash,
albumpicture.dateline, album.public,
picture.thumbnail AS filedata, picture.thumbnail_filesize AS filesize
FROM vb_albumpicture AS albumpicture
INNER JOIN vb_picture AS picture ON (albumpicture.pictureid = picture.pictureid)
INNER JOIN vb_album AS album ON (albumpicture.albumid = album.albumid)
WHERE albumpicture.albumid = 3 AND albumpicture.pictureid = 5;
MySQL Error : Unknown column 'album.public' in 'field list'

What can i do against it?

Greets

Floris
Wed 30th Jan '08, 7:22am
Hello,

Thank you for contacting vBulletin Support.

Re-upload all the 3.7.0 beta 4 files, this error indicates that not all the files have been uploaded properly.

All the best,

drknickel
Wed 30th Jan '08, 11:25am
I just re uploaded all the files but i still get the same error :(

Greets

Floris
Wed 30th Jan '08, 6:11pm
Run diagnostics > file suspect
and see if it reports anything back to you.