Piwigo Bugtracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001022Piwigoalbumspublic2009.06.01 23:232009.06.02 22:23
Assigned Toplg 
PlatformOSOS Version
Product Version2.0.2 
Target Version2.0.3Fixed in Version2.0.3 
Summary0001022: No more categories when removing all category associations from a photo
DescriptionWith pLoader I have no more physical categories. So while managing categories associated to a given photo, you might remove all associations, and the error occur:

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 ')' at line 3

SELECT id,name,uppercats,global_rank
  FROM categories
  WHERE id NOT IN ()
; in include/functions.inc.php on line 918

Then I see no categories to associate the photo to (and this is a problem).

I have a workaround, because I can associate some categories from the bulk manager.
TagsNo tags attached.
Database engine and version
PHP version
Web serverApache 1.3.x
Attached Files

- Relationships

-  Notes
plg (manager)
2009.06.02 22:23

fixed on branch 2.0 in [Subversion] r3389
merged on trunk Colibri in [Subversion] r3390

- Issue History
Date Modified Username Field Change
2009.06.01 23:23 plg New Issue
2009.06.01 23:23 plg Status new => assigned
2009.06.01 23:23 plg Assigned To => plg
2009.06.01 23:23 plg browser => any
2009.06.01 23:23 plg Web server => Apache 1.3.x
2009.06.02 22:23 plg Note Added: 0002631
2009.06.02 22:23 plg Status assigned => closed
2009.06.02 22:23 plg Resolution open => fixed
2009.06.02 22:23 plg Fixed in Version => 2.0.3

Copyright © 2000 - 2015 MantisBT Team
Powered by Mantis Bugtracker