SQL syntax error

Just installed SermonSpeaker to try it out. Successfully used the 'Create sermons automatically' tool to import some old archived sermons.

I created the category "Archived Sermons" and wanted to move all of the imported sermons to this category. However, anytime I attempt to show more than 20 sermons, or go beyond the first page of 20 sermons listed I get the following error:


500 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 12 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 'LIMIT 20' at line 12 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 12


I can't access the sermons again without logging out and back in to Joomla.

Any ideas on the problem or how to remedy it?

Thanks!
Joomla 3.8.10
SermonSpeaker 5.8.4

Can you try enable debugging and reproduce it then? I think that should give you the complete failing query then.

I will try to reproduce it tomorrow.

Works fine here for me so far. SO I need more details to find out exactly what triggered your error.
The logging out and in to reset it may mean some filters or sorting options are applied. Logging out (or closing the browser) would clear those. So this may be relevant.
And how ar you trying to move the sermons? Using the batch button and selecting the new category there for the 20 sermons at once?

Thank you for the reply.

The error seems to occur anytime I try to do anything beyond the front page of (20) sermons.
If I click to proceed to page '2' it throws the error. If I choose to filter 'Uncategorized' sermons it throws the same error.

I'm attaching a screenshot of the error with debugging on.

Call stack
# Function Location
1 () JROOT/administrator/components/com_sermonspeaker/views/sermons/view.html.php:75

2 SermonspeakerViewSermons->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672

3 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_sermonspeaker/controller.php:45

4 SermonspeakerController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710

5 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_sermonspeaker/sermonspeaker.php:21

6 require_once() JROOT/libraries/src/Component/ComponentHelper.php:382

7 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357

8 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101

9 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159

10 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195

11 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51

I realized the image may be hard to read.