Piwigo Bugtracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000278Piwigoalbumspublic2006.01.29 12:562006.02.23 22:37
ReporterVDigital 
Assigned Toplg 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformAnyOSAnyOS VersionAny
Product Version1.5.2 
Target VersionFixed in Version1.5.3 
Summary0000278: Calendar failure with $conf['calendar_datefield'] = 'date_available';
Descriptiondate_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.'\'
TagsNo tags attached.
browserany
Database engine and version
PHP version
Web serverApache 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


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