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. Skype Required?
× 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

Skype Required?

1 year 9 months ago #26376 by trlbldr
When I attempt to add a new Contact, CE Pro returns this error message:
"Save failed with the following error: Field 'skype' doesn't have a default value".

Of course there is no default value. We don't use Skype and there is no specified field in the Contact form for Skype - one can add Skype (and other Social Media outlets) but none is required.

If I open a current Contact, modify it, and Save it, the Skype error does not occur; this only applies to a New Contact.

System info:

Joomla 4.1.5
PHP 8.0.21
MySQL 10.3.26-MariaDB
Contact Enhanced Pro v4.0.6.3
Don White
Sr. Technical Communicator

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

1 year 9 months ago - 1 year 9 months ago #26378 by support
Dear Don,

Skype is not required. This message is regarding the database table field. I have tested with MySQL and MariaDB and never got this error.

I have just checked the installation and update script and the default value for the database table column should be NULL.

Anyway, in order to make sure the default value is NULL, please replace the #__ with your database table prefix and run this SQL statement:
ALTER TABLE `#__ce_contacts`
	CHANGE `skype` `skype` VARCHAR(255) NULL,
	CHANGE `twitter` `twitter` VARCHAR(255)  NULL,
	CHANGE `facebook` `facebook` VARCHAR(255)  NULL,
	CHANGE `linkedin` `linkedin` VARCHAR(255)  NULL,
	CHANGE `google_plus` `google_plus` VARCHAR(255)  NULL,
	CHANGE `xreference` `xreference` VARCHAR(50)  NULL,
	CHANGE `extra_field_1` `extra_field_1` MEDIUMTEXT  NULL,
	CHANGE `extra_field_2` `extra_field_2` MEDIUMTEXT  NULL,
	CHANGE `extra_field_3` `extra_field_3` MEDIUMTEXT  NULL,
	CHANGE `extra_field_4` `extra_field_4` MEDIUMTEXT  NULL,
	CHANGE `extra_field_5` `extra_field_5` MEDIUMTEXT  NULL,
	CHANGE `extra_field_6` `extra_field_6` MEDIUMTEXT  NULL,
	CHANGE `extra_field_7` `extra_field_7` MEDIUMTEXT  NULL,
	CHANGE `extra_field_8` `extra_field_8` MEDIUMTEXT  NULL,
	CHANGE `extra_field_9` `extra_field_9` MEDIUMTEXT  NULL,
	CHANGE `extra_field_10` `extra_field_10` MEDIUMTEXT  NULL;

Also, this is a safe SQL statement and I have tested it before posting it here, but I always recommend creating a backup before making any changes in the database. Just to be on the safe side.

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

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

  1. Forum
  3. Ideal Joomla Extensions
  5. Component: Contact Enhanced
  7. Skype Required?
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