CiviCRM Community Forums (archive)

I upgraded Drupal from 7.21 and checked it, everything seemed to work fine (just like before). The upgraded CiviCRM from 4.2.8 to 4.2.9 and my views field and filter handlers are broken, they are no longer accessible through Views. This SQl error message displays on the View page:

"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM civicrm_event civicrm_event WHERE (( (civicrm_event.event_type_id IN ('7'' at line 1"

This shows up as the query in Views:

Query   
SELECT
FROM
{civicrm_event} civicrm_event
WHERE (( (civicrm_event.event_type_id IN  ('7')) ))


I cleared all the caches (including Views) but the problem persists. The View wasn't doing anything unusual although there is some PHP code (that was working) as described here:

http://wiki.civicrm.org/confluence/display/CRMDOC40/Event+listing+showing+fully-booked+result+using+Drupal+Views+PHP

It all worked perfectly prior to upgrading, any help will be very much appreciated.