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

Bugs item #1579600, was opened at 2006-10-18 11:54
Message generated for change (Comment added) made by garvinhicking
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: Pending
>Resolution: Accepted
>Priority: 2
Submitted By: Vladimir Georgiev (vladog)
>Assigned to: Garvin Hicking (garvinhicking)
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

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

>Comment By: Garvin Hicking (garvinhicking)
Date: 2006-10-19 08:37

Message:
Logged In: YES 
user_id=473563

Hi!

Sadly this plugin was developed with only MySQL in mind.

Since I don't use SQLite and don't know how it supports
things, maybe you can edit your serendipity_event_backup.php
file and replace that SQL query with the one you suggest? If
that works I could patch the official plugin!

Until then, I've at least added a note into the plugin that
says "MySQL(i)" only.

However, when you use SQLite, you can make a backup easier
by just zipping up your directory via FTP, then the database
will go with it.

Best regards,
Garvin

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

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