News:

Looking for documentation? Take a look on our wiki

Main Menu

2.6.10 Install Update

Started by alex2311, September 11, 2014, 14:56:04 PM

Previous topic - Next topic

alex2311

For information...  Not the first time I have hit these errors on update...  See below.

The queries to do not want to attempt to run because no Primary Key has been defined with the AUto Increment fields.  No issue because the tables already exist...  Nice if they could be fixed so you don't get the sea of red after update success message  :D

Cheers,

Alex

vmError: createTable ERROR :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE IF NOT EXISTS `WA_virtuemart_payment_plg_standard` ( `id` int(1) UNSIGNED NOT NULL AUTO_INCREMENT, `virtuemart_order_id` int(1) UNSIGNED, `order_number` char(64), `virtuemart_paymentmethod_id` mediumint(1) UNSIGNED, `payment_name` varchar(5000), `payment_order_total` decimal(15,5) NOT NULL DEFAULT '0.00000', `payment_currency` char(3), `email_currency` char(3), `cost_per_transaction` decimal(10,2), `cost_percent_total` 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 ;

vmError: createTable ERROR :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE IF NOT EXISTS `WA_virtuemart_payment_plg_paypal` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `virtuemart_order_id` int(1) UNSIGNED, `order_number` char(64), `virtuemart_paymentmethod_id` mediumint(1) UNSIGNED, `payment_name` varchar(5000), `payment_order_total` decimal(15,5) NOT NULL, `payment_currency` smallint(1), `email_currency` smallint(1), `cost_per_transaction` decimal(10,2), `cost_percent_total` decimal(10,2), `tax_id` smallint(1), `paypal_custom` varchar(255), `paypal_method` varchar(200), `paypal_response_mc_gross` decimal(10,2), `paypal_response_mc_currency` char(10), `paypal_response_invoice` char(32), `paypal_response_protection_eligibility` char(128), `paypal_response_payer_id` char(13), `paypal_response_tax` decimal(10,2), `paypal_response_payment_date` char(28), `paypal_response_payment_status` char(50), `paypal_response_pending_reason` char(50), `paypal_response_mc_fee` decimal(10,2), `paypal_response_payer_email` char(128), `paypal_response_last_name` char(64), `paypal_response_first_name` char(64), `paypal_response_business` char(128), `paypal_response_receiver_email` char(128), `paypal_response_transaction_subject` char(128), `paypal_response_residence_country` char(2), `paypal_response_txn_id` char(32), `paypal_response_txn_type` char(32), `paypal_response_parent_txn_id` char(32), `paypal_response_case_creation_date` char(32), `paypal_response_case_id` char(32), `paypal_response_case_type` char(32), `paypal_response_reason_code` char(32), `paypalresponse_raw` varchar(512), `paypal_fullresponse` text, `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 ;


vmError: createTable ERROR :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE IF NOT EXISTS `WA_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 ;