Results 1 to 6 of 6

Hybrid View

  1. #1
    Join Date
    Dec 2006
    Posts
    16
    Plugin Contributions
    0

    Default 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 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

  2. #2
    Join Date
    Dec 2006
    Posts
    16
    Plugin Contributions
    0

    Default 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.

  3. #3
    Join Date
    Feb 2006
    Location
    Chicago
    Posts
    1,162
    Plugin Contributions
    0

    Default 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!!

  4. #4
    Join Date
    Dec 2006
    Posts
    16
    Plugin Contributions
    0

    Default 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.

  5. #5
    Join Date
    Feb 2006
    Location
    Chicago
    Posts
    1,162
    Plugin Contributions
    0

    Default 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!!

  6. #6
    Join Date
    Dec 2006
    Posts
    16
    Plugin Contributions
    0

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

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

 

 

Similar Threads

  1. 1146 Table doesn't exist
    By Bryan G in forum Addon Payment Modules
    Replies: 9
    Last Post: 30 Jul 2011, 03:06 PM
  2. 1146 Table doesnīt exist...
    By ppsoyal in forum General Questions
    Replies: 0
    Last Post: 29 Jan 2011, 10:37 PM
  3. 1146 Table 'XXXX.zen_configuration' doesn't exist in: [db_cache table]
    By CheapStairParts in forum General Questions
    Replies: 1
    Last Post: 4 Jan 2011, 12:39 AM
  4. 1146 Table Doesn't Exist
    By pazdar in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 3 Jan 2008, 07:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR