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

Bugs item #1767866, was opened at 2007-08-05 09:50
Message generated for change (Settings changed) made by garvinhicking
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: Closed
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: Garvin Hicking (garvinhicking)
Date: 2007-08-06 08:17

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

Hi!

Can you tell me how your entry looks that you save, which gives you that
error? In some rare cases, where you use the same link multiple times, the
error still happens with 1.2. It is differently fixed in the new 1.3 s9y
branch, but we can't backport that patch easily to 1.2...because this error
only occurs in very rare conditions now, where you use an empty <a>-Tag,
for example.

Regards,
Garvin

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

Comment By: Gabor Janak (white2001)
Date: 2007-08-05 13: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 10: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

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php