Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Display Categories Issue from Voting Plugin  (Read 9521 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

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • 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: 15764
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 19 queries.