search

lcdservices / CiviCRM-Group-Sync

Two-way synchronize CiviCRM groups with Joomla ACL groups.
4 stars 1 forks source link

Joomla 3.5.1 civicrm 4.7.3 Unknown column 'title' in 'field list' #7

Open karenannx opened 8 years ago

karenannx commented 8 years ago

1054 Unknown column 'title' in 'field list' SQL=SELECT title as cgroup_label, id as cgroup_id FROM civicrm_group WHERE is_active = 1 Error seen when trying to add new synchronization rule to CiviCRM Group Sync.

lcdservices commented 8 years ago

Unable to reproduce. I installed the current version of CiviGroup sync in a J3.5.1 install running Civi 4.7.6 and was able to create a sync rule without issue. Further, the civicrm_group table does have a title column, so the query should work fine.

Is your CiviCRM installation working properly? Are you able to view groups?

karenannx commented 8 years ago

Maybe I’m using the wrong file to install? CiviCRM-Group-Sync-master.zip

This is what I am using. It installs ok, but when I go to Components and select NEW to create a new rule I get this (see below)

J3.5.1 Civicrm version 4.7.3

From: Brian Shaughnessy [mailto:notifications@github.com] Sent: May 23, 2016 10:03 AM To: lcdservices/CiviCRM-Group-Sync CiviCRM-Group-Sync@noreply.github.com Cc: karenannx karenann@xavierinnovations.com; Author author@noreply.github.com Subject: Re: [lcdservices/CiviCRM-Group-Sync] Joomla 3.5.1 civicrm 4.7.3 Unknown column 'title' in 'field list' (#7)

Unable to reproduce. I installed the current version of CiviGroup sync in a J3.5.1 install running Civi 4.7.6 and was able to create a sync rule without issue. Further, the civicrm_group table does have a title column, so the query should work fine.

Is your CiviCRM installation working properly? Are you able to view groups?

— You are receiving this because you authored the thread. Reply to this email directly or view it on GitHub https://github.com/lcdservices/CiviCRM-Group-Sync/issues/7#issuecomment-220989179 https://github.com/notifications/beacon/AHfcrLo8D4m8LvaCsNjlf14CtMBFiBbTks5qEbOfgaJpZM4IhTZh.gif

No virus found in this message. Checked by AVG - www.avg.com http://www.avg.com Version: 2016.0.7597 / Virus Database: 4568/12282 - Release Date: 05/23/16

karenannx commented 8 years ago

Works on Civicrm 4.6.10 and joomla 3.5.1

From: Brian Shaughnessy [mailto:notifications@github.com] Sent: May 23, 2016 10:03 AM To: lcdservices/CiviCRM-Group-Sync CiviCRM-Group-Sync@noreply.github.com Cc: karenannx karenann@xavierinnovations.com; Author author@noreply.github.com Subject: Re: [lcdservices/CiviCRM-Group-Sync] Joomla 3.5.1 civicrm 4.7.3 Unknown column 'title' in 'field list' (#7)

Unable to reproduce. I installed the current version of CiviGroup sync in a J3.5.1 install running Civi 4.7.6 and was able to create a sync rule without issue. Further, the civicrm_group table does have a title column, so the query should work fine.

Is your CiviCRM installation working properly? Are you able to view groups?

— You are receiving this because you authored the thread. Reply to this email directly or view it on GitHub https://github.com/lcdservices/CiviCRM-Group-Sync/issues/7#issuecomment-220989179 https://github.com/notifications/beacon/AHfcrLo8D4m8LvaCsNjlf14CtMBFiBbTks5qEbOfgaJpZM4IhTZh.gif

No virus found in this message. Checked by AVG - www.avg.com Version: 2016.0.7597 / Virus Database: 4568/12282 - Release Date: 05/23/16

lcdservices commented 8 years ago

As I indicated before, I am unable to reproduce in J3.5.1 + C4.7.6. The query is valid. Unless your civicrm installation is broken, selecting title from civicrm_group should not cause a problem. And if it was broken, you would notice on your manage groups page.

Please try upgrading civicrm to the latest revision (4.7.7). It's possible the issue may be with the civicrm installation.