My Whole system get close Suitecrm

namitkakusuitecrm · 10 December 2019 05:40

Please help me this is disgusting why every time my suitecrm setup stop working suddenly. Why ? Please help me in this. This is happening 5th time.
It shows only header after login . I don’t know where the problem is but i am totally depressed by this error.

This is my log file of suitecrm

Monday 09 December 2019 08:28:42 AM CET [26908][-none-][FATAL] User update error: Temp User is not retrieved at ID 1, boolean given
Monday 09 December 2019 08:28:43 AM CET [26908][-none-][FATAL] Email address save error
Mon Dec  9 09:10:22 2019 [24461][1][FATAL] Mysqli_query failed.
Mon Dec  9 09:10:22 2019 [24461][1][FATAL]  Query Failed: ALTER TABLE documents_cstm drop COLUMN parent_name: MySQL error 1091: Can't DROP COLUMN `parent_name`; check that it exists
Tuesday 10 December 2019 06:37:11 AM CET [4582][1][FATAL] Mysqli_query failed.

Tuesday 10 December 2019 06:37:11 AM CET [4582][1][FATAL] Retrieving record by id documents:a2b6149b-eb70-4a2f-d234-5dee13bdc131 found  Query Failed: SELECT documents.*,documents_cstm.* FROM documents  LEFT JOIN documents_cstm ON documents.id = documents_cstm.id_c  WHERE documents.id = 'a2b6149b-eb70-4a2f-d234-5dee13bdc131' AND documents.deleted=0 LIMIT 0,1: MySQL error 1932: Table 'LQCRM.documents_cstm' doesn't exist in engine
Tuesday 10 December 2019 06:37:11 AM CET [4582][1][FATAL] Exception handling in /opt/lampp/htdocs/LQCRM/include/MVC/Controller/SugarController.php:400
Tuesday 10 December 2019 06:37:11 AM CET [4582][1][FATAL] Exception in Controller: Some garbage state left in stack (did you pop everything?)
Needs to restore:
	[error_reporting.sugar_smarty_errors] => 'sugar_smarty_errors'

Tuesday 10 December 2019 06:37:11 AM CET [4582][1][FATAL] backtrace:
#0 /opt/lampp/htdocs/LQCRM/include/Sugar_Smarty.php(161): SuiteCRM\StateSaver->__destruct()
#1 /opt/lampp/htdocs/LQCRM/vendor/smarty/smarty/libs/Smarty.class.php(1113): Sugar_Smarty->fetch('themes/SuiteP/t...', NULL, NULL, true)
#2 /opt/lampp/htdocs/LQCRM/include/MVC/View/SugarView.php(794): Smarty->display('themes/SuiteP/t...')
#3 /opt/lampp/htdocs/LQCRM/include/MVC/View/SugarView.php(218): SugarView->displayHeader()
#4 /opt/lampp/htdocs/LQCRM/include/MVC/Controller/SugarController.php(435): SugarView->process()
#5 /opt/lampp/htdocs/LQCRM/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#6 /opt/lampp/htdocs/LQCRM/include/MVC/SugarApplication.php(113): SugarController->execute()
#7 /opt/lampp/htdocs/LQCRM/index.php(52): SugarApplication->execute()
#8 {main}
Tuesday 10 December 2019 06:37:11 AM CET [4582][1][FATAL] Previous:

