MantisBT - Piwigo
View Issue Details
0001851Piwigonotificationpublic2010.09.13 11:562011.09.08 12:56
rvelices 
rvelices 
normalminoralways
closedreopened 
2.1.2 
2.1.3 
any
Apache 1.3.x
0001851: duplicate images in RSS feed (or notification by email)
because of missing DISTINCT in notification sql queries, the RSS feed might return the same image more than once resulting in double thumbnails (or even more thumbnails that were added at that date)
No tags attached.
Issue History
2010.09.13 11:56rvelicesNew Issue
2010.09.13 11:56rvelicesStatusnew => assigned
2010.09.13 11:56rvelicesAssigned To => rvelices
2010.09.13 11:56rvelicesbrowser => any
2010.09.13 11:56rvelicesWeb server => Apache 1.3.x
2010.09.13 11:56rvelicesNote Added: 0004157
2010.09.13 11:56rvelicesNote Edited: 0004157
2010.09.13 11:57rvelicesResolutionopen => fixed
2010.09.13 11:57rvelicesFixed in Version => 2.1.3
2010.09.13 11:57rvelicesStatusassigned => closed
2010.09.15 21:46nikrouNote Added: 0004186
2010.09.15 21:46nikrouStatusclosed => feedback
2010.09.15 21:46nikrouResolutionfixed => reopened
2010.09.16 10:02rvelicesNote Added: 0004192
2011.09.08 12:56plgNote Added: 0005493
2011.09.08 12:56plgStatusfeedback => closed

Notes
(0004157)
rvelices   
2010.09.13 11:56   
[Subversion] r6870
[Subversion] r6871

(0004186)
nikrou   
2010.09.15 21:46   
Adding distinct breaks sql queries with PostgreSQL database engine
(0004192)
rvelices   
2010.09.16 10:02   
I thought of it because you just removed DISTINCT when added Postgres compatibility (which resulted in this bug)
Would you mind making the correction yourself and especially could you document somewhere what are the rules when using DISTINCT with Postgres (I dont have Postgres and whatever the Postgres requirement, it seems very strange to me) ?
(0005493)
plg   
2011.09.08 12:56   
Issue closed unresolved, see 0002431 : Piwigo drops support for PostgreSQL/SQLite