Addon acymailing newsletter - error 1452

05.06.2020 23:03
#1
alexzah901
Joomshopping forum user no avatar
Name: Александр
03.03.2018
Posts: 4
Quote
Addon acymailing newsletter - error 1452

Encountered error 1452
There is a bundle of jshopping + AcyMailing and the addon "Addon acymailing newsletter".
JoomShopping, Joomla and AcyMailing are the latest versions.
This error occurs when trying to register on a site with the subscription checkbox enabled.
Addon acymailing newsletter - error 1452


Joomla: 3.9.19
JoomShopping: 4.18.4
PHP: 7.3.12
MySQL: 5.7.21

Last change: 06.06.2020 12:52
 
06.06.2020 12:52
#2
alexzah901
Joomshopping forum user no avatar
Name: Александр
03.03.2018
Posts: 4
Quote
Aw: Addon acymailing newsletter - error 1452

Addon acymailing newsletter is compatible with Acymailing v6 ?

 
06.06.2020 14:02
#3
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25934
Quote
Aw: Addon acymailing newsletter - error 1452

Yes.
We will look for a problem.

 
08.06.2020 09:25
#4
kreativ quadrat
User kreativ quadrat
Name: garry
25.11.2010
Posts: 325
Quote
Aw: Addon acymailing newsletter - error 1452

the problem arises when a guest registers
fix plugins/jshoppingcheckout/acymailing_newsletter/acymailing_newsletter.php
row 118
change
$acymailingUserId = self::_getStatusForSubscriber($acy_user);
tp
$acymailingUserId = self::_addSubscriber($acy_user);

also change ROW 63 to insert created date correctly
$query = "INSERT INTO `#__acym_user` (`email`, `cms_id`, `name`, `creation_date`, `confirmed`, `active`) VALUES (
'" . $db->escape($user->email) . "', 0, '" . $db->escape($user->name) . "', NOW(), 1, 1);";

 
16.06.2020 20:07
#5
alexzah901
Joomshopping forum user no avatar
Name: Александр
03.03.2018
Posts: 4
Quote
Aw: Addon acymailing newsletter - error 1452

Thank you very much! helped

 
16.06.2020 20:09
#6
alexzah901
Joomshopping forum user no avatar
Name: Александр
03.03.2018
Posts: 4
Quote
Aw: Addon acymailing newsletter - error 1452

kreativ quadrat - 08.06.2020 09:25
the problem arises when a guest registers
fix plugins/jshoppingcheckout/acymailing_newsletter/acymailing_newsletter.php
row 118
change
$acymailingUserId = self::_getStatusForSubscriber($acy_user);
tp
$acymailingUserId = self::_addSubscriber($acy_user);

also change ROW 63 to insert created date correctly
$query = "INSERT INTO `#__acym_user` (`email`, `cms_id`, `name`, `creation_date`, `confirmed`, `active`) VALUES (
'" . $db->escape($user->email) . "', 0, '" . $db->escape($user->name) . "', NOW(), 1, 1);";

Thank you very much!

 
08.06.2021 09:23
#7
kkania
Joomshopping forum user no avatar
Name: Katrin Kania
09.06.2011
Posts: 50
Quote
Aw: Addon acymailing newsletter - error 1452

I get an error message when I enable the plugin - when I try to login, register, or buy without registration:

Table '***.#__acym_user' doesn't exist

 
08.06.2021 21:21
#8
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25934
Quote
Aw: Addon acymailing newsletter - error 1452

Need install component acymailing

 
25.06.2021 10:59
#9
kkania
Joomshopping forum user no avatar
Name: Katrin Kania
09.06.2011
Posts: 50
Quote
Aw: Addon acymailing newsletter - error 1452

The component is installed...

 
25.06.2021 13:44
#10
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25934
Quote
Aw: Addon acymailing newsletter - error 1452

Version component?
version plugin?

 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.