Support Forum

Every time that you post a problem, PLEASE add the Joomla and the extension's versions and revisions (for example: Joomla 3.3.6, Contact Enhanced 3.3.5), PHP version and Server's Operating System. If you only manage only one site it is easier if you edit your profile and just add that information to your signature. Don't forget to add a detailed description of the problem. If possible, write down all steps to simulate the problem.

Before submitting a new post, PLEASE make sure you are running the latest version, test in different browsers (IE, FF, Chrome,..) and clear Joomla and browser's cache after every change you make.

Also, most questions are already answered in our FAQ and in iFAQ and Contact Enhanced documentation pages.

× Contact Enhanced is a contact component manager created to replace Joomla! core contacts component and add lots of advantages and new features (see Features ) and it offers many plugins and modules for several different purposes,
Product page | Documentation Page

Error Table::store() for #__ce_messages Field 'email_cc' doesn't have a default

2 months 3 weeks ago #26491 by gdietz68
Hallo,

When I send an email with the contact form in the frontend, the error message appears and no message is saved in backend:
Error Table::store() for #__ce_messages Field 'email_cc' doesn't have a default.

I have updated to the latest version.
Joomla 4.2.2 - Contact Enhanced Pro 4.2 - PHP 7.4.30

many thanks and regards

Gabi Dietz

Please Log in or Create an account to join the conversation.

2 months 3 weeks ago #26495 by support
Dear Gabi,

Is this a fresh Contact Enhanced installation, or have you updated it from Joomla 3.9?

Do you have access to PHPMyAdmin? If so, can you please run the following SQL statements one by one? Just replace #__ with your Joomla database table prefix.
ALTER TABLE `#__ce_message_fields` DROP `id`;
 
ALTER TABLE `#__ce_message_fields` ADD PRIMARY KEY( `message_id`, `field_id`),
  CHANGE `value` `value` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL;
 
ALTER TABLE `#__ce_messages`
  ADD `checked_out` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `utm_campaign`,
  ADD `checked_out_time` DATETIME NULL AFTER `checked_out`;
 
ALTER TABLE `#__ce_messages`
  CHANGE `email_to` `email_to` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  CHANGE `email_cc` `email_cc` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  CHANGE `email_bcc` `email_bcc` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  CHANGE `comments` `comments` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  CHANGE `reply_date` `reply_date` DATETIME NULL,
  CHANGE `replied_by` `replied_by` INT(11) UNSIGNED NULL,
  CHANGE `message` `message` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  CHANGE `message_html` `message_html` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  CHANGE `utm_source` `utm_source` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  CHANGE `utm_medium` `utm_medium` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  CHANGE `utm_term` `utm_term` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  CHANGE `utm_content` `utm_content` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  CHANGE `utm_campaign` `utm_campaign` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL;

Don't worry if you get errors executing the first 3 statements, it means the statements were already executed correctly when you first migrated Contact Enhanced to Joomla 4.

Best regards,

Please Log in or Create an account to join the conversation.

2 months 3 weeks ago #26502 by gdietz68
Hi Douglas,

thank you very much for your quick answer.

Sorry, but die Script doesn´t work.
I changed the prefix and copied and insert the scripts

First:
'id' doesn`t exist in the table #_ce_message_fields.

Error at the script:
ALTER TABLE `#__ce_message_fields` ADD PRIMARY KEY( `message_id`, `field_id`),
CHANGE `value` `value` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL;
- Message -> #1068 - Multible primary key defined (PRIMARY KEY)

ALTER TABLE `#__ce_messages`
ADD `checked_out` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `utm_campaign`,
ADD `checked_out_time` DATETIME NULL AFTER `checked_out`;
- Message -> #1060 - duplicate column name

ALTER TABLE `#__ce_messages`
CHANGE `email_to` `email_to` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
CHANGE `email_cc` `email_cc` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
CHANGE `email_bcc` `email_bcc` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
CHANGE `comments` `comments` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
CHANGE `reply_date` `reply_date` DATETIME NULL,
CHANGE `replied_by` `replied_by` INT(11) UNSIGNED NULL,
CHANGE `message` `message` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
CHANGE `message_html` `message_html` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
CHANGE `utm_source` `utm_source` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
CHANGE `utm_medium` `utm_medium` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
CHANGE `utm_term` `utm_term` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
CHANGE `utm_content` `utm_content` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
CHANGE `utm_campaign` `utm_campaign` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL;
- Message -> #1292 - incorrect date value '0000-00-00 00:00:00' from field 'reply_date' in Zeile 1

much regards

Gabi Dietz

Please Log in or Create an account to join the conversation.

2 months 3 weeks ago #26504 by gdietz68
Hi Douglas,

i forgot: I have updated from Joomla 3.10.10 to Joomla 4.1.5.

Now i´ve Joomla 4.2.2.

Thanks a lot
Gabi Dietz

Please Log in or Create an account to join the conversation.

2 months 3 weeks ago #26507 by support
Dear Gabi,

I was expecting to see all these errors except the last one. I was just checking the MySQL database documentation and the latest versions do not allow zero dates by default. We already knew that and Contact Enhanced no longer uses zero dates. However, we didn't expect to have a problem with existing values.

In order to fix that, please run the SQL Statement below and the last one from my previous post.
UPDATE `#__ce_messages` SET `reply_date` = NULL WHERE `reply_date` < '0001-01-01 00:00:00';

I've already added this to the update script for the next version.

Let me know if you encounter any further issues.

Have a blessed weekend,

Please Log in or Create an account to join the conversation.

2 months 2 weeks ago #26518 by gdietz68
Hallo Douglas,

thank you for your help.

Now the recorded messages are shown in backend and there is no error by sending the form.

much regards

Gabi

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum

Copyright © 2018 IdealExtensions.com. All Rights Reserved.

This site is not affiliated with or endorsed by the Joomla!™ Project. It is not supported or warranted by the Joomla!™ Project or Open Source Matters™. The Joomla!™ logo is used under a limited license granted by Open Source Matters™, the trademark holder in the United States and other countries.
We may collect your IP address and your browser's User Agent string while using our site for security reasons and deriving aggregate information (analytics). This information is retained for a minimum of 1 and a maximum of 24 months.
Feedback