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. 


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

Upload Track button not working
  • 9 replies
Hallo, I have a problem uploading new gps tracks. Clicking on the...

Latest questions
  • 1 reply
I am trying to recreate the very slim (just a header and topic...

  • 1 reply
I only have two questions per survey. Is it possible to place them...

  • 1 reply
Hi Maverick, IMPORTANT ISSUE : After installing v5.1.1, it's...

Import Wordpress posts
  • 1 reply
Is there a migrator to do this? I have a site with nearly 600 posts...

Subscribe Newsletter