Piwigo Bugtracker

Viewing Issue Advanced Details Jump to Notes ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0001717 [Piwigo] other crash have not tried 2010.06.03 17:06 2010.06.04 21:39
Reporter VDigital View Status public  
Assigned To nikrou
Priority normal Resolution fixed Platform Any
Status closed   OS Any
Projection none   OS Version Any
ETA none Fixed in Version 2.1.2 Product Version 2.1.1
  Target Version Product Build
Summary 0001717: SQLite: access failure on Admin > Tools > History
Description 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
Steps To Reproduce
Additional Information
Tags No tags attached.
browser any
Database engine and version sqlite: 3.6.15
PHP version 5.3.0
Web server Apache 2.2.11
Attached Files

- Relationships

-  Notes
(0003956)
svn (reporter)
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 (reporter)
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.

- Issue History
Date Modified Username Field Change
2010.06.03 17:06 VDigital New Issue
2010.06.03 17:06 VDigital browser => any
2010.06.03 17:06 VDigital MySQL version => sqlite: 3.6.15
2010.06.03 17:06 VDigital PHP version => 5.3.0
2010.06.03 17:06 VDigital Web server => Apache 2.2.11
2010.06.04 21:34 nikrou Status new => assigned
2010.06.04 21:34 nikrou Assigned To => nikrou
2010.06.04 21:36 svn Checkin
2010.06.04 21:36 svn Note Added: 0003956
2010.06.04 21:39 svn Checkin
2010.06.04 21:39 svn Note Added: 0003957
2010.06.04 21:39 nikrou Status assigned => closed
2010.06.04 21:39 nikrou Resolution open => fixed
2010.06.04 21:39 nikrou Fixed in Version => 2.1.2


Mantis 1.1.6[^]
Copyright © 2000 - 2008 Mantis Group
Contact
Powered by Mantis Bugtracker