User's Manual
VirtueMart User Manual
7
# Adjust order item final price
ALTER TABLE `jos_vm_order_item` CHANGE `product_final_price` `product_final_price` DECIMAL( 12, 2 ) NOT NULL DEFAULT '0.00';
# Adjust order total, allowing totals up to 9 999 999 999 999.99
ALTER TABLE `jos_vm_orders` CHANGE `order_total` `order_total` DECIMAL( 15, 5 ) NULL DEFAULT NULL ;
ALTER TABLE `jos_vm_orders` CHANGE `order_subtotal` `order_subtotal` DECIMAL( 15, 5 ) NULL DEFAULT NULL ;
# Allow larger coupon amounts
ALTER TABLE `jos_vm_orders` CHANGE `coupon_discount` `coupon_discount` DECIMAL( 12, 2 ) NOT NULL DEFAULT '0.00';
ALTER TABLE `jos_vm_coupons` CHANGE `coupon_value` `coupon_value` DECIMAL( 12, 2 ) NOT NULL DEFAULT '0.00';
# Allow larger payment discounts
ALTER TABLE `jos_vm_orders` CHANGE `order_discount` `order_discount` DECIMAL( 12, 2 ) NOT NULL DEFAULT '0.00';
ALTER TABLE `jos_vm_payment_method` CHANGE `payment_method_discount` `payment_method_discount` DECIMAL( 12, 2 ) NULL DEFAULT NULL ;
UPDATE `jos_components` SET `params` = 'RELEASE=1.0.5\nDEV_STATUS=stable' WHERE `name` = 'virtuemart_version';
If you have another database prefix than "jos_" you must change the "jos_" to your prefix (mostly
'mos_' then).
The queries can be found in the file /sql/UPDATE-SCRIPT_VirtueMart_1.0.x-
to-VirtueMart_1.0.3.sql and /sql/UPDATE-SCRIPT_VirtueMart_1.0.3-to-
VirtueMart_1.0.5.sql.
3.3. Automatic Installation
VirtueMart is a complex script. It's not component-only, but also requires a Module. So it comes to
you in a file called 'VirtueMart_x.x_COMPLETE_PACKAGE.zip'. This file contains various
Elements for VirtueMart.
Important
This file is not installable! Its contents are, but they must be unpacked first.
Package Contents:
• 1 Component (com_virtuemart_x.x.tar.gz)
• 1 Main VirtueMart module (mod_virtuemart_x.x.tar.gz)
• 10 additional Modules
• 2 Mambots (1 Search, 1 Content Mambot)
1. Unpack the file 'VirtueMart_x.x_COMPLETE_PACKAGE.zip' to a local directory.
2. Log in into Mambo's Backend (using the URL ' http://joomla_url/administrator') to
access the administrative interface.