Piwigo Bugtracker

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
Powered by Mantis Bugtracker