"1054 - Unknown column 'p.category'..." error

nadav
nadav
  • nadav
  • 10 months ago
Hi,

I have 'Community Polls - Random Poll' module enabled on my home page (edoula.me).

It was working fine, but once I've set 'Custom Poll Ids' I get an error message on my site:
1054 - Unknown column 'p.category' in 'where clause' SQL=select p.id from xjfs9_jcp_polls p left join xjfs9_categories c on p.catid = c.id where (p.category in (30) ) and ( p.published = 1 ) and ( p.close_date = '0000-00-00 00:00:00' or p.close_date > now() ) and ( c.`language` in ('en-GB','*') ) and ( p.private = 0) order by rand() LIMIT 0, 1

Error and module settings available in the attached screenshot.

Please advice how to fix this.
Thanks

Access to viewing replies is restricted.
Showing 1 of 1 replies
You do not have permissions for replying to this topic.
Loading...
Confirm delete? This action is irreversible and the data will be deleted permanently. Do you want to continue? Confirm Add New Delete Unpublish Cancel Import Uninstall The selected item successfully deleted.
Shondalai