Piwigo Bugtracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0002184Piwigonavigationpublic2011.02.08 14:332011.02.08 15:24
Reporterplg 
Assigned Toplg 
PrioritynormalSeverityblockReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version2.2.0RC1 
Target Version2.2.0RC2Fixed in Version2.2.0RC2 
Summary0002184: SQL blocking error on recently posted photos filter
DescriptionWhen clicking on the icon "display only recently posted photos" (in the "Albums" section of the menu), we get a blocking SQL error:

Piwigo encountered a non recoverable error
[mysql error 1064] syntax error 'NULLAND (id IN (1,2,3,4,5,6,7))
  ORDER BY rank' on line 11

SELECT
    c.*,
    user_representative_picture_id,
    nb_images,
    date_last,
    max_date_last,
    count_images,
    count_categories
  FROM pwg_categories c
    INNER JOIN pwg_user_cache_categories ucc ON id = cat_id AND user_id = 2
  WHERE id_uppercat is NULLAND (id IN (1,2,3,4,5,6,7))
  ORDER BY rank
;

0000001 my_error C:\Users\Claude\Documents\web\cl.josse.club.fr\piwigo\include\dblayer\functions_mysql.inc.php(90)
0000002 pwg_query C:\Users\Claude\Documents\web\cl.josse.club.fr\piwigo\include\category_cats.inc.php(70)
0000003 include C:\Users\Claude\Documents\web\cl.josse.club.fr\piwigo\index.php(277)
TagsNo tags attached.
browserany
Database engine and version
PHP version
Web serverApache 1.3.x
Attached Files

- Relationships

-  Notes
(0004799)
svn (reporter)
2011.02.08 14:34

[Subversion] r9116 by plg on trunk

-----[Subversion commit log]----------------------------------------------------
bug 2184 fixed: avoid SQL syntax error on "display only recently posted photos" filter.

- Issue History
Date Modified Username Field Change
2011.02.08 14:33 plg New Issue
2011.02.08 14:33 plg Status new => assigned
2011.02.08 14:33 plg Assigned To => plg
2011.02.08 14:33 plg browser => any
2011.02.08 14:33 plg Web server => Apache 1.3.x
2011.02.08 14:34 svn Checkin
2011.02.08 14:34 svn Note Added: 0004799
2011.02.08 14:34 plg Status assigned => closed
2011.02.08 14:34 plg Resolution open => fixed
2011.02.08 14:34 plg Fixed in Version => 2.2.0RC2
2011.02.08 15:24 plg Summary SQL blocking error on recentlty posted photos filter => SQL blocking error on recently posted photos filter


Copyright © 2000 - 2015 MantisBT Team
Contact
Powered by Mantis Bugtracker