Getting a few different errors after trying to create a new site within a multisite install. The site was originally on a LAMP server but was just moved to a new WAMP server, I first got an error when trying to enable ldap integration on a new site. I have uninstalled ldap integration, ldap groups, and ldap data a few times now in an attempt to get this to work. The last time I did this I also disabled the profile module since it depends on ldap data (which meant I also had to disable the birthdays module since it depends on the profile module), I uninstalled ldap integration, ldap groups, and ldap data then ran the update.php script, then enabled and configured ldap integration, no errors, then enabled and configured ldap groups, no errors, then enabled ldap data and got this error:
user warning: BLOB/TEXT column 'ldapdata_rwattrs' can't have a default value query: ALTER TABLE ldapauth ADD ( ldapdata_binddn VARCHAR(255) NOT NULL default '', ldapdata_bindpw VARCHAR(255) NOT NULL default '', ldapdata_bindpw_clear VARCHAR(2) NOT NULL default '', ldapdata_rwattrs LONGTEXT NOT NULL default '', ldapdata_roattrs LONGTEXT NOT NULL default '', ldapdata_mappings LONGTEXT NOT NULL default '' ) in C:\www\drupal\includes\database.mysql.inc on line 172.
I also tried to place the ldap integration module in site specific module directories, so now have /drupal/sites/siteOne/modules/ldap_integration, /drupal/sites/siteTwo/modules/ldap_integration, etc. SiteOne still works fine, siteTwo gets the error still.
I received this error prior to my complete uninstall of the modules:

user warning: Unknown column 'ldapdata_mappings' in 'field list' query: SELECT ldapdata_mappings, encrypted FROM ldapauth WHERE name = '' in C:\www\drupal\includes\database.mysql.inc on line 172. 
user warning: Unknown column 'ldapdata_binddn' in 'field list' query: SELECT ldapdata_binddn, ldapdata_bindpw FROM ldapauth WHERE name = 'dc' in C:\www\drupal\includes\database.mysql.inc on line 172. 
user warning: Unknown column 'ldapdata_binddn' in 'field list' query: SELECT ldapdata_binddn, ldapdata_bindpw FROM ldapauth WHERE name = 'dc' in C:\www\drupal\includes\database.mysql.inc on line 172.

I saw other postings regarding similar errors but it was said that their had been fixes applied. Should I be getting a dev version of this module or stick with the stable? Anyone have any idea how to sort this one out?
Thanks

Comments

kpm’s picture

kpm commented

Just tried again with another site... same error on enabling ldap data:

BLOB/TEXT column 'ldapdata_rwattrs' can't have a default value query: ALTER TABLE ldapauth ADD ( ldapdata_binddn VARCHAR(255) NOT NULL default '', ldapdata_bindpw VARCHAR(255) NOT NULL default '', ldapdata_bindpw_clear VARCHAR(2) NOT NULL default '', ldapdata_rwattrs LONGTEXT NOT NULL default '', ldapdata_roattrs LONGTEXT NOT NULL default '', ldapdata_mappings LONGTEXT NOT NULL default '') in database.mysql.inc on line 172.

Then if I navigate to the admin/settings/ldapdata/edit/dc I receive the following warning at the top of the page:

* user warning: Unknown column 'ldapdata_mappings' in 'field list' query: SELECT ldapdata_mappings, ldapdata_roattrs, ldapdata_rwattrs, ldapdata_binddn, ldapdata_bindpw, ldapdata_bindpw_clear FROM ldapauth WHERE name = 'kirkdc01' in C:\www\drupal\includes\database.mysql.inc on line 172.
* user warning: Unknown column 'ldapdata_mappings' in 'field list' query: SELECT ldapdata_mappings FROM ldapauth WHERE name = 'kirkdc01' in C:\www\drupal\includes\database.mysql.inc on line 172.

I am using the latest version available and looked for a development version to try, but I don't see any links to any on the ldap integration project page. I read in other posts that this was a bug that was fixed in 'head'. But I don't know where to grab that to see if it will solve the issue.
Thanks.

kpm’s picture

kpm commented
Title: user warning: BLOB/TEXT column 'ldapdata_rwattrs' can't have a default value query » I made some typos in the above error blocks...

since I am overly paranoid, I like to replace the server names with generic ones... but I forgot to in the last post, 'kirkdc01' I would have changed to 'dc'...

kpm’s picture

kpm commented
Title: I made some typos in the above error blocks... » Solved... MySQL 5 On Windows - BLOB and TEXT columns can not have default
Status: Active » Closed (fixed)

Since I moved from Linux to Windows, I had to go to \MySQL\my.ini and comment out the strict sql mode.
Change this:

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

To this:

# Set the SQL mode to strict
# sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"