VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: jayem on March 27, 2015, 14:23:33 PM

Title: errors on page after upgrade
Post by: jayem on March 27, 2015, 14:23:33 PM
Hello

I just upgraded from VM 2.6 to the latest version of 3 - and I get quite a few errors on the product pages. I was wandering if someone could help me.

Here is an example of the errors http://www.hawkshouse.co.uk.gridhosted.co.uk/online-shop/energy-balancing-tools.html

Thanks very much
Title: Re: errors on page after upgrade
Post by: PRO on March 27, 2015, 14:43:30 PM
have you tried the "install or update tables"


in the tools/migration    ?
Title: Re: errors on page after upgrade
Post by: jayem on March 27, 2015, 15:28:47 PM
OK I just tried that and also hit the "remove old VM2 inherited custom fields" button. I got the following message after doing what you said, and the error is still there:

alterTable CHANGE robert_virtuemart_order_userinfos.agreed : ALTER TABLE `robert_virtuemart_order_userinfos` CHANGE COLUMN `agreed` `agreed` TINYINT(1) NOT NULL DEFAULT '0' AFTER `email`
alterTable CHANGE robert_virtuemart_order_userinfos.tos : ALTER TABLE `robert_virtuemart_order_userinfos` CHANGE COLUMN `tos` `tos` TINYINT(1) NOT NULL DEFAULT '0' AFTER `agreed`
alterTable CHANGE robert_virtuemart_order_userinfos.customer_note : ALTER TABLE `robert_virtuemart_order_userinfos` CHANGE COLUMN `customer_note` `customer_note` VARCHAR(2500) NOT NULL DEFAULT '' AFTER `tos`
alterTable CHANGE robert_virtuemart_userinfos.agreed : ALTER TABLE `robert_virtuemart_userinfos` CHANGE COLUMN `agreed` `agreed` TINYINT(1) NOT NULL DEFAULT '0' AFTER `zip`
alterTable CHANGE robert_virtuemart_userinfos.tos : ALTER TABLE `robert_virtuemart_userinfos` CHANGE COLUMN `tos` `tos` TINYINT(1) NOT NULL DEFAULT '0' AFTER `agreed`
alterTable CHANGE robert_virtuemart_userinfos.customer_note : ALTER TABLE `robert_virtuemart_userinfos` CHANGE COLUMN `customer_note` `customer_note` VARCHAR(2500) NOT NULL DEFAULT '' AFTER `tos`
Table updated: Tablename robert_virtuemart_order_userinfos dropped: 0 altered: 3 added: 0
Table updated: Tablename robert_virtuemart_userinfos dropped: 0 altered: 3 added: 0
Database updated

Thanks
Title: Re: errors on page after upgrade
Post by: GJC Web Design on March 27, 2015, 15:37:27 PM
does the downloads_for_sale plugin need updating for VM3?
Title: Re: errors on page after upgrade
Post by: jayem on March 27, 2015, 15:49:08 PM
I just disabled it and it seems to have fixed it.

When I click on an actual product there is another error, i presume it was there before too. Here is an e.g. http://www.hawkshouse.co.uk.gridhosted.co.uk/shamanic-trance-drumming-detail.html
Title: Re: errors on page after upgrade
Post by: GJC Web Design on March 28, 2015, 11:58:28 AM
give us a clue..  ;)

quantity buttons?  just your css needs changing