New Zenner
- Join Date:
- Apr 2006
- Posts:
- 54
- Plugin Contributions:
- 0
USAepay for 1.2.6d
I downloaded the USAePay API (the newer of the two) from here
when i try to update the sql, i get the following error.
Error
SQL query:
CREATE TABLE `usaepay_api` (
`id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`customer_id` int( 11 ) NOT NULL default '0',
`order_id` int( 11 ) NOT NULL default '0',
`result_code` varchar( 50 ) NOT NULL default '0',
`auth_code` varchar( 50 ) default NULL ,
`ref_num` varchar( 100 ) default NULL ,
`batch` varchar( 50 ) NOT NULL default '0',
`avs_result` varchar( 50 ) NOT NULL default '0',
`cvv2_result` varchar( 50 ) NOT NULL default '0',
`error` varchar( 50 ) NOT NULL default '0',
`error_code` varchar( 50 ) NOT NULL default '0',
`curl_error` varchar( 50 ) NOT NULL default '0',
`acs_url` varchar( 50 ) NOT NULL default '0',
`pareq` varchar( 50 ) NOT NULL default '0',
`reason` varchar( 50 ) NOT NULL default '0',
UNIQUE KEY `id` ( `id` )
) TYPE = MYISAM AUTO_INCREMENT =1;
MySQL said:
#1046 - No Database Selected
i apologize in advance. i'm a designer, not an SQL-type person. If it doesnt work when i click 'ok' then i havent the foggiest idea what the error codes mean or what i should do to fix them.
any help appreciated. thanks.