CiviCRM Community Forums (archive)

lobo, Also i'd argue that if you've have 4 developers in the past 3 years try to port CiviCRM to PG, then you probably have 400 people who are interested in using it.  Does CiviCRM have a place to propose feature requests and vote them up?

Not sure if I should post here, or start a new thread. This issue is related to having Drupal (Views) installed on PostgreSQL database and querying the MySQL CiviCRM database.

I am trying to simply create a group in CiviCRM (of contacts) and display in Views (and eventually OpenLayers). I have been able to get all contacts to display fine in Views, but when I try to add the Contacts:Groups field (or filter) it gives me an error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm_contact.group' in 'where clause'

Here is the SQL generated:

SELECT civicrm_contact.id AS id
FROM
{civicrm_contact} civicrm_contact
WHERE (( (civicrm_contact.group IS NOT NULL ) ))

It seems the problem is that it is not querying the correct database table. When I look in PhpMyAdmin, it seems the table and field that should be queried is civicrm_group_contact.group_id

Perhaps this is a fundamental difference in how Civi installs on these different databases. Is there a way to fix this?

Thanks you very much for your time.

Aaron

Thanks for the response Lobo.

Do you know if there is some kind of list or table that defines the databases and how to connect? I am curious why Views would try to use the wrong table name. Do you know where this info originates?

Thanks. If you can help me narrow my search for the problem, that would be awesome.

Aaron