Support November 11th, 2020 @ 9:41 pm

My quotas are based on invoices. My users did not have access to this module. I just corrected that and it fixed it. Thank you so much for your help!

View Comment

Is it possible to select another module to pull data from?

Support July 21st, 2020 @ 5:06 pm

Got it. Thanks for the reply. I figured as much. We do use quotes, but they don't apply to the sales pipeline. I see that your software can also pull from the invoice module. I'll make some customizations to that and use that instead. No worries at all.

View Comment

Cannot update Quotas

Support July 2nd, 2020 @ 3:35 pm

Hello, After looking at this problem myself, the issue is half solved. The issue was that 2.3 was leaving tables in DB, even after I selected "remove all tables" at uninstall and even after performing a quick repair and rebuild. I went into the database and manually removed all of the left over tables, then installed version 2.5 and now it is working. The only issue I am having now is that there is no text appearing in the sales VS quota dashlet. It is just numbers and the graphs. I can absolutely allow you into the CRM to debug/take a look yourself to clean up the remaining issues. This will have to be later in the day when my users are offline. What exactly would you need access to? Just the CRM via and admin login? Or you would also need access to the DB and file system on the webserver? Thank you for your time

View Comment

Cannot update Quotas

Support July 2nd, 2020 @ 1:54 pm

With version 2.5 I lose the text boxes to input quotas completely. The edit quotas page is blank and just shows everyone's names. What do you advise I do next? Nothing with your module appears to be working.

View Comment

Cannot update Quotas

Support July 1st, 2020 @ 8:30 pm

I am running 2.3A. The system requirements with version 2.5 don't line up with me. I am running suiteCRM 7.11.13 . Is there away that I can get version 2.3 to work?

View Comment

Does not work. Database Failure.

Support June 25th, 2020 @ 5:07 pm

That fixed it! I'll be playing with it more over the next couple of days but from what I see so far, everything is working. Thank you!

View Comment

Does not work. Database Failure.

Support June 25th, 2020 @ 2:44 pm

Sorry! Here is my log, I will try the quick repair and rebuild.

Thu Jun 25 14:14:38 2020 [19450][1][FATAL] Mysqli_query failed. Thu Jun 25 14:14:38 2020 [19450][1][FATAL] Query Failed: select amount,id from ns_user_quotas where deleted = 0 and assigned_user_id = '1' and date_start = '2020-01-01' and date_end = '2020-03-31': MySQL error 1146: Table 'suitecrm.ns_user_quotas' doesn't exist Thu Jun 25 14:14:38 2020 [19450][1][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:400 Thu Jun 25 14:14:38 2020 [19450][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details. Thu Jun 25 14:14:38 2020 [19450][1][FATAL] backtrace:

0 /var/www/html/suitecrm/include/database/DBManager.php(353): sugar_die('Database failur...')

1 /var/www/html/suitecrm/include/database/DBManager.php(328): DBManager->registerError(' Query Failed: ...', ' Query Failed: ...', true)

2 /var/www/html/suitecrm/include/database/MysqliManager.php(179): DBManager->checkError(' Query Failed: ...', true)

3 /var/www/html/suitecrm/modules/NS_User_Quotas/quota_utils.php(392): MysqliManager->query('select amount,i...', true)

4 /var/www/html/suitecrm/modules/NS_User_Quotas/Quotas_report.php(124): Quota_Utils->get_quota_results('Q', Array, '2020')

5 /var/www/html/suitecrm/modules/NS_User_Quotas/views/view.quotareport.php(16): include_once('/var/www/html/s...')

6 /var/www/html/suitecrm/include/MVC/View/SugarView.php(226): NS_User_QuotasViewquotareport->display()

7 /var/www/html/suitecrm/include/MVC/Controller/SugarController.php(435): SugarView->process()

8 /var/www/html/suitecrm/include/MVC/Controller/SugarController.php(375): SugarController->processView()

9 /var/www/html/suitecrm/include/MVC/SugarApplication.php(113): SugarController->execute()

10 /var/www/html/suitecrm/index.php(52): SugarApplication->execute()

11

Thu Jun 25 14:15:06 2020 [19449][1][FATAL] Mysqli_query failed. Thu Jun 25 14:15:06 2020 [19449][1][FATAL] Query Failed: select amount,id from ns_user_quotas where deleted = 0 and assigned_user_id = '1' and date_start = '2020-01-01' and date_end = '2020-03-31': MySQL error 1146: Table 'suitecrm.ns_user_quotas' doesn't exist Thu Jun 25 14:15:06 2020 [19449][1][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:400 Thu Jun 25 14:15:06 2020 [19449][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details. Thu Jun 25 14:15:06 2020 [19449][1][FATAL] backtrace:

0 /var/www/html/suitecrm/include/database/DBManager.php(353): sugar_die('Database failur...')

1 /var/www/html/suitecrm/include/database/DBManager.php(328): DBManager->registerError(' Query Failed: ...', ' Query Failed: ...', true)

2 /var/www/html/suitecrm/include/database/MysqliManager.php(179): DBManager->checkError(' Query Failed: ...', true)

