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 »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • DB Error: No Such Field (On Price Set Custom Field Export)
Pages: [1]

Author Topic: DB Error: No Such Field (On Price Set Custom Field Export)  (Read 736 times)

zkrebs

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 1
DB Error: No Such Field (On Price Set Custom Field Export)
June 20, 2014, 06:35:38 pm
Help!
Drupal 7, CiviCRM 4.4.4

Database Error Code: Unknown column 'price_field_438' in 'field list', 1054
Additional Details:
Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] =>
UPDATE civicrm_temp_custom_20187c4970e7d90400b605b40089672e
SET price_field_438 = 1
WHERE participant_id = 1130;
 [nativecode=1054 ** Unknown column 'price_field_438' in 'field list']
    [type] => DB_Error
    [user_info] =>
UPDATE civicrm_temp_custom_20187c4970e7d90400b605b40089672e
SET price_field_438 = 1
WHERE participant_id = 1130;
 [nativecode=1054 ** Unknown column 'price_field_438' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
UPDATE civicrm_temp_custom_20187c4970e7d90400b605b40089672e
SET price_field_438 = 1
WHERE participant_id = 1130;
 [nativecode=1054 ** Unknown column 'price_field_438' in 'field list']"]
)
« Last Edit: June 21, 2014, 09:52:58 am by zkrebs »

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: DB Error: No Such Field (On Price Set Custom Field Export)
June 25, 2014, 04:14:09 am
Hard to know what may be wrong. Did you drop any fields ever? Or any price sets?

Do you know what field 438 is?
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.

zkrebs

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 1
Re: DB Error: No Such Field (On Price Set Custom Field Export)
July 22, 2014, 09:39:57 am
I think when we made our 2012 conference we used price sets for early bird and normal prices, made it live, and some may have been deleted in the process as our requirements changed. Any hope of what I can do to fix this? Field 438 - no idea!

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: DB Error: No Such Field (On Price Set Custom Field Export)
July 23, 2014, 10:13:56 am
Seems you may need to recreate that missing field, but you would probably need MySQL skills for that. You would have to create it normally through the CiviCRM interface and then edit the name in the database, in (at least) two places.

I'm guessing that's the fix that will be necessary. I'm not certain. You might want to hire a consultant.
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 »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • DB Error: No Such Field (On Price Set Custom Field Export)

This forum was archived on 2017-11-26.