[ php-blog-Bugs-1579600 ] sqlite query error

Bugs item #1579600, was opened at 2006-10-18 11:54
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=1579600&group_id=75065

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Vladimir Georgiev (vladog)
Assigned to: Nobody/Anonymous (nobody)
Summary: sqlite query error

Initial Comment:
Hello,

I have the following error appearing when I go to 
Administration -> Backup Interface:

"Warning: sqlite_query(): near "SHOW": syntax error in 
_some_path_\...\include\db\sqlite.inc.php on line 226"

I am using SQLITE as a DB.

I assume the error is raised because the Backup Event 
plugin uses the "SHOW TABLES", which is not supported 
by SQLITE. Instead, something like:
"SELECT name FROM sqlite_master WHERE type = 'table'" 
should be used for the SQLITE case...

Is there a chance this is fixed soon?

Thanks in advance

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=1579600&group_id=75065

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642