0000278: Calendar failure with $conf['calendar_datefield'] = 'date_available'; - Mantis

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

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