Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Display Categories Issue from Voting Plugin  (Read 1944 times)

0 Members and 1 Guest are viewing this topic.

veyrnosi

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Display Categories Issue from Voting Plugin
« 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'
Logged

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4624
    • Windsurf.me
Re: Display Categories Issue from Voting Plugin
« Reply #1 on: October 01, 2018, 07:49:53 pm »

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

veyrnosi

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Display Categories Issue from Voting Plugin
« Reply #2 on: October 02, 2018, 12:38:44 pm »

Yes, I probably should have mentioned that.  :P
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15651
Re: Display Categories Issue from Voting Plugin
« Reply #3 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 20 queries.