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: albumdownload plug-in don't work  (Read 5895 times)

0 Members and 1 Guest are viewing this topic.

N2GetherNow

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
albumdownload plug-in don't work
« on: July 21, 2013, 08:16:21 am »

Hello there,
i've installed this plug-in but seem to not work. When i hit "zip" button it returns this error:
Quote
    Critical error
    There was an error while processing a database query
Also this is from the database log:
Quote
        Юли 20, 2013 at 09:21 PM - While executing query 'SELECT filepath, filename FROM cpg_fairs_pictures AS pictures , (SELECT keyword FROM cpg_fairs_albums WHERE aid = '5' ) AS keyword, cpg_fairs_albums AS r WHERE (1) AND r.aid = pictures.aid AND (pictures.aid = '5' OR ( keyword.keyword <> '' AND CONCAT(';', keywords, ';') LIKE CONCAT('%;', keyword.keyword, ';%')))' in plugins\albumdownload\zip.php on line 28 the following error was encountered:
        You have an error in your SQL syntax near '(SELECT keyword FROM cpg_fairs_albums WHERE aid = '5' ) AS keyword, cpg_fairs_al' at line 1
I'm running cpg 1.5.24 revision 8570 on Win7, Apache 1.3.7 (PHP v.4.3.2, MySQL v.3.23.49).
Favorites zip download works perfect. Any ideas?

P.S. THIS is the gallery and English language exist, so this is not the problem (i've checked it for sure and don't work while english is active)
Logged

ron4mac

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 2026
Re: albumdownload plug-in don't work
« Reply #1 on: July 21, 2013, 04:30:41 pm »

It would probably be beneficial for you (especially in the long run) to update/upgrade your versions of MySQL and PHP.
Logged

N2GetherNow

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
Re: albumdownload plug-in don't work
« Reply #2 on: July 21, 2013, 05:01:12 pm »

It would probably be beneficial for you (especially in the long run) to update/upgrade your versions of MySQL and PHP.
It would probably, but i don't think i can configure them properly (i had tried already in the past). This is complete package like xampp.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: albumdownload plug-in don't work
« Reply #3 on: August 20, 2013, 03:52:56 pm »

Your MySQL version is too old, as it doesn't support sub-queries. However, that could probably be fixed if you move the sub-query to a separate query.

If you don't know how to do that, please reply to this post.
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: albumdownload plug-in don't work
« Reply #4 on: August 20, 2013, 06:03:49 pm »

It is quite easy to upgrade XAMPP, please visit their website for full details. It is because of things like this that we try not to recommend self hosting.
Logged
It is a mistake to think you can solve any major problems just with potatoes.
Pages: [1]   Go Up
 

Page created in 0.034 seconds with 20 queries.