[ php-blog-Bugs-1494653 ] Database error in serendipity_exits

Bugs item #1494653, was opened at 2006-05-24 23:27
Message generated for change (Comment added) made by garvinhicking
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=1494653&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: 8
Submitted By: Nobody/Anonymous (nobody)
>Assigned to: Garvin Hicking (garvinhicking)
Summary: Database error in serendipity_exits

Initial Comment:
The serendipity_exits table contains a primary key 
(entry_id, day, host). This leads to the problem that 
whenever an entry contains two links with the same 
host but different paths, only the first one clicked 
at a day will work. The other will yield a constraint 
violation of the serendipity_exit_pkey-constraint, 
effectivly preventing the redirection to the link 
target.
The reason is that the two links are distinct for the 
software but not for the database. S9Y tries to write 
the statistics for the second link into the database 
using exactly the same primary key as for the first 
one which will obviously fail.
Proposed fix is to add the path-column to the primary 
key. This can be done in the running system by doing 
a
ALTER TABLE serendipity_exits DROP 
CONSTRAINT "serendipity_exits_pkey";
ALTER TABLE serendipity_exits ADD PRIMARY KEY 
(entry_id,day,host,path);
The fix is tested and works on my system.

For further questions contact me at 
[email protected]

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

>Comment By: Garvin Hicking (garvinhicking)
Date: 2006-05-25 11:41

Message:
Logged In: YES 
user_id=473563

Thanks a lot for finding the cause of this. I will fix it as
soon as I get SVN access back, later this weekend, for the
SVN trunk.

Best regards,
Garvin

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

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


-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642