[SOLVED] Fatal error upon checkout

[jdwire]

I've just installed VM RC3 Pre-J on joomla 1.7.3, and my first attempt to check out has failed with a 500 error. Here are the steps that I went through.

System Information:
Database Version: 5.1.41-3ubuntu12.10
Database Collation: utf8_general_ci
PHP Version: 5.3.2-1ubuntu4.10
Web Server: Apache/2.2.14 (Ubuntu)
WebServer to PHP Interface: apache2handler
Joomla! Version: Joomla! 1.7.3 Stable [ Ember ] 14-Nov-2011 14:00 GMT
Joomla! Platform Version: Joomla Platform 11.2.0 Stable+Modified [ Omar ] 27-Jul-2011 00:00 GMT

1. copied core and aio to joomla tmp folder
2. installed core using install from directory
3. installed sample data
4. installed aio using install from directory
5. Loaded frontend store
   Note:the following error showed twice above the store: Error: Couldnt create thumb, file not found /var/www/jmed/dev/images/stories/virtuemart/product/images/stories/virtuemart/category/1b0c96d67abdbea648cd0ea96fd6abcb.jpg
6. Added a hand shovel to the cart and showed the cart
7. As expected, observed the following notes, but still tried to continue checkout:
   No payment method has been configurated , please visit http://*****************/administrator/index.php?option=com_virtuemart&view=paymentmethod
   No shipment method has been configurated , please visit http://*****************/administrator/index.php?option=com_virtuemart&view=shipmentmethod
8. Clicked Check Out Now
9. As expected, received the following error:
   Please select a shipment method
   We are sorry, no shipment method matches the characteristics of your order.

10. Loaded backend and added a new shipment method:
      Shipment Name:UPS
      Published:Yes
      Shipment Description:UPS
      Shipment Method:VM - Shipment, by weight, ZIP, and countries
      Shopper Group:-default-
      List Order:0
11. Clicked save and entered following configuration:
      Logo:empty
      Countries:empty
      ZIP range start:0
      ZIP range end:0
      Lowest Weight:0
      Highest Weight:0
      Weight Unit:Kilograms
      Shipment Cost:5
      Package Fee:0
      Tax: Apply default rules
      Minimum Amount for Free Shipment:0
12. Clicked save

13. Added a new payment method:
      Payment Name:PayPal
      Published:yes
      Payment Description:PayPal
      Payment Method:VM - Payment, Paypal
      Shopper Group:-default-
      List Order:empty
14. Clicked save and entered following configuration:
      PayPal payment email:username@email.com
      Currencies:Euro
      Accept only verivied buyers?:No
      Sandbox:No
      Merchant Sandbox Email:no
      Logos:empty
      Debug:No
      Order Status for Pending Payments:Pending
      Order Status for Successful Payments:Pending
      Order Status for Failed Payments:Pending
      Countries:empty
      Minimum Amount:0
      Maximum Amount:0
      Fee per transaction:0
      Percent of the total amount:0
      Tax:Apply default rules
15. Clicked save

16. Loaded frontend cart:/component/virtuemart/cart
17. Removed shovel from cart
18. Added shovel to cart and showed cart
   Note: Shipping is 50 euros instead of 5
19. Clicked Check Out Now
   Note: As expected, obeserved message: Info: Checkout done, please confirm the order
20. Clicked Confirm Order
21. Received a 500 Error (Not Standard Joomla Error Screen)
22. Found following error in server log:
   PHP Fatal error:  Call to private method VirtueMartModelProduct::updateStockInDB() from context 'VirtueMartModelOrders' in **********/administrator/components/com_virtuemart/models/orders.php on line 731, referer: http://**********/component/virtuemart/cart
   
I found that I can temporarily work around this error by checking "Check Stock?" in Configuration->Configuration->Checkou

[alatak]

Hi,

Txs for this nice big report.
The problem has been fixed in the K version.
Please update.

[atb]

Hi,

Txs for this nice big report.
The problem has been fixed in the K version.
Please update.

This error appears to be related to the one I reported a few days ago, and which had not been corrected in i version.  However I can now confirm I updated to k version and can now succeed with a PayPal (Sandbox) payment, rather than get an Error 500.
Please note that I needed to delete the existing Shipment Method and create it again, presumably required to create the missing SQL file.

Thanks for the update.

[jdwire]

I just uninstalled VM RC3 PRe-J and installed Pre-K, and I can confirm that the checkout process now works.

[alatak]

Hi,

Please note that I needed to delete the existing Shipment Method and create it again, presumably required to create the missing SQL file.

Yes you are completly rigth. The shipment and payment tables have changed. So they must be recreated.