[pLog-svn] addcomment sql error

[Jon Daley]

 	I should have said: the 266 and 9 are valid article and 
category ids, and that particular article has gotten a lot of spam 
recently (bayesian filter, yay), so it is likely that it was a spammer who 
tried to make that comment, and maybe made multiple comments close 
together chronologically, though I am not sure what the article_category 
field would be updated when a comment is made.


On Sat, 15 Jul 2006, Jon Daley wrote:

> Anyone figure this out quicker than I can get to it?
>
> /home/jondaley/www/plog/class/logger/logger/logger.class.php(157): 
> patternlayout.format
> /home/jondaley/www/plog/class/logger/logger/logger.class.php(137): logger.log
> /home/jondaley/www/plog/class/dao/model.class.php(149): logger.error
> /home/jondaley/www/plog/class/dao/articles.class.php(665): articles.execute
> /home/jondaley/www/plog/class/dao/articles.class.php(725): 
> articles.addpostcategorieslink
> /home/jondaley/www/plog/class/dao/articles.class.php(959): 
> articles.updatepostcategorieslink
> /home/jondaley/www/plog/class/dao/commentscommon.class.php(84): 
> articles.updatearticle
> /home/jondaley/www/plog/class/security/bayesianfilter.class.php(123): 
> articlecomments.addcomment
> /home/jondaley/www/plog/class/security/pipeline.class.php(171): 
> bayesianfilter.filter
> /home/jondaley/www/plog/class/action/blogaction.class.php(79): 
> pipeline.process
> /home/jondaley/www/plog/class/action/addcommentaction.class.php(44): 
> addcommentaction.blogaction
> /home/jondaley/www/plog/class/controller/controller.class.php(304): 
> addcommentaction.addcommentacti
> on
> /home/jondaley/www/plog/index.php(50): blogcontroller.process
>
> 09-07-2006 08:51:51 ERROR - The following query =
> INSERT INTO plog_article_categories_link (article_id,category_id) VALUES 
> (266,9);generated the foll
> owing error message =
> Duplicate entry '266-9' for key 1
> ~
> ~
> ~
>
>
> -- 
> Jon Daley
> http://jon.limedaley.com/
>
> The problem with the gene pool is that there is no lifeguard.
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn
>

-- 
Jon Daley
http://jon.limedaley.com/

German is a great language, because no matter what word you say,
it always sounds like millions of people are going to die.
-- Vagel Keller