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) »
  • 3.1.3 --> 3.2.3 DB Error: no such field
Pages: [1]

Author Topic: 3.1.3 --> 3.2.3 DB Error: no such field  (Read 1766 times)

erich_prinz

  • I’m new here
  • *
  • Posts: 25
  • Karma: 1
3.1.3 --> 3.2.3 DB Error: no such field
September 12, 2010, 07:59:21 am
After upgrading to 3.2.3, many reports now fail with the above error. No additional details are given in the error code (such as which field is being requested.)

On the template page (screen shot attached), notice the spurious data that shows (check boxes with no field labels) on the configuration page. Certainly odd as the upgrade to the database was successful.

What's the process to troubleshoot and fix?

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Re: 3.1.3 --> 3.2.3 DB Error: no such field
September 12, 2010, 06:05:21 pm
Can I suggest you find the error log and see if that tells you which field it is complaining about?

On Joomla, the error log has a name like CiviCRM.*.log and lives in media/civicrm/templates_c/en_US/ConfigAndLog/ under your Joomla root directory.

If you publish the error, that will give the guys here something to chew on!

Ken

erich_prinz

  • I’m new here
  • *
  • Posts: 25
  • Karma: 1
Re: 3.1.3 --> 3.2.3 DB Error: no such field
September 12, 2010, 06:25:05 pm
Thanks for the note Ken. Much appreciated.

Here is the snippet from the log file:

