Status : Setting db config ....


Status : Setting db config ....


Status : Cheking backup files ....


Status : Checking files to be replaced ....


Status : Cheking permission of new files ....


Status : backup existing files to be replaced ....


Status : backup of database ....


Status : replacing old files ....


Status : copying new files ....


Status : running single sql ....


Status : custom php ....


Status : changing version name ....


Result : Fail query ....

Query : ALTER TABLE `company` ADD `masterMSIC` INT(12) NOT NULL 
Query : ALTER TABLE `comp_supplier_invoice` ADD `invoiceType` TINYINT(1) NOT NULL AFTER `badDebtID`
Query : ALTER TABLE `supplier` ADD `approvalNo` VARCHAR(32) NOT NULL AFTER is_delete, ADD `commenceDate` DATE NOT NULL AFTER `approvalNo`, ADD `ceaseDate` DATE NOT NULL AFTER `commenceDate`
Query : ALTER TABLE `comp_payment_others` ADD `simplifiedTax` INT(1) NOT NULL AFTER `memo`
Query : ALTER TABLE `comp_payment_others_without_item` ADD `taxBL` DOUBLE NOT NULL AFTER `taxID`
Query : INSERT INTO `_ref_gst_03_field` (`id`, `item`, `description`, `taxCode`, `changeable`, `createdTS`, `updatedTS`) VALUES (1, 'B5a', 'Total Value of Standard Rated Supply', 'SR,DS', 1, '2015-07-10 01:17:43', '2015-07-10 06:53:15'), (2, 'B5b', 'Total Output Tax (Inclusive of Tax Value on Bad Debt Recovered & other Adjustments)', 'SR,DS,AJS', 1, '2015-07-10 01:17:43', '2015-07-10 06:53:21'), (3, 'B6a', 'Total Value of Standard Rate and Flat Rate Acquisitions', 'TX,IM,IMS,TX-E43,TX-RE', 1, '2015-07-10 01:18:11', '2015-07-10 06:53:31'), (4, 'B6b', 'Total Input Tax (Inclusive of Tax Value on Bad Debt Relief & other Adjustments)', 'TX-CG,TX,IM,IMS,TX-E43,TX-RE,AJP', 1, '2015-07-10 01:18:11', '2015-07-10 06:53:44'), (5, 'B7', 'GST Amount Payable (Item 5b - Item 6b)', '', 0, '2015-07-10 01:19:22', '2015-07-10 06:56:52'), (6, 'B8', 'GST Amount Claimable (Item 6b - Item 5b)', '', 0, '2015-07-10 01:19:22', '2015-07-10 06:56:55'), (7, 'C10', 'Total Value of Local Zero-Rated Supplies', 'ZRL', 1, '2015-07-10 01:19:37', '2015-07-10 06:54:18'), (8, 'C11', 'Total Value of Export Supplies', 'ZRE', 1, '2015-07-10 01:19:37', '2015-07-10 06:54:29'), (9, 'C12', 'Total Value of Exempt Supplies', 'ES43,ES', 1, '2015-07-10 01:19:52', '2015-07-10 06:54:33'), (10, 'C13', 'Total Value of Supplies Granted GST Relief', 'RS', 1, '2015-07-10 01:19:52', '2015-07-10 06:54:38'), (11, 'C14', 'Total Value of Goods Imported Under Approved Trader Scheme', 'IS', 1, '2015-07-10 01:20:11', '2015-07-10 06:54:47'), (12, 'C15', 'Total Value of GST Suspended under item 14', '', 0, '2015-07-10 01:20:11', '2015-07-10 06:57:02'), (13, 'C16', 'Total Value of Capital Goods Acquired', 'TX-CG', 1, '2015-07-10 01:20:28', '2015-07-10 06:54:48'), (14, 'C17', 'Total Value of Bad Debt Relief Inclusive Tax', '', 0, '2015-07-10 01:20:28', '2015-07-10 06:57:06'), (15, 'C18', 'Total Value of Bad Debt Recovered Inclusive Tax', '', 0, '2015-07-10 01:20:38', '2015-07-10 06:57:09')
Query : INSERT INTO `_sys_menu` (`fldid`, `code`, `name`, `parents`, `module`, `submenu`, `urls`, `urls2`, `access`, `seq`, `display`, `icons`, `language`) VALUES (387, 'GSTTXMP', 'gsttaxmapping', '102', '6', 0, 'gstsetting/GSTtaxMapping', '0', NULL, 33, 1, 'icon-active.png', 'EN')
Query : ALTER TABLE `zakat_details` ADD `checkAble` TINYINT(1) NOT NULL AFTER `updatedTS`
Query : ALTER TABLE `zakat_summary` ADD `updateAble` TINYINT(1) NOT NULL DEFAULT '1' AFTER `is_delete`
Query : ALTER TABLE `zakat_details` ADD `compAcctDetailID` INT(11) NOT NULL AFTER `zakatSummaryID`
Query : ALTER TABLE `comp_gst_preference` ADD `suppGSTregistrationVerifyFrequency` INT(20) NOT NULL DEFAULT '1' AFTER `TotalexemptsuppliesnotexceedPercentage`
Query : CREATE TABLE `comp_historical_supplier_invoice` ( `ID` INT(11) NOT NULL AUTO_INCREMENT , `serialNo` INT(11) NOT NULL DEFAULT '1' , `companyID` INT(11) NOT NULL , `supplierID` INT(11) NOT NULL , `formNo` VARCHAR(32) NOT NULL , `invoiceDate` DATE NOT NULL , `supplierInvoiceNo` VARCHAR(32) NOT NULL , `currencyID` INT(11) NOT NULL , `exchangeRate` DOUBLE NOT NULL , `totalAmount` DOUBLE NOT NULL , `amountPaid` DOUBLE NOT NULL , `totalTaxAmount` DOUBLE NOT NULL , `totalPayable` DOUBLE NOT NULL , `total` DOUBLE NOT NULL , `createdBy` INT(11) NOT NULL , `createdTS` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `updatedBy` INT(11) NOT NULL , `updatedTS` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL , `is_delete` SMALLINT(16) NOT NULL , `updateAble` TINYINT(1) NOT NULL , PRIMARY KEY (`ID`) ) ENGINE = InnoDB
Query : CREATE TABLE `comp_historical_customer_invoice` ( `ID` INT(11) NOT NULL AUTO_INCREMENT , `serialNo` INT(11) NOT NULL DEFAULT '1' , `companyID` INT(11) NOT NULL , `customerID` INT(11) NOT NULL , `formNo` VARCHAR(32) NOT NULL , `salesInvoiceDate` DATE NOT NULL , `customerPoNo` VARCHAR(32) NOT NULL , `taxID` INT(11) NOT NULL , `currencyID` INT(11) NOT NULL , `exchangeRate` DOUBLE NOT NULL , `amount` DOUBLE NOT NULL , `totalTaxAmount` DOUBLE NOT NULL , `totalReceivable` DOUBLE NOT NULL ,`total` DOUBLE NOT NULL , `totalAmount` DOUBLE NOT NULL , `createdBy` INT(11) NOT NULL , `createdTS` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `updatedBy` INT(11) NOT NULL , `updatedTS` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL , `is_delete` SMALLINT(6) NOT NULL , `updateAble` SMALLINT(6) NOT NULL DEFAULT '1' , PRIMARY KEY (`ID`) ) ENGINE = InnoDB
Query : drop TRIGGER is exists `trigger_before_insert_historicalcusinv_add_serialNo` 
Query : CREATE TRIGGER `trigger_before_insert_historicalsupinv_add_serialNo` BEFORE INSERT ON `comp_historical_supplier_invoice` FOR EACH ROW set new.serialNo = (select nextSerialNo from view_serial_comp_historical_supplier_invoice where companyID = new.companyID)
Query : INSERT INTO `_sys_menu` (`fldid`, `code`, `name`, `parents`, `module`, `submenu`, `urls`, `urls2`, `access`, `seq`, `display`, `icons`, `language`) VALUES ('389', 'ARHISTCUSINV', 'HistoricalCustomerInvoice', '86', '2', '0', 'historicalinvoice/historicalCustomerInvoice', '0', NULL, '10', '1', 'icon-active.png', 'EN')
Query : INSERT INTO `_sys_menu` (`fldid`, `code`, `name`, `parents`, `module`, `submenu`, `urls`, `urls2`, `access`, `seq`, `display`, `icons`, `language`) VALUES ('390', 'APHISTSUPINV', 'HistoricalSupplierInvoice', '85', '3', '0', 'historicalinvoice/HistoricalSupplierInvoice', '0', NULL, '15', '1', 'icon-active.png', 'EN')
Query : create or replace VIEW `view_expence_and_income` AS select `a`.`companyID` AS `companyid`,`a`.`year` AS `year`,`a`.`period` AS `period`,`c`.`ID` AS `groupID`,`c`.`acctTypeID` AS `acctType`, coalesce(sum(`a`.`amountdr`),0) AS `totalDr`, coalesce(sum(`a`.`amountcr`),0) AS `totalCr`, if((`c`.`acctTypeID` = 3),(coalesce(sum(`a`.`amountcr`),0) - coalesce(sum(`a`.`amountdr`),0)),(coalesce(sum(`a`.`amountdr`),0) - coalesce(sum(`a`.`amountcr`),0))) AS `balance` from ((`comp_acc_det` `a` join `comp_chart_of_acct` `b`) join `_ref_acct_group` `c`) where ((`b`.`ID` = `a`.`acctID`) and (`c`.`ID` = `b`.`acctGroupID`) and (`c`.`acctTypeID` in (3,4)) and (`c`.`title` = 1) and (`a`.`period` > 0)) and b.companyID > 0 group by `a`.`companyID`,`a`.`year`,`a`.`period`,`acctType` create or replace view view_journal_table as select distinct `a`.`ID` AS `ID`,`a`.`companyID` AS `companyID`,`a`.`referenceNo` AS `referenceNo`,'comp_cash_sales' AS `tableName`,`b`.`journalID` AS `journalID`,`b`.`formNo` AS `formNo` from (`comp_cash_sales` `a` join `comp_journal` `b`) where ((convert(`a`.`journalNo` using utf8) = `b`.`journalID`) and (`a`.`is_delete` = 0)) union select distinct `a`.`ID` AS `ID`,`a`.`companyID` AS `companyID`,`a`.`referenceNo` AS `referenceNo`,'comp_payment' AS `comp_payment`,`b`.`journalID` AS `journalID`,`b`.`formNo` AS `formNo` from (`comp_payment` `a` join `comp_journal` `b`) where ((convert(`a`.`journalNo` using utf8) = `b`.`journalID`) and (`a`.`is_delete` = 0)) union select distinct `a`.`ID` AS `ID`,`a`.`companyID` AS `companyID`,`a`.`referenceNo` AS `referenceNo`,'comp_payment_others' AS `comp_payment_others`,`b`.`journalID` AS `journalID`,`b`.`formNo` AS `formNo` from (`comp_payment_others` `a` join `comp_journal` `b`) where ((convert(`a`.`journalNo` using utf8) = `b`.`journalID`) and (`a`.`is_delete` = 0)) union select distinct `a`.`ID` AS `ID`,`a`.`companyID` AS `companyID`,`a`.`formNo` AS `referenceNo`,'comp_purchase_order' AS `comp_purchase_order`,`b`.`journalID` AS `journalID`,`b`.`formNo` AS `formNo` from (`comp_purchase_order` `a` join `comp_journal` `b`) where ((convert(`a`.`journalNo` using utf8) = `b`.`journalID`) and (`a`.`is_delete` = 0)) union select distinct `a`.`ID` AS `ID`,`a`.`companyID` AS `companyID`,`a`.`referenceNo` AS `referenceNo`,'comp_receive_payment' AS `comp_receive_payment`,`b`.`journalID` AS `journalID`,`b`.`formNo` AS `formNo` from (`comp_receive_payment` `a` join `comp_journal` `b`) where ((convert(`a`.`journalNo` using utf8) = `b`.`journalID`) and (`a`.`is_delete` = 0)) union select distinct `a`.`ID` AS `ID`,`a`.`companyID` AS `companyID`,`a`.`referenceNo` AS `referenceNo`,'comp_receive_payment_others' AS `comp_receive_payment_others`,`b`.`journalID` AS `journalID`,`b`.`formNo` AS `formNo` from (`comp_receive_payment_others` `a` join `comp_journal` `b`) where ((convert(`a`.`journalNo` using utf8) = `b`.`journalID`) and (`a`.`is_delete` = 0)) union select distinct `a`.`ID` AS `ID`,`a`.`companyID` AS `companyID`,`b`.`formNo` AS `referenceNo`,'comp_sales_creditnote' AS `comp_sales_creditnote`,`b`.`journalID` AS `journalID`,`b`.`formNo` AS `formNo` from (`comp_sales_creditnote` `a` join `comp_journal` `b`) where ((convert(`a`.`journalNo` using utf8) = `b`.`journalID`) and (`a`.`is_delete` = 0)) union select distinct `a`.`ID` AS `ID`,`a`.`companyID` AS `companyID`,`b`.`formNo` AS `referenceNo`,'comp_sales_debitnote' AS `comp_sales_debitnote`,`b`.`journalID` AS `journalID`,`b`.`formNo` AS `formNo` from (`comp_sales_debitnote` `a` join `comp_journal` `b`) where ((convert(`a`.`journalNo` using utf8) = `b`.`journalID`) and (`a`.`is_delete` = 0)) union select distinct `a`.`ID` AS `ID`,`a`.`companyID` AS `companyID`,`a`.`customerPoNo` AS `referenceNo`,'comp_sales_invoice' AS `comp_sales_invoice`,`b`.`journalID` AS `journalID`,`b`.`formNo` AS `formNo` from (`comp_sales_invoice` `a` join `comp_journal` `b`) where ((convert(`a`.`journalNo` using utf8) = `b`.`journalID`) and (`a`.`is_delete` = 0)) union select distinct `a`.`ID` AS `ID`,`a`.`companyID` AS `companyID`,`b`.`formNo` AS `referenceNo`,'comp_supplier_creditnote' AS `comp_supplier_creditnote`,`b`.`journalID` AS `journalID`,`b`.`formNo` AS `formNo` from (`comp_supplier_creditnote` `a` join `comp_journal` `b`) where ((convert(`a`.`journalNo` using utf8) = `b`.`journalID`) and (`a`.`is_delete` = 0)) union select distinct `a`.`ID` AS `ID`,`a`.`companyID` AS `companyID`,`b`.`formNo` AS `referenceNo`,'comp_supplier_debitnote' AS `comp_supplier_debitnote`,`b`.`journalID` AS `journalID`,`b`.`formNo` AS `formNo` from (`comp_supplier_debitnote` `a` join `comp_journal` `b`) where ((convert(`a`.`journalNo` using utf8) = `b`.`journalID`) and (`a`.`is_delete` = 0)) union select distinct `a`.`ID` AS `ID`,`a`.`companyID` AS `companyID`,`a`.`supplierInvoiceNo` AS `referenceNo`,'comp_supplier_invoice' AS `comp_supplier_invoice`,`b`.`journalID` AS `journalID`,`b`.`formNo` AS `formNo` from (`comp_supplier_invoice` `a` join `comp_journal` `b`) where ((convert(`a`.`journalNo` using utf8) = `b`.`journalID`) and (`a`.`is_delete` = 0)) union select distinct `a`.`ID` AS `ID`,`a`.`companyID` AS `companyID`,`b`.`formNo` AS `referenceNo`,'comp_delivery_order' AS `comp_delivery_order`,`b`.`journalID` AS `journalID`,`b`.`formNo` AS `formNo` from (`comp_delivery_order` `a` join `comp_journal` `b`) where (convert(`a`.`journalNo` using utf8) = `b`.`journalID`) union select distinct `a`.`ID` AS `ID`,`a`.`companyID` AS `companyID`,`a`.`reference` AS `referenceNo`,'comp_gst_transaction' AS `comp_gst_transaction`,`b`.`journalID` AS `journalID`,`b`.`formNo` AS `formNo` from (`comp_gst_transaction` `a` join `comp_journal` `b`) where (convert(`a`.`journalNo` using utf8) = `b`.`journalID`) union select distinct `a`.`ID` AS `ID`,`a`.`companyID` AS `companyID`,`a`.`supplierDoNo` AS `referenceNo`,'comp_receive_item' AS `comp_receive_item`,`b`.`journalID` AS `journalID`,`b`.`formNo` AS `formNo` from (`comp_receive_item` `a` join `comp_journal` `b`) where (convert(`a`.`journalNo` using utf8) = `b`.`journalID`)
Query : INSERT INTO `_ref_visual_report` (`id`, `name`, `slug`, `description`, `file_path`, `dimension`, `screenShoot`) VALUES (1, 'Profit and Loss', 'profitLoss', 'Company profit and loss visual report', 'graph/profit-loss', '1x2', 'profit-n-loss.jpg'), (2, 'Sales Unpaid Invoices', 'salesDue', 'Visual report of company sales invoices, those are not yet paid.', 'graph/sales-due', '1x2', 'sales-outstanding.jpg'), (3, 'Due Purchase Amount', 'purchaseDue', 'Company Purchase invoices, those are not paid yet.', 'graph/purchase-due', '1x2', 'demographics.jpg'), (4, 'Sales By Item', 'salesByItem', 'Sales information according to items.', 'graph/sales-by-item', '1x1', 'sales-by-items.jpg'), (5, 'Sales By Customer', 'salesByCustomer', 'Sales information according to Customers', 'graph/sales-by-customer', '1x1', 'sales-by-customers.jpg'), (6, 'GST 03 Summary', 'gst03summary', 'Company GST 03 Summary.', 'graph/gst03', '1x1', 'demographics.jpg')
Query : INSERT INTO `_ref_gst_03_field` (`id`, `item`, `description`, `taxCode`, `changeable`, `createdTS`, `updatedTS`) VALUES (1, 'B5a', 'Total Value of Standard Rated Supply', 'SR,DS', 1, '2015-07-10 01:17:43', '2015-07-10 06:53:15'), (2, 'B5b', 'Total Output Tax (Inclusive of Tax Value on Bad Debt Recovered & other Adjustments)', 'SR,DS,AJS', 1, '2015-07-10 01:17:43', '2015-07-10 06:53:21'), (3, 'B6a', 'Total Value of Standard Rate and Flat Rate Acquisitions', 'TX,IM,IMS,TX-E43,TX-RE', 1, '2015-07-10 01:18:11', '2015-07-10 06:53:31'), (4, 'B6b', 'Total Input Tax (Inclusive of Tax Value on Bad Debt Relief & other Adjustments)', 'TX-CG,TX,IM,IMS,TX-E43,TX-RE,AJP', 1, '2015-07-10 01:18:11', '2015-07-10 06:53:44'), (5, 'B7', 'GST Amount Payable (Item 5b - Item 6b)', '', 0, '2015-07-10 01:19:22', '2015-07-10 06:56:52'), (6, 'B8', 'GST Amount Claimable (Item 6b - Item 5b)', '', 0, '2015-07-10 01:19:22', '2015-07-10 06:56:55'), (7, 'C10', 'Total Value of Local Zero-Rated Supplies', 'ZRL', 1, '2015-07-10 01:19:37', '2015-07-10 06:54:18'), (8, 'C11', 'Total Value of Export Supplies', 'ZRE', 1, '2015-07-10 01:19:37', '2015-07-10 06:54:29'), (9, 'C12', 'Total Value of Exempt Supplies', 'ES43,ES', 1, '2015-07-10 01:19:52', '2015-07-10 06:54:33'), (10, 'C13', 'Total Value of Supplies Granted GST Relief', 'RS', 1, '2015-07-10 01:19:52', '2015-07-10 06:54:38'), (11, 'C14', 'Total Value of Goods Imported Under Approved Trader Scheme', 'IS', 1, '2015-07-10 01:20:11', '2015-07-10 06:54:47'), (12, 'C15', 'Total Value of GST Suspended under item 14', '', 0, '2015-07-10 01:20:11', '2015-07-10 06:57:02'), (13, 'C16', 'Total Value of Capital Goods Acquired', 'TX-CG', 1, '2015-07-10 01:20:28', '2015-07-10 06:54:48'), (14, 'C17', 'Total Value of Bad Debt Relief Inclusive Tax', '', 0, '2015-07-10 01:20:28', '2015-07-10 06:57:06'), (15, 'C18', 'Total Value of Bad Debt Recovered Inclusive Tax', '', 0, '2015-07-10 01:20:38', '2015-07-10 06:57:09')
Query : INSERT INTO `_sys_menu` (`fldid`, `code`, `name`, `parents`, `module`, `submenu`, `urls`, `urls2`, `access`, `seq`, `display`, `icons`, `language`) VALUES (391, 'GRAPHSET', 'graphsetup', '5', '1', 0, 'graph', '0', '0', 80, 1, 'iconcompanysetup.png', 'EN')
Query : INSERT INTO `_sys_menu` (`fldid`, `code`, `name`, `parents`, `module`, `submenu`, `urls`, `urls2`, `access`, `seq`, `display`, `icons`, `language`) VALUES (388, 'GSTPREF', 'gstpreference', '102', '6', 0, 'gstsetting/', '0', NULL, 33, 1, 'icon-active.png', 'EN')
Status : Resetting db config ....


The upgrator has encounter some issues during the processing, do email us the error file. located in: sps folder/upload/error_log.txt