Tag Filter - (Habtm)

Mar 10, 2008
01:03

HABTM error 512 duplicate sql in CakePHP 1.2

While trying to submit a $hasAndBelongsToMany (HABTM) related form under cakephp (1.2 rev 6311) I was getting the following SQL Error :-

Warning (512): SQL Error: 1062: Duplicate entry '4-1' for key 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 440]

Filed under: Cakephp Tags: Habtm

(default) 3 queries took 5 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT Post.* FROM posts Post, posts_tags pt, tags t WHERE t.tag = ('Habtm') AND t.id = pt.tag_id AND pt.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC	1	1	3
2	SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category	15	15	1
3	SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag	49	49	1

(default) 3 queries took 5 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT Post.* FROM posts Post, posts_tags pt, tags t WHERE t.tag = ('Habtm') AND t.id = pt.tag_id AND pt.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC

SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category

SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag

Tag Filter - (Habtm)

HABTM error 512 duplicate sql in CakePHP 1.2

Categories

Tags

Site Sections

Blog Categories

Latest

Popular