[ php-blog-Bugs-1767866 ] weired sqlite Error Message on Entry-Edit

Bugs item #1767866, was opened at 2007-08-05 11:50
Message generated for change (Comment added) made by white2001
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=1767866&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: Administrative functions
Group: None
>Status: Open
Resolution: Out of Date
Priority: 1
Private: No
Submitted By: Gabor Janak (white2001)
Assigned to: Garvin Hicking (garvinhicking)
Summary: weired sqlite Error Message on Entry-Edit

Initial Comment:
Sometimes, on edit a Article i get sqlite errors
on each Link.
Only for Links present in the version before.

I think its again a small sqlite weired behavior.

I don't known exactly, but it can be that this is a Sitemap-generator-plugin specific Bug.

But i could remember to get it too without this Plugin.

Reproduce:
Create a entry with some links... having TrackbackDetection enabled.

Edit the Entry, and save again...
The links are checked again.. and the error occurs

The Message on Save:

Sitemap Update an www.google.com gemeldet.
Sitemap Update an submissions.ask.com gemeldet.

Warning: sqlite_query() [function.sqlite-query]: PRIMARY KEY must be unique in /MYPATH/s9y/include/db/sqlite.inc.php on line 229
bool(false) string(186) "INSERT INTO serendipity_references (id,name,link,entry_id) values ('17', ' LinkTitel', 'http://ob81.com/2007/07/28/6-things-you-must-do-before-you-die-geek-edition/', '7')"


perhaps only a @ is missing :)

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

>Comment By: Gabor Janak (white2001)
Date: 2007-08-05 15:30

Message:
Logged In: YES 
user_id=205502
Originator: YES

Oh soory...

i'm using Serendipity 1.2-beta4.
I thought this is new current one.


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

Comment By: Garvin Hicking (garvinhicking)
Date: 2007-08-05 12:08

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

Hi!

You sadly didn't specifiy your s9y version. I believe you're using 1.1.x?
This bug above should be fixed in the 1.2 versions.:)

Could you try that version? The current beta release is already quite
stable and will become final this month.

Best regards,
Garvin

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=1767866&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/