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) »
  • 4.1.2 -> 4.2.8 Error
Pages: [1]

Author Topic: 4.1.2 -> 4.2.8 Error  (Read 1113 times)

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
4.1.2 -> 4.2.8 Error
March 07, 2013, 04:25:52 am
I am trying to upgrade a site from civicrm-4.1.2-drupal6 to civicrm-4.2.8-drupal6 and it fails on [Error: Upgrade DB to 4.2.alpha1: Price Sets] with:

Code: [Select]
SELECT title FROM civicrm_price_field where id =4
[nativecode=1054 ** Unknown column 'title' in 'field list']

This field does not appear to exist in 4.2.8 nor in 4.1.2, at least not on this site. The text "SELECT title FROM civicrm_price_field" does not appear in the codebase, so it appears to be a dynamically-generated query. I could just add that field temporarily to proceed, but I'm wondering what this query thinks it's doing....
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: 4.1.2 -> 4.2.8 Error
March 07, 2013, 01:46:19 pm
civicrm_price_field does exist in 4.2 as well as 4.1. Can you re-check the integrity of your db?
Try asking your question on the new CiviCRM help site.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: 4.1.2 -> 4.2.8 Error
March 08, 2013, 06:12:36 am
Quote from: Coleman Watts on March 07, 2013, 01:46:19 pm
civicrm_price_field does exist in 4.2 as well as 4.1.

Of course it does. The issue is not the existence of the table. The error is the non-existence of a field called title within that table. I see no such field.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: 4.1.2 -> 4.2.8 Error
March 08, 2013, 10:31:19 am
Ah, you're right it does not exist. I checked 4.1 and 4.2. The table has fields "name" and "label" but not "title".
Can you generate a backtrace to try to find where that code is coming from?
Try asking your question on the new CiviCRM help site.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: 4.1.2 -> 4.2.8 Error
March 10, 2013, 08:15:10 am
Here you are:

Code: [Select]
[Error: Upgrade DB to 4.2.alpha1: Price Sets]
Error Field Error Value
Type DB_Error
Code -19
Message DB Error: no such field
Mode 16
UserInfo SELECT title FROM civicrm_price_field where id =4 [nativecode=1054 ** Unknown column 'title' in 'field list']
DebugInfo SELECT title FROM civicrm_price_field where id =4 [nativecode=1054 ** Unknown column 'title' in 'field list']
PEAR_Exception: DB Error: no such field in unknown on line unknown
- DB_Error: DB Error: no such field in unknown on line unknown
Exception trace
# Function Location
0 CRM_Core_Error::exceptionHandler(Object(DB_Error)) unknown:unknown
1 call_user_func(Array, Object(DB_Error)) /home/mycivisite/www/www/sites/all/modules/civicrm/packages/PEAR.php:931
2 PEAR_Error->PEAR_Error('DB Error: no suc…', -19, 16, Array, 'SELECT title FRO…') /home/mycivisite/www/www/sites/all/modules/civicrm/packages/DB.php:968
3 DB_Error->DB_Error(-19, 16, Array, 'SELECT title FRO…') /home/mycivisite/www/www/sites/all/modules/civicrm/packages/PEAR.php:564
4 PEAR->raiseError(null, -19, null, null, 'SELECT title FRO…', 'DB_Error', true) /home/mycivisite/www/www/sites/all/modules/civicrm/packages/DB/common.php:1903
5 DB_common->raiseError(-19, null, null, null, '1054 ** Unknown …') /home/mycivisite/www/www/sites/all/modules/civicrm/packages/DB/mysql.php:898
6 DB_mysql->mysqlRaiseError() /home/mycivisite/www/www/sites/all/modules/civicrm/packages/DB/mysql.php:327
7 DB_mysql->simpleQuery('SELECT title FRO…') /home/mycivisite/www/www/sites/all/modules/civicrm/packages/DB/common.php:1216
8 DB_common->query('SELECT title FRO…') /home/mycivisite/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php:2421
9 DB_DataObject->_query('SELECT title FRO…') /home/mycivisite/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php:1613
10 DB_DataObject->query('SELECT title FRO…') /home/mycivisite/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php:155
11 CRM_Core_DAO->query('SELECT title FRO…', true) /home/mycivisite/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php:964
12 CRM_Core_DAO::singleValueQuery('SELECT title FRO…', Array) /home/mycivisite/www/www/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourTwo.php:422
13 CRM_Upgrade_Incremental_php_FourTwo::createPriceSet(Array, Array, Array) /home/mycivisite/www/www/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourTwo.php:376
14 CRM_Upgrade_Incremental_php_FourTwo::task_4_2_alpha1_createPriceSets(Object(CRM_Queue_TaskContext), '4.2.alpha1') unknown:unknown
15 call_user_func_array(Array, Array) /home/mycivisite/www/www/sites/all/modules/civicrm/CRM/Queue/Task.php:79
16 CRM_Queue_Task->run(Object(CRM_Queue_TaskContext)) /home/mycivisite/www/www/sites/all/modules/civicrm/CRM/Queue/Runner.php:187
17 CRM_Queue_Runner->runNext(true) /home/mycivisite/www/www/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:44
18 {closure}() /home/mycivisite/www/www/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php:80
19 CRM_Queue_ErrorPolicy->call(Object(Closure)) /home/mycivisite/www/www/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:47
20 CRM_Queue_Page_AJAX::runNext(Array) unknown:unknown
21 call_user_func(Array, Array) /home/mycivisite/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php:187
22 CRM_Core_Invoke::_invoke(Array) /home/mycivisite/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php:51
23 CRM_Core_Invoke::invoke(Array) /home/mycivisite/www/www/sites/all/modules/civicrm/drupal/civicrm.module:382
24 civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext') unknown:unknown
25 call_user_func_array('civicrm_invoke', Array) /home/mycivisite/www/www/includes/menu.inc:350
26 menu_execute_active_handler() /home/mycivisite/www/www/index.php:17
27 {main}

What I did to continue was to make this title field and then run:

Code: [Select]
UPDATE `civicrm_price_field` SET `title` = `label` ;

and then the upgrade worked.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: 4.1.2 -> 4.2.8 Error
March 11, 2013, 07:07:40 am
When trying to add a contribution now, we get:

Code: [Select]
    SELECT
       DISTINCT ( price_set_id ) as id, title
    FROM
       civicrm_price_field,
       civicrm_price_set
    WHERE
       civicrm_price_set.id = civicrm_price_field.price_set_id  AND is_quick_config = 0  AND civicrm_price_set.is_active = 1  AND civicrm_price_set.extends LIKE '%2%' 
       
       [nativecode=1052 ** Column 'title' in field list is ambiguous]"]

So I dropped that field I made. :)
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: 4.1.2 -> 4.2.8 Error
March 13, 2013, 03:38:20 pm
I've looked at the code, I can see where the query is being generated but don't see how 'title' would get in there (also the line numbers don't match with your backtrace which makes it harder -- possibly that means this has been fixed in 4.3?)
Try asking your question on the new CiviCRM help site.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: 4.1.2 -> 4.2.8 Error
March 14, 2013, 03:30:59 am
> possibly that means this has been fixed in 4.3?

Perhaps. Anyhow I never saw this particular error before in an upgrade so it may be a marginal case.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • 4.1.2 -> 4.2.8 Error

This forum was archived on 2017-11-26.