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 »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Event Fees Crashes with Error Message
Pages: [1]

Author Topic: Event Fees Crashes with Error Message  (Read 631 times)

markimus

  • I post occasionally
  • **
  • Posts: 75
  • Karma: 0
Event Fees Crashes with Error Message
December 04, 2012, 09:20:01 pm
I am running a D7 Civi 4.26
When I am setting up events all the event data is relatively easy yo enter but when I click on fees the System Crashes and throws this error
 Sorry but we are not able to provide this at the moment.
DB Error: no such field

I can't reproduce this on the demo site nor can I set up price sets through the admin console. 

any ideas where I can look to troubleshoot this error would be appreciated
Success is the ability to go from one failure to another with no loss of enthusiasm.

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Event Fees Crashes with Error Message
December 05, 2012, 02:04:21 am
Hi,

Can you enable debug and paste the detail of the error message? (it should mention what field is missing in which table).
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

markimus

  • I post occasionally
  • **
  • Posts: 75
  • Karma: 0
Re: Event Fees Crashes with Error Message
December 05, 2012, 07:50:27 am
Database Error Code: Unknown column 'is_quick_config' in 'where clause', 1054
Additional Details:
Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
  • [1] => handle
            )

       
Code: [Select]
=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] =>
    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 '%1%'  [nativecode=1054 ** Unknown column 'is_quick_config' in 'where clause']
    [type] => DB_Error
    [user_info] =>
    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 '%1%'  [nativecode=1054 ** Unknown column 'is_quick_config' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
    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 '%1%'  [nativecode=1054 ** Unknown column 'is_quick_config' in 'where clause']"]
)
Success is the ability to go from one failure to another with no loss of enthusiasm.

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: Event Fees Crashes with Error Message
December 05, 2012, 01:21:31 pm

seems like the result of a bad upgrade to 4.2 and hence a missing column. Might want to compare your 4.2 schema to a clean 4.2 install schema

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

markimus

  • I post occasionally
  • **
  • Posts: 75
  • Karma: 0
Re: Event Fees Crashes with Error Message
December 05, 2012, 02:08:06 pm
Ok where can I find a clean install schema?
Success is the ability to go from one failure to another with no loss of enthusiasm.

Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1274
  • Karma: 55
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Event Fees Crashes with Error Message
December 05, 2012, 11:39:30 pm
clean install scheme = the schema of a clean install,

i.e. do a seperate new installation and compare the schemas.
Service providers: Grow your business, build your reputation and support CiviCRM. Become a partner today

sonicthoughts

  • Ask me questions
  • ****
  • Posts: 498
  • Karma: 10
Re: Event Fees Crashes with Error Message
December 10, 2012, 01:50:44 pm
I have exactly the same issue.  missing is_quick_config in price_set table.  Not sure if it was an upgrade issue or got dropped.  will have to look at backup.

sonicthoughts

  • Ask me questions
  • ****
  • Posts: 498
  • Karma: 10
Re: Event Fees Crashes with Error Message
December 11, 2012, 08:18:21 am
I re-ran the upgrade and have not seen this issue.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Event Fees Crashes with Error Message

This forum was archived on 2017-11-26.