[Vtigercrm-developers] upgrade from 5.0 to 5.0.3 (query failures)

[J Zakhar]

I get these failed query entries after the migration is run.


alter table vtiger_inventoryproductrel add column description TEXT 
default NULL after comment;
alter table vtiger_purchaseorder change salestax salestax decimal(25,3);
alter table vtiger_salesorder change salestax salestax decimal(25,3);
alter table vtiger_invoice change salestax salestax decimal(25,3);
alter table vtiger_quotes change tax tax decimal(25,3);
alter table vtiger_leadsubdetails drop column currency;
alter table vtiger_contactdetails drop column currency;
alter table vtiger_invoice add column (invoice_no varchar(50) UNIQUE 
default NULL);
update vtiger_cvcolumnlist set columnindex=6 where columnindex=5 and 
cvid=21;
update vtiger_cvcolumnlist set columnindex=5 where columnindex=4 and 
cvid=21;
update vtiger_cvcolumnlist set columnindex=4 where columnindex=3 and 
cvid=21;
update vtiger_cvcolumnlist set columnindex=3 where columnindex=2 and 
cvid=21;
update vtiger_cvcolumnlist set columnindex=2 where columnindex=1 and 
cvid=21;
insert into vtiger_cvcolumnlist 
values(21,1,'vtiger_invoice:invoice_no:invoice_no:Invoice_invoice_no:V');
alter table vtiger_quotes drop column tax;
alter table vtiger_purchaseorder drop column salestax;
alter table vtiger_salesorder drop column salestax;
alter table vtiger_invoice drop column salestax;
CREATE TABLE vtiger_version (id int(11) NOT NULL auto_increment, 
old_version varchar(30) default NULL, current_version varchar(30) 
default NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE vtiger_leadgrouprelation ADD CONSTRAINT 
fk_1_vtiger_leadgrouprelation FOREIGN KEY (groupname) REFERENCES 
vtiger_groups(groupname) ON UPDATE CASCADE;
ALTER TABLE vtiger_accountgrouprelation ADD CONSTRAINT 
fk_2_vtiger_accountgrouprelation FOREIGN KEY (groupname) REFERENCES 
vtiger_groups(groupname) ON UPDATE CASCADE;
ALTER TABLE vtiger_contactgrouprelation ADD CONSTRAINT 
fk_2_vtiger_contactgrouprelation FOREIGN KEY (groupname) REFERENCES 
vtiger_groups(groupname) ON UPDATE CASCADE;
ALTER TABLE vtiger_potentialgrouprelation ADD CONSTRAINT 
fk_1_vtiger_potentialgrouprelation FOREIGN KEY (groupname) REFERENCES 
vtiger_groups(groupname) ON UPDATE CASCADE;
ALTER TABLE vtiger_sogrouprelation ADD CONSTRAINT 
fk_1_vtiger_sogrouprelation FOREIGN KEY (groupname) REFERENCES 
vtiger_groups(groupname) ON UPDATE CASCADE;
ALTER TABLE vtiger_invoicegrouprelation ADD CONSTRAINT 
fk_1_vtiger_invoicegrouprelation FOREIGN KEY (groupname) REFERENCES 
vtiger_groups(groupname) ON UPDATE CASCADE;
alter table vtiger_accountbillads change column city bill_city varchar(30);
alter table vtiger_accountbillads change column code bill_code varchar(30);
alter table vtiger_accountbillads change column country bill_country 
varchar(30);
alter table vtiger_accountbillads change column state bill_state 
varchar(30);
alter table vtiger_accountbillads change column street bill_street 
varchar(250);
alter table vtiger_accountbillads change column pobox bill_pobox 
varchar(30);
alter table vtiger_accountshipads change column city ship_city varchar(30);
alter table vtiger_accountshipads change column code ship_code varchar(30);
alter table vtiger_accountshipads change column country ship_country 
varchar(30);
alter table vtiger_accountshipads change column state ship_state 
varchar(30);
alter table vtiger_accountshipads change column street ship_street 
varchar(250);
alter table vtiger_accountshipads change column pobox ship_pobox 
varchar(30);

AS well as some strange issues, people unable to add contacts under 
accounts. Anytime we edit a person in the user manager, they just poof 
(a blank file is made in user_privs, and the SQL entry is all null..

Any advice here would be helpful.

-- 
John Zakhar <john at tantor.com>
860-395-1155 x 37
http://www.tantor.com
Lead Software Developer