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 »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Error on Contact Screen's Group Tab: DB Error: no such field
Pages: [1]

Author Topic: Error on Contact Screen's Group Tab: DB Error: no such field  (Read 4404 times)

zkrebs

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 1
Error on Contact Screen's Group Tab: DB Error: no such field
April 24, 2013, 12:14:55 pm
Got this message after upgrading to CiviCRM 4.3.1

One weird thing - we upgraded our version of PHP to support the new CiviCRM (required 5.3.3 + ), and our site wouldn't work unless we changed the civicrm.settings.php CiviCRM 4.3.1 to use 127.0.0.1 instead of localhost - could that be the problem?

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Error on Contact Screen's Group Tab: DB Error: no such field
April 24, 2013, 12:47:18 pm
can you copy paste the entire error message/log

-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

zkrebs

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 1
Re: Error on Contact Screen's Group Tab: DB Error: no such field
April 24, 2013, 01:46:06 pm
Sorry but we are not able to provide this at the moment.
DB Error: no such field
Return to home page.


Is there a place/way I could get you a more detailed log?

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Error on Contact Screen's Group Tab: DB Error: no such field
April 24, 2013, 01:59:47 pm
can you turn your debug settings

Administer > System Setting > Debugging and Error Handling

enable debug and backtrace
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

zkrebs

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 1
Re: Error on Contact Screen's Group Tab: DB Error: no such field
April 24, 2013, 02:05:30 pm
Database Error Code: Unknown column 'price_field_' 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_8c1c6423d53b358b23cece88928d598c
SET price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1
WHERE participant_id = 448;
 [nativecode=1054 ** Unknown column 'price_field_' in 'field list']
    [type] => DB_Error
    [user_info] =>
UPDATE civicrm_temp_custom_8c1c6423d53b358b23cece88928d598c
SET price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1
WHERE participant_id = 448;
 [nativecode=1054 ** Unknown column 'price_field_' 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_8c1c6423d53b358b23cece88928d598c
SET price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1
WHERE participant_id = 448;
 [nativecode=1054 ** Unknown column 'price_field_' in 'field list']"]
)

zkrebs

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 1
Re: Error on Contact Screen's Group Tab: DB Error: no such field
May 13, 2013, 08:38:38 am
Is there any advise on how to fix this? I tried updating / deleting some price set rows, and I just kept getting the error.

Help?

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: Error on Contact Screen's Group Tab: DB Error: no such field
May 13, 2013, 08:52:17 am
Can you try clearing civicrm cache? It might also be possible that you have created a smart group using custom search etc, that might be the issue.

HTh
Kurund
Found this reply helpful? Support CiviCRM

zkrebs

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 1
Re: Error on Contact Screen's Group Tab: DB Error: no such field
May 13, 2013, 10:51:40 am
Cleared the cache twice, did not solve.

I do have custom smart groups - how would I identify which one is wrong?

Also, in another thread I see this:

Quote
We had tesame issue, a "Unknown column 'price_field_1' in 'field list'" error occured.

Thanks to Lobo's direction we descovered that event-manager changed the price-list, after he add 3 persons to the event with the old price-list.

We solved it by :

1) looking into this query (in file PriceSet.php)
        $sql = "
SELECT c.id as contact_id,
       p.id as participant_id,
       l.price_field_value_id as price_field_value_id,
       l.qty
FROM   civicrm_contact c,
       civicrm_participant  p,
       civicrm_line_item    l       
WHERE  c.id = p.contact_id
AND    p.event_id = {$this->_eventID}
AND    p.id = l.entity_id
AND    l.entity_table ='civicrm_participant'
ORDER BY c.id, l.price_field_value_id;
";

2) We have changed the fields 'price_field_id' and 'price_field_value_id' in the table 'civicrm_line_item' where the 'entity_id' equals the 'participant_id' in your error message.
Look at the 'id' field into the tables 'civicrm_price_field' and 'civicrm_price_field_value' for the correct values you can use for the 'price_field_id' and 'price_field_value_id'

Peter

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: Error on Contact Screen's Group Tab: DB Error: no such field
May 14, 2013, 02:50:39 pm

zkrebs:

so most likely this is the price set custom search that is throwing the error. A few options:

a. In 4.3.3, u can disable these groups and it will no longer be computed, which should prevent the fatal. Probably your best short term option

b. Might want to investigate the solution proposed in the quoted text and see if you can debug the issue and preferably also create a patch that fixes the issue

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

zkrebs

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 1
Re: Error on Contact Screen's Group Tab: DB Error: no such field
June 05, 2013, 11:21:28 am
I disabled the custom price set search in Civi 4.3.3 and now get

"Sorry but we are not able to provide this at the moment.
Could not resolve custom search ID
Return to home page."

Also, I attempted the other solution but was unable to fix it.

Any way to keep going with the above solution?
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Error on Contact Screen's Group Tab: DB Error: no such field

This forum was archived on 2017-11-26.