[ php-blog-Bugs-1758416 ] guestbook Plugin: sqlite incompatibily

Bugs item #1758416, was opened at 2007-07-22 11:24
Message generated for change (Comment added) made by garvinhicking
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=1758416&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: Plugins
Group: None
Status: Open
>Resolution: Accepted
>Priority: 6
Private: No
Submitted By: Gabor Janak (white2001)
>Assigned to: Garvin Hicking (garvinhicking)
Summary: guestbook Plugin: sqlite incompatibily

Initial Comment:

version: 2.8

If installed, the plugin executes teh Query:
CREATE TABLE IF NOT EXISTS.

I'm trie to use the sqlite Backend.
It seems this dont support IF NOT EXISTS.

i removed it.. get only a warning during install, that table exists (seems install function is called twice).

And no sql errors about missing Tables anymore.


It seems there are many sqlite incompatiblities in the Whole Software...


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

>Comment By: Garvin Hicking (garvinhicking)
Date: 2007-07-22 14:08

Message:
Logged In: YES 
user_id=473563
Originator: NO

Hi!

Generally we try to have SQLite compatibility as well as possible. The
serendipity core package honours SQLite, but plugin developers are often
not used to compatibilityissues. So plugins like the guestbook plugin, that
are not coded by core developers, can have outages like this. "Whole
software" so is a very broad term that I wouldn't like to see applied in
this case ;)

SQLite is only used by about 5% of our users,so we need feedback like
yours to get the attention that something is wrong. I'll commit a fix for
your report tomorrow! :)

Best regards,
Garvin

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

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

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/