CiviCRM Community Forums (archive)

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)

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

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.

Quote

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.