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: 7
  • 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: 983
  • Thank you received: 89
    • 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.
    The following user(s) said Thank You: arcodejong

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

    28 Nov 2025 10:15 #2645 by arcodejong

    • New Member
    • New Member

  • Posts: 7
  • Thank you received: 1
    • Replied by arcodejong on topic SQL error in frontend module monthly newsletter
    I have just send you a PM with the file.

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

    30 Nov 2025 13:42 #2646 by Romana

    • Moderator
    • Moderator

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

    the provided data helped to reproduce the problem. Is is indeed a special combination of Your data and Your settings. You have all newsletters from a campaign. There is one mailing list for this campaign. The mailing list is not published and that caused the error to show up.

    I have fixed this problem with the next version of BwPostman, so the error will not appear anymore. A fast workaround for You is to publish the mailing list. Or You want to test the next version, so I could add You to the testers of BwPostman. Then You are able to download the current build, which contains the fix.

    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.
    The following user(s) said Thank You: arcodejong

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

    01 Dec 2025 10:57 #2647 by arcodejong

    • New Member
    • New Member

  • Posts: 7
  • Thank you received: 1
    • Replied by arcodejong on topic SQL error in frontend module monthly newsletter
    Hello Romana,

    Publishing the mailing list solved the issue!
    Thank you for your efforts!

    Best regards,

    Arco

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

    Time to create page: 0.298 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: