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) »
  • Participant and event searches failing after 3.4.6 -> 4.1.3 upgrade
Pages: [1]

Author Topic: Participant and event searches failing after 3.4.6 -> 4.1.3 upgrade  (Read 684 times)

jimurl

  • I post occasionally
  • **
  • Posts: 70
  • Karma: 0
  • CiviCRM version: 3.4.6
  • CMS version: drupal 6.22
  • MySQL version: 5+
  • PHP version: 5+
Participant and event searches failing after 3.4.6 -> 4.1.3 upgrade
July 10, 2012, 09:07:49 am
AFter upgrading a test site, I have found that browsing to the 'Event' tab on any contacts page, we get an error,
Code: [Select]
DB Error: no such field . From the drupal watchdog log, I can also find this error with more details- it lists a very long SQL statement ( can post if it will help ) with this at the bottom.

 
Code: [Select]
Unknown column 'discount_name.label' in 'field list']
Same error when : REgistering a participant for an event; when viewing Advanced Search results "as Event participants" (but NOT when viewing results as contacts, or as related contacts, or activities- those are fine) ; when doing a participant search.

Basically, anywhere I'm listing participants.

We don't have any fee events, and don't use any discounts.

I wil start looking around here: CRM/Event/Page/Tab.tpl or the corresponding php file for the missing field, but if anyone else has seen/fixed this already, please let me know.


« Last Edit: July 10, 2012, 09:09:49 am by jimurl »

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: Participant and event searches failing after 3.4.6 -> 4.1.3 upgrade
July 10, 2012, 11:49:45 am

might want to wait and install 4.1.5 coming tomorrow. I could not reproduce this on the demo server

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

jimurl

  • I post occasionally
  • **
  • Posts: 70
  • Karma: 0
  • CiviCRM version: 3.4.6
  • CMS version: drupal 6.22
  • MySQL version: 5+
  • PHP version: 5+
Re: Participant and event searches failing after 3.4.6 -> 4.1.3 upgrade
July 20, 2012, 01:05:08 pm
Nevermind, my bad. I had a custom extension for CRM/Event/BAO/Query.php still left in the extensions folder; and it was formulating a bad query.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Participant and event searches failing after 3.4.6 -> 4.1.3 upgrade

This forum was archived on 2017-11-26.