1064 You have an error in your SQL syntax
By Wayne Booth on Tuesday, 26 April 2016
Posted in General
Likes 0
Views 769
Votes 0
Hi guys

i can't access the backend of easy discuss after the update

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 SQL=select count(1) from `#__discuss_thread` as a where a.`published` = '1' and a.`cluster_id` = '0' and a.`category_id` in ()

please advise

thanks
wayne
Hi Wayne,

In EasyDiscuss 4.0, we no longer use mod_ask module as this module and the module name is already deprecated. This module was replaced by mod_easydiscuss_ask module

This mod_easydiscus_ask (EasyDiscuss Ask Module) should be installed by default when you installing EasyDiscuss 4.0.2. I have temporarily disabled mod_ask module from your site and your site should be accessible now.
Ezrul Fazwan
·
Wednesday, 27 April 2016 17:26
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Wayne,

I am really sorry for the delay of this reply. Seems like the issue was caused by some of your categories does not allow super user group to view the discussion from that category. I've applied the fix on your site and it should be working correctly now.

The fix will be added in the next release of EasyDiscuss.
Ezrul Fazwan
·
Wednesday, 27 April 2016 13:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Ezrul,

I am now able to access the components from the admin side but i still can't access via front end.


Warning: require_once(/home/allseasstaff/public_html/components/com_easydiscuss/helpers/helper.php): failed to open stream: No such file or directory in /home/allseasstaff/public_html/modules/mod_ask/mod_ask.php on line 16

Fatal error: require_once(): Failed opening required '/home/allseasstaff/public_html/components/com_easydiscuss/helpers/helper.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/allseasstaff/public_html/modules/mod_ask/mod_ask.php on line 16

Thanks
wayne
Wayne Booth
·
Wednesday, 27 April 2016 17:11
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks Ezrul!!
Wayne Booth
·
Wednesday, 27 April 2016 17:32
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Wayne. Glad to hear that your issue has been resolved now.
Ezrul Fazwan
·
Wednesday, 27 April 2016 17:37
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post