Problem upgrading from 5.x to 6.x
martink - December 9, 2008 - 16:43
| Project: | LDAP integration |
| Version: | 6.x-1.0-alpha2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
I just upgraded to Drupal 6.6, which meant upgrading from ldapauth 5.x-1.3 to 6.x-1.0-alpha2. I have all three modules installed (though actually I think I only need the authorisation).
Everything went ok apparently. I reinstalled the module and ran update.php which told me there were no new versions to upgrade to. However, when I logged in for the first time with an LDAP authenticated user I get this message:
user warning: Unknown column 'ldapgroups_in_dn' in 'field list' query: SELECT ldapgroups_in_dn, ldapgroups_in_attr, ldapgroups_as_entries, ldapgroups_dn_attribute, ldapgroups_attr, ldapgroups_entries, ldapgroups_entries_attribute FROM ldapauth WHERE sid = 1 in /var/www/drupal-6.6/sites/all/modules/ldap_integration/ldapgroups.module on line 150.Disconnecting ldapgroups made the issue go away

#1
It looks that for your installation there is something wrong in the ldapgroups database fields. Try disabling (and uninstalling) ldap groups module, then reinstalling it again. Installation should create a proper table fields.
#2
I tried uninstalling LDAP groups and go this:
* user warning: Can't DROP 'ldapgroups_in_dn'; check that column/key exists query: ALTER TABLE ldapauth DROP ldapgroups_in_dn in /var/www/drupal-6.6/includes/database.mysql-common.inc on line 322.* user warning: Can't DROP 'ldapgroups_in_dn_desc'; check that column/key exists query: ALTER TABLE ldapauth DROP ldapgroups_in_dn_desc in /var/www/drupal-6.6/includes/database.mysql-common.inc on line 322.
* user warning: Can't DROP 'ldapgroups_dn_attribute'; check that column/key exists query: ALTER TABLE ldapauth DROP ldapgroups_dn_attribute in /var/www/drupal-6.6/includes/database.mysql-common.inc on line 322.
* user warning: Can't DROP 'ldapgroups_attr'; check that column/key exists query: ALTER TABLE ldapauth DROP ldapgroups_attr in /var/www/drupal-6.6/includes/database.mysql-common.inc on line 322.
* user warning: Can't DROP 'ldapgroups_in_attr'; check that column/key exists query: ALTER TABLE ldapauth DROP ldapgroups_in_attr in /var/www/drupal-6.6/includes/database.mysql-common.inc on line 322.
* user warning: Can't DROP 'ldapgroups_as_entries'; check that column/key exists query: ALTER TABLE ldapauth DROP ldapgroups_as_entries in /var/www/drupal-6.6/includes/database.mysql-common.inc on line 322.
* user warning: Can't DROP 'ldapgroups_entries'; check that column/key exists query: ALTER TABLE ldapauth DROP ldapgroups_entries in /var/www/drupal-6.6/includes/database.mysql-common.inc on line 322.
* user warning: Can't DROP 'ldapgroups_entries_attribute'; check that column/key exists query: ALTER TABLE ldapauth DROP ldapgroups_entries_attribute in /var/www/drupal-6.6/includes/database.mysql-common.inc on line 322.
However, the reinstallation does seem to have done the trick!
#3
Had the same problem with ldap groups when migrating from 5.16 to 6.14. Disabled the data and group modules, tried uninstalling two modules, got the error message, re-enabled the two data and group modules (they were still listed on the modules page), and I was able to configure both ldap groups and data modules.