User's Manual

VirtueMart User Manual
6
1. The automatic installation with Joomla's / Mambo's Element (Component-, Module-, Mambot-)
Installer.
2. The manual installation.
Some users can't use the automatic Installer because of the PHP setting 'safe_mode' being set to 'On'.
In case you're running into trouble with the automatic Installer try the manual installation instead.
Upgrade from mambo-phpShop
You want to upgrade to VirtueMart from mambo-phpShop? This is easy.
All you need to do is install VirtueMart! It will convert your installation of mambo-phpShop, rename
the tables and copy all customer information into its own table #__vm_user_info.
So just follow the instructions for the automatic installation (or if you have difficulties with it: the
manual installation).
Note
It is recommended to uninstall the old mambo-phpShop modules after you have installed the
VirtueMart component and then install the new VirtueMart modules.
Caution
It is absolutely necessary to make a backup of your whole site before you upgrade your
shop! An upgrade failure can always happen! So please: BACKUP, BACKUP, BACKUP!
Upgrade from VirtueMart 1.0.0-1.0.5
We have fixed a lot of bugs! An upgrade is highly recommended. Just get the "Patch Package" for
your current VirtueMart version and overwrite your exising files with the ones from that package.
The are two small changes to the database, so you must run the following SQL queries on your database
to update it.
Just open phpMyAdmin and run those queries:
#############################################
# SQL update script for upgrading
# from VirtueMart 1.0.x to VirtueMart 1.0.5
#
#############################################
ALTER TABLE `jos_vm_product_mf_xref` CHANGE `product_id` `product_id` INT( 11 ) NULL DEFAULT NULL;
ALTER TABLE `jos_vm_orders` ADD `order_tax_details` TEXT NOT NULL AFTER `order_tax`;
# Allow Shopper group discounts up to 100.00%
ALTER TABLE `jos_vm_shopper_group` CHANGE `shopper_group_discount` `shopper_group_discount` DECIMAL( 5, 2 ) NOT NULL DEFAULT '0.00';
# Allow bigger discounts than 999.99
ALTER TABLE `jos_vm_product_discount` CHANGE `amount` `amount` DECIMAL( 12, 2 ) NOT NULL DEFAULT '0.00';
# Allow prices up to 9 999 999 999.99
ALTER TABLE `jos_vm_product_price` CHANGE `product_price` `product_price` DECIMAL( 12, 5 ) NULL DEFAULT NULL ;
# Adjust order item price
ALTER TABLE `jos_vm_order_item` CHANGE `product_item_price` `product_item_price` DECIMAL( 15, 5 ) NULL DEFAULT NULL ;