Post by ipthena » Tue Sep 11, 2018 9:54 pm

Fresh install of 3.0.2.0. I when to my payment extensions and clicked install for PayPal Payflow Pro iFrame (this is what i have been using on my 1.5.6.1). I get an error about the PRIMARY KEY. Error text is below. Any suggestions?

PHP Fatal error: Uncaught Exception: Error: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead<br />Error No: 1171<br />
CREATE TABLE `paypal_payflow_iframe_order` (
`order_id` int(11) DEFAULT NULL,
`secure_token_id` varchar(255) NOT NULL,
`transaction_reference` varchar(255) DEFAULT NULL,
`transaction_type` varchar(1) DEFAULT NULL,
`complete` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY(`order_id`),
KEY `secure_token_id` (`secure_token_id`)
) ENGINE=MyISAM DEFAULT COLLATE=utf8_general_ci in C:\inetpub\wwwroot\mystore\system\library\db\mysqli.php:40
Stack trace:
#0 C:\inetpub\wwwroot\mystore\system\library\db.php(45): DB\MySQLi->query('\r\n\t\t\tCREATE TAB...')
#1 C:\inetpub\wwwroot\mystore\admin\model\extension\payment\pp_payflow_iframe.php(5): DB->query('\r\n\t\t\tCREATE TAB...')
#2 C:\inetpub\wwwroot\mystore\vqmod\vqcache\vq2-C:_inetpub_wwwroot_mystore-storage_modific in C:\inetpub\wwwroot\mystore\system\library\db\mysqli.php on line 40

Newbie

Posts

Joined
Sun Dec 07, 2014 3:18 am

Post by ipthena » Tue Sep 11, 2018 9:58 pm

RESOLVED! I simply went to the extension file in the admin (in my case it was located here C:\inetpub\wwwroot\mystore\admin\model\extension\payment\pp_payflow_iframe.php) and modified the 6th line to say " `order_id` int(11) NOT NULL, " ------- it previously had "`order_id` int(11) DEFAULT NULL,"

Newbie

Posts

Joined
Sun Dec 07, 2014 3:18 am
Who is online

Users browsing this forum: adycobra2003, Bing [Bot], OSWorX and 416 guests