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.

215,49€
× Please always add your "Report Configuration Settings" into your support request.

Thank you!

1069 error when activating one time per day

3 months 1 week 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.

3 months 1 week 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.

If you enjoy our extensions and found our assistance helpful, please consider supporting the project as outlined at the top of the page. Your support would be greatly appreciated.

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

1 week 9 hours ago - 1 week 9 hours ago #579 by Sven Schultschik
Replied by Sven Schultschik on topic 1069 error when activating one time per day
Hi serge,

I couldn't reproduce the issue.

Can you tell me every versions you are using?

php, mysql/mariadb, Joomla, Community builder, birthday module version, which configuration you are using?

If you enjoy our extensions and found our assistance helpful, please consider supporting the project as outlined at the top of the page. Your support would be greatly appreciated.

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

Time to create page: 0.123 seconds
Powered by Kunena Forum