MantisBT - Piwigo
View Issue Details
0001717Piwigootherpublic2010.06.03 17:062010.06.04 21:39
VDigital 
nikrou 
normalcrashhave not tried
closedfixed 
AnyAnyAny
2.1.1 
2.1.2 
any
sqlite: 3.6.15
5.3.0
Apache 2.2.11
0001717: SQLite: access failure on Admin > Tools > History
White screen with

Warning: SQLite3::query() [sqlite3.query]: Unable to prepare statement: 1, near "ASC": syntax error in C:\wamp\www\pwglite\include\dblayer\functions_sqlite.inc.php on line 129
SELECT date, HOUR(time) AS hour, MAX(id) AS max_id, COUNT(*) AS nb_pages FROM piwigo_history WHERE summarized = 'false' GROUP BY date ASC, HOUR(time) ASC ;
near "ASC": syntax error
No tags attached.
Issue History
2010.06.03 17:06VDigitalNew Issue
2010.06.03 17:06VDigitalbrowser => any
2010.06.03 17:06VDigitalMySQL version => sqlite: 3.6.15
2010.06.03 17:06VDigitalPHP version => 5.3.0
2010.06.03 17:06VDigitalWeb server => Apache 2.2.11
2010.06.04 21:34nikrouStatusnew => assigned
2010.06.04 21:34nikrouAssigned To => nikrou
2010.06.04 21:36svnCheckin
2010.06.04 21:36svnNote Added: 0003956
2010.06.04 21:39svnCheckin
2010.06.04 21:39svnNote Added: 0003957
2010.06.04 21:39nikrouStatusassigned => closed
2010.06.04 21:39nikrouResolutionopen => fixed
2010.06.04 21:39nikrouFixed in Version => 2.1.2

Notes
(0003956)
svn   
2010.06.04 21:36   
[Subversion] r6463 by nikrou on trunk

-----[Subversion commit log]----------------------------------------------------
Fix bug 1717 : SQLite: access failure on Admin > Tools > History
hour function doesn't exists
(0003957)
svn   
2010.06.04 21:39   
[Subversion] r6464 by nikrou on branch 2.1

-----[Subversion commit log]----------------------------------------------------
Bug 1717 fixed : SQLite: access failure on Admin > Tools > History
hour function doesn't exists
Merge from trunk.