Piwigo Bugtracker

Viewing Issue Advanced Details Jump to Notes ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0002184 [Piwigo] navigation block have not tried 2011.02.08 14:33 2011.02.08 15:24
Reporter plg View Status public  
Assigned To plg
Priority normal Resolution fixed Platform
Status closed   OS
Projection none   OS Version
ETA none Fixed in Version 2.2.0RC2 Product Version 2.2.0RC1
  Target Version 2.2.0RC2 Product Build
Summary 0002184: SQL blocking error on recently posted photos filter
Description When 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)
Steps To Reproduce
Additional Information
Tags No tags attached.
browser any
Database engine and version
PHP version
Web server Apache 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


Mantis 1.1.6[^]
Copyright © 2000 - 2008 Mantis Group
Contact
Powered by Mantis Bugtracker