Piwigo Bugtracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001717Piwigootherpublic2010.06.03 17:062010.06.04 21:39
ReporterVDigital 
Assigned Tonikrou 
PrioritynormalSeveritycrashReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformAnyOSAnyOS VersionAny
Product Version2.1.1 
Target VersionFixed in Version2.1.2 
Summary0001717: SQLite: access failure on Admin > Tools > History
DescriptionWhite 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
TagsNo tags attached.
browserany
Database engine and versionsqlite: 3.6.15
PHP version5.3.0
Web serverApache 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


Copyright © 2000 - 2015 MantisBT Team
Contact
Powered by Mantis Bugtracker