On Aug 10, 2006, at 3:40 AM, Scott L. wrote:
Hey Scott, after upgrading and migrating the db through the admin-ui
this is seen in my main content body:
Mysql::Error: Unknown column ‘contents.comments_count’ in ‘field
list’: SELECT contents.id AS t0_r0, contents.title AS t0_r1,
contents.author AS t0_r2, contents.body AS t0_r3,
contents.body_html AS t0_r4, contents.extended AS t0_r5,
contents.excerpt AS t0_r6, contents.keywords AS t0_r7,
contents.created_at AS t0_r8, contents.updated_at AS t0_r9,
contents.extended_html AS t0_r10, contents.user_id AS t0_r11,
contents.permalink AS t0_r12, contents.guid AS t0_r13,
contents.text_filter_id AS t0_r14, contents.whiteboard AS t0_r15,
contents.comments_count AS t0_r16, contents.trackbacks_count AS
t0_r17, contents.type AS t0_r18, contents.article_id AS t0_r19,
contents.email AS t0_r20, contents.url AS t0_r21, contents.ip
AS t0_r22, contents.blog_name AS t0_r23, contents.name AS t0_r24,
contents.published AS t0_r25, contents.allow_pings AS t0_r26,
contents.allow_comments AS t0_r27, contents.blog_id AS t0_r28,
contents.published_at AS t0_r29, contents.state AS t0_r30,
categories.id AS t1_r0, categories.name AS t1_r1,
categories.position AS t1_r2, categories.permalink AS t1_r3,
tags.id AS t2_r0, tags.name AS t2_r1, tags.created_at AS t2_r2,
tags.updated_at AS t2_r3, tags.display_name AS t2_r4, users.id
AS t3_r0, users.login AS t3_r1, users.password AS t3_r2,
users.email AS t3_r3, users.name AS t3_r4,
users.notify_via_email AS t3_r5, users.notify_on_new_articles AS
t3_r6, users.notify_on_comments AS t3_r7,
users.notify_watch_my_articles AS t3_r8, users.notify_via_jabber
AS t3_r9, users.jabber AS t3_r10, blogs.id AS t4_r0,
blogs.settings AS t4_r1 FROM contents LEFT OUTER JOIN
articles_categories ON articles_categories.article_id = contents.id
LEFT OUTER JOIN categories ON categories.id =
articles_categories.category_id LEFT OUTER JOIN articles_tags ON
articles_tags.article_id = contents.id LEFT OUTER JOIN tags ON
tags.id = articles_tags.tag_id LEFT OUTER JOIN users ON users.id =
contents.user_id LEFT OUTER JOIN blogs ON blogs.id = contents.blog_id
WHERE (published = 1 AND contents.published_at < ‘2006-08-10
07:32:55’ AND blog_id = 1) AND ( (contents.type = ‘Article’ ) ) AND
contents.id IN (‘364’, ‘363’, ‘357’, ‘354’, ‘342’, ‘296’, ‘272’)
ORDER BY contents.published_at DESC