Cannot add new user to SugarCRM

AndyS
Posts: 72
Member Since:
2006-06-19

I get a 'page cannot be displayed' error when I try to create a user in SugarCRM. I did some digging and found a SQL error in sugarcrm.log: MySQL error 1054: Unknown column 'is_ldap_user' in 'field list'.

A quick google turned up nothing except "you need to install the LDAP patch" on the SugarCRM site. I'm not convinced that this is the right move for a TrixBox installation.

I did also find a SQL script but again I'm not convinced that it's the correct option:
ALTER TABLE `users` ADD `is_ldap_user` TINYINT DEFAULT '0' AFTER `portal_only`;
UPDATE `users` SET is_ldap_user=1, user_password='' WHERE user_password='@ldap';

ALTER TABLE `users` CHANGE `user_name` `user_name` VARCHAR( 60 );

Can someone point me in the right direction please?

FYI, I'm not looking to do LDAP integration right now.

Andy.

--

FtOCC Technician Certified.
ipPhoneShack.com



AndyS
Posts: 72
Member Since:
2006-06-19
Re: Cannot add new user to SugarCRM

Update: I noticed that the SQL 1054 errors are old, and all the LDAP integration stuff appears to be complete. I guess that's not the problem.

Anyone have any more ideas on why users aren't being created?

Andy.

--

FtOCC Technician Certified.
ipPhoneShack.com



Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.