sending error message

I'm suddenly getting the following error when I try to send my latest newsletter:

"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND TIMESTAMPDIFF(MINUTE, `datetime`, "2026-05-19 21:21:14") > 90' at line 1"

I've never seen such an error before.

 

Hello Grant and thank you for posting.

Do you get this error when clicking Send from the backend newsletter manager?

Yes, that's exactly it. Created the newsletter. Sent it. A few sent properly, then it paused. That's happened before. But trying again, I get that error.

Can you enable system debug for a moment, and try another sending?
It could help if we get a little more details.

Thank you for bringing this up.

It only shows the error for a couple seconds, then reloads the newsletters page. But I managed to copy this (I can't find a way to keep the formatting, sorry):

1    ()    JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
2    mysqli->prepare()    JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
3    Joomla\Database\Mysqli\MysqliStatement->__construct()    JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:972
4    Joomla\Database\Mysqli\MysqliDriver->prepareStatement()    JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1780
5    Joomla\Database\DatabaseDriver->setQuery()    JROOT/administrator/components/com_nspro/src/Model/SendingModel.php:193
6    Nspro\Component\Nspro\Administrator\Model\SendingModel->send()    JROOT/administrator/components/com_nspro/src/Controller/NewslettersController.php:68
7    Nspro\Component\Nspro\Administrator\Controller\NewslettersController->send()    JROOT/libraries/src/MVC/Controller/BaseController.php:730
8    Joomla\CMS\MVC\Controller\BaseController->execute()    JROOT/libraries/src/Dispatcher/ComponentDispatcher.php:143
9    Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch()    JROOT/libraries/src/Component/ComponentHelper.php:361
10    Joomla\CMS\Component\ComponentHelper::renderComponent()    JROOT/libraries/src/Application/AdministratorApplication.php:150
11    Joomla\CMS\Application\AdministratorApplication->dispatch()    JROOT/libraries/src/Application/AdministratorApplication.php:206
12    Joomla\CMS\Application\AdministratorApplication->doExecute()    JROOT/libraries/src/Application/CMSApplication.php:304
13    Joomla\CMS\Application\CMSApplication->execute()    JROOT/administrator/includes/app.php:58
14    require_once()    JROOT/administrator/index.php:32