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. 500 error
× 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

500 error

15 years 1 week ago - 15 years 1 week ago #118 by candisseverett
It seems that by installing this component, it did not set up the mysql database. I get this 500 error when trying to add a custom field:

TableCustomfield::store failed - Table 'candisse_synergy.jos_contact_enhanced_cf' doesn't exist
SQL=INSERT INTO `jos_contact_enhanced_cf` ( `id`,`name`,`published`,`required`,`ordering`,`catid`,`type`,`attributes` )
VALUES ( '','First Annuitant Name','1','0','','2','text','' )

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

15 years 1 week ago #119 by candisseverett
I need to get this up and running soon - can anyone help me set up the mysql?

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

15 years 1 week ago - 15 years 1 week ago #120 by candisseverett
This is what I get when I try to add a contact:

TableContact::store failed - Table 'candisse_synergy.jos_contact_enhanced_details' doesn't exist
SQL=INSERT INTO `jos_contact_enhanced_details` ( `id`,`name`,`alias`,`con_position`,`address`,`suburb`,`state`, `country`, `postcode`, `telephone`, `fax`, `misc`, `image`, `email_to`, `default_con`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `user_id`, `catid`, `access`, `mobile`, `webpage` ) VALUES ( '','Income Case Designing','income-case-designing', ','','','','','','','','','','','0','1','0','0','', 'show_name=1 \nshow_position=1 \nshow_email=0\nshow_street_address=1 \nshow_suburb=1 \nshow_state=1\nshow_postcode=1\nshow_country=1\nshow_telephone=1 \nshow_mobile=1 \nshow_fax=1\nshow_webpage=1 \nshow_misc=1\nshow_image=1 \nallow_vcard=0\ncontact_icons=0 \nicon_address=\nicon_email= \nicon_telephone= \nicon_mobile=\nicon_fax= \nicon_misc= \nshow_email_form=1 \nemail_description=\nshow_email_copy=1 \nbanned_email= \nbanned_subject= \nbanned_text=','0','2','0','','' )

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

15 years 1 week ago #121 by
Dear Candiss,

That's really odd!

Do you have access to PHPMyAdmin?
Please run the following SQL Queries:
CREATE TABLE IF NOT EXISTS `jos_contact_enhanced_cf` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) 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` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
)  ;
CREATE TABLE IF NOT EXISTS `jos_contact_enhanced_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `con_position` varchar(255) DEFAULT NULL,
  `address` text,
  `suburb` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `postcode` varchar(100) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `misc` mediumtext,
  `image` varchar(255) DEFAULT NULL,
  `imagepos` varchar(20) DEFAULT NULL,
  `email_to` varchar(255) DEFAULT NULL,
  `default_con` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `published` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `catid` int(11) NOT NULL DEFAULT '0',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `mobile` varchar(255) NOT NULL DEFAULT '',
  `webpage` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `catid` (`catid`)
) ;

Regards,

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

15 years 1 week ago #122 by justin
Hi, I just purchased this component and have the same issue!

It installed fine, I added the component as a menu item, created the catagories I needed without issue.

When I attempt to create a contact or custom field I get
500 - An error has occurred.

Please help!

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

15 years 1 week ago #123 by
Dear Justin,

Please run the SQL queries that I wrote on the previous post.
That should fix it.

Which Joomla version do you have installed?

Regards,

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

15 years 1 week ago #124 by justin
I'll try that. I have 1.5 installed

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

15 years 1 week ago #125 by candisseverett
It worked like a charm for me.

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

15 years 1 week ago #126 by justin
Thanks! it worked!

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

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