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) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.1 Release Testing »
  • Database Error Code: Unknown column 'name' in 'field list', 1054
Pages: [1]

Author Topic: Database Error Code: Unknown column 'name' in 'field list', 1054  (Read 23343 times)

jeffsensat

  • Guest
Database Error Code: Unknown column 'name' in 'field list', 1054
September 30, 2008, 03:55:47 am
SYSTEM: Drupal 6.4 / CiviCRM 2.1 Beta 6 / PHP 5.2.6 / MySQL 5.0.16

I have a user in my CiviCRM 2.1b6 database who’s a member of a household. He’s also been assigned sibling and spouse relationships, all of whom are members of the same household. Instead of inputting specific Home phone / address / etc. info, I’ve left those fields blank and am, instead, trying to assign his record to a household by selecting “Use Household Address.” I get this error:

Code: [Select]
Sorry. A non-recoverable error has occurred.
DB Error: no such field

Database Error Code: Unknown column 'name' in 'field list', 1054
Error Details indicate:

Code: [Select]
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , street_address , street_number , street_number_suffix , street_number_predirectional , street_name , street_type , street_number_postdirectional , street_unit , supplemental_address_1 , supplemental_address_2 , supplemental_address_3 , city , county_id , state_province_id , postal_code_suffix , postal_code , usps_adc , country_id , geo_code_1 , geo_code_2 , name ) VALUES ( 1338 ,  1 ,  1 ,  0 , '11323 Riverstone Lake Ln' ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL , 'Houston' ,  NULL ,  NULL , '3608' , '77089' ,  NULL ,  1228 ,  NULL ,  NULL ,  NULL )  [nativecode=1054 ** Unknown column 'name' in 'field list']
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , street_address , street_number , street_number_suffix , street_number_predirectional , street_name , street_type , street_number_postdirectional , street_unit , supplemental_address_1 , supplemental_address_2 , supplemental_address_3 , city , county_id , state_province_id , postal_code_suffix , postal_code , usps_adc , country_id , geo_code_1 , geo_code_2 , name ) VALUES ( 1338 ,  1 ,  1 ,  0 , '11323 Riverstone Lake Ln' ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL , 'Houston' ,  NULL ,  NULL , '3608' , '77089' ,  NULL ,  1228 ,  NULL ,  NULL ,  NULL )  [nativecode=1054 ** Unknown column 'name' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , street_address , street_number , street_number_suffix , street_number_predirectional , street_name , street_type , street_number_postdirectional , street_unit , supplemental_address_1 , supplemental_address_2 , supplemental_address_3 , city , county_id , state_province_id , postal_code_suffix , postal_code , usps_adc , country_id , geo_code_1 , geo_code_2 , name ) VALUES ( 1338 ,  1 ,  1 ,  0 , '11323 Riverstone Lake Ln' ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL ,  NULL , 'Houston' ,  NULL ,  NULL , '3608' , '77089' ,  NULL ,  1228 ,  NULL ,  NULL ,  NULL )  [nativecode=1054 ** Unknown column 'name' in 'field list']"]
)
Additionally, this error info is printed in the page header area:

Code: [Select]
/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 138, handle,
/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912
/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 966
/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 574
/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2394
/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1039
/sites/all/modules/civicrm/CRM/Core/DAO.php, insert, 279
/sites/all/modules/civicrm/CRM/Core/BAO/Address.php, save, 144
/sites/all/modules/civicrm/CRM/Core/BAO/Address.php, add, 116
/sites/all/modules/civicrm/CRM/Core/BAO/Location.php, create, 82
/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php, create, 255
/sites/all/modules/civicrm/CRM/Contact/Form/Edit.php, create, 678
/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 247
/sites/all/modules/civicrm/CRM/Core/StateMachine.php, mainProcess, 166
/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 232
/sites/all/modules/civicrm/CRM/Utils/Wrapper.php, run, 114
/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 169
/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 315, civicrm_invoke,
/includes/menu.inc, call_user_func_array, 346
/index.php, menu_execute_active_handler, 18

Any ideas?

Thanks.
[/code]

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Database Error Code: Unknown column 'name' in 'field list', 1054
September 30, 2008, 04:45:07 am
Have you done fresh 2.1beta6 install ?

Kurund
Found this reply helpful? Support CiviCRM

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Database Error Code: Unknown column 'name' in 'field list', 1054
September 30, 2008, 04:47:49 am
1. was this a new install or upgrade

2. if upgrade, what version did u upgrade to initially?

3. If new, its a bit wierd, since name is a column in civicrm_address table. can u check your civicrm.mysql file and ensure its there

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

jeffsensat

  • Guest
Re: Database Error Code: Unknown column 'name' in 'field list', 1054
September 30, 2008, 05:05:26 am
Kurund:

I think I started using CiviCRM at beta 3 or 4. When each newer version was released, I would completely trash the existing “civicrm” module folder in my Drupal installation and replace it with the newest beta release.

Donald:

1. This was an upgrade. And, I religiously run Drupal’s update.php each time an updated module is installed.
2. Not sure what you mean. I started using CiviCRM around beta 3 or 4, I think.
3. My civicrm.sql is definitely there. I’m doing lots of OTHER work with CiviCRM right now, including importing contacts, massaging data, creating relationships, assigning groups, etc.

Thanks for the brain power, folks ...

Everything BUT this feature seems to be working for me at the moment.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Database Error Code: Unknown column 'name' in 'field list', 1054
September 30, 2008, 05:18:47 am
Can you check if your civicrm_address table has field "name" ?  We added this field in CiviCRM 2.1 alpha 4.

Kurund
Found this reply helpful? Support CiviCRM

jeffsensat

  • Guest
Re: Database Error Code: Unknown column 'name' in 'field list', 1054
September 30, 2008, 05:33:21 am
Kurund —

You may be on to something. It doesn’t look like my “civicrm_address” table has a “name” field. Take a look:

(http://slightlyoffcenterplayers.com/misc/civicrm/mysql_namesearch.png)

I’m no programmer, but I’m SOMEWHAT savvy. If you can tell me what to do, and there’s a solution, I might be able to tackle it.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Database Error Code: Unknown column 'name' in 'field list', 1054
September 30, 2008, 05:34:36 am

run this sql using PMA

ALTER TABLE `civicrm_address`
 ADD `name` varchar(255) collate utf8_unicode_ci DEFAULT NULL ;

A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

jeffsensat

  • Guest
Re: Database Error Code: Unknown column 'name' in 'field list', 1054
September 30, 2008, 05:55:12 am
Donald —

Ding-ding-ding! Ran your sql and that did it. I’m now able to designate “Use Household Address” to contacts now.

I appreciate both you and Kurund helping me out of the tar pit.

Thanks so much for the QUICK help and EXACT instructions.

 :D

For the record, would this error have occured because of something I did, or is it a CiviCRM issue? (It’d be nice if others didn’t experience the same thing, if it can be fixed in CiviCRM.)

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Database Error Code: Unknown column 'name' in 'field list', 1054
September 30, 2008, 10:04:03 am

This was an upgrade issue. name was added in the last alpha or first beta, and we dont support db changes between alpha's. CiviCRM does not follow drupal's update protocol

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.1 Release Testing »
  • Database Error Code: Unknown column 'name' in 'field list', 1054

This forum was archived on 2017-11-26.