VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: marklandry on September 03, 2013, 18:48:09 PM

Title: can't upgrade from 2.0.20 to 2.0.22c
Post by: marklandry on September 03, 2013, 18:48:09 PM
Hi,
I get the following errors after upgrade to 2.0.22c (joomla 2.5.14 upgrading from vm 2.0.20)

When clicking into product details (http://dev2.seejesus.net/store/shop-jesus-resources/person-of-jesus-leaders-manual-detail (http://dev2.seejesus.net/store/shop-jesus-resources/person-of-jesus-leaders-manual-detail))
QuoteWarning: require(/nfs/c03/h04/mnt/51974/domains/dev2.seejesus.net/html/components/com_virtuemart/helpers/shopfunctions.php) [function.require]: failed to open stream: No such file or directory in /nfs/c03/h04/mnt/51974/domains/dev2.seejesus.net/html/administrator/components/com_virtuemart/helpers/mediahandler.php on line 232

Fatal error: require() [function.require]: Failed opening required '/nfs/c03/h04/mnt/51974/domains/dev2.seejesus.net/html/components/com_virtuemart/helpers/shopfunctions.php' (include_path='.:/usr/local/php-5.3.27/share/pear') in /nfs/c03/h04/mnt/51974/domains/dev2.seejesus.net/html/administrator/components/com_virtuemart/helpers/mediahandler.php on line 232

When trying to save info for the same product listed above
QuotevmError: TableProduct_prices::store failed - Column 'created_on' cannot be null SQL=UPDATE `rrvip_virtuemart_product_prices` SET `virtuemart_product_id`='20',`virtuemart_shoppergroup_id`='0',`product_price`='49.99000',`override`='1',`product_override_price`='30.00000',`product_tax_id`='0',`product_discount_id`='0',`product_currency`='144',`product_price_publish_up`='0',`product_price_publish_down`='0',`price_quantity_start`='15',`price_quantity_end`='999',`created_on`=NULL,`created_by`=NULL,`modified_on`='2013-09-03 16:47:11',`modified_by`='1032' WHERE `virtuemart_product_price_id`='104'
vmError: TableProduct_prices::store failed - Column 'created_on' cannot be null SQL=UPDATE `rrvip_virtuemart_product_prices` SET `virtuemart_product_id`='20',`virtuemart_shoppergroup_id`='0',`product_price`='49.99000',`override`='1',`product_override_price`='35.00000',`product_tax_id`='0',`product_discount_id`='0',`product_currency`='144',`product_price_publish_up`='0',`product_price_publish_down`='0',`price_quantity_start`='10',`price_quantity_end`='14',`created_on`=NULL,`created_by`=NULL,`modified_on`='2013-09-03 16:47:11',`modified_by`='1032' WHERE `virtuemart_product_price_id`='103'

Got the same probs when trying to upgrade to 2.0.22b

Thanx for your help

Mark

EDIT:  forgot to mentioned that I did this upgrade through the Joomla extension manager install.  Also, tested this installation on a different server and got the same result...
Title: Re: can't upgrade from 2.0.20 to 2.0.22c
Post by: Maxim Pishnyak on September 04, 2013, 21:43:41 PM
For what VM version your template was built originally?
Title: Re: can't upgrade from 2.0.20 to 2.0.22c
Post by: marklandry on September 05, 2013, 01:30:08 AM
The template was originally built for 1.5, then upgraded to 2.5.  It's the new JA purity template...

edit -
sorry, a previous developer created the template for joomla 1.5 and virtuemart 1.0. 
I upgraded the template to be joomla 2.5 compatible and initially used VM 2.0.20 without problems until recently.
Title: Re: can't upgrade from 2.0.20 to 2.0.22c
Post by: Maxim Pishnyak on September 05, 2013, 19:13:41 PM
Quote from: marklandry on September 05, 2013, 01:30:08 AM
sorry, a previous developer created the template for joomla 1.5 and virtuemart 1.0. 
I upgraded the template to be joomla 2.5 compatible and initially used VM 2.0.20 without problems until recently.
Probably it's time to upgrade your template again. Ask for support author of template.
Title: Re: can't upgrade from 2.0.20 to 2.0.22c
Post by: marklandry on September 05, 2013, 21:06:39 PM
Upgrade to what?  It's a Joomla 2.5 template and we're running joomla 2.5.
I don't understand...  Are there certain things that need to be done to the template to make it VM 2.0.20c?
Title: Re: can't upgrade from 2.0.20 to 2.0.22c
Post by: jenkinhill on September 05, 2013, 21:49:41 PM
I went to http://dev2.seejesus.net/store/shop-jesus-resources/person-of-jesus-leaders-manual-detail  and added the product to the cart OK, then slected checkout and was referred to https://dev2.seejesus.net/component/virtuemart/cart/checkout?Itemid=0 at which point the browser bugged out as either there is no SSL security certificate or it is badly set up. That's the only error message I saw.

Looking at your error message you must have some old VM stuff still in your site. The file that cannot be found, shopfunctions.php does not exxist in current VM versions, it is shopfunctionsf.php  (with an f).