I am updating a site that I did not originally develop. When trying to trouble shoot why the Community Answers categories are not working, I found that new categories are being saved to xxx_categories instead of xxx_answers_categories. The first thing I found was that adding a new category resulted in the status always being 'Trashed', and would not allow me to publish it. I was also getting the following error:  Unknown column 'a.state' in 'field list'

Existing categories are not showing up at all in the Categories dashboard. 

When taking a look at the database, I found that the new category was added to  the xxx_categories table. Existing categories are in the xxx_answers_categories table (which the dashboard is not pulling from.

I located one of the files that has the wrong table, but I'm not sure if there are others. 

pkg_communityanswers_v5.0.2/packages/com_communityanswers/admin/models/fields/cjcategoryedit.php

Can you tell me what I should do to correct this?

I am running the following versions:

  • Joomla: 3.9.3
  • JomSocial: 4.5.1
  • Community Answers: 5.0.2

 

Thanks for your assistance.

Like it on Facebook, Tweet it or share this topic on other bookmarking websites.
You do not have permissions to reply to this topic.

Powered by CjForum

Site Search

Trending Topics

kml file not working in demo site
  • 3 replies
Hi,I uploaded one kml file to your demo site...

Change date format and where are the charts?
  • 1 reply
Hi,how do I change the date format from yyyy-mm-dd to dd-mm-yyyy? I...

User name displayed twice ?
  • 1 reply
Hi,I noticed that the used name is displayed twice:Once on the...

how put a banner in community answere?
  • 1 reply
how put a banner in community answere?  

Edit the content of Email Notification
  • 1 reply
where to edit the content of Email Notification? Thanks.

Subscribe Newsletter