REST API Session not genrated After upgraded suit CRM 7.8.8 to 7.10.1

SuiteCRM Forum - English Language Installation & Upgrade Help
1

Hi,

I have some issue while upgrade the my suit CRM as I am not able to create the session of admin user though REST API. I have used the Rest API to create the session variable. But it is only saying that password is expired. Note that I have update my CRM from 7.8.8 => 7.8.16 => 7.10.1 (For UI). But we are not able to sync all database with the 7.10.1 version we have try with repair and rebuild the CRM. Also when we create suit crm instance on the local by download 7.10.1 and install it is working fine with rest API that i have created as you can see the screen shot “http://nimb.ws/f2aOAD” here. But domain that we have upgrade it is showing “Password expired” message you can see here http://nimb.ws/XfuScj . For many time I have repair and rebuild the CRM each time but Repair and rebuild is stuck in this screen “http://nimb.ws/YyhQKk”. I have Repeated several time but it with same message. I have also Checked the log file. In log we have entry like.

“Thu Mar 8 07:44:13 2018 [27199][1][FATAL] Query Failed: DELETE FROM users WHERE id <> 1: MySQL error 1292: Truncated incorrect DOUBLE value: '10b9f790-08cb-6f36-52d9-5a9e43ecdd3d ’
Thu Mar 8 07:44:13 2018 [27199][1][FATAL] Query Failed: DELETE FROM users_cstm WHERE id <> 1: MySQL error 1054: Unknown column ‘id’ in ‘where clause’
Fri Mar 9 07:49:53 2018 [101093][1][FATAL] field_defs should be an array
Fri Mar 9 07:50:03 2018 [101164][1][FATAL] field_defs should be an array
Fri Mar 9 07:53:16 2018 [101939][1][FATAL] field_defs should be an array
Fri Mar 9 07:55:57 2018 [102521][1][FATAL] field_defs should be an array
Fri Mar 9 07:56:13 2018 [102594][1][FATAL] field_defs should be an array
Fri Mar 9 08:48:05 2018 [113751][-none-][FATAL] SECURITY: User authentication for santosh failed
Fri Mar 9 08:48:05 2018 [113751][-none-][FATAL] FAILED LOGIN:attempts[1], ip[123.136.169.62], username[santosh]
Fri Mar 9 08:48:19 2018 [113887][1][FATAL] password expired for user admin”

So please help ME with this I have used “SuiteCRM-Upgrade-7.8.x-to-7.10.1.zip” this update on CRM and it is done. I have used this link to create session “https://suitecrm.com/suitecrm/forum/developer-help/7424-rest-api-documentation”

Suit CRM => 7.8.8 => 7.8.16 => 7.10.1 (Updated)

PHP => 5.6.32

2

I know there are missing filed warning in the CRM but why it is not working on “Repai”

3

Hi Patilamol,

SuiteCRM 7.10 introduced a change to the password management, so that administrators can enforce stricter password polices like how long before a password expires, if it should contain a upper case values, numbers etc.

Please see our documentation:
https://docs.suitecrm.com/user/modules/passwordmanagement/

Try and access the password management admin console, set the system generated passwords expire to “none” and click save. Does your problem still exist afterwards?