1064 - SQL syntax error, v4.0.1
By n00bster on Monday, 25 April 2016
Posted in Technical Issues
Replies 9
Likes 0
Views 387
Votes 0
i have installed the stable version of ED (4.0.1). after the installation process was finished i got this error when i click in the backend on the joomla extension menu link from ED:
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 ()
Yes it is. We will release the new version soon to address some of the issues that was reported earlier.
Ezrul Fazwan
·
Wednesday, 27 April 2016 18:39
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Noobster,

I just tried to access your easydiscuss backend but it seems like everything is loaded correctly from my end. May I know on which page you are hitting this error?
Ezrul Fazwan
·
Monday, 25 April 2016 21:07
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Ezrul!

i have updated the site details in the first post, please look again.
(this problem happens on a second development site too)
n00bster
·
Monday, 25 April 2016 22:24
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi n00bster,

Regarding your issue, I've logged into your dev site again your EasyDicuss backend and I did not hit the above issue. Is your issue already resolved?

Please advise.
Sam
·
Tuesday, 26 April 2016 16:49
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi,
the problem is not solved jet. take a look on the screenshot. I get this error on my working pc and on mobile phone.
n00bster
·
Tuesday, 26 April 2016 17:53
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

Em strange, I can access your EasyDiscuss both frontend and backend without any error. Please see:

http://screencast.com/t/Ng66yQ34t
http://screencast.com/t/9j7L5iz4syC

Can you pass me the user login that you used to access your site? I suspect this issue happen to only certain user?

Please advise.
Sam
·
Tuesday, 26 April 2016 19:34
·
0 Likes
·
0 Votes
·
0 Comments
·
Sam wrote:
Can you pass me the user login that you used to access your site? I suspect this issue happen to only certain user?.


i have added in the first post the login details for the super user account what i'm using.
please have a look again.
n00bster
·
Tuesday, 26 April 2016 20:22
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Noobster,

I've applied the fix inside the following files and it should be working correctly now:
1) /administrator/components/com_easydiscuss/models/category.php
2) /administrator/components/com_easydiscuss/models/categories.php
3) /administrator/components/com_easydiscuss/includes/category/category.php

Please have a look.
Ezrul Fazwan
·
Wednesday, 27 April 2016 17:03
·
0 Likes
·
0 Votes
·
0 Comments
·
is this fix in the next version?
n00bster
·
Wednesday, 27 April 2016 18:35
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post