3 /var/www/html/suitecrm/modules/NS_User_Quotas/quota_utils.php(392): MysqliManager->query('select amount,i...', true)

4 /var/www/html/suitecrm/modules/NS_User_Quotas/Quotas_report.php(124): Quota_Utils->get_quota_results('Q', Array, '2020')

5 /var/www/html/suitecrm/modules/NS_User_Quotas/views/view.quotareport.php(16): include_once('/var/www/html/s...')

6 /var/www/html/suitecrm/include/MVC/View/SugarView.php(226): NS_User_QuotasViewquotareport->display()

7 /var/www/html/suitecrm/include/MVC/Controller/SugarController.php(435): SugarView->process()

8 /var/www/html/suitecrm/include/MVC/Controller/SugarController.php(375): SugarController->processView()

9 /var/www/html/suitecrm/include/MVC/SugarApplication.php(113): SugarController->execute()

10 /var/www/html/suitecrm/index.php(52): SugarApplication->execute()

11

Thu Jun 25 14:17:39 2020 [19449][1][FATAL] Mysqli_query failed. Thu Jun 25 14:17:39 2020 [19449][1][FATAL] Query Failed: select amount,id from ns_user_quotas where deleted = 0 and assigned_user_id = '1' and date_start = '2020-01-01' and date_end = '2020-03-31': MySQL error 1146: Table 'suitecrm.ns_user_quotas' doesn't exist Thu Jun 25 14:17:39 2020 [19449][1][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:400 Thu Jun 25 14:17:39 2020 [19449][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details. Thu Jun 25 14:17:39 2020 [19449][1][FATAL] backtrace:

0 /var/www/html/suitecrm/include/database/DBManager.php(353): sugar_die('Database failur...')

1 /var/www/html/suitecrm/include/database/DBManager.php(328): DBManager->registerError(' Query Failed: ...', ' Query Failed: ...', true)

2 /var/www/html/suitecrm/include/database/MysqliManager.php(179): DBManager->checkError(' Query Failed: ...', true)

3 /var/www/html/suitecrm/modules/NS_User_Quotas/quota_utils.php(392): MysqliManager->query('select amount,i...', true)

4 /var/www/html/suitecrm/modules/NS_User_Quotas/Quotas_report.php(119): Quota_Utils->get_quota_results('Q', Array, '2020')

5 /var/www/html/suitecrm/modules/NS_User_Quotas/views/view.quotareport.php(16): include_once('/var/www/html/s...')

6 /var/www/html/suitecrm/include/MVC/View/SugarView.php(226): NS_User_QuotasViewquotareport->display()

7 /var/www/html/suitecrm/include/MVC/Controller/SugarController.php(435): SugarView->process()

8 /var/www/html/suitecrm/include/MVC/Controller/SugarController.php(375): SugarController->processView()

9 /var/www/html/suitecrm/include/MVC/SugarApplication.php(113): SugarController->execute()

10 /var/www/html/suitecrm/index.php(52): SugarApplication->execute()

11

Thu Jun 25 14:21:00 2020 [19450][1][FATAL] Mysqli_query failed. Thu Jun 25 14:21:00 2020 [19450][1][FATAL] Query Failed: select amount,id from ns_user_quotas where deleted = 0 and assigned_user_id = '1' and date_start = '2020-01-01' and date_end = '2020-03-31': MySQL error 1146: Table 'suitecrm.ns_user_quotas' doesn't exist Thu Jun 25 14:21:00 2020 [19450][1][FATAL] Exception handling in /var/www/html/suitecrm/include/MVC/Controller/SugarController.php:400 Thu Jun 25 14:21:00 2020 [19450][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details. Thu Jun 25 14:21:00 2020 [19450][1][FATAL] backtrace:

0 /var/www/html/suitecrm/include/database/DBManager.php(353): sugar_die('Database failur...')

1 /var/www/html/suitecrm/include/database/DBManager.php(328): DBManager->registerError(' Query Failed: ...', ' Query Failed: ...', true)

2 /var/www/html/suitecrm/include/database/MysqliManager.php(179): DBManager->checkError(' Query Failed: ...', true)

3 /var/www/html/suitecrm/modules/NS_User_Quotas/quota_utils.php(388): MysqliManager->query('select amount,i...', true)

4 /var/www/html/suitecrm/modules/NS_User_Quotas/Quotas_report.php(119): Quota_Utils->get_quota_results('Q', Array, '2020')

5 /var/www/html/suitecrm/modules/NS_User_Quotas/views/view.quotareport.php(16): include_once('/var/www/html/s...')

6 /var/www/html/suitecrm/include/MVC/View/SugarView.php(226): NS_User_QuotasViewquotareport->display()

7 /var/www/html/suitecrm/include/MVC/Controller/SugarController.php(435): SugarView->process()

8 /var/www/html/suitecrm/include/MVC/Controller/SugarController.php(375): SugarController->processView()

9 /var/www/html/suitecrm/include/MVC/SugarApplication.php(113): SugarController->execute()

10 /var/www/html/suitecrm/index.php(52): SugarApplication->execute()

11

View Comment