0001717: SQLite: access failure on Admin > Tools > History - Mantis

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

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