search

lcdservices / CiviCRM-Group-Sync

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

Not able to set rule (getting a failure message) #3

Closed Peraf closed 10 years ago

Peraf commented 10 years ago

Hi, I just came over your plugin, which is perfect for our site. The only problem is that I can't get it working. New Joomla 3.3.1 installation. New Civicrm 4.4.5 installation. Installed the Group Sync component and everything installs fine. When pressing the new Rule button it says "An error has occurred." with the following message:

1054 Unknown column 'title' in 'field list' SQL=SELECT title as cgroup_label, id as cgroup_id FROM civicrm_group WHERE is_active = 1

Any clue?

I would be very happy if I could this working. This one should be included in the CiviCRM standard package btw:-)

lcdservices commented 10 years ago

hmmm... that's quite strange. the title field should definitely be present in the civicrm_group table. can you get into your db, look at that table, and see if the title column is present? if not, something may be messed up with your installation.

also, let me know if you have any non-standard aspects to your installation (separate DB for civi, etc.)

Peraf commented 10 years ago

Thanx for quick reply. I think I might found the problem.. In the civicrm_group, I don't have "title", but "title_en_US". I guess this is because I enabled the multi language feature in Civicrm during installation? What do you think?

lcdservices commented 10 years ago

ok, that's definitely a problem. and it may not be easy to work around. in this context we are strictly in Joomla and not as aware of what the user's language preference is in CiviCRM. I'll need to think about whether there is a way we can work around that.

Peraf commented 10 years ago

I understand that. Well I think when people register a contact or organization, it will not have different names registered anyway? Just the field. It seems like the "title_en_US" become default when the multi language is turned on..?

lcdservices commented 10 years ago

only if you're using the en_US translation. that's the problem. we don't have an easy way to determine the logged in user's language preference (or even what languages are installed) in order to create the correct query.

I will give some thought to this, but I may just need to leave the extension as something not compatible with multi-language.

you could try modifying your installation of the extension manually. just change that query to reference the correct localized version of the title column.

Peraf commented 10 years ago

Thanx anyway. Maybe it is possible in the extention to set the default installation language or set the select prefered title field?

Have a good weekend!

Med vennlig hilsen / Best Regards Per Anders Friise

Den 20. juni 2014 kl. 17:38 skrev Brian Shaughnessy notifications@github.com:

only if you're using the en_US translation. that's the problem. we don't have an easy way to determine the logged in user's language preference (or even what languages are installed) in order to create the correct query.

I will give some thought to this, but I may just need to leave the extension as something not compatible with multi-language.

you could try modifying your installation of the extension manually. just change that query to reference the correct localized version of the title column.

— Reply to this email directly or view it on GitHub.

lcdservices commented 10 years ago

closing. will not support multi-lingual installs at this time.