Quote:
Originally Posted by troppodel
hi there
i have updated the mod from 2.0 to 3.0 now i receive this error:
Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT COUNT('pictureid') AS fotos
FROM BMWM_FORUM_albumpicture
INNER JOIN BMWM_FORUM_album
ON BMWM_FORUM_albumpicture.albumid = BMWM_FORUM_album.albumid
WHERE userid = 1 AND (cat = 2 OR storecat = 2);
MySQL Error : Unknown column 'cat' in 'where clause'
Error Number : 1054
Request Date : Saturday, January 31st 2009 @ 11:24:16 AM
Error Date : Saturday, January 31st 2009 @ 11:24:16 AM
Script : http://www.bobmarleymagazine.com/for...=vB_Editor_001
Referrer : http://www.bobmarleymagazine.com/for...newthread&f=81
IP Address :
Username : ivan
Classname : vB_Database
MySQL Version : 4.0.27-standard-log
i forgot something to configure?
thanks
|
I am getting the same error when switching albums. I also integrated Photoplog and it would display the albums in the drop down list, but when you selected one it would always state that I had no images available to insert therein. Even if I had uploaded the images, it would not display or allow any to be inserted. I cannot recall the exact verbiage, since the database error is displayed now when I initiate the insert. I had no problems in the previous version. I also had Photoplog's custom insert code working well alongside this mod. I disabled it to be sure there was no conflict, but it did not resolve the issues.