DB Error: No such field

[welly]

Hello all,

This is the strangest thing ever. On trying to create a new profile, I'm getting an error reporting: DB Error: No such field.

So I've checked my civi log and it gives me the following details on the error:

1054 ** Unknown column 'description' in 'field list'

The query being run is:

INSERT INTO civicrm_uf_group (is_active , title , description , help_pre , help_post , limit_listings_group_id , post_URL , add_to_group_id , add_captcha , is_map , is_edit_link , is_uf_link , is_update_dupe , cancel_URL , is_cms_user , notify , name , created_id , created_date , is_proximity_search ) VALUES ( 1 , 'Testing 321' , 'Testing' ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  0 ,  0 ,  0 ,  0 ,  0 ,  NULL ,  NULL ,  NULL , 'Testing_321' ,  2 ,  20140303120825 ,  0 );

I've gone into mysql to try to run this query and I'm getting the same error from SQL. Running SHOW CREATE TABLE civicrm_uf_group reports the following:

Code: [Select]

| civicrm_uf_group | CREATE TABLE `civicrm_uf_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique table ID',
  `is_active` tinyint(4) DEFAULT '1' COMMENT 'Is this form currently active? If false, hide all related fields for all sharing contexts.',
  `group_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'This column will store a comma separated list of the type(s) of profile fields.',
  `title` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Form title.',
  `description` text COLLATE utf8_unicode_ci COMMENT 'Optional verbose description of the profile.',
  `help_pre` text COLLATE utf8_unicode_ci COMMENT 'Description and/or help text to display before fields in form.',
  `help_post` text COLLATE utf8_unicode_ci COMMENT 'Description and/or help text to display after fields in form.',
  `limit_listings_group_id` int(10) unsigned DEFAULT NULL COMMENT 'Group id, foriegn key from civicrm_group',
  `post_URL` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Redirect to URL.',
  `add_to_group_id` int(10) unsigned DEFAULT NULL COMMENT 'foreign key to civicrm_group_id',
  `add_captcha` tinyint(4) DEFAULT '0' COMMENT 'Should a CAPTCHA widget be included this Profile form.',
  `is_map` tinyint(4) DEFAULT '0' COMMENT 'Do we want to map results from this profile.',
  `is_edit_link` tinyint(4) DEFAULT '0' COMMENT 'Should edit link display in profile selector',
  `is_uf_link` tinyint(4) DEFAULT '0' COMMENT 'Should we display a link to the website profile in profile selector',
  `is_update_dupe` tinyint(4) DEFAULT '0' COMMENT 'Should we update the contact record if we find a duplicate',
  `cancel_URL` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Redirect to URL when Cancle button clik .',
  `is_cms_user` tinyint(4) DEFAULT '0' COMMENT 'Should we create a cms user for this profile ',
  `notify` text COLLATE utf8_unicode_ci,
  `is_reserved` tinyint(4) DEFAULT NULL COMMENT 'Is this group reserved for use by some other CiviCRM functionality?',
  `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Name of the UF group for directly addressing it in the codebase',
  `created_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact, who created this UF group',
  `created_date` datetime DEFAULT NULL COMMENT 'Date and time this UF group was created.',
  `is_proximity_search` tinyint(4) DEFAULT '0' COMMENT 'Should we include proximity search feature in this profile search form?',
  PRIMARY KEY (`id`),
  KEY `FK_civicrm_uf_group_limit_listings_group_id` (`limit_listings_group_id`),
  KEY `FK_civicrm_uf_group_add_to_group_id` (`add_to_group_id`),
  KEY `FK_civicrm_uf_group_created_id` (`created_id`),
  CONSTRAINT `FK_civicrm_uf_group_add_to_group_id` FOREIGN KEY (`add_to_group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_uf_group_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_civicrm_uf_group_limit_listings_group_id` FOREIGN KEY (`limit_listings_group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |

Clearly the column does exist. I'm basically at my wits end!

Any ideas?

Thanks!

welly

[Eileen]

Is logging on? is there a table log_civicrm_uf_group?

[welly]

Hi Eileen,

In civicrm.settings.php, I have

define('CIVICRM_LOGGING_DSN', CIVICRM_DSN);

but have not set

define( 'CIVICRM_DEBUG_LOG_QUERY', 1 );

However, I'm still getting plenty of logging information in sites/default/files/civicrm/ConfigAndLog.

There is a log_civicrm_uf_group table as well as a bunch of other civicrm_log_* tables.

[Eileen]

I was meaning logging as configured on this screen

http://drupal.demo.civicrm.org/civicrm/admin/setting/misc?reset=1

[welly]

Oh, I've just disabled it. I'll test it again.

And apparently that's fixed it. Who'da thunk it? 

[Eileen]

I think if you enable it now you will be OK - but the problem would have been that the log_civicrm_* table was missing the description field