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

Bugs item #1604918, was opened at 2006-11-28 23:47
Message generated for change (Settings changed) 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: Closed
>Resolution: Fixed
>Priority: 1
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

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/