Child pages
  • [emails] Missing "l1_TranslateFrom" column during upgrade from 5.2.x to 5.3.x
Skip to end of metadata
Go to start of metadata

After upgrade from 5.2.x to 5.3.x is done I'm setting 5 SQL errors like this one in final step:

Warning (#7): Unknown column 'l1_TranslateFrom' in 'field list' (1054)
SQL: 

    REPLACE INTO `51x_ses_740237230_edit_51x_EmailTemplates` (`TemplateId`,`TemplateName`,`Type`,`l1_Subject`,`l1_HtmlBody`,`l1_PlainTextBody`,`l1_TranslateFrom`,`Headers`)
    VALUES ('13','CATEGORY.ADD','0','New Category \"<inp2:c_Field name=\"Name\"/>\" - Added','Your suggested category \"<inp2:c_Field name=\"Name\"/>\" has been added.','','0',''),('16','CATEGORY.ADD','1','New Category \"<inp2:c_Field name=\"Name\"/>\" Submitted by Users','A category \"<inp2:c_Field name=\"Name\"/>\" has been added.','','0',''),('14','CATEGORY.ADD.PENDING','0','Suggested Category \"<inp2:c_Field name=\"Name\"/>\" is Pending','The category you suggested \"<inp2:c_Field name=\"Name\"/>\" is pending for administrative approval.\r\n\r\nThank you!','','0',''),('15','CATEGORY.ADD.PENDING','1','Suggested Category \"<inp2:c_Field name=\"Name\"/>\" is Pending','A category \"<inp2:c_Field name=\"Name\"/>\" has been added, pending your confirmation. Please review the category and approve or deny it.','','0',''),('17','CATEGORY.APPROVE','0','A category has been approved','Your suggested category \"<inp2:c_Field name=\"Name\"/>\" has been approved.','','0',''),('18','CATEGORY.DENY','0','Your Category \"<inp2:c_Field name=\"Name\"/>\" has been Denied','Your category suggestion \"<inp2:c_Field name=\"Name\"/>\" has been denied.','','0',''),('34','FORM.SUBMISSION.REPLY.FROM.USER','1','New Email REPLY Received in \"Feedback Manager\" (<inp2:formsubs.-item_Field name=\"FormSubmissionId\"/>)','New Email REPLY Received in &quot;Feedback Manager&quot;.<br />\r\n<br />\r\nOriginal FeedbackId: <inp2:formsubs.-item_Field name=\"FormSubmissionId\"/> <br />\r\nOriginal Subject: <inp2:formsubs.-item_FormField role=\"subject\"/> <br />\r\n<br />\r\nPlease proceed to the Admin Console in order to review and reply to the user.','','0',''),('35','FORM.SUBMISSION.REPLY.FROM.USER.BOUNCED','1','New Email - Delivery Failure Received in \"Feedback Manager\" (<inp2:formsubs.-item_Field name=\"FormSubmissionId\"/>)','New Email Delivery Failure Received in &quot;Feedback Manager&quot;.<br />\r\n<br />\r\nOriginal FeedbackId: <inp2:formsubs.-item_Field name=\"FormSubmissionId\"/> <br />\r\nOriginal Subject: <inp2:formsubs.-item_FormField role=\"subject\"/> <br />\r\n<br />\r\nPlease proceed to the Admin Console in order to review and reply to the user.','','0',''),('33','FORM.SUBMISSION.REPLY.TO.USER','1','<inp2:m_Param name=\"subject\"/> #verify<inp2:submission-log_Field name=\"VerifyCode\"/>','','<inp2:m_Param name=\"message\"/>','0',''),('32','FORM.SUBMITTED','0','Thank You for Contacting Us!','<p>Thank you for contacting us. We\'ll be in touch with you shortly!</p>','','0',''),('31','FORM.SUBMITTED','1','New form submission','<p>Form has been submitted. Please proceed to the Admin Console to review the submission!</p>','','0',''),('134','ROOT.RESET.PASSWORD','1','Root Reset Password','Your new password is: <inp2:m_Param name=\"password\"/>','','0',''),('141','SYSTEM.LOG.NOTIFY','1','System Log Notifications (<inp2:system-log.email_TotalRecords/>)','<inp2:m_DefineElement name=\"backtrace_element\">\r\n <li><inp2:m_Phrase name=\"la_LogBacktraceFunction\"/>: <inp2:m_Param name=\"file_info\"/></li>\r\n</inp2:m_DefineElement>\r\n\r\n<inp2:m_DefineElement name=\"system_log_element\">\r\n <h4><inp2:Field name=\"LogTimestamp\" format=\"M d H:i:s\"/> <inp2:Field name=\"LogHostname\"/> <inp2:RequestURI html_escape=\"1\"/>[PID=<inp2:Field name=\"LogProcessId\"/>,UID=<inp2:Field name=\"LogUniqueId\"/>]</h4>\r\n [<inp2:Field name=\"LogLevel\"/>] #<inp2:Field name=\"LogCode\"/>: <inp2:Field name=\"LogMessage\" no_special=\"1\"/> in <inp2:Filename/> on line <inp2:Field name=\"LogSourceFileLine\"/><br/>\r\n\r\n <inp2:m_if check=\"Field\" name=\"LogBacktrace\" db=\"db\">\r\n <br/>Backtrace:\r\n\r\n <ol style=\"margin: 0; padding-left: 25px; font-size: 12px;\">\r\n <inp2:PrintBacktrace render_as=\"backtrace_element\"/>\r\n </ol>\r\n </inp2:m_if>\r\n\r\n <inp2:m_ifnot check=\"m_Param\" name=\"is_last\"><hr/></inp2:m_ifnot>\r\n</inp2:m_DefineElement>\r\n\r\n<inp2:system-log.email_PrintList render_as=\"system_log_element\"/>','<inp2:m_DefineElement name=\"backtrace_plain_element\">\r\n<inp2:BacktraceIndex/>. <inp2:m_Phrase name=\"la_LogBacktraceFunction\"/>: <inp2:m_Param name=\"file_info\"/>\r\n<inp2:m_ifnot check=\"m_Param\" name=\"is_last\">\r\n\r\n</inp2:m_ifnot>\r\n</inp2:m_DefineElement>\r\n<inp2:m_DefineElement name=\"system_log_plain_element\">\r\n<inp2:Field name=\"LogTimestamp\" format=\"M d H:i:s\"/> <inp2:Field name=\"LogHostname\"/> <inp2:RequestURI/>[PID=<inp2:Field name=\"LogProcessId\"/>,UID=<inp2:Field name=\"LogUniqueId\"/>]\r\n[<inp2:Field name=\"LogLevel\"/>] #<inp2:Field name=\"LogCode\"/>: <inp2:Field name=\"LogMessage\" no_special=\"1\"/> in <inp2:Filename/> on line <inp2:Field name=\"LogSourceFileLine\"/>\r\n<inp2:m_if check=\"Field\" name=\"LogBacktrace\" db=\"db\">\r\n\r\nBacktrace:\r\n<inp2:PrintBacktrace render_as=\"backtrace_plain_element\" strip_tags=\"1\"/></inp2:m_if>\r\n<inp2:m_ifnot check=\"m_Param\" name=\"is_last\">\r\n-------------\r\n\r\n</inp2:m_ifnot>\r\n</inp2:m_DefineElement>\r\n<inp2:system-log.email_PrintList render_as=\"system_log_plain_element\"/>','0',''),('1','USER.ADD','0','In-portal registration','Dear <inp2:u.register_Field name=\"FirstName\" /> <inp2:u.register_Field name=\"LastName\" />,\r\n\r\nThank you for registering on <inp2:m_Link template=\"index\"/>. Your registration is now active.\r\n<inp2:m_if check=\"u.register_Field\" name=\"Email\">\r\n<br/><br/>\r\nPlease click here to verify your E-mail address:\r\n<a href=\"<inp2:u.register_ConfirmPasswordLink t=\"platform/my_account/verify_email\" no_amp=\"1\"/>\"><inp2:u.register_ConfirmPasswordLink t=\"platform/my_account/verify_email\" no_amp=\"1\"/></a><br/><br/>\r\n</inp2:m_if>','','0',''),('2','USER.ADD','1','New User Registration (<inp2:u.register_Field name=\"Username\"/>)','A new user \"<inp2:u.register_Field name=\'Username\'/>\" has been added.','','0',''),('140','USER.ADD.BYADMIN','0','New user has been created','','Dear <inp2:u_Field name=\"FirstName\"/>,\r\n\r\nA new user has been created and assigned to you\r\n\r\nNow you can login using the following credentials:\r\n\r\n<inp2:m_if check=\"u_Field\" name=\"Username\">Username: <inp2:u_Field name=\"Username\"/><inp2:m_else/>E-mail: <inp2:u_Field name=\"Email\"/></inp2:m_if> \r\nPassword: <inp2:u_Field name=\"Password_plain\"/> \r\n','0',''),('11','USER.ADD.PENDING','0','New User Registration (<inp2:u.register_Field name=\"Username\"/><inp2:m_if check=\"m_GetConfig\" name=\"User_Allow_New\" equals_to=\"4\"> - Activation Email</inp2:m_if>)','Dear <inp2:u.register_Field name=\"FirstName\" /> <inp2:u.register_Field name=\"LastName\" />,<br />\r\n<br />\r\n<inp2:m_if check=\"m_GetConfig\" name=\"User_Allow_New\" equals_to=\"4\">\r\n Thank you for registering on <inp2:m_Link template=\"index\"/> website. To activate your registration please follow link below. <inp2:u.register_ActivationLink template=\"platform/login/activate_confirm\"/>\r\n<inp2:m_else/>\r\n Thank you for registering on <inp2:m_Link template=\"index\"/> website. Your registration will be active after approval. \r\n \r\n <inp2:m_if check=\"u.register_Field\" name=\"Email\">\r\n <br/><br/>\r\n Please click here to verify your E-mail address:\r\n <a href=\"<inp2:u.register_ConfirmPasswordLink t=\"platform/my_account/verify_email\" no_amp=\"1\"/>\"><inp2:u.register_ConfirmPasswordLink t=\"platform/my_account/verify_email\" no_amp=\"1\"/></a><br/><br/>\r\n </inp2:m_if>\r\n</inp2:m_if>','','0',''),('12','USER.ADD.PENDING','1','New User Registered','A new user \"<inp2:u.register_Field name=\"Username\"/>\" has registered and is pending administrative approval.','','0',''),('3','USER.APPROVE','0','Your Account is Active','Welcome to <inp2:m_Link template=\"index\"/>!\r\n\r\nYour user registration has been approved. Your user name is: \"<inp2:u_Field name=\"Username\"/>\".','','0',''),('4','USER.APPROVE','1','New User Account \"<inp2:u_Field name=\"Username\"/>\" was Approved','User \"<inp2:u_Field name=\"Username\"/>\" has been approved.','','0',''),('7','USER.DENY','0','Your Registration has been Denied','Your registration on <a href=\"<inp2:m_Link template=\"index\"/>\"><inp2:m_Link template=\"index\"/></a> website has been denied.','','0',''),('8','USER.DENY','1','User Registration for \"<inp2:u_Field name=\"Username\"/>\" has been Denied','User \"<inp2:u_Field name=\"Username\"/>\" has been denied.','','0',''),('136','USER.EMAIL.CHANGE.UNDO','0','Changed E-mail Rollback','Hello,<br/><br/>\r\n\r\nIt seems that you have changed e-mail in your In-portal account. You may undo this change by clicking on the link below:<br/><br/>\r\n\r\n<a href=\"<inp2:u_UndoEmailChangeLink template=\"platform/my_account/restore_email\"/>\"><inp2:u_UndoEmailChangeLink template=\"platform/my_account/restore_email\"/></a><br/><br/>\r\n\r\nIf you believe you have received this email in error, please ignore this email. Your account will be linked to another e-mail unless you have clicked on the above link.','','0',''),('135','USER.EMAIL.CHANGE.VERIFY','0','Changed E-mail Verification','Hello,<br/><br/>\r\n\r\nIt seems that you have changed e-mail in your In-portal account. Please verify this new e-mail by clicking on the link below:<br/><br/>\r\n\r\n<a href=\"<inp2:u_ConfirmPasswordLink t=\"platform/my_account/verify_email\" no_amp=\"1\"/>\"><inp2:u_ConfirmPasswordLink t=\"platform/my_account/verify_email\" no_amp=\"1\"/></a><br/><br/>\r\n\r\nIf you believe you have received this email in error, please ignore this email. Your email will not get verified status unless you have clicked on the above link.\r\n','','0',''),('28','USER.MEMBERSHIP.EXPIRATION.NOTICE','0','Membership Expiration Notice','Your membership on <inp2:m_Link template=\"index\"/> website will soon expire.','','0',''),('29','USER.MEMBERSHIP.EXPIRATION.NOTICE','1','Membership Expiration Notice for \"<inp2:u_Field name=\"Username\"/>\" Sent','User <inp2:u_Field name=\"Username\"/> membership will expire soon.','','0',''),('26','USER.MEMBERSHIP.EXPIRED','0','Your Membership Expired','Your membership on <inp2:m_Link template=\"index\"/> website has expired.','','0',''),('27','USER.MEMBERSHIP.EXPIRED','1','User\'s Membership Expired ( <inp2:u_Field name=\"Username\"/>)','User\'s (<inp2:u_Field name=\"Username\"/>) membership on <inp2:m_Link template=\"index\"/> website has expired.','','0',''),('139','USER.NEW.PASSWORD','0','New password generated','','Dear <inp2:u_Field name=\"FirstName\"/>,\r\n\r\nA new password has been generated for your user.\r\n\r\nNow you can login using the following credentials:\r\n\r\n<inp2:m_if check=\"u_Field\" name=\"Username\">Username: <inp2:u_Field name=\"Username\"/><inp2:m_else/>E-mail: <inp2:u_Field name=\"Email\"/></inp2:m_if> \r\nPassword: <inp2:u_Field name=\"Password_plain\"/> ','0',''),('25','USER.PSWDC','0','Reset Password Confirmation','Hello,<br/><br/>\r\n\r\nIt seems that you have requested a password reset for your In-portal account. If you would like to proceed and change the password, please click on the link below:<br/><br/>\r\n\r\n<a href=\"<inp2:u_ConfirmPasswordLink no_amp=\"1\"/>\"><inp2:u_ConfirmPasswordLink no_amp=\"1\"/></a><br/><br/>\r\n\r\nYou will receive a second email with your new password shortly.<br/><br/>\r\n\r\nIf you believe you have received this email in error, please ignore this email. Your password will not be changed unless you have clicked on the above link.\r\n','','0',''),('19','USER.SUBSCRIBE','0','Subscribed to a Mailing List on <inp2:m_Link template=\"index\"/>','You have subscribed to a mailing list on <inp2:m_Link template=\"index\"/> website.','','0',''),('20','USER.SUBSCRIBE','1','New User has Subscribed to a Malling List','New user <inp2:Field name=\"Email\"/> has subscribed to a mailing list on <a href=\"<inp2:m_Link template=\"index\"/>\"><inp2:m_Link template=\"index\"/></a> website.','','0',''),('23','USER.SUGGEST','0','Check out this Website','Hello,</br></br>\r\n\r\nThis message has been sent to you
    from one of your friends.</br></br>\r\nCheck out this site: <a href=\"<inp2:m_Link template=\"index\"/>\"><inp2:m_Link template=\"index\"/></a>!','','0',''),('24','USER.SUGGEST','1','Website Suggested to a Friend','A visitor suggested <a href=\"<inp2:m_Link template=\"index\"/>\"><inp2:m_Link template=\"index\"/></a> website to a friend.','','0',''),('21','USER.UNSUBSCRIBE','0','You have been unsubscribed','You have successfully unsubscribed
    from the mailing list on <a href=\"<inp2:m_BaseUrl />\"><inp2:m_BaseUrl /></a> website.','','0',''),('22','USER.UNSUBSCRIBE','1','User Unsubsribed
    from Mailing List','A user \"<inp2:Field name=\"Email\"/>\" has unsubscribed
    from the mailing list on <a href=\"<inp2:m_Link template=\"index\"/>\"><inp2:m_Link template=\"index\"/></a>.','','0',''),('5','USER.VALIDATE','0','User Registration is Validated','Welcome to In-portal!<br/><br/>\r\n\r\nYour user registration has been approved. You can login now <a href=\"<inp2:m_Link template=\"index\"/>\"><inp2:m_Link template=\"index\"/></a> using the following information:<br/><br/>\r\n\r\n==================<br/>\r\nUsername: \"<inp2:u_Field name=\"Username\"/>\"<br/>\r\nPassword: \"<inp2:u_Field name=\"Password_plain\"/>\"<br/>\r\n==================<br/><br/>\r\n','','0',''),('6','USER.VALIDATE','1','New User Registration is Validated','User \"<inp2:u_Field name=\"Username\"/>\" has been validated.','','0','') 

 in ...\core\kernel\utility\logger.php on line 888

Stack trace:

The problem happens because of missing "TranslateFrom" field declaration in the "email-template" unit. The is even bigger problem, because field was declared after commits, related to  INP-825 - Getting issue details... STATUS  task, but later was removed by incorrectly solving merge conflict in http://fisheye.in-portal.org/changelog/In-Portal?cs=15677 commit (the "emailevents" unit was renamed to "email-template" in 5.2.x, but was changed in both 5.2.x and 5.3.x).

Solution

Locate all code fragments in all files affected by merge, that might have been deleted by accident and manually put them back.

Related Tasks

INP-1505 - Getting issue details... STATUS