sorted by: recent | see : popular

Content Tagged with LiveMarks + bug

I noticed an annoying bug in LiveMarks that I had been ignoring, there’s an issue with the RSS unique item identifier where it gets confused on long URLs.

The MySQL database setup stores urls as 255 varchars, the max size for a varchar. Unfortunately, there is no such limit of 255 characters for URLs. When the importer is looking if a link already exists, it’s looking for a link that’s chopped off by MySQL (when MySQL attempts to put in a long string where only 255 chars are allocated, it just silently chops the string).

I did think ahead for this, as you can see in the code I also generate a hash that I should be doing my unique comparisons by, but I guess somewhere I forgot to use it…

I’ll look into fixing it, plz stay tuned.