CiviCRM Community Forums (archive)

I get the following two user warnings:

user warning: 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 '-iw-civicrm.civicrm_event civicrm_event WHERE ((civicrm_event.is_active <> 0) ' at line 4 query: SELECT civicrm_event.id AS id,
civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.title AS civicrm_event_title FROM dev-iw-civicrm.civicrm_event civicrm_event
WHERE ((civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0)) AND ((DATE_FORMAT(CONVERT_TZ(civicrm_event.start_date, 'UTC',
'America/Los_Angeles'), '%Y-%m') <= '2009-09' AND DATE_FORMAT(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/Los_Angeles'), '%Y-%m')
>= '2009-09')) ORDER BY civicrm_event_start_date ASC in ####/modules/acquia/views/includes/view.inc on line 759.

user warning: 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
'-iw-civicrm.civicrm_event civicrm_event WHERE ((civicrm_event.is_active <> 0) ' at line 4 query: SELECT civicrm_event.id AS id, civicrm_event.start_date
AS civicrm_event_start_date, civicrm_event.title AS civicrm_event_title FROM dev-iw-civicrm.civicrm_event civicrm_event WHERE ((civicrm_event.is_active
<> 0) AND (civicrm_event.is_public <> 0)) AND ((DATE_FORMAT(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/Los_Angeles'), '%Y-%m') <= '2009-09'
AND DATE_FORMAT(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/Los_Angeles'), '%Y-%m') >= '2009-09')) ORDER BY civicrm_event_start_date ASC
in ####/modules/acquia/views/includes/view.inc on line 759.
Any advice on how to interpret, troubleshoot? My thinking so far:

1. What it means
My MYSQL version doesn't like the SQL statements.

2. Troubleshooting strategy:
donwgrade my MYSQL version and see if the problem goes away.

Anybody else have other thoughts or ideas I could try?


Additional background:
Drupal and CiviCRM have seperate dbs
I got the db prefix statement from the CiviCRM URL and edited the settings.php file
drupal user has privileges to the civicrm db

As always, lobo is right
Didn't like my db names.

For others struggling with this (it is really very easy when it works):
http://wiki.civicrm.org/confluence/display/CRMDOC/Views2+Integration+Module

And I added a quick step by step guide to that page.