LogTrack is the best plugin to track the user login history. It stores the login and logout date and time, and the IP address from where the users logged in.
#3372 - Database Failure
Database failure. Please refer to suitecrm.log for details.
And in the log, Fri Jan 22 17:34:02 2021 [4732][1][FATAL] Mysqli_query failed. Fri Jan 22 17:34:02 2021 [4732][1][FATAL] Query Failed: SELECT spec_logtrack.id , spec_logtrack.name , spec_logtrack.login_time , spec_logtrack.logout_time , spec_logtrack.ip_address , spec_logtrack.assigned_user_id FROM spec_logtrack where spec_logtrack.deleted=0 ORDER BY spec_logtrack.date_entered DESC LIMIT 0,26: MySQL error 1146: Table 'suitecrm.spec_logtrack' doesn't exist Fri Jan 22 17:34:16 2021 [4738][1][FATAL] Mysqli_query failed. Fri Jan 22 17:34:16 2021 [4738][1][FATAL] Error inserting into table: spec_logtrack: Query Failed: INSERT INTO spec_logtrack (id,name,date_entered,date_modified,modified_user_id,created_by,description,deleted,assigned_user_id,login_time,logout_time,ip_address) VALUES ('134988ca-25cc-74bc-1dca-600b60e768c5','Randy Millner','2021-01-22 23:34:16','2021-01-22 23:34:16','1','1','',0,'1',NULL,NULL,''): MySQL error 1146: Table 'suitecrm.spec_logtrack' doesn't exist Fri Jan 22 17:34:16 2021 [4738][1][FATAL] Exception handling in /var/www/html/CRM/include/MVC/Controller/SugarController.php:400 Fri Jan 22 17:34:16 2021 [4738][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details. Fri Jan 22 17:34:16 2021 [4738][1][FATAL] backtrace:
0 /var/www/html/CRM/include/database/DBManager.php(353): sugar_die('Database failur...')
@
3 years ago
Hi
Thanks for creating a case.
Can you please do repair and rebuilt and check?
Best, Prafull