While im installing my Customized Suitecrm i have an exception in my sugarcrm.log file
/* Table : aos_products_quotes /
/ MISSING TABLE: aos_products_quotes */
CREATE TABLE aos_products_quotes (id char(36) NOT NULL ,name text 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 ,currency_id char(36) NULL ,part_number varchar(255) NULL ,item_description text NULL ,number int(11) NULL ,product_qty decimal(18,4) NULL ,product_cost_price decimal(26,6) NULL ,product_cost_price_usdollar decimal(26,6) NULL ,product_list_price decimal(26,6) NULL ,product_list_price_usdollar decimal(26,6) NULL ,product_discount decimal(26,6) NULL ,product_discount_usdollar decimal(26,6) NULL ,product_discount_amount decimal(26,6) NULL ,product_discount_amount_usdollar decimal(26,6) NULL ,discount varchar(255) DEFAULT ‘Percentage’ NULL ,product_unit_price decimal(26,6) NULL ,product_unit_price_usdollar decimal(26,6) NULL ,vat_amt decimal(26,6) NULL ,vat_amt_usdollar decimal(26,6) NULL ,product_total_price decimal(26,6) NULL ,product_total_price_usdollar decimal(26,6) NULL ,vat varchar(100) DEFAULT ‘5.0’ NULL ,parent_type varchar(255) NULL ,parent_id char(255) NULL ,product_id char(36) NULL ,group_id char(36) NULL , PRIMARY KEY (id), KEY idx_aospq_par_del (parent_id, parent_type, deleted)) CHARACTER SET utf8 COLLATE utf8_general_ci;
#MYSQL Error 1071: Key length was too long
I’m trying to avoid exception and installed the Suitecrm but in quotation window its not working perfectly…While Adding line items its shows undefined…
Someone guide me how to solve this error …I have a Demo on tomorrow.