Sales Quotas

by NS-Team

Define Quotas for your Sales Reps and visualize achievement and forecast.

Cancel at any time!
Free Trial

#2889 - Does not work. Database Failure.

Closed Installation created by sollo 4 years ago

Hello,

I attempted to install the sales quotas module, which was successful, but after opening the module I was greeted with "Database Failure. Please refer to Suitecrm.log for more details". I have attached the log file to this email. I am running SuiteCRM version 7.11.13 (Sugar Version 6.5.25 (Build 344)) on an Ubuntu Apache server running php 7.2 . Should be well within the sales quota's ability to run. Please help with this as soon as possible.

  1. bluquet member avatar

    NS-Team Provider Affiliate

    4 years ago

    Hi,

    I have not received your log, but I believe you should run Repair / Quick Repair from the admin page. At the bottom, you will probably see some SQL queries and an Execute button,. Click on that button.

  2. sollo member avatar

    sollo

    4 years ago

    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

  3. sollo member avatar

    sollo

    4 years ago

    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!

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • Supported Versions
  • 7.1.0 to 8.6.1

Other add-ons of interest

Glances - Integrate SuiteCRM with all your apps

The simplest way to work™. Glances integrates SuiteCRM with all your favorite workplace apps, acting as your go-to hub for real-time customer insights and personal tasks.

Featured

Mokas SalesPipe

Intuitive and powerful sales pipe management for SuiteCRM opportunites

Rating

Opportunity Line Item

Line Items in your Opportunity are used to record the products and/or services that your prospective customer may be interested in buying. You can add as many more as needed and you can modify the values and quantities as you learn more about the Opportunity.

Rating
Sales Productivity Reporting quota target objectives forecast sales