Tuesday 10 December 2019 06:37:11 AM CET [4582][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Tuesday 10 December 2019 06:37:11 AM CET [4582][1][FATAL] backtrace:
#0 /opt/lampp/htdocs/LQCRM/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /opt/lampp/htdocs/LQCRM/include/database/DBManager.php(328): DBManager->registerError('Retrieving reco...', 'Retrieving reco...', true)
#2 /opt/lampp/htdocs/LQCRM/include/database/MysqliManager.php(179): DBManager->checkError('Retrieving reco...', true)
#3 /opt/lampp/htdocs/LQCRM/include/database/MysqlManager.php(285): MysqliManager->query('SELECT document...', true, 'Retrieving reco...')
#4 /opt/lampp/htdocs/LQCRM/data/SugarBean.php(4531): MysqlManager->limitQuery('SELECT document...', 0, 1, true, 'Retrieving reco...')
#5 /opt/lampp/htdocs/LQCRM/include/SugarObjects/templates/file/File.php(144): SugarBean->retrieve('a2b6149b-eb70-4...', true, true)
#6 /opt/lampp/htdocs/LQCRM/data/BeanFactory.php(104): File->retrieve('a2b6149b-eb70-4...', true, true)
#7 /opt/lampp/htdocs/LQCRM/include/Smarty/plugins/function.suite_check_access.php(35): BeanFactory::getBean('Documents', 'a2b6149b-eb70-4...')
#8 /opt/lampp/htdocs/LQCRM/cache/smarty/templates_c/%%F6^F60^F609237E%%_headerModuleList.tpl.php(118): smarty_function_suite_check_access(Array, Object(Sugar_Smarty))
#9 /opt/lampp/htdocs/LQCRM/vendor/smarty/smarty/libs/Smarty.class.php(1876): include('/opt/lampp/htdo...')
#10 /opt/lampp/htdocs/LQCRM/cache/smarty/templates_c/%%F9^F94^F946E606%%header.tpl.php(23): Smarty->_smarty_include(Array)
#11 /opt/lampp/htdocs/LQCRM/vendor/smarty/smarty/libs/Smarty.class.php(1263): include('/opt/lampp/htdo...')
#12 /opt/lampp/htdocs/LQCRM/include/Sugar_Smarty.php(161): Smarty->fetch('themes/SuiteP/t...', NULL, NULL, true)
#13 /opt/lampp/htdocs/LQCRM/vendor/smarty/smarty/libs/Smarty.class.php(1113): Sugar_Smarty->fetch('themes/SuiteP/t...', NULL, NULL, true)
#14 /opt/lampp/htdocs/LQCRM/include/MVC/View/SugarView.php(794): Smarty->display('themes/SuiteP/t...')
#15 /opt/lampp/htdocs/LQCRM/include/MVC/View/SugarView.php(218): SugarView->displayHeader()
#16 /opt/lampp/htdocs/LQCRM/include/MVC/Controller/SugarController.php(435): SugarView->process()
#17 /opt/lampp/htdocs/LQCRM/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#18 /opt/lampp/htdocs/LQCRM/include/MVC/SugarApplication.php(113): SugarController->execute()
#19 /opt/lampp/htdocs/LQCRM/index.php(52): SugarApplication->execute()
#20 {main}

Tuesday 10 December 2019 06:37:18 AM CET [4582][1][FATAL] Mysqli_query failed.
Tuesday 10 December 2019 06:37:18 AM CET [4582][1][FATAL] Retrieving record by id documents:a2b6149b-eb70-4a2f-d234-5dee13bdc131 found  Query Failed: SELECT documents.*,documents_cstm.* FROM documents  LEFT JOIN documents_cstm ON documents.id = documents_cstm.id_c  WHERE documents.id = 'a2b6149b-eb70-4a2f-d234-5dee13bdc131' AND documents.deleted=0 LIMIT 0,1: MySQL error 1932: Table 'LQCRM.documents_cstm' doesn't exist in engine
Tuesday 10 December 2019 06:37:18 AM CET [4582][1][FATAL] Exception handling in /opt/lampp/htdocs/LQCRM/include/MVC/Controller/SugarController.php:400
Tuesday 10 December 2019 06:37:18 AM CET [4582][1][FATAL] Exception in Controller: Some garbage state left in stack (did you pop everything?)
Needs to restore:
	[error_reporting.sugar_smarty_errors] => 'sugar_smarty_errors'

Tuesday 10 December 2019 06:37:18 AM CET [4582][1][FATAL] backtrace:
#0 /opt/lampp/htdocs/LQCRM/include/Sugar_Smarty.php(161): SuiteCRM\StateSaver->__destruct()
#1 /opt/lampp/htdocs/LQCRM/vendor/smarty/smarty/libs/Smarty.class.php(1113): Sugar_Smarty->fetch('themes/SuiteP/t...', NULL, NULL, true)
#2 /opt/lampp/htdocs/LQCRM/include/MVC/View/SugarView.php(794): Smarty->display('themes/SuiteP/t...')
#3 /opt/lampp/htdocs/LQCRM/include/MVC/View/SugarView.php(218): SugarView->displayHeader()
#4 /opt/lampp/htdocs/LQCRM/include/MVC/Controller/SugarController.php(435): SugarView->process()
#5 /opt/lampp/htdocs/LQCRM/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#6 /opt/lampp/htdocs/LQCRM/include/MVC/SugarApplication.php(113): SugarController->execute()
#7 /opt/lampp/htdocs/LQCRM/index.php(52): SugarApplication->execute()
#8 {main}
Tuesday 10 December 2019 06:37:18 AM CET [4582][1][FATAL] Previous:

Tuesday 10 December 2019 06:37:18 AM CET [4582][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Tuesday 10 December 2019 06:37:18 AM CET [4582][1][FATAL] backtrace:
#0 /opt/lampp/htdocs/LQCRM/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /opt/lampp/htdocs/LQCRM/include/database/DBManager.php(328): DBManager->registerError('Retrieving reco...', 'Retrieving reco...', true)
#2 /opt/lampp/htdocs/LQCRM/include/database/MysqliManager.php(179): DBManager->checkError('Retrieving reco...', true)
#3 /opt/lampp/htdocs/LQCRM/include/database/MysqlManager.php(285): MysqliManager->query('SELECT document...', true, 'Retrieving reco...')
#4 /opt/lampp/htdocs/LQCRM/data/SugarBean.php(4531): MysqlManager->limitQuery('SELECT document...', 0, 1, true, 'Retrieving reco...')
#5 /opt/lampp/htdocs/LQCRM/include/SugarObjects/templates/file/File.php(144): SugarBean->retrieve('a2b6149b-eb70-4...', true, true)
#6 /opt/lampp/htdocs/LQCRM/data/BeanFactory.php(104): File->retrieve('a2b6149b-eb70-4...', true, true)
#7 /opt/lampp/htdocs/LQCRM/include/Smarty/plugins/function.suite_check_access.php(35): BeanFactory::getBean('Documents', 'a2b6149b-eb70-4...')
#8 /opt/lampp/htdocs/LQCRM/cache/smarty/templates_c/%%F6^F60^F609237E%%_headerModuleList.tpl.php(118): smarty_function_suite_check_access(Array, Object(Sugar_Smarty))
#9 /opt/lampp/htdocs/LQCRM/vendor/smarty/smarty/libs/Smarty.class.php(1876): include('/opt/lampp/htdo...')
#10 /opt/lampp/htdocs/LQCRM/cache/smarty/templates_c/%%F9^F94^F946E606%%header.tpl.php(23): Smarty->_smarty_include(Array)
#11 /opt/lampp/htdocs/LQCRM/vendor/smarty/smarty/libs/Smarty.class.php(1263): include('/opt/lampp/htdo...')
#12 /opt/lampp/htdocs/LQCRM/include/Sugar_Smarty.php(161): Smarty->fetch('themes/SuiteP/t...', NULL, NULL, true)
#13 /opt/lampp/htdocs/LQCRM/vendor/smarty/smarty/libs/Smarty.class.php(1113): Sugar_Smarty->fetch('themes/SuiteP/t...', NULL, NULL, true)
#14 /opt/lampp/htdocs/LQCRM/include/MVC/View/SugarView.php(794): Smarty->display('themes/SuiteP/t...')
#15 /opt/lampp/htdocs/LQCRM/include/MVC/View/SugarView.php(218): SugarView->displayHeader()
#16 /opt/lampp/htdocs/LQCRM/include/MVC/Controller/SugarController.php(435): SugarView->process()
#17 /opt/lampp/htdocs/LQCRM/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#18 /opt/lampp/htdocs/LQCRM/include/MVC/SugarApplication.php(113): SugarController->execute()
#19 /opt/lampp/htdocs/LQCRM/index.php(52): SugarApplication->execute()
#20 {main}

Tuesday 10 December 2019 06:42:13 AM CET [4583][1][FATAL] Mysqli_query failed.
Tuesday 10 December 2019 06:42:13 AM CET [4583][1][FATAL] Retrieving record by id documents:a2b6149b-eb70-4a2f-d234-5dee13bdc131 found  Query Failed: SELECT documents.*,documents_cstm.* FROM documents  LEFT JOIN documents_cstm ON documents.id = documents_cstm.id_c  WHERE documents.id = 'a2b6149b-eb70-4a2f-d234-5dee13bdc131' AND documents.deleted=0 LIMIT 0,1: MySQL error 1932: Table 'LQCRM.documents_cstm' doesn't exist in engine
Tuesday 10 December 2019 06:42:13 AM CET [4583][1][FATAL] Exception handling in /opt/lampp/htdocs/LQCRM/include/MVC/Controller/SugarController.php:400
Tuesday 10 December 2019 06:42:13 AM CET [4583][1][FATAL] Exception in Controller: Some garbage state left in stack (did you pop everything?)
Needs to restore:
	[error_reporting.sugar_smarty_errors] => 'sugar_smarty_errors'

Tuesday 10 December 2019 06:42:13 AM CET [4583][1][FATAL] backtrace:
#0 /opt/lampp/htdocs/LQCRM/include/Sugar_Smarty.php(161): SuiteCRM\StateSaver->__destruct()
#1 /opt/lampp/htdocs/LQCRM/vendor/smarty/smarty/libs/Smarty.class.php(1113): Sugar_Smarty->fetch('themes/SuiteP/t...', NULL, NULL, true)
#2 /opt/lampp/htdocs/LQCRM/include/MVC/View/SugarView.php(794): Smarty->display('themes/SuiteP/t...')
#3 /opt/lampp/htdocs/LQCRM/include/MVC/View/SugarView.php(218): SugarView->displayHeader()
#4 /opt/lampp/htdocs/LQCRM/include/MVC/Controller/SugarController.php(435): SugarView->process()
#5 /opt/lampp/htdocs/LQCRM/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#6 /opt/lampp/htdocs/LQCRM/include/MVC/SugarApplication.php(113): SugarController->execute()
#7 /opt/lampp/htdocs/LQCRM/index.php(52): SugarApplication->execute()
#8 {main}
Tuesday 10 December 2019 06:42:13 AM CET [4583][1][FATAL] Previous:

Tuesday 10 December 2019 06:42:13 AM CET [4583][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Tuesday 10 December 2019 06:42:13 AM CET [4583][1][FATAL] backtrace:
#0 /opt/lampp/htdocs/LQCRM/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /opt/lampp/htdocs/LQCRM/include/database/DBManager.php(328): DBManager->registerError('Retrieving reco...', 'Retrieving reco...', true)
#2 /opt/lampp/htdocs/LQCRM/include/database/MysqliManager.php(179): DBManager->checkError('Retrieving reco...', true)
#3 /opt/lampp/htdocs/LQCRM/include/database/MysqlManager.php(285): MysqliManager->query('SELECT document...', true, 'Retrieving reco...')
#4 /opt/lampp/htdocs/LQCRM/data/SugarBean.php(4531): MysqlManager->limitQuery('SELECT document...', 0, 1, true, 'Retrieving reco...')
#5 /opt/lampp/htdocs/LQCRM/include/SugarObjects/templates/file/File.php(144): SugarBean->retrieve('a2b6149b-eb70-4...', true, true)
#6 /opt/lampp/htdocs/LQCRM/data/BeanFactory.php(104): File->retrieve('a2b6149b-eb70-4...', true, true)
#7 /opt/lampp/htdocs/LQCRM/include/Smarty/plugins/function.suite_check_access.php(35): BeanFactory::getBean('Documents', 'a2b6149b-eb70-4...')
#8 /opt/lampp/htdocs/LQCRM/cache/smarty/templates_c/%%F6^F60^F609237E%%_headerModuleList.tpl.php(118): smarty_function_suite_check_access(Array, Object(Sugar_Smarty))
#9 /opt/lampp/htdocs/LQCRM/vendor/smarty/smarty/libs/Smarty.class.php(1876): include('/opt/lampp/htdo...')
#10 /opt/lampp/htdocs/LQCRM/cache/smarty/templates_c/%%F9^F94^F946E606%%header.tpl.php(23): Smarty->_smarty_include(Array)
#11 /opt/lampp/htdocs/LQCRM/vendor/smarty/smarty/libs/Smarty.class.php(1263): include('/opt/lampp/htdo...')
#12 /opt/lampp/htdocs/LQCRM/include/Sugar_Smarty.php(161): Smarty->fetch('themes/SuiteP/t...', NULL, NULL, true)
#13 /opt/lampp/htdocs/LQCRM/vendor/smarty/smarty/libs/Smarty.class.php(1113): Sugar_Smarty->fetch('themes/SuiteP/t...', NULL, NULL, true)
#14 /opt/lampp/htdocs/LQCRM/include/MVC/View/SugarView.php(794): Smarty->display('themes/SuiteP/t...')
#15 /opt/lampp/htdocs/LQCRM/include/MVC/View/SugarView.php(218): SugarView->displayHeader()
#16 /opt/lampp/htdocs/LQCRM/include/MVC/Controller/SugarController.php(435): SugarView->process()
#17 /opt/lampp/htdocs/LQCRM/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#18 /opt/lampp/htdocs/LQCRM/include/MVC/SugarApplication.php(113): SugarController->execute()
#19 /opt/lampp/htdocs/LQCRM/index.php(52): SugarApplication->execute()
#20 {main}

Mac-Rae · 10 December 2019 08:52

Hi there,

It would be of great assistance in debugging this issue if the logs could be provided at the “Debug” reporting level, however, these logs are showing many issues in regards to databases.

For example;

Mon Dec 9 09:10:22 2019 [24461][1][FATAL] Query Failed: ALTER TABLE documents_cstm drop COLUMN parent_name: MySQL error 1091: Can’t DROP COLUMN parent_name; check that it exists

Tuesday 10 December 2019 06:37:11 AM CET [4582][1][FATAL] Retrieving record by id documents:a2b6149b-eb70-4a2f-d234-5dee13bdc131 found Query Failed: SELECT documents.,documents_cstm. FROM documents LEFT JOIN documents_cstm ON documents.id = documents_cstm.id_c WHERE documents.id = ‘a2b6149b-eb70-4a2f-d234-5dee13bdc131’ AND documents.deleted=0 LIMIT 0,1: MySQL error 1932: Table ‘LQCRM.documents_cstm’ doesn’t exist in engine

Which appear to be reporting the table documents_cstm doesn’t exist.

Via a database manager could you check if this table is present?
Have you recently made any field changes to this module? If so have you run a Quick Repair & Rebuild to ensure both vardefs are database are in sync?

Could you also please provide a screenshot of the white-screening you are getting when logging in?

Thanks

Mac-Rae · 16 December 2019 14:23