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.