Forums / Addon Payment Modules / 1146 Table 'gagrags.usaepay_api' doesn't exist

1146 Table 'gagrags.usaepay_api' doesn't exist

Locked

Views: 1,563

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
11 Mar 2007, 3:00 AM
#1
maxx409 avatar

maxx409

New Zenner

Join Date:
Dec 2006
Posts:
16
Plugin Contributions:
0

1146 Table 'gagrags.usaepay_api' doesn't exist

Hi all, I'm using ZC 1.3.6 hosted on Crystal tech. I am trying to get usa epay to work from the module dl'd from Zencarts payment module downloads, meanwhile I'm collecting and knocking out every error message this puppy can generate. This is the latest "1146 Table 'gagrags.usaepay_api' doesn't exist
in:
[insert into usaepay_api (id, customer_id, order_id, result_code, auth_code, ref_num, batch, avs_result, cvv2_result, error, error_code, curl_error, acs_url, pareq, reason) values ('', '2', '1', 'E', '000000', '', '', '', '', 'Specified source key not found.', '00023', '', '', '', 'Specified source key not found.')]"

Now I've checked my server and Curl is enabled, I've also enabled visa and mastercard in my admin options. it seems I'm getting to the final stage of checkout when I get this message. my url is https://www.gagragsbyleetah.com. I may have read somewhere about inserting a table somewhere, but not sure what this means. Any help would be REALLy appreciated. Thanks:shocking:

11 Mar 2007, 4:03 PM
#2
maxx409 avatar

maxx409

New Zenner

Join Date:
Dec 2006
Posts:
16
Plugin Contributions:
0

Re: 1146 Table 'gagrags.usaepay_api' doesn't exist

Okay, in looking through the files I downloaded for the usaepay module I found a notepad document with what appears to be much of the information the error message says I need. Here's what was in the notepad:

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 ;

can anyone please tell me if I'm supposed to put this into a .php or something? I've spent hours in the forum and can find next to nothing on usaepay. Again, thanks for any help.:bored:

11 Mar 2007, 10:49 PM
#3
superprg avatar

superprg

Totally Zenned

Join Date:
Feb 2006
Location:
Chicago
Posts:
1,349
Plugin Contributions:
0

Re: 1146 Table 'gagrags.usaepay_api' doesn't exist

You have to run that query in phpmyadmin
You can find phpmyadmin in Cpanel
Select the database which is being used by your zen cart site and then Run that query!

Tutorials on Zen Cart
http://tutorials.zen-cart.com/index.php

advanced.programmer at gmail dot com
In love with Zen Cart!!

13 Mar 2007, 4:45 PM
#4
maxx409 avatar

maxx409

New Zenner

Join Date:
Dec 2006
Posts:
16
Plugin Contributions:
0

Re: 1146 Table 'gagrags.usaepay_api' doesn't exist

Thanks for the reply Superprg, so I log on to Crystaltech cpanel, correct? and go to mysql database and click it. It brings up a text box that has a "test" button on the upper right. Now am I supposed to cut and paste the whole thing from "Table" on? I'm not quite sure what you meant by "run That query. Thanks again for the help.

13 Mar 2007, 5:31 PM
#5
superprg avatar

superprg

Totally Zenned

Join Date:
Feb 2006
Location:
Chicago
Posts:
1,349
Plugin Contributions:
0

Re: 1146 Table 'gagrags.usaepay_api' doesn't exist

Do you have a link to phpmyadmin when y ou click on Mysql?

Tutorials on Zen Cart
http://tutorials.zen-cart.com/index.php

advanced.programmer at gmail dot com
In love with Zen Cart!!

14 Mar 2007, 4:19 AM
#6
maxx409 avatar

maxx409

New Zenner

Join Date:
Dec 2006
Posts:
16
Plugin Contributions:
0

Re: 1146 Table 'gagrags.usaepay_api' doesn't exist

No, Mysql admin and mysql query test:(. Not the same thing huh?