CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Resolved: Unknown column 'modified_id' in 'field list' saving new group 4.5.5
Pages: [1]

Author Topic: Resolved: Unknown column 'modified_id' in 'field list' saving new group 4.5.5  (Read 400 times)

ericross

  • I’m new here
  • *
  • Posts: 27
  • Karma: 0
  • civiadmin
    • National Day of Prayer New York
  • CiviCRM version: 4.6.2
  • CMS version: WordPress 4.1.1
  • MySQL version: 5.5.40-36.1
  • PHP version: 5.4.38
Resolved: Unknown column 'modified_id' in 'field list' saving new group 4.5.5
February 02, 2015, 07:28:10 pm
Saving contacts to a new group fails. modified_id has been added to the table but is not part of the query.


    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_group (name , title , description , is_active , visibility , group_type , created_id ) VALUES ('Fix_Blank_City_tmp' , 'Fix Blank City' ,  NULL ,  1 , 'User and User Admin Only' , '12' ,  1954 )  [nativecode=1054 ** Unknown column 'modified_id' in 'field list']
    [type] => DB_Error
« Last Edit: February 03, 2015, 01:58:04 pm by ericross »
Usability Matters.

ericross

  • I’m new here
  • *
  • Posts: 27
  • Karma: 0
  • civiadmin
    • National Day of Prayer New York
  • CiviCRM version: 4.6.2
  • CMS version: WordPress 4.1.1
  • MySQL version: 5.5.40-36.1
  • PHP version: 5.4.38
Re: Resolved: Unknown column 'modified_id' in 'field list' saving new group 4.5.5
February 03, 2015, 02:04:30 pm
Unknown column 'XXXXX' in 'field list' - Check log tables for missing field.


For whatever reason, the log table was required.

Logging caused problems for me in 4.5.1 so I turned it off. The log tables were still in the schema but were not upgraded properly during the 4.5.5 upgrade. The field 'modified_id' did not exist in the log table. Once I added this field, I was able to save a new group.
« Last Edit: February 03, 2015, 02:06:05 pm by ericross »
Usability Matters.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Resolved: Unknown column 'modified_id' in 'field list' saving new group 4.5.5

This forum was archived on 2017-11-26.