Our Joomla! extensions are all OpenSource and free of charge. Support is also free of charge. Nevertheless, we do have costs that need to be paid. This is done out of our own pocket. We have had a donation button on our website for some time now, which is actually used to make donations from time to time. The donation progress bar is intended to show how much support we have received and how much is still missing to cover the basic costs, such as hosting and services. The annual costs currently amount to 356€.

Thank you for your support!

Donate PayPal GitHub Sponsors You want to support and there is no suitable platform? Write to us in the forum.

118,33€
× Please always add your "Report Configuration Settings" into your support request.

Thank you!

1069 error when activating one time per day

2 weeks 4 days ago #564 by serge
Hello,

Thanks for your module
When I activate one time per day on calculation interval I have this error : 1064You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '1975-07-16', 1),(134, 12, , '1954-07-17', 1),(159, 20, , '1947-07-25', 1)' at line 3


the stack is : 
ERROR 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 ' '1975-07-16', 1),(134, 12, , '1954-07-17', 1),(159, 20, , '1947-07-25', 1)' at line 3 in /home/microfer/www/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
Call Stack#FunctionLocation1()JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:1382mysqli->prepare()JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:1383Joomla\Database\Mysqli\MysqliStatement->__construct()JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:10204Joomla\Database\Mysqli\MysqliDriver->prepareStatement()JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:17855Joomla\Database\DatabaseDriver->setQuery()JROOT/modules/mod_sw_kbirthday/src/Helper/BirthdayHelper.php:4236SchuWeb\Module\Birthday\Site\Helper\BirthdayHelper->calcBirthdays()JROOT/modules/mod_sw_kbirthday/src/Helper/BirthdayHelper.php:1097SchuWeb\Module\Birthday\Site\Helper\BirthdayHelper->getBirthdayUser()JROOT/modules/mod_sw_kbirthday/src/Helper/BirthdayHelper.php:2458SchuWeb\Module\Birthday\Site\Helper\BirthdayHelper->getUserBirthday()JROOT/modules/mod_sw_kbirthday/src/Dispatcher/Dispatcher.php:1059SchuWeb\Module\Birthday\Site\Dispatcher\Dispatcher->getLayoutData()JROOT/libraries/src/Dispatcher/AbstractModuleDispatcher.php:6310Joomla\CMS\Dispatcher\AbstractModuleDispatcher->dispatch()JROOT/libraries/src/Helper/ModuleHelper.php:29111Joomla\CMS\Helper\ModuleHelper::renderRawModule()JROOT/libraries/src/Helper/ModuleHelper.php:16212Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:9913Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:5114Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:57515Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:89416Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:64717Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:107318Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:73219Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:31120Joomla\CMS\Application\CMSApplication->execute()JROOT/includes/app.php:5821require_once()JROOT/index.php:32
is it possible it is your module ? or perharps the community builder tables ?
 
The following user(s) said Thank You: Sven Schultschik

Please Log in or Create an account to join the conversation.

1 week 6 days ago #565 by Sven Schultschik
Replied by Sven Schultschik on topic 1069 error when activating one time per day
Hi,
thanks for report. I will investigate.

Please Log in or Create an account to join the conversation.

Time to create page: 0.097 seconds
Powered by Kunena Forum