can't upgrade from 2.0.20 to 2.0.22c

[marklandry]

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)

Warning: 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

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`='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...

[Maxim Pishnyak]

For what VM version your template was built originally?

[marklandry]

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.

[Maxim Pishnyak]

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.

[marklandry]

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?

[jenkinhill]

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).