 Relationships |
|
| Anonymous | Login | Signup for a new account | 2013.05.24 17:37 CEST |
| Main | My View | View Issues | Change Log | Roadmap | Docs |
| Viewing Issue Advanced Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||
| ID | Category | Severity | Reproducibility | Date Submitted | Last Update | ||
| 0001744 | [Piwigo] database | minor | always | 2010.06.25 21:37 | 2010.06.25 21:45 | ||
| Reporter | nikrou | View Status | public | ||||
| Assigned To | nikrou | ||||||
| Priority | normal | Resolution | fixed | Platform | |||
| Status | closed | OS | |||||
| Projection | none | OS Version | |||||
| ETA | none | Fixed in Version | 2.1.2 | Product Version | 2.1.1 | ||
| Target Version | 2.1.2 | Product Build | |||||
| Summary | 0001744: Incorrect use of timezone with SQLite | ||||||
| Description |
Anti-flood system doesn't work because date comparaison is incorrect. Someone can add a comment but he must wait at list many hours (depending on the timezone of the server). Fix the same kind of problem for introduction page. Use datetime('now', 'localtime') SQLite function instead of system time. |
||||||
| Steps To Reproduce | |||||||
| Additional Information | |||||||
| Tags | No tags attached. | ||||||
| browser | any | ||||||
| Database engine and version | SQLite | ||||||
| PHP version | |||||||
| Web server | Apache 1.3.x | ||||||
| Attached Files | |||||||
|
|
|||||||
|
Relationships |
|
|
Notes |
|
|
(0004006) svn (reporter) 2010.06.25 21:43 |
[Subversion] r6604 by nikrou on trunk -----[Subversion commit log]---------------------------------------------------- Bug 1744 fixed : Incorrect use of timezone with SQLite Fixed anti-flood system. Need refactoring between each interval functions |
|
(0004007) svn (reporter) 2010.06.25 21:45 |
[Subversion] r6605 by nikrou on branch 2.1 -----[Subversion commit log]---------------------------------------------------- Bug 1744 fixed : Incorrect use of timezone with SQLite Fixed anti-flood system. Merge from trunk |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010.06.25 21:37 | nikrou | New Issue | |
| 2010.06.25 21:37 | nikrou | Status | new => assigned |
| 2010.06.25 21:37 | nikrou | Assigned To | => nikrou |
| 2010.06.25 21:37 | nikrou | browser | => any |
| 2010.06.25 21:37 | nikrou | Database engine and version | => SQLite |
| 2010.06.25 21:37 | nikrou | Web server | => Apache 1.3.x |
| 2010.06.25 21:43 | svn | Checkin | |
| 2010.06.25 21:43 | svn | Note Added: 0004006 | |
| 2010.06.25 21:45 | svn | Checkin | |
| 2010.06.25 21:45 | svn | Note Added: 0004007 | |
| 2010.06.25 21:45 | nikrou | Status | assigned => closed |
| 2010.06.25 21:45 | nikrou | Resolution | open => fixed |
| 2010.06.25 21:45 | nikrou | Fixed in Version | => 2.1.2 |
| Mantis 1.1.6[^] Copyright © 2000 - 2008 Mantis Group Contact |  |
