Elxis CMS Forum

Extensions => Modules => Topic started by: bledi on June 26, 2020, 09:20:49

Title: Newsletter Module with Openshop products
Post by: bledi on June 26, 2020, 09:20:49
Hello!
I have set the newsletter module to send automatically newsletters every week, and I had activated: Articles + Mikro blogs. It works fine.
Last week i activated also the Openshop products but i had a Fatal Error:

The detailed error message was:
ERROR in file /home2/bbbncid/public_html/includes/libraries/elxis/database/statement.class.php line 41
Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 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 'WHERE p.dateadded >= '2020-06-19 00:00:00' AND p.dateadded < '2020-06-26 00:00:0' at line 4 in /home2/bbbncid/public_html/includes/libraries/elxis/database/statement.class.php:41
Stack trace:
#0 /home2/bbbncid/public_html/includes/libraries/elxis/database/statement.class.php(41): PDOStatement->execute(NULL)
#1 /home2/bbbncid/public_html/modules/mod_newsletter/mod_newsletter.php(1107): elxisPDOStatement->execute()
#2 /home2/bbbncid/public_html/modules/mod_newsletter/mod_newsletter.php(611): modNewsletter->getOpenShop()
#3 /home2/bbbncid/public_html/modules/mod_newsletter/mod_newsletter.php(272): modNewsletter->getContent()
#4 /home2/bbbncid/public_html/modules/mod_newsletter/mod_newsletter.php(104): modNewsletter->taxidromos()
#5 /home2/bbbncid/public_html/modules/mod_newsletter/mod_newsletter.php(11

I can see there is a problem between Newsletter Module and Openshop, but thats all i see :(
Title: Re: Newsletter Module with Openshop products
Post by: datahell on September 04, 2020, 19:33:15
Oooooops! I just saw this post. Problem solved, it was due to a miss-type in an SQL query.
Please update to module Newsletter 1.5 (https://www.elxis.net/edc/communication/61.html)
Title: Re: Newsletter Module with Openshop products
Post by: bledi on October 22, 2020, 08:35:21
After updating to :Elxis 5.1 Stable [Cronus] rev2356, there is still the problem with sql database.

The detailed error message was:
ERROR in file /home/ideaidea/public_html/includes/libraries/elxis/database/statement.class.php line 41
Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm.dateadded' in 'order clause' in /home/ideaidea/public_html/includes/libraries/elxis/database/statement.class.php:41
Stack trace:
#0 /home/ideaidea/public_html/includes/libraries/elxis/database/statement.class.php(41): PDOStatement->execute(NULL)
#1 /home/ideaidea/public_html/modules/mod_newsletter/mod_newsletter.php(2213): elxisPDOStatement->execute()
#2 /home/ideaidea/public_html/modules/mod_newsletter/mod_newsletter.php(1221): modNewsletter->getOpenShop()
#3 /home/ideaidea/public_html/modules/mod_newsletter/mod_newsletter.php(543): modNewsletter->getContent()
#4 /home/ideaidea/public_html/modules/mod_newsletter/mod_newsletter.php(207): modNewsletter->taxidromos()
#5 /home/ideaidea/public_html/modules/mod_newsletter/mod_newsletter.php(2275): modNewsletter->run()
#6 /home/ideaidea/public_html/includes/libraries/elxis/module.class.php(288): include('/home3/ideaidea...')
#7 /home/ideaidea/public_html/incl