My client wants to pull JEvents entries into her AcyMailing v5 newsletter. We want to use content for 2 weeks starting the day the newsletter is sent, and pull content from all categories. When I try to Preview/Send, I get this 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 'AND jfc.imagename1 = '') AND catmap.catid IN(-1,25,29,31,28,27,35,36,37,38,46,' at line 24
If I remove the JEvents tag, the rest of the content displays correctly. I noticed the "-1" at the beginning of the category list, is that supposed to be there?
Here is the System Information from Joomla:
Setting -- Value
PHP Built On --Linux 4.9.0-8-amd64 #1 SMP Debian 4.9.144-3.1 (2019-02-19) x86_64
Database Type -- mysql
Database Version -- 5.7.25
Database Collation -- utf8_general_ci
Database Connection Collation -- utf8mb4_general_ci
PHP Version -- 7.1.27
Web Server -- Apache
WebServer to PHP Interface -- fpm-fcgi
Joomla! Version -- Joomla! 3.9.15 Stable [ Amani ] 27-January-2020 15:00 GMT
Joomla! Platform Version -- Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
We have the latest version of Joomla, AcyMailing 5, and JEvents installed.
Please advise! Thanks,
Toolie