Legal compliance module: no e-mails displayed for adding CMS page content

[carlfriedrich]

The legal compliance module has support for adding the contents of CMS pages to shop e-mails. This is how the configuration page should look like, as I found in other threads in this forum:

 

In my installation, however, the e-mail list is empty:

 

 

Does anybody have an idea why this is the case?

It's a fresh PrestaShop 1.7.7.1 installation with legal compliance 3.0.2.

[Marco_Co]

Zitat

 

Do you have a solution for this? I have the same problem.

 

Edit: I found the problem. The table ps_aeuc_email is empty, you need to fill this manuel.

Edited March 4, 2021 by Marco_Co (see edit history)

[carlfriedrich]

Yes, I found exactly that out, too. You can either fill it by hand, or install PrestaShop 1.7.6 (which does not have the problem) and then upgrade to 1.7.7, then the table is filled correctly, even after the upgrade.

[Hanuchin]

PrestaShop has stopped to maintain this module. i read it in release notes, or the Newsletter.

Is there any other working modul for the legal compliance in europe?

Before PrestaShop implemented the ps_legalcompliance modul, there has been 2 modules from the community (silbersaiten and gurkcity). But i think PrestaShop used this modules as a blueprint. So they stopped. 

Now its not available/maintained anymore. 

I dont get it. It seems, that PrestaShop dont want any eu legal compliance by default anymore?!?!

Edited March 17, 2021 by Hanuchin (see edit history)

[RabbitZzZ]

That's very bad for European Users of PS, because here (especially in Germany) it's mandatory to use this module.
Also there are still some issues open https://github.com/PrestaShop/ps_legalcompliance/issues
Would be great if someone would take the initiative on this.

[pcsk]

Hello,
please have you found a solution how to use this module?

I also have the empty table and I do not have example which data fill to tables to make it working 😞

[carlfriedrich]

I fixed it - as described above - by installing 1.7.6 and upgrading to newer version.

However, here is a dump of the according table ps_aeuc_mail from my instance, maybe it works by simply importing it (have not tried it myself):

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


CREATE TABLE `ps_aeuc_email` (
  `id_mail` int NOT NULL,
  `filename` varchar(64) NOT NULL,
  `display_name` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

INSERT INTO `ps_aeuc_email` (`id_mail`, `filename`, `display_name`) VALUES
(1, 'account', 'Account'),
(2, 'backoffice_order', 'Backoffice order'),
(3, 'bankwire', 'Bankwire'),
(4, 'cheque', 'Cheque'),
(5, 'contact_form', 'Contact form'),
(6, 'contact', 'Contact'),
(7, 'credit_slip', 'Credit slip'),
(8, 'download_product', 'Download product'),
(9, 'employee_password', 'Employee password'),
(10, 'forward_msg', 'Forward msg'),
(11, 'guest_to_customer', 'Guest to customer'),
(12, 'import', 'Import'),
(13, 'in_transit', 'In transit'),
(14, 'log_alert', 'Log alert'),
(15, 'newsletter', 'Newsletter'),
(16, 'order_canceled', 'Order canceled'),
(17, 'order_changed', 'Order changed'),
(18, 'order_conf', 'Order conf'),
(19, 'order_customer_comment', 'Order customer comment'),
(20, 'order_merchant_comment', 'Order merchant comment'),
(21, 'order_return_state', 'Order return state'),
(22, 'outofstock', 'Outofstock'),
(23, 'password', 'Password'),
(24, 'password_query', 'Password query'),
(25, 'payment_error', 'Payment error'),
(26, 'payment', 'Payment'),
(27, 'preparation', 'Preparation'),
(28, 'productoutofstock', 'Productoutofstock'),
(29, 'refund', 'Refund'),
(30, 'reply_msg', 'Reply msg'),
(31, 'shipped', 'Shipped'),
(32, 'test', 'Test'),
(33, 'voucher', 'Voucher'),
(34, 'voucher_new', 'Voucher new');

ALTER TABLE `ps_aeuc_email`
  ADD PRIMARY KEY (`id_mail`);

ALTER TABLE `ps_aeuc_email`
  MODIFY `id_mail` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
COMMIT;