Piwigo Bugtracker

Viewing Issue Advanced Details Jump to Notes ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000278 [Piwigo] albums minor always 2006.01.29 12:56 2006.02.23 22:37
Reporter VDigital View Status public  
Assigned To plg
Priority normal Resolution fixed Platform Any
Status closed   OS Any
Projection none   OS Version Any
ETA none Fixed in Version 1.5.3 Product Version 1.5.2
  Target Version Product Build
Summary 0000278: Calendar failure with $conf['calendar_datefield'] = 'date_available';
Description date_available is datetime
date_creation is date
So, in include/category_calendar.inc.php
ligne 340 is in error.

AND '.$conf['calendar_datefield'].' = \''.$calendar_day.'\'
Replace by:
AND DATE('.$conf['calendar_datefield'].') = \''.$calendar_day.'\'
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
(0000656)
rvelices (developer)
2006.02.23 06:49

I had the same error during the calendar redesign and it's corrected now
(0000657)
plg (manager)
2006.02.23 22:37

Extract from MySQL documentation [1] : "DATE() is available as of MySQL 4.1.1."

Instead, we should use DATE_FORMAT(date_available, '%Y-%m-%d') when compared with $calendar_day and DATE_FORMAT(date_available, '%Y-%c-%e') when compared to $page['calendar_date']. Search also needs to be updated. That's what I did in [Subversion] r1054

I make this correction on branch 1.5. As said by rvelices, I suppose it has been corrected on BSF with calendar rewrite. This issue goes directly to "closed" status.

[1] http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html [^]

- Issue History
Date Modified Username Field Change
2006.01.29 12:56 VDigital New Issue
2006.01.29 12:56 VDigital browser => any
2006.01.29 12:56 VDigital Web server => Apache 1.3.x
2006.02.23 06:46 rvelices Status new => assigned
2006.02.23 06:46 rvelices Assigned To => rvelices
2006.02.23 06:49 rvelices Note Added: 0000656
2006.02.23 06:49 rvelices Status assigned => closed
2006.02.23 06:49 rvelices Resolution open => fixed
2006.02.23 06:49 rvelices Fixed in Version => BSF branch (dev)
2006.02.23 22:37 plg Note Added: 0000657
2006.02.23 22:37 plg Assigned To rvelices => plg
2006.02.23 22:37 plg Fixed in Version BSF branch (dev) => 1.5.3


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