Advanced search  

News:

cpg1.5.46 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter recently discovered vulnerabilities. It is important that all users who run version cpg1.5.44 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 1618 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: 4577
    • 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: 15587
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.014 seconds with 20 queries.