Hello,

I've had a problem after installing SmartAlbums version  2.2.2

The error went away after I manually downgraded to SmartAlbums version 2.2.1.

When I pressed the button: "Administration - Albums - Manage - Regenerate photos list of all SmartAlbums", or the same button in the plugin, I got this error:


Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
      )
  GROUP BY i.id
  ORDER BY date_creation DESC' at line 7

SELECT i.id
  FROM piwigo_images AS i
  WHERE
    i.id NOT IN (
      SELECT image_id
        FROM piwigo_image_category
        WHERE category_id IN()
      )
  GROUP BY i.id
  ORDER BY date_creation DESC
 
; in /var/www/gallery/include/dblayer/functions_mysqli.inc.php on line 798
Fatal error: Call to a member function fetch_assoc() on a non-object in /var/www/gallery/include/dblayer/functions_mysqli.inc.php on line 181


I'm going to stay with SmartAlbums Version 2.2.1 for now.

I'm running with Piwigo as follows:

Piwigo version: 2.6.2
PHP version: 5.3.3-7+squeeze15
MySQL version: 5.1.66-0+squeeze1
Graphics Library: External ImageMagick 6.6.0-4

Advanced Menu Manager    Version 3.2.6
AStat.2    Advanced statistics Version 2.4.2
Crypto Captcha Version 2.1.2
Grum Plugins Classes.3 Version 3.5.6
GThumb+    Version 2.6.b
Header Manager Version 1.1.0
Language Switch    Version 2.6.2
LocalFiles Editor    Version 2.6.0
Rotate Image    Version 2.6.a
SmartAlbums    Version 2.2.1 (no errors with this version)
Statistics    Version 2.6.a
UserAdvManager Version 2.60.2

11722 photos
44 albums including 40 physical and 4 virtual (35640 associations)

Cheers
Mark