[Vtigercrm-developers] vtiger migration 6.0-6.1
micker
micker at free.fr
Tue Nov 18 08:47:16 GMT 2014
hello i try update 6.0->6.1all was mark done but i have this report
errorALTER TABLE com_vtiger_workflows ADD COLUMN filtersavedinnew int(1)
FailureALTER TABLE vtiger_accounttype ADD COLUMN sortorderid INT(1)
FailureALTER TABLE vtiger_activitytype ADD COLUMN sortorderid INT(1)
FailureALTER TABLE vtiger_assetstatus ADD COLUMN sortorderid INT(1)
FailureALTER TABLE vtiger_campaignstatus ADD COLUMN sortorderid INT(1)
FailureALTER TABLE vtiger_campaigntype ADD COLUMN sortorderid INT(1)
FailureALTER TABLE vtiger_carrier ADD COLUMN sortorderid INT(1) FailureALTER
TABLE vtiger_cf_539 ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_cf_541 ADD COLUMN sortorderid INT(1) FailureALTER TABLE vtiger_cf_544
ADD COLUMN sortorderid INT(1) FailureALTER TABLE vtiger_cf_545 ADD COLUMN
sortorderid INT(1) FailureALTER TABLE vtiger_cf_547 ADD COLUMN sortorderid
INT(1) FailureALTER TABLE vtiger_cf_567 ADD COLUMN sortorderid INT(1)
FailureALTER TABLE vtiger_cf_568 ADD COLUMN sortorderid INT(1) FailureALTER
TABLE vtiger_cf_569 ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_cf_570 ADD COLUMN sortorderid INT(1) FailureALTER TABLE vtiger_cf_571
ADD COLUMN sortorderid INT(1) FailureALTER TABLE vtiger_cf_572 ADD COLUMN
sortorderid INT(1) FailureALTER TABLE vtiger_cf_573 ADD COLUMN sortorderid
INT(1) FailureALTER TABLE vtiger_cf_574 ADD COLUMN sortorderid INT(1)
FailureALTER TABLE vtiger_cf_575 ADD COLUMN sortorderid INT(1) FailureALTER
TABLE vtiger_cf_578 ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_cf_579 ADD COLUMN sortorderid INT(1) FailureALTER TABLE vtiger_cf_580
ADD COLUMN sortorderid INT(1) FailureALTER TABLE vtiger_cf_583 ADD COLUMN
sortorderid INT(1) FailureALTER TABLE vtiger_cf_586 ADD COLUMN sortorderid
INT(1) FailureALTER TABLE vtiger_cf_590 ADD COLUMN sortorderid INT(1)
FailureALTER TABLE vtiger_cf_766 ADD COLUMN sortorderid INT(1) FailureALTER
TABLE vtiger_contract_priority ADD COLUMN sortorderid INT(1) FailureALTER
TABLE vtiger_contract_status ADD COLUMN sortorderid INT(1) FailureALTER
TABLE vtiger_contract_type ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_eventstatus ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_expectedresponse ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_faqcategories ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_faqstatus ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_glacct ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_industry ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_invoicestatus ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_leadsource ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_leadstatus ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_manufacturer ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_opportunity_type ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_postatus ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_productcategory ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_progress ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_projectmilestonetype ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_projectpriority ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_projectstatus ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_projecttaskpriority ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_projecttaskprogress ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_projecttaskstatus ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_projecttasktype ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_projecttype ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_quotestage ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_rating ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_sales_stage ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_servicecategory ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_service_usageunit ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_sostatus ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_taskpriority ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_taskstatus ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_ticketcategories ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_ticketpriorities ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_ticketseverities ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_ticketstatus ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_tracking_unit ADD COLUMN sortorderid INT(1) FailureALTER TABLE
vtiger_usageunit ADD COLUMN sortorderid INT(1) FailureINSERT INTO
vtiger_ws_entity_tables(webservice_entity_id,table_name) VALUES
('33','vtiger_inventoryproductrel') FailureINSERT INTO
vtiger_ws_entity_fieldtype(fieldtypeid,table_name, field_name,fieldtype)
VALUES (11,'vtiger_inventoryproductrel','productid','reference');
FailureINSERT INTO vtiger_ws_entity_referencetype(fieldtypeid,type) VALUES
(11,'Products') FailureINSERT INTO
vtiger_ws_entity_fieldtype(fieldtypeid,table_name, field_name,fieldtype)
VALUES (12,'vtiger_inventoryproductrel','id','reference'); FailureINSERT
INTO vtiger_ws_entity_referencetype(fieldtypeid,type) VALUES (12,'Invoice')
FailureINSERT INTO vtiger_ws_entity_referencetype(fieldtypeid,type) VALUES
(12,'SalesOrder') FailureINSERT INTO
vtiger_ws_entity_referencetype(fieldtypeid,type) VALUES (12,'PurchaseOrder')
FailureINSERT INTO vtiger_ws_entity_referencetype(fieldtypeid,type) VALUES
(12,'Quotes') FailureINSERT INTO
vtiger_ws_entity_fieldtype(fieldtypeid,table_name,field_name,fieldtype)
VALUES (13,'vtiger_inventoryproductrel','incrementondel','autogenerated');
FailureINSERT INTO vtiger_ws_entity_tables(webservice_entity_id,table_name)
VALUES ('34','vtiger_inventorytaxinfo') FailureINSERT INTO
vtiger_ws_entity_tables(webservice_entity_id,table_name) VALUES
('35','vtiger_producttaxrel') FailureINSERT INTO
vtiger_ws_entity_fieldtype(fieldtypeid,table_name,field_name,fieldtype)
VALUES (14,'vtiger_producttaxrel','productid','reference'); FailureINSERT
INTO vtiger_ws_entity_referencetype(fieldtypeid,type) VALUES (14,'Products')
FailureINSERT INTO
vtiger_ws_entity_fieldtype(fieldtypeid,table_name,field_name,fieldtype)
VALUES (15,'vtiger_producttaxrel','taxid','reference'); FailureINSERT INTO
vtiger_ws_entity_referencetype(fieldtypeid,type) VALUES (15,'Tax')
FailureINSERT INTO vtiger_ws_referencetype VALUES (31,'Campaigns')
FailureALTER TABLE vtiger_modtracker_basic ADD INDEX crmidx (crmid)
FailureALTER TABLE vtiger_modtracker_basic ADD INDEX idx (id) FailureALTER
TABLE vtiger_modtracker_detail ADD INDEX idx (id) FailureALTER TABLE
vtiger_crmentity ADD COLUMN label varchar(255) FailureCREATE INDEX
vtiger_crmentity_labelidx ON vtiger_crmentity(label) FailureALTER TABLE
vtiger_mailscanner ADD COLUMN timezone VARCHAR(10) default NULL FailureALTER
TABLE vtiger_settings_field ADD COLUMN pinned int(1) DEFAULT 0 FailureALTER
TABLE vtiger_profile ADD COLUMN directly_related_to_role int(1) DEFAULT 0
FailureALTER TABLE vtiger_salutationtype ADD COLUMN sortorderid INT(1)
FailureALTER TABLE vtiger_invoice_recurring_info ADD PRIMARY KEY
(salesorderid) FailureALTER TABLE vtiger_role ADD allowassignedrecordsto
INT(2) NOT NULL DEFAULT 1 FailureALTER TABLE com_vtiger_workflowtask_queue
ADD COLUMN task_contents text FailureALTER TABLE
com_vtiger_workflowtask_queue DROP INDEX com_vtiger_workflowtask_queue_idx
FailureALTER TABLE vtiger_mailscanner_ids add index scanner_message_ids_idx
(scannerid, messageid) FailureALTER TABLE vtiger_mailscanner_folders add
index folderid_idx (folderid) FailureALTER TABLE vtiger_leaddetails add
index email_idx (email) FailureALTER TABLE vtiger_contactdetails add index
email_idx (email) FailureALTER TABLE vtiger_account add index email_idx
(email1, email2) FailureALTER TABLE vtiger_shorturls ADD COLUMN onetime
int(5) FailureUPDATE vtiger_blocks SET blocklabel = CASE blockid ELSE
blocklabel END Failurewhy ????
--
View this message in context: http://vtiger-crm.2324883.n4.nabble.com/vtiger-migration-6-0-6-1-tp14454.html
Sent from the vtigercrm-developers mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20141118/86ea19bd/attachment.html>
More information about the vtigercrm-developers
mailing list