Sep 12 10:40:46  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT participant_civireport.contact_id as civicrm_participant_contact_id, participant_civireport.id as civicrm_participant_participant_id, participant_civireport.event_id as civicrm_participant_event_id, participant_civireport.participant_status_id as civicrm_participant_participant_status_id, participant_civireport.role_id as civicrm_participant_role_id, participant_civireport.register_date as civicrm_participant_participant_register_date, participant_civireport.fee_level as civicrm_participant_fee_level, participant_civireport.fee_amount as civicrm_participant_fee_amount   FROM
                            civicrm_contact  contact_civireport
                            INNER JOIN civicrm_participant       participant_civireport
                                    ON contact_civireport.id = participant_civireport.contact_id
                               
                         WHERE    contact_civireport.id IN ( 1,3,4,6,7,8,172,326,371,386 )
                         GROUP BY contact_civireport.id,participant_civireport.id  [nativecode=1054 ** Unknown column 'participant_civireport.participant_status_id' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT participant_civireport.contact_id as civicrm_participant_contact_id, participant_civireport.id as civicrm_participant_participant_id, participant_civireport.event_id as civicrm_participant_event_id, participant_civireport.participant_status_id as civicrm_participant_participant_status_id, participant_civireport.role_id as civicrm_participant_role_id, participant_civireport.register_date as civicrm_participant_participant_register_date, participant_civireport.fee_level as civicrm_participant_fee_level, participant_civireport.fee_amount as civicrm_participant_fee_amount   FROM
                            civicrm_contact  contact_civireport
                            INNER JOIN civicrm_participant       participant_civireport
                                    ON contact_civireport.id = participant_civireport.contact_id
                               
                         WHERE    contact_civireport.id IN ( 1,3,4,6,7,8,172,326,371,386 )
                         GROUP BY contact_civireport.id,participant_civireport.id  [nativecode=1054 ** Unknown column 'participant_civireport.participant_status_id' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT participant_civireport.contact_id as civicrm_participant_contact_id, participant_civireport.id as civicrm_participant_participant_id, participant_civireport.event_id as civicrm_participant_event_id, participant_civireport.participant_status_id as civicrm_participant_participant_status_id, participant_civireport.role_id as civicrm_participant_role_id, participant_civireport.register_date as civicrm_participant_participant_register_date, participant_civireport.fee_level as civicrm_participant_fee_level, participant_civireport.fee_amount as civicrm_participant_fee_amount   FROM
                            civicrm_contact  contact_civireport
                            INNER JOIN civicrm_participant       participant_civireport
                                    ON contact_civireport.id = participant_civireport.contact_id
                               
                         WHERE    contact_civireport.id IN ( 1,3,4,6,7,8,172,326,371,386 )
                         GROUP BY contact_civireport.id,participant_civireport.id  [nativecode=1054 ** Unknown column 'participant_civireport.participant_status_id' in 'field list']"]



Sep 12 10:40:46  [info] $backTrace = /var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 189
, handle,
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 931
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 968
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 564
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2411
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 1597
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 145
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 867
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Report/Form/Contact/Detail.php, executeQuery, 477
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Report/Form/Contact/Detail.php, clauseComponent, 648
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Report/Form.php, postProcess, 420
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Report/Form/Contact/Detail.php, preProcess, 273
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php, preProcess, 314
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php, buildForm, 99
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php, handle, 279
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Utils/Wrapper.php, run, 115
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Report/Page/Instance.php, run, 94
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 219
/var/www/html/pie/administrator/components/com_civicrm/admin.civicrm.php, invoke, 72
/var/www/html/pie/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 45
/var/www/html/pie/libraries/joomla/application/component/helper.php, require_once, 162
/var/www/html/pie/administrator/includes/application.php, renderComponent, 136
/var/www/html/pie/administrator/index.php, dispatch, 67
/var/www/html/pie/administrator/index2.php, include, 14

Deepak Srivastava

  • Moderator
  • Ask me questions
  • *****
  • Posts: 677
  • Karma: 65
Re: 3.1.3 --> 3.2.3 DB Error: no such field
September 12, 2010, 11:30:33 pm
Try using the template (not ready made reports) and see if you get the same error. If not -

1. Its a bug with ready made report. Please file an issue for this mentioning all the reports along with error.

2. Quick fix for you 'll be to re-create the report from the templates.
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

sjthespian

  • I post occasionally
  • **
  • Posts: 63
  • Karma: 3
    • The League of Professional System Administrators
  • CiviCRM version: 4.2.7
  • CMS version: Drupal 6.28
  • MySQL version: 5.1.66
  • PHP version: 5.3.3
Re: 3.1.3 --> 3.2.3 DB Error: no such field
March 08, 2011, 05:49:24 pm
I'm seeing the same error here after upgrading to 3.3.5. My guess is that the database upgrade didn't complete because it used too much CPU (I'm on a shared host where I can't control the CPU limits).

Is there a way to rerun the database upgrade process from the command line?
Dan Rich <drich@lopsa.org>
    Director, LOPSA - http://lopsa.org/

erich_prinz

  • I’m new here
  • *
  • Posts: 25
  • Karma: 1
Re: 3.1.3 --> 3.2.3 DB Error: no such field
March 08, 2011, 06:09:17 pm
I re-ran the update database script in hopes of clearing the problem. Sadly it hasn't. I'm still dealing with this issue, not just with reports, but with standard queries.

Perhaps it will require a data dump, build out of a new database, and import the data back in.

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: 3.1.3 --> 3.2.3 DB Error: no such field
March 09, 2011, 08:29:31 am

sjthespian:

you'll need to roll back to an older release and try the process again. We currently do not have a command line upgrade process (though if you are familiar with drush, you can use drush from the command line and upgrade civicrm that way)

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

sjthespian

  • I post occasionally
  • **
  • Posts: 63
  • Karma: 3
    • The League of Professional System Administrators
  • CiviCRM version: 4.2.7
  • CMS version: Drupal 6.28
  • MySQL version: 5.1.66
  • PHP version: 5.3.3
Re: 3.1.3 --> 3.2.3 DB Error: no such field
March 09, 2011, 09:00:53 am
I ended up rolling back the db and re-installing 3.2.5.  I got an error from the installer as it ran out of time doing the database work again, but it looks like it didn't need to do anything important as things appear to be working.

Unfortunately, drush won't do me any good as this site is running on Joomla (I keep debating "fixing" that.... :-) ).  Fortunately the other site where I support CiviCRM is running drupal - it makes life so much simpler.
Dan Rich <drich@lopsa.org>
    Director, LOPSA - http://lopsa.org/
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • 3.1.3 --> 3.2.3 DB Error: no such field

This forum was archived on 2017-11-26.