Display Categories Issue from Voting Plugin Display Categories Issue from Voting Plugin
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Display Categories Issue from Voting Plugin

Started by veyrnosi, October 01, 2018, 01:17:05 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

veyrnosi

When I try to view albums in a category I get this error:

I assume it's because of the voting plugin?

While executing query 'SELECT *, COUNT(v.aid) AS album_votes FROM ntvd_album_votes AS v
                INNER JOIN ntvd_albums AS r ON r.aid = v.aid
                INNER JOIN ntvd_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 11 AND 12) AND (1 OR keywords like '%Pod%')
                AND r.aid IN (SELECT DISTINCT aid FROM ntvd_pictures)
                GROUP BY v.aid
                ORDER BY album_votes DESC, v.aid DESC
                 LIMIT 0 ,16' in plugins/album_voting/codebase.php on line 129

mySQL error: Unknown column 'keywords' in 'where clause'

phill104

Does the error go away if you disable the plugin?
It is a mistake to think you can solve any major problems just with potatoes.

veyrnosi

Yes, I probably should have mentioned that.  :P

ΑndrĂ©

I cannot replicate the issue. Please post a link to your gallery where we can see the issue. The plugin itself doesn't add the "keywords" column to the query, but it is added by $RESTRICTEDWHERE. The keyword column is part of the cpg_pictures table, which is not included in the query.