Newsletter Module with Openshop products

[bledi]

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

[datahell]

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

[bledi]

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