Infos For The Update Of BwPostman Timecontrol to Version 2.0.0

SQL error in frontend module monthly newsletter

27 Nov 2025 14:45 #2643 by arcodejong

  • New Member
  • New Member

  • Posts: 5
  • Thank you received: 1
    • SQL error in frontend module monthly newsletter was created by arcodejong
    Hello,

    When I publish the module to view the montly newsletters I get the following error :
    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 `campaign_id` IN (1)' at line 3

    I already tried to use your build in maintenance / Check and fix tables feature and it does not detect any problems. Everything is green / Ok.

    Currently I am running : 
    Joomla version 5.4.1. Stable
    PHP version 8.2.28
    MySQL version 10.11.11-MariaDB-0+deb12u1
    Webserver Apache/2.4.62 (Debian)

    Do you have an idea what the problem is?

    Thanks in advance.

    Best regards,

    Arco

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

    27 Nov 2025 22:21 #2644 by Romana

    • Moderator
    • Moderator

  • Posts: 982
  • Thank you received: 87
    • Replied by Romana on topic SQL error in frontend module monthly newsletter
    Hello Arco,

    I suppose this is a combination of settings vs. existing data. Please provide Your complete settings of the module. Probably a backup of BwPostman tables by PM could help.

    Hth
    Romana
    Problem gelöst? Dann bitte auf gelöst klicken. Über ein Danke freue ich mich immer.
    Problem solved? Please click to solved.I am glad to every thank you.

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

    Time to create page: 0.108 seconds

    Register to newsletter

    Hint: Your entered data are only used to register to and sending of the newsletter. Your data will be processed and stored by me. For more information have a look at my privacy policy.
    Your mailing list:
    BwPostman:
    Infos about Joomla! extensions of Boldt Webservice...

    () Mandatory fields

    Information

    ×

    Voluntary salary

    If you like Boldt Webservice then I would be glad about your backing:
    • Recommend Boldt Webservice.
    • If you want to support my work with a donation, please click on the following button - the donation will be handled via paypal.

    With your voluntary salary you also support the development of free software and extensions for the CMS Joomla.

    Enter your amount below and click on the following button:

     

    Register to newsletter

    Hint: Your entered data are only used to register to and sending of the newsletter. Your data will be processed and stored by me. For more information have a look at my privacy policy.
    Your mailing list:
    BwPostman:
    Infos about Joomla! extensions of Boldt Webservice...

    () Mandatory fields

    Information

    ×

    Voluntary salary

    If you like Boldt Webservice then I would be glad about your backing:
    • Recommend Boldt Webservice.
    • If you want to support my work with a donation, please click on the following button - the donation will be handled via paypal.

    With your voluntary salary you also support the development of free software and extensions for the CMS Joomla.

    Enter your amount below and click on the following button: