forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 plugins => Topic started by: veyrnosi on October 01, 2018, 01:17:05 pm

Title: Display Categories Issue from Voting Plugin
Post by: veyrnosi on October 01, 2018, 01:17:05 pm

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

I assume it's because of the voting plugin?

Code: [Select]

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'


Title: Re: Display Categories Issue from Voting Plugin
Post by: phill104 on October 01, 2018, 07:49:53 pm

Does the error go away if you disable the plugin?

Title: Re: Display Categories Issue from Voting Plugin
Post by: veyrnosi on October 02, 2018, 12:38:44 pm

Yes, I probably should have mentioned that.  :P

Title: Re: Display Categories Issue from Voting Plugin
Post by: Αndré on October 24, 2018, 03:25:07 pm

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.