By Sylvain ROGER on Monday, 28 January 2019
Posted in Technical Issues
Replies 6
Likes 0
Views 581
Votes 0
Hello team,

In the backend,
administrator/index.php?option=com_easydiscuss&view=posts&layout=questions

Step to reproduce:change the pagination to ALL and delete 2 questions gives:
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 'all' at line 1

Not a big deal, but just to report
Hey there,

Thanks for your input.

It seems that I am able to replicate it on my local site.

I will log this into our issue tracker.
·
Tuesday, 29 January 2019 13:13
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Irwin,

I have just experienced the exact same problem as per above. Please see attached video. I changed the number of rows to 'All' and then checked one of the posts and pressed 'Delete'. It returned this error. When I try to open any of the links under 'Posts' (Questions, Replies, Under Moderation), it returns the 1064 Error page. I feel very worried because this is on our development site. I am hoping you know how we can easily clear this issue up. I cannot provide FTP access to this particular site unfortunately.

Here is a link - https://monosnap.com/file/7NvEwNC4azQlV9TOIs1nQyzNvH5PIU

Thanks,
Jeanette
·
Wednesday, 12 June 2019 09:52
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey there,

I changed the number of rows to 'All' and then checked one of the posts and pressed 'Delete'. It returned this error. When I try to open any of the links under 'Posts' (Questions, Replies, Under Moderation), it returns the 1064 Error page.


Do you mean that you change the number of rows to 'All' is at administrator/index.php?option=com_easydiscuss&view=posts&layout=questions right?

Thanks for your input.

It seems that I am able to replicate it on my local site.


We had fixed this issue internally already. You can paste the posts.php file into JoomlaFolder/administrator/components/com_easydiscuss/models/posts.php and system.php file into JoomlaFolder/administrator/components/com_easydiscuss/models/system.php.

If yes on your first quote, can you test it again after you applied the fix and see how it goes as I can't replicate it after applying the fix?
·
Wednesday, 12 June 2019 10:33
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post