News:

Support the VirtueMart project and become a member

Main Menu

Error 1975 when creating shipping method

Started by rtringo, February 04, 2016, 19:41:20 PM

Previous topic - Next topic

rtringo

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 ;