TOPIC:

I am using the latest version of mail box - Joomla 4 PHP 8. I tried to look at a newsletter at the front end, logged in as superuser and got:
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 (0)' at line 3
When I logged in as a registered usetr there was no problem,

Hote, I'm afraid I don't speak German,

Hello paulblackburn,

I need more input, because I can't reproduce this error.

Tested: Newsletter sent and published to a mailing list with restricted access to registered users. If I login at front end as SuperUser I can see the newsletter in the list and a click to this newsletter opens the newsletter without problem. Do You perhaps use a campaign?

By the way: You should also be more precise with the specification of the used versions, if you want help. Latest is for BwPostman in some days not the latest, because a new release is planned for Saturday. So if someone reads this thread at Sunday, Your current version is not the latest.

I assume, with 'mail box' You denote BwPostman?

Hth
Romana

Hi Romana,
Thank tou for your quick reponse. I am using BwPostman version 4.1.3. Unfortunately, i accidentally deleted the newslatter so I can's replicate the error either. Please delete this thread.
Regards
Paul

Problem solved.