Sales Quotas

by NS-Team

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

Free 30 day trial
Try it Now

#2889 - Does not work. Database Failure.

Closed Installation created by sollo 3 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

    3 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

    3 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

    3 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.4.2

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

Sales Commissions

Calculate Sales Commission - Incentives for your Team or Individually.

Profile Scoring

Profile scores allow customer-facing teams to prioritize and pay attention to significant (potential) customers.

Rating
Sales Productivity Reporting quota target objectives forecast sales