[ 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 (Tracker Item Submitted) made by Item Submitter
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: None
Priority: 5
Private: No
Submitted By: Gabor Janak (white2001)
Assigned to: Nobody/Anonymous (nobody)
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 :)

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

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/