Jump to:
| Project: | LDAP integration |
| Version: | 6.x-1.0-beta1 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed (duplicate) |
Issue Summary
After entering group mappings on the Administration->site configuration->LDAP->groups->[my LDAP profile] page, I get the following error:
user warning: Unknown column 'ldapgroups_mappings' in 'field list' query: UPDATE ldapauth SET ldapgroups_in_dn = 1, ldapgroups_dn_attribute = 'ou', ldapgroups_in_attr = 0, ldapgroups_attr = '', ldapgroups_as_entries = 0, ldapgroups_entries = '', ldapgroups_entries_attribute = '', ldapgroups_mappings = 'a:7:{s:33:\"ou=students,dc=pmsnet,dc=internal\";s:7:\"Student\";s:42:\"ou=teachers,ou=staff,dc=pmsnet,dc=internal\";s:5:\"Staff\";s:50:\"ou=teachers-relaxed,ou=staff,dc=pmsnet,dc=internal\";s:5:\"Staff\";s:39:\"ou=admin,ou=staff,dc=pmsnet,dc=internal\";s:5:\"Staff\";s:39:\"ou=administrators,dc=pmsnet,dc=internal\";s:14:\"Administrators\";s:67:\"ou=sims - administrator gpo,ou=administrators,dc=pmsnet,dc=internal\";s:5:\"Staff\";s:68:\"ou=less-restricted admin gpo,ou=administrators,dc=pmsnet,dc=internal\";s:5:\"Staff\";}', ldapgroups_mappings_filter = 0, ldapgroups_filter_php = '', ldapgroups_groups = '' WHERE sid = 1 in E:\Website Files\intranet\modules\ldap_integration\ldapgroups.admin.inc on line 283.
Comments
#1
This was in the "Mapping of LDAP groups to Drupal roles: " box, entering in the form ou=xxxx,dc=xxx,dc=xxx | Groupname
#2
I also have this issue, but only on my development box, not on my local installation.
user warning: Unknown column 'ldapgroups_in_dn' in 'field list' query: UPDATE ldapauth SET ldapgroups_in_dn = 0, ldapgroups_dn_attribute = 'ou=persons, o=external', ldapgroups_in_attr = 0, ldapgroups_attr = '', ldapgroups_as_entries = 0, ldapgroups_entries = '', ldapgroups_entries_attribute = '', ldapgroups_mappings = '', ldapgroups_mappings_filter = 0, ldapgroups_filter_php = '', ldapgroups_groups = '' WHERE sid = 4 in /srv/www/vhosts/riskscape_portal/sites/all/modules/ldap_integration/ldapgroups.admin.inc on line 283.
#3
You might check to make sure that your ldapauth table doesn't have column names "ldap_group". Somehow I missed a patch that would have presumably altered columns named ldap_group to ldapgroups. If your table is in that state none of the update queries will execute and throw the errors you reported. If you alter ldapgroups.install so that the update adds the tables named ldapgroups it will solve your problem.
#4
@sabunome: There is no such patch or update. The upgrade path from 5.x to 6.x is broken. I have submitted a patch that add an update for the ldapgroups module to fix this problem here: #1021892: Upgrade from 5 to 6 does not work properly
#5
Marking as duplicate.