“1054 – Unknown column ‘p.category’…” error
"1054 - Unknown column 'p.category'..." error
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
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.