A very dumb question

[Shuchi]

Hi,

While truncating the demo data from tables, i accidentally truncated the user's table and lost the login details. DOH!
Even if i do an insert with the detailsin the USERS table, the interface compalins about invalid details.

Can i fix this without reinstalling the whole thing .....

Thanks in advance

[Shuchi]

Anybody.....any ideas on how to create a admin account?????

[jmaxwell]

use this to reinstall the admin user:

INSERT INTO `users` VALUES ('1', 'admin', 'adhvvM2WskjKo', '76a2173be6393254e72ffa4d6df1030a', NULL, 'Administrator', NULL, 'on', '1', NULL, '2005-10-19 20:41:51', '2005-11-08 03:07:27', '1', '', 'Administrator', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Active', NULL, NULL, NULL, NULL, NULL, 'YToxODp7czoxODoiSG9tZV9DQVNFX09SREVSX0JZIjtzOjEyO iJwcmlvcml0eSBhc2MiO3M6MTg6IkhvbWVfVEFTS19PUkRFUl9 CWSI7czoyMjoiZGF0ZV9kdWUscHJpb3JpdHkgZGVzYyI7czoxO DoiSG9tZV9MRUFEX09SREVSX0JZIjtzOjIzOiJsZWFkcy5kYXR lX2VudGVyZWQgZGVzYyI7czoxNzoiSG9tZV9CVUdfT1JERVJfQ lkiO3M6MjI6ImJ1Z3MuZGF0ZV9lbnRlcmVkIGRlc2MiO3M6MTI 6InVzZXJQcml2R3VpZCI7czozNjoiNGNmOGU3ZjQtZmFlZi1hZ DI4LWQ4NzAtNDM1NmFmZWNlZmY5IjtzOjI2OiJIb21lX1BST0p FQ1RfVEFTS19PUkRFUl9CWSI7czoyMjoiZGF0ZV9kdWUscHJpb 3JpdHkgZGVzYyI7czoxOToiUm9sZXNfUk9MRV9PUkRFUl9CWSI 7czo0OiJuYW1lIjtzOjE5OiJVc2Vyc19VU0VSX09SREVSX0JZI jtzOjIxOiJsYXN0X25hbWUsIGZpcnN0X25hbWUiO3M6MjU6IkF jY291bnRzX0FDQ09VTlRfT1JERVJfQlkiO3M6NDoibmFtZSI7c zoyNDoiUHJvamVjdF9QUk9KRUNUX09SREVSX0JZIjtzOjQ6Im5 hbWUiO3M6MzQ6Ik9wcG9ydHVuaXRpZXNfT1BQT1JUVU5JVFlfT 1JERVJfQlkiO3M6NDoibmFtZSI7czoyNToiQ29udGFjdHNfQ09 OVEFDVF9PUkRFUl9CWSI7czozOToiY29udGFjdHMubGFzdF9uY W1lLCBjb250YWN0cy5maXJzdF9uYW1lIjtzOjI0OiJBY3Rpdml 0aWVzX0NBTExfT1JERVJfQlkiO3M6MTA6ImRhdGVfc3RhcnQiO 3M6MTk6IlRhc2tzX1RBU0tfT1JERVJfQlkiO3M6MjA6ImRhdGV fZHVlLHN0YXR1cyBkZXNjIjtzOjIzOiJpRnJhbWVzX0lGUkFNR V9PUkRFUl9CWSI7czo0OiJuYW1lIjtzOjE5OiJMZWFkc19MRUF EX09SREVSX0JZIjtzOjMzOiJsZWFkcy5sYXN0X25hbWUsIGxlY WRzLmZpcnN0X25hbWUiO3M6MTc6IkJ1Z3NfQlVHX09SREVSX0J ZIjtzOjEwOiJidWdfbnVtYmVyIjtzOjIzOiJzZWxsZXJzX3Nlb Gxlcl9PUkRFUl9CWSI7czo0OiJuYW1lIjt9', 0, 0, NULL, NULL, NULL);


password is "passwd"

[Shuchi]

Thanks for the reply.
I did insert a row in the user table but when i log in CRM interface,with the username and pwd it displays the the login page again.No error is thrown.

Any ideas???

[stevec]

Had something similar when importing data direct into the user table in the sugarcrm database. With me, I had something erroneous in the user_preferences field.
As I was using Navicat to manage MySQL, I just right clicked on the field for that user and selected 'set to Null' and the user could log on.
I daresay you could try it at the mysql command line:

update users set user_preferences to null where user_name = "joeblow";

[Shuchi]

Setting the user_preferences to NULL does let u log in but it removes the option of creating users.

So even as the administrator , u can't create users.
REsolving to default preferences also does not fix this...

[stevec]

For the admin user, is the field "is_admin" set to "on"?

[Shuchi]

Thanks Steve, it fixed my problem.
I had is_ admin set to '1'

Cheers