I just installed community answers into joomla 3.

Before I installed it I imported all "jos_answers_" tables from a joomla 1.5 site. The prefix was changed on these tables to match with the new database prefix. Components installs successfully and I can see all data in the admin panel.

When I create a "Community Answers Question Layout" menu item and navigate to the page. I get the following error:


Error: 1054 - Unknown column 'a.modified_by' in 'on clause' SQL=select a.id, a.title, a.alias, a.description, a.created, a.accepted_answer, a.featured, a.answers, a.hits, a.published, a.modified, a.ip_address, b.bounty_points as bounty, b.expiry_date as expiry, b.state as bounty_state, c.id as catid, c.title as category_title, c.alias as category_alias, u1.id as created_by, u1.username as created_by_alias, u2.id as modified_by, u2.name as modified_by_name, u2.username as modified_by_username, case when a.created_by > 0 then u1.email else a.email end as email, case when a.created_by > 0 then u1.name else a.user_name end as username from pk9jt_answers_questions as a left join pk9jt_answers_categories as c on a.catid = c.id left join pk9jt_answers_bounties as b on b.question_id = a.id left join pk9jt_users as u1 on a.created_by = u1.id left join pk9jt_users as u2 on a.modified_by = u2.id where (a.catid = 2 ) and (a.published = 1 ) and ((c.permission_view is null or find_in_set('1', c.permission_view) > 0 ) or ( c.permission_view is null or find_in_set('9', c.permission_view) > 0)) order by a.created desc LIMIT 0, 20

Here's the link if that helps:
http://www.globalsecurityexperts.com/dev/ask-the-security-sensei.html

Thanks!