search

in2code-de / powermail

This is the official repository of the TYPO3 extension powermail! Powermail is a well-known, editor-friendly, powerful and easy mailform extension for TYPO3
https://in2code.de
86 stars 169 forks source link

findByUid over optinConfirmAction #491

Open prdt3e opened 4 years ago

prdt3e commented 4 years ago

I have a problem. My multilingual website has an optin for Powermail. The website reports "The given link is not correct". In search of the error I looked at the SQl from findByUid which does not return anything.

'SELECT `tx_powermail_domain_model_mail`.* FROM `tx_powermail_domain_model_ma
   il` `tx_powermail_domain_model_mail` WHERE ((`tx_powermail_domain_model_mail
   `.`uid` = :dcValue1) AND (`tx_powermail_domain_model_mail`.`deleted` = :dcVa
   lue2)) AND ((`tx_powermail_domain_model_mail`.`sys_language_uid` = -1) OR ((
   `tx_powermail_domain_model_mail`.`sys_language_uid` = 3) AND (`tx_powermail_
   domain_model_mail`.`l10n_parent` IN (SELECT `tx_powermail_domain_model_mail_
   dl`.`uid` FROM `tx_powermail_domain_model_mail` `tx_powermail_domain_model_m
   ail_dl` WHERE (`tx_powermail_domain_model_mail_dl`.`l10n_parent` = 0) AND (`
   tx_powermail_domain_model_mail_dl`.`sys_language_uid` = 0) AND ((`tx_powerma
   il_domain_model_mail_dl`.`deleted` = 0) AND (`tx_powermail_domain_model_mail
   _dl`.`hidden` = 0) AND (`tx_powermail_domain_model_mail_dl`.`starttime` <= 1
   579874580) AND ((`tx_powermail_domain_model_mail_dl`.`endtime` = 0) OR (`tx_
   powermail_domain_model_mail_dl`.`endtime` > 1579874580))))))) AND (tx_powerm
   ail_domain_model_mail.deleted=0)

The mail is deactivated in the backend and can be found in the folder. has anyone ever had the problem?

thanks

prdt3e commented 4 years ago

Typo3: 9.5.13 Powermail: 7.4.0

vendytjung commented 4 years ago

I have also the same issue, the optionConfirm on default language work, but not but alternativ language (sys_language_uid > 0). Any idea @einpraegsam?

Schweriner commented 3 years ago

This may help: https://github.com/einpraegsam/powermail/issues/213