I have not been able to use the LDAP Data component. I just upgraded to version 1.3 and the issue is still there. When I enable it I get:

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 D:\server\htdocs\wiki\includes\database.mysql.inc on line 172.

Comments

nmakarov’s picture

nmakarov commented

The thing is that Postgres doesn't understand several alterations of a table in one line.

Here's the solution:
In the file "ldapdata.install" replace db_query after "case 'pgsql':" with the following:
db_query("ALTER TABLE {ldapauth} ADD
ldapdata_binddn VARCHAR(255) NOT NULL default ''");
db_query("ALTER TABLE {ldapauth} ADD
ldapdata_bindpw VARCHAR(255) NOT NULL default ''");
db_query("ALTER TABLE {ldapauth} ADD
ldapdata_bindpw_clear VARCHAR(2) NOT NULL default ''");
db_query("ALTER TABLE {ldapauth} ADD
ldapdata_rwattrs TEXT NOT NULL");
db_query("ALTER TABLE {ldapauth} ADD
ldapdata_roattrs TEXT NOT NULL");
db_query("ALTER TABLE {ldapauth} ADD
ldapdata_mappings TEXT NOT NULL");

nospam2’s picture

nospam2 commented

I posted a patch last month here: http://drupal.org/node/204586

scafmac’s picture

scafmac commented
Status: Active » Closed (duplicate)