by prafullsatasiya

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.

Cancel at any time!
Free Trial

#3372 - Database Failure

Open Bug? created by KnightFlyer 3 years ago

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...')

@

  1. prafullsatasiya member avatar

    prafullsatasiya Provider Affiliate

    3 years ago

    Hi

    Thanks for creating a case.

    Can you please do repair and rebuilt and check?

    Best, Prafull

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...