[cellarius]

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

Thank you for reporting this, I can reproduce this. There is indeed a mixup in the configuration file for vB albums. That must have happened while I was preparing the config-files for release There's a Photopost query in the vB albums config. There'll be a bugfix release shortly.

Originally Posted by Dr. Bantham

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.

The same error is probably the same problem. Concerning Photoplog I cannot reproduce this. I can only suspect that the database structure for Photoplog Pro is different from Photoplog lite (which I cannot access. Is this issue the same whether you access a Photoplog category or a user owned album?