Piwigo bug tracker has moved to Github
This bugtracker is kept to provide history on old issues.
| Anonymous | Login | Signup for a new account | 2019.08.20 08:27 CEST | |
| My View | View Issues | Change Log | Roadmap |
| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||
| 0000278 | Piwigo | albums | public | 2006.01.29 12:56 | 2006.02.23 22:37 | ||||
| Reporter | VDigital | ||||||||
| Assigned To | plg | ||||||||
| Priority | normal | Severity | minor | Reproducibility | always | ||||
| Status | closed | Resolution | fixed | ||||||
| Platform | Any | OS | Any | OS Version | Any | ||||
| Product Version | 1.5.2 | ||||||||
| Target Version | Fixed in Version | 1.5.3 | |||||||
| 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.'\' | ||||||||
| Tags | No tags attached. | ||||||||
| browser | any | ||||||||
| Database engine and version | |||||||||
| PHP version | |||||||||
| Web server | Apache 1.3.x | ||||||||
| Attached Files | |||||||||
 Relationships |
|
 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 [^] |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2019 MantisBT Team Contact |
 |