Database Error Code: Unknown column 'civicrm_participant'

[rmmcclay]

CiviCRM 2.2.7
Drupal 6.1.3

Under user, then click on Events tab, it shows
the event the user has registered for and then
click on View in the last column:

http://xxxxxxxxx/civicrm/contact/view/participant?reset=1&id=58&cid=103&action=view&context=participant&selectedChild=event

Sorry. A non-recoverable error has occurred.

DB Error: no such field

Database Error Code: Unknown column 'civicrm_participant' in 'where clause', 1054

Return to home page.


Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] =>
SELECT   id, note FROM civicrm_note
WHERE    entity_table="civicrm_participant"
  AND    entity_id = 58
  AND    note is not null
ORDER BY modified_date desc [nativecode=1054 ** Unknown column 'civicrm_participant' in 'where clause']
    [type] => DB_Error
    [user_info] =>
SELECT   id, note FROM civicrm_note
WHERE    entity_table="civicrm_participant"
  AND    entity_id = 58
  AND    note is not null
ORDER BY modified_date desc [nativecode=1054 ** Unknown column 'civicrm_participant' 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   id, note FROM civicrm_note
WHERE    entity_table="civicrm_participant"
  AND    entity_id = 58
  AND    note is not null
ORDER BY modified_date desc [nativecode=1054 ** Unknown column 'civicrm_participant' in 'where clause']"]
)


[rmmcclay]

Looking at the query we see:

[debug_info] =>
SELECT   id, note FROM civicrm_note
WHERE    entity_table="civicrm_participant"
  AND    entity_id = 58
  AND    note is not null
ORDER BY modified_date desc [nativecode=1054 ** Unknown column 'civicrm_participant' in 'where clause']

Ok...let's look at the table, yep, it's true, there is no column 'civicrm_participant'
in the table civicrm_participant.  No wonder it's failing.  Now, how to fix this?

mysql> describe civicrm_participant;
+------------------+------------------+------+-----+---------+----------------+
| Field            | Type             | Null | Key | Default | Extra          |
+------------------+------------------+------+-----+---------+----------------+
| id               | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| contact_id       | int(10) unsigned | YES  | MUL | 0       |                |
| event_id         | int(10) unsigned | YES  | MUL | 0       |                |
| status_id        | int(10) unsigned | NO   | MUL | 1       |                |
| role_id          | int(10) unsigned | YES  | MUL | NULL    |                |
| register_date    | datetime         | YES  |     | NULL    |                |
| source           | varchar(128)     | YES  |     | NULL    |                |
| fee_level        | varchar(255)     | YES  |     | NULL    |                |
| is_test          | tinyint(4)       | YES  |     | 0       |                |
| is_pay_later     | tinyint(4)       | YES  |     | 0       |                |
| fee_amount       | decimal(20,2)    | YES  |     | NULL    |                |
| registered_by_id | int(10) unsigned | YES  | MUL | NULL    |                |
| discount_id      | int(10) unsigned | YES  | MUL | NULL    |                |
+------------------+------------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)

[Kurund Jalmi]

It's hard for us to support older versions 2.2.x, so I would recommend you should upgrade to 3.0.x.

Kurund

[Yashodha Chaku]

Ok...let's look at the table, yep, it's true, there is no column 'civicrm_participant'
in the table civicrm_participant.

The query is looking for entity_table = 'civicrm_participant' in civicrm_note table,
should work fine.

Yashodha

[rmmcclay]

Ok...let's look at the table, yep, it's true, there is no column 'civicrm_participant'
in the table civicrm_participant.

The query is looking for entity_table = 'civicrm_participant' in civicrm_note table,
should work fine.

Yashodha

My mistake. In civicrm_note, every entry (mostly from the sample data) is "civicrm_contact"
in the entity_table column. Besides the error says it can't find the "column" civicrm_participant.

It's a deep game.

Thanks for the reply.

[rmmcclay]

It's hard for us to support older versions 2.2.x, so I would recommend you should upgrade to 3.0.x.

Kurund

As soon as CiviCRM can run on the latest PHP (5.3.1) we'll upgrade.  Until then
I guess it's game over. Which is quite sad considering how much time and effort
our organization has put into this project.

Thanks for the reply.

[Kurund Jalmi]

As soon as CiviCRM can run on the latest PHP (5.3.1) we'll upgrade.

Well you will have to wait till 3.2.
IMHO upgrading from 2.2.x to at least 3.1 is recommended since there has been major improvement in 3.x version

Kurund

[rmmcclay]

As soon as CiviCRM can run on the latest PHP (5.3.1) we'll upgrade.

Well you will have to wait till 3.2.
IMHO upgrading from 2.2.x to at least 3.1 is recommended since there has been major improvement in 3.x version

Kurund

We may roll back PHP on our production server to accomodate CiviCRM.  But I
am scared to death of the unknown problems which we will most certainly encounter
doing the upgrade.

The issues that concern me to upgrade are: our site is bi-lingual Chinese/English,
and our installation of Drupal/CiviCRM shares the same database.

In closing, I wasn't really looking for "support" about the fatal database error; but
more hoping someone else had had this problem.  It seems like a rare error. And
we were almost there!!!  The frustration I feel is replete.