Joomla: 3.4.8
VM: 3.0.12
PHP: 5.4
When updating my website from J 2.5 to 3.4 and VM to 3.0, I have an unresolved problem with creating a Shipping Method. I get the error message below.
1. I have installed all three of the VM plugins
2. Same error occurs whether I create using
USPS Shipping for Virtuemart, or
VM Shipment by weight, zip and country
3. Using my phpMYADMIN to view Database, I find there is no: "qulkr_virtuemart_shipment_plg_weight_countries" created.
4. For some reason VM is not creating correct entry into the database.
Need some help, do not know what to do next. ANY IDEAS?
-------------------------------------------------------------------
An error has occurred.
1075 Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE IF NOT EXISTS `qulkr_virtuemart_shipment_plg_weight_countries` ( `id` int(1) UNSIGNED NOT NULL AUTO_INCREMENT, `virtuemart_order_id` int(11) UNSIGNED, `order_number` char(32), `virtuemart_shipmentmethod_id` mediumint(1) UNSIGNED, `shipment_name` varchar(5000), `order_weight` decimal(10,4), `shipment_weight_unit` char(3) DEFAULT 'KG', `shipment_cost` decimal(10,2), `shipment_package_fee` decimal(10,2), `tax_id` smallint(1), `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) NOT NULL DEFAULT '0', `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL DEFAULT '0', `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `locked_by` int(11) NOT NULL DEFAULT '0') ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;