MantisBT - Piwigo
View Issue Details
0001022Piwigoalbumspublic2009.06.01 23:232009.06.02 22:23
Apache 1.3.x
0001022: No more categories when removing all category associations from a photo
With 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/ 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.
No tags attached.
Issue History
2009.06.01 23:23plgNew Issue
2009.06.01 23:23plgStatusnew => assigned
2009.06.01 23:23plgAssigned To => plg
2009.06.01 23:23plgbrowser => any
2009.06.01 23:23plgWeb server => Apache 1.3.x
2009.06.02 22:23plgNote Added: 0002631
2009.06.02 22:23plgStatusassigned => closed
2009.06.02 22:23plgResolutionopen => fixed
2009.06.02 22:23plgFixed in Version => 2.0.3

2009.06.02 22:23   
fixed on branch 2.0 in [Subversion] r3389
merged on trunk Colibri in [Subversion] r3390