[wp-hackers] post2cat bug, WP2.2

[Boris Anthony]

Thanks Brian, I rectified it in the DB but by all means if you have  
that 1 liner in case I need it... ;)

little extra info on this occurence came in after I sent this off:  
the editor and the author apparently at some point were working on  
the post in question at the same time. Details of draft mode/ 
publication time are unavailable though (one's in NYC the other in  
jees not even sure The Hague or somesuch?)

:)

B.



On 8-Jun-07, at 11:51 AM, Brian Layman wrote:

> Would you like a query to clean that up or have you got that  licked
> already?  Assuming you are on MySQL 4.1+ I can give you a 1 liner that
> will remove the extras.
>
> BTW I would definitely say log it in Trac so that it at least is
> recorded and it can be repaired later.
>
> ______________________________________________
> Brian Layman
> b5media Inc.
> www.b5Media.com / www.TheCodeCave.com
> Skype: BrianLayman
> Cell: (330) 858-3446
> Fax: (416) 849-0347
> TF: 866-652-7189
>
>
> -----Original Message-----
> From: wp-hackers-bounces at lists.automattic.com
> [mailto:wp-hackers-bounces at lists.automattic.com] On Behalf Of Boris
> Anthony
> Sent: Friday, June 08, 2007 10:36 AM
> To: wp-hackers at lists.automattic.com
> Subject: [wp-hackers] post2cat bug, WP2.2
>
>
> Hi gang,
>
> Mysterious thing started happening yesterday afternoon on our site,
> globalvoicesonline.org: a post appeared twice in some but not all of
> the category archives of categories it was assignd to.
>
> pokign my head into the database revealed that 9 of the 11 categories
> the post was associated to, were associated twice!
>
> e.g.:
> post2cat:
> rel_id	post_id	category_id
> 145262  	26542  	300
> 145256 	26542 	300
> 145259 	26542 	287
> 145253 	26542 	287
> 145261 	26542 	282
> 145255 	26542 	282
> 145260 	26542 	271
> 145254 	26542 	271
> 145258 	26542 	259
> 145252 	26542 	259
> 145257 	26542 	256
> 145251 	26542 	256
> 145248 	26542 	247
> 145247 	26542 	247
> 145250 	26542 	227
> 145249 	26542 	227
> 144951 	26542 	221
> 144953 	26542 	21
> 144952 	26542 	14
> (yeah we're at almost 30,000 posts, 350 categories and almost 150k
> post2cat associations... ouch)
>
> I'm thinking there's something funky happening at posting time? Or on
> auto-save?
>
> [May this be related to some strange behavior some of our authors
> have been experiencing where a draft is no longer editable by them...
> yet to replicate that one myself but it's happened 3 times since we
> upped to 2.2 2 weeks ago. As well as disappearing comments... but I
> digress. :\ ]
>
> Is there somewhere else I need to mention this? Bug tracker? :D
>
> thnx!
>
> B.
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers