If this is your first visit, check our documentation. To post, register or login.

USAepay for 1.2.6d

Locked

Started by cudaboy71 on 21 Jul 2006, 7:15 PM · Views: 1,482

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
21 Jul 2006, 7:15 PM
#1
cudaboy71 avatar

cudaboy71

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.

23 Jul 2006, 4:41 PM
#2
knuckle_101 avatar

knuckle_101

Totally Zenned

Join Date:
Dec 2005
Location:
Cincinnati Ohio
Posts:
1,034
Plugin Contributions:
3

Re: USAepay for 1.2.6d

cudaboy71:

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.


You have to select the database you want to insert it to. if you are running mysql then you have the choice to select the database you wish to insert the sql to.

usually to the left of the screen in myphpadmin of your control panel. Or you can try using the up-load feature in admin/tools/Install SQL patches 

make sure you back up your database before doing anything

Hope this helps.
Good Luck

PCI Certified Web Hosting - ControlScan, Security Metrics (Platinum Partner), McAfee, TrustKeeper
Business Class Web Hosting - Linux and cPanel Powered

25 Jul 2006, 2:44 PM
#3
cudaboy71 avatar

cudaboy71

New Zenner

Join Date:
Apr 2006
Posts:
54
Plugin Contributions:
0

Re: USAepay for 1.2.6d

thanks knuckle.

that must have been it. went through fine this morning.