News:

Looking for documentation? Take a look on our wiki

Main Menu

VM error after upgrading to 4.4.6

Started by Slavomir, March 09, 2025, 21:47:30 PM

Previous topic - Next topic

Slavomir

After upgrading the VM from 4.4.4 to 4.4.6, I get this error. Is there any way I can fix it?

com_virtuemart.log.php:

2025-03-09 20:17:34 ERROR vmError: vmTable store insertObject #__virtuemart_order_calc_rules Out of range value for column 'virtuemart_calc_id' at row 1 INSERT INTO `hfryd_virtuemart_order_calc_rules`
(`virtuemart_calc_id`,`virtuemart_order_id`,`virtuemart_vendor_id`,`calc_rule_name`,`calc_kind`,`calc_amount`,`calc_result`,`calc_value`,`created_on`,`created_by`) VALUES
('-1','13967','0','Ingen','payment','0','0','0','2025-03-09 20:17:34','1611')<pre>#0 /mysite/www/administrator/components/com_virtuemart/helpers/vmtable.php(1349): vmError()
#1 /mysite/www/administrator/components/com_virtuemart/models/orders.php(2321): VmTable->store()
#2 /mysite/www/administrator/components/com_virtuemart/models/orders.php(1708): VirtueMartModelOrders->_createOrderCalcRules()
#3 /mysite/www/components/com_virtuemart/helpers/cart.php(1934): VirtueMartModelOrders->createOrderFromCart()
#4 /mysite/www/components/com_virtuemart/helpers/cart.php(1627): VirtueMartCart->confirmedOrder()
#5 /mysite/www/components/com_virtuemart/controllers/cart.php(111): VirtueMartCart->confirmDone()
#6 /mysite/www/components/com_virtuemart/controllers/cart.php(230): VirtueMartControllerCart->display()
</pre>

Joomla 5.2.4
VM 4.4.6
PHP 8.3.3
DB 8.0.36

Best
Slavomir


Milbo

Thank you Slavomir. I just noted that this page is quite high listed, here a short summary in english.

The table updater was not executed correctly on your installation. The reason for this is that you are probably not using radical shipment tax. This means mixed calculation with two tax rates and calc id = -1. To do this, the table had to be changed. Just remove the unsigned of virtuemart_calc_id in the table #__virtuemart_order_calc_rules. This is actually done by the table updater. But if you get this message, something went wrong. So just do it manually
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/