News:

Support the VirtueMart project and become a member

Main Menu

Error installing 2.0.10

Started by Jason Farmer, August 23, 2012, 01:02:32 AM

Previous topic - Next topic

chiappa

has anyone found some a bit easier fix to this error message when upgrading AIO?

QuotevmError: 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 `sahx1_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 DEFAULT '0.00000', `payment_currency` char(3) , `cost_per_transaction` decimal(10,2), `cost_percent_total` decimal(10,2), `tax_id` smallint(1), `paypal_custom` varchar(255), `paypal_response_mc_gross` decimal(10,2) NULL DEFAULT NULL, `paypal_response_mc_currency` char(10) NULL DEFAULT NULL, `paypal_response_invoice` char(32) NULL DEFAULT NULL, `paypal_response_protection_eligibility` char(128) NULL DEFAULT NULL, `paypal_response_payer_id` char(13) NULL DEFAULT NULL, `paypal_response_tax` decimal(10,2) NULL DEFAULT NULL, `paypal_response_payment_date` char(28) NULL DEFAULT NULL, `paypal_response_payment_status` char(50) NULL DEFAULT NULL, `paypal_response_pending_reason` char(50) NULL DEFAULT NULL, `paypal_response_mc_fee` decimal(10,2) NULL DEFAULT NULL, `paypal_response_payer_email` char(128) NULL DEFAULT NULL, `paypal_response_last_name` char(64) NULL DEFAULT NULL, `paypal_response_first_name` char(64) NULL DEFAULT NULL, `paypal_response_business` char(128) NULL DEFAULT NULL, `paypal_response_receiver_email` char(128) NULL DEFAULT NULL, `paypal_response_transaction_subject` char(128) NULL DEFAULT NULL, `paypal_response_residence_country` char(2) NULL DEFAULT NULL, `paypal_response_txn_id` char(32) NULL DEFAULT NULL, `paypal_response_txn_type` char(32) NULL DEFAULT NULL, `paypal_response_parent_txn_id` char(32) NULL DEFAULT NULL, `paypal_response_case_creation_date` char(32) NULL DEFAULT NULL, `paypal_response_case_id` char(32) NULL DEFAULT NULL, `paypal_response_case_type` char(32) NULL DEFAULT NULL, `paypal_response_reason_code` char(32) NULL DEFAULT NULL, `paypalresponse_raw` varchar(512) NULL DEFAULT NULL, `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 ;