#1199 - Sales Quotas not Working
Hello,
I installed v1.9 on my suitecrm Version 7.8.2. The install was successful.
After installed, when I opened Sales Quotas, I got a blank pop-up/frame with an error message: "if this error persists please have your administrator disable ajax for this module"
I disabled AJAX for Sales Quotas module. Now the Sales Quotas module opens, but it is blank - I have tried opening Edit Quotas and View Quotas, but both are blank.
Would appreciate if you could help resolve this issue.
gabriel1
5 years ago
Can you run Repair/ Quick Repair and check if some SQL queries need to be executed?
5 years ago
I did run Quick Repair and Rebuild and it asks for the following commands to be executed - however when I press Execute, nothing happens:
/* Table : campaigns / /COLUMNS/ /MISMATCH WITH DATABASE - end_date - ROW [name] => 'end_date' [type] => 'varchar' [len] => '15' / / VARDEF - end_date - ROW[name] => 'end_date' [vname] => 'LBL_CAMPAIGN_END_DATE' [type] => 'date' [audited] => '1' [comment] => 'Ending date of the campaign' [importable] => 'required' [required] => '' [enable_range_search] => '1' [options] => 'date_range_search_dom' [dbType] => 'date' [len] => '' / / INDEXES / ALTER TABLE campaigns modify COLUMN end_date date NULL ; / Table : email_marketing / /COLUMNS/ /MISMATCH WITH DATABASE - date_start - ROW [name] => 'date_start' [type] => 'varchar' [len] => '20' / / VARDEF - date_start - ROW[name] => 'date_start' [vname] => 'LBL_DATE_START' [type] => 'datetime' [importable] => 'required' [required] => '' [dbType] => 'datetime' [len] => '' / / INDEXES / ALTER TABLE email_marketing modify COLUMN date_start datetime NULL ; / Table : ns_user_quotas / / MISSING TABLE: ns_user_quotas */ CREATE TABLE ns_user_quotas (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,date_start date NULL ,date_end date NULL ,period varchar(100) DEFAULT 'Q' NULL ,amount decimal(26,6) NULL ,achieved decimal(26,6) NULL ,achieved_locked bool DEFAULT '0' NULL ,quota_locked bool DEFAULT '0' NULL ,currency_id char(36) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
5 years ago
Some of these queries are related to Sales Quotas module, some are not. What do you mean by "nothing happens".
5 years ago
After I press Execute, the page waits for 5-10 mins and then the pages goes blank.
Then I open Sales Quotas that is also blank.
When I run Quick Repair and Rebuild it gives me the same commands to Execute again.
5 years ago
Then you have a problem with your SuiteCRM install. That might be due to your 7.8.2 version. Latest 7.8 version is 7.8.20