News:

Support the VirtueMart project and become a member

Main Menu

Error installing VM 2.08c aio

Started by WVQ, July 14, 2012, 13:24:39 PM

Previous topic - Next topic

WVQ

VM 2.08c just installed
Joomla! 2.5.6 Stable
DB: 5.0.91-log
PHP 5.3.8
Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8r

I've installed VM-2.08c-AIO and got the following errors:

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 `master_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 `master_virtuemart_payment_plg_authorizenet` ( `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), `return_context` char(255), `cost_per_transaction` decimal(10,2), `cost_percent_total` char(10), `tax_id` smallint(1), `authorizenet_response_authorization_code` char(10), `authorizenet_response_transaction_id` mediumint(1) UNSIGNED, `authorizenet_response_response_code` char(128), `authorizenet_response_response_subcode` char(13), `authorizenet_response_response_reason_code` decimal(10,2), `authorizenet_response_response_reason_text` text, `authorizenet_response_transaction_type` char(50), `authorizenet_response_account_number` char(4), `authorizenet_response_card_type` char(128), `authorizenet_response_card_code_response` char(5), `authorizenet_response_cavv_response` char(1), `authorizeresponse_raw` 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 `master_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), `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), `paypalresponse_raw` varchar(512), `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 `master_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 can I solve this issue?

Thanks in advance

WVQ

unistalled 2.08c and installed 2.08d and solved

Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/