Print Page - Setting up a payment.

Title: Setting up a payment.
Post by: Wallstickr on July 31, 2014, 18:06:50 PM

I try to set up payments and they seem to succeed, but every time i add one i get the following fail...

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 `wxscd_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 ;

Title: Re: Setting up a payment.
Post by: GJC Web Design on July 31, 2014, 18:20:24 PM

http://forum.virtuemart.net/index.php?topic=104795.0

Title: Re: Setting up a payment.
Post by: John2400 on August 01, 2014, 03:38:19 AM

You might just solve this by doing a reinstall of both VM extensions again. Most who had this issue on the forum had a go at this and it appeared to solve the issue.

Title: Re: Setting up a payment.
Post by: Wallstickr on August 02, 2014, 13:25:53 PM

Hi john.

Thanks for your reply.
I did a complete reinstall and it solved the problem.

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: Wallstickr on July 31, 2014, 18:06:50 PM