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.

  1. Forum
  3. Ideal Joomla Extensions
  5. Component: Contact Enhanced
  7. recorded messages in backend shows 500 Unkown column 'a.checked_out' in 'on cla
× 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

recorded messages in backend shows 500 Unkown column 'a.checked_out' in 'on cla

1 year 8 months ago #26390 by gdietz68
Hallo,

after updating joomla 4 and contact enhanced 4.1, in backend recorded messages shows an error 500 Unknown column 'a.checked_out' in 'field list' Unknown column 'a.checked_out' in 'on clause'.
There were recorded messages before the update from Joomla 3.10.10 to 4.1.5
Do you have any idea?
Joomla 4.1.5 - Contact Enhanced V4.1/3.10.5 - PHP 7.4.30

many regards
G.Dietz

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

1 year 8 months ago #26391 by support
Dear G.Dietz,

I'm unsure why the Update SQL script for the Messages table was not executed. Anyway, you can replace #__ in the SQL statements below with your Joomla Database Table Prefix and execute them using PHPMyAdmin.
Run each statement separately.
You might see an error when you execute these next two SQL statements because the script might already have dropped the ID column and added the Primary Key. If so, you can just ignore the error and execute the other two statements.
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`
  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;
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`;

Let me know if it works for you.

Best regards,
Douglas Machado
iStoreLocator | iFAQ | Ideal Related Articles | Contact Enhanced

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

1 year 8 months ago #26392 by gdietz68
Thank you very much for your fast answer.
It works!!!

best regards
G.Dietz

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

  1. Forum
  3. Ideal Joomla Extensions
  5. Component: Contact Enhanced
  7. recorded messages in backend shows 500 Unkown column 'a.checked_out' in 'on cla
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