News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

[SOLVED] 2.0.12b AIO: "createTable ERROR :Incorrect table definition"

Started by chiappa, October 15, 2012, 08:41:13 AM

Previous topic - Next topic

chiappa

1) Do a fresh install of Joomla 2.5.7 Stable
2) Install Virtuemart 2.0.12b component
3) Install Virtuemart 2.0.12b AIO component
(result below)

Quotecom_virtuemart_allinoneInstallerScript:: VirtueMart2 update #__virtuemart_payment_plg_standard
com_virtuemart_allinoneInstallerScript:: VirtueMart2 update #__virtuemart_payment_plg_paypal
com_virtuemart_allinoneInstallerScript:: VirtueMart2 update #__virtuemart_shipment_plg_weight_countries
Installing component was successful.

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 `delete_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), `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 `delete_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 ;
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 `delete_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 ;

How should I deal with this error? Thanks!!

mysql  Ver 14.14 Distrib 5.1.63, for debian-linux-gnu (x86_64) using readline 6.1

chiappa

I just updated Joomla from 2.5.7 to 2.5.8 and installation of com_virtuemart.2.0.16_ext_aio.zip & com_virtuemart.2.0.16.zip was NP!