MantisBT - Piwigo
View Issue Details
0001744Piwigodatabasepublic2010.06.25 21:372010.06.25 21:45
nikrou 
nikrou 
normalminoralways
closedfixed 
2.1.1 
2.1.22.1.2 
any
SQLite
Apache 1.3.x
0001744: Incorrect use of timezone with SQLite
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.
No tags attached.
Issue History
2010.06.25 21:37nikrouNew Issue
2010.06.25 21:37nikrouStatusnew => assigned
2010.06.25 21:37nikrouAssigned To => nikrou
2010.06.25 21:37nikroubrowser => any
2010.06.25 21:37nikrouDatabase engine and version => SQLite
2010.06.25 21:37nikrouWeb server => Apache 1.3.x
2010.06.25 21:43svnCheckin
2010.06.25 21:43svnNote Added: 0004006
2010.06.25 21:45svnCheckin
2010.06.25 21:45svnNote Added: 0004007
2010.06.25 21:45nikrouStatusassigned => closed
2010.06.25 21:45nikrouResolutionopen => fixed
2010.06.25 21:45nikrouFixed in Version => 2.1.2

Notes
(0004006)
svn   
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   
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