Hello-
I had reported this error before and thought it had been fixed, but I was too optimistic. I receive it several times night
Code:
Invalid SQL:
SELECT picture.pictureid, picture.userid, picture.extension, picture.idhash, picture.state, picture.fbbypass,
albumpicture.dateline, album.state AS albumstate, profileblockprivacy.requirement AS privacy_requirement,
picture.filedata, picture.filesize
FROM vbalbumpicture AS albumpicture
INNER JOIN vbpicture AS picture ON (albumpicture.pictureid = picture.pictureid)
INNER JOIN vbalbum AS album ON (albumpicture.albumid = album.albumid)
LEFT JOIN vbprofileblockprivacy AS profileblockprivacy ON
(profileblockprivacy.userid = picture.userid AND profileblockprivacy.blockid = 'albums')
WHERE albumpicture.albumid = 35 AND albumpicture.pictureid = 147;
MySQL Error : Table '417278_forum.vbprofileblockprivacy' doesn't exist
Error Number : 1146
Request Date : Tuesday, March 16th 2010 @ 01:19:38 PM
Error Date : Tuesday, March 16th 2010 @ 01:19:39 PM
Script : http://www.mysite.com/forum/facebook.php?do=albumpicture&albumid=35&pictureid=147
Referrer :
IP Address : 66.220.145.246
Username : Unregistered
Classname : vB_Database
As I read the error, it seems it is complaining about a missing table: vbprofileblockprivacy
I'm not much of a coder, but it seems if that's the problem, I could just go into phpMyAdmin and add the table. I started to do that this morning, but when I did, besides prompting for the table name, it also wants the number of fields, so it seems I need a bit more info.
- Is my conclusion correct that this vbprofileblockprivacy table should be there?
- If it should be, then how many fields should it have?
- Is this the logical fix?
Thanks for any thoughts on this.
dc