[ php-blog-Bugs-1604918 ] Bug in serendipity_track_url()

Bugs item #1604918, was opened at 2006-11-28 23:47
Message generated for change (Comment added) made by garvinhicking
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=1604918&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: Frontend functions
Group: None
Status: Open
>Resolution: Accepted
>Priority: 3
Private: No
Submitted By: Andreas Scherbaum (scherbaum)
>Assigned to: Garvin Hicking (garvinhicking)
Summary: Bug in serendipity_track_url()

Initial Comment:
Just tracked done a bug in the serendipity_track_url() function:

In this function, a table entry is updated which the following conditions: scheme, host, port, path, query, day, entry_id. If affected_rows() is 0, then a new entry is inserted into the statistic table. This table has an unique constraint about three of the seven columns: host, day and entry_id.

So if i have 2 URLs in a blog entry, which have the same host but different pathnames, i get a SQL error about unique key violation, because it won't match the first update but will match the unique constraint.

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

>Comment By: Garvin Hicking (garvinhicking)
Date: 2006-11-29 13:18

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

Thanks a lot. Sadly this requires a DB update, but we will fix this bug
for the 1.2 release tree.

Best regards,
Garvin

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

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

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV