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

another 500 error when adding custom field

14 years 9 months ago #722 by iammontoya
Hi.. Im trying to get this to work. I entered the sql query that was outlined in the other post and it worked. However, now I get this error

500 - An error has occurred.

TableCustomfield::store failed - Unknown column 'tooltip' in 'field list' SQL=INSERT INTO `jos_contact_enhanced_cf` ( `id`,`name`,`published`,`required`,`ordering`,`catid`,`type`,`value`,`attributes`,`tooltip`,`params` ) VALUES ( '','Company Name','1','1','1','8','text','','','','' )



Can you please help?

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

14 years 9 months ago #723 by douglas
Dear Inigo,

Which Contact Enhanced version do you have installed?

Regards,

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

14 years 9 months ago #724 by iammontoya
I just got it in the mail a few minutes ago.

com_contact_enhanced_1.5.4_090729_1317

Thank you in advance for the help.

The problem seems to happen as I try to add a custom field.

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

14 years 9 months ago #725 by douglas
Dear Inigo,

That's odd. I'm using that same version on my testing server and it is working all right.

Do you have access to PHPMyAdmin? Can you please verify if you have the tooltip field in the jos_contact_enhanced_cf table?

Regards,

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

14 years 9 months ago #726 by iammontoya
it does not exist there. The fields I have there are:

Field Type Collation Attributes Null Default Extra Action
id int(3) No None auto_increment
name varchar(100) latin1_swedish_ci No None
required tinyint(1) No 0
type varchar(20) latin1_swedish_ci No None
value mediumtext latin1_swedish_ci No None
ordering tinyint(4) No None
catid int(11) No None
published tinyint(1) No 1
attributes

that is all I have.

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

14 years 9 months ago #727 by douglas
That's strange! Are you upgrading from an older version?

Please run this script in PHPMyAdmin:
DROP TABLE IF EXISTS `jos_contact_enhanced_cf`;
CREATE TABLE  `jos_contact_enhanced_cf` (
  `id` int(3) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `label` varchar(200) NOT NULL,
  `required` tinyint(1) NOT NULL default '0',
  `type` varchar(20) NOT NULL,
  `value` mediumtext NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `catid` int(11) NOT NULL,
  `published` tinyint(1) NOT NULL default '1',
  `attributes` mediumtext,
  `tooltip` varchar(255) default NULL,
  `iscore` tinyint(1) NOT NULL default '0',
  `params` mediumtext,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
 
 
INSERT INTO `jos_contact_enhanced_cf` (`id`, `name`, `required`, `type`, `value`, `ordering`, `catid`, `published`, `attributes`, `tooltip`, `iscore`, `params`) VALUES
(1, 'Name', 1, 'name', '', 1, 0, 1, '', '', 1, NULL),
(2, 'Email', 1, 'email', '', 2, 0, 1, 'maxlength="100"', '', 1, NULL),
(3, 'Subject', 1, 'subject', '', 3, 0, 1, '', '', 1, NULL),
(4, 'Enter your Message', 1, 'multitext', '', 4, 0, 1, '', '', 0, NULL);

Regards,

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