Results 1 to 10 of 10
  1. #1
    Join Date
    Apr 2011
    Location
    Milwaukee, WI
    Posts
    7
    Plugin Contributions
    0

    Default 1146 Table doesn't exist

    I'm pretty confident I won't find a solution but I'll try....

    I have zencart 1.3.9h no upgrade, installed this last week.
    I have php 5.2.14
    Template is free_zen_cart_template2
    It's hosted on Lunarpages
    I am trying to install usa_epay, I placed the folder in properly (I think) but I don't know how to install the mysql.sql

    I called usa_epay and they said I installed it right because it's in the zen admin under "modules/payment". From there I set it up with their help. Today I tried a test run with one of their test credit card numbers and if I have the wrong cc date (a date earlier that todays) I get an error "Internet explorer cannot read this webpage format".

    If I use a proper CC I go on to the next page to confirm. When I click the confirm button I get this error:

    1146 Table 'thefish2_zc1.zen_usaepay_api' doesn't exist
    in:
    [insert into zen_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 ('', '1', '1', 'D', '000000', '231507876', '19', 'Retry / System Unavailable', 'No Match', 'Pickup Card', '10204', '', '', '', 'Pickup Card')]


  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,762
    Plugin Contributions
    9

    Default Re: 1146 Table doesn't exist

    Use phpmyadmin to inspect the other tables and to insure that the usaepay_api table has a matching prefix to your other tables

    usaepay_api may be there but it appears that it should be zen_usaepay_api
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Apr 2011
    Location
    Milwaukee, WI
    Posts
    7
    Plugin Contributions
    0

    Default Re: 1146 Table doesn't exist

    Quote Originally Posted by kobra View Post
    Use phpmyadmin to inspect the other tables and to insure that the usaepay_api table has a matching prefix to your other tables

    usaepay_api may be there but it appears that it should be zen_usaepay_api
    I can't find any tables for usa_epay. All the tables look like this zen_address_format so I assume I'm in the right section because they all start with zen.

    Like I mentioned, I don't think i installed it right. It says I need to use myphpadmin to install mysql.sql but I don't know how. Could someone explain to me how to install/run mysql.sql with phpMyAdmin?


    Here are the instructions
    Code:
    INSTALLATION:
    
    The files are arranged in the same structure as Zen-Cart v1.2.2
    
    Run the attached SQL file via phpMyAdmin
    
    Go to the Admin ...
    Go to Modules ...
    Go to Payment ...
    Select USA ePay ...
    Enter your appropriate information provided by USA ePay
    
    You are done!

    The only part I didn't know how to do was the "Run the attached SQL file via phpMyAdmin"

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,762
    Plugin Contributions
    9

    Default Re: 1146 Table doesn't exist

    If you have the sql file, open it in notepad and copy & paste it into your admin > tools > sql patches
    Zen-Venom Get Bitten

  5. #5
    Join Date
    Apr 2011
    Location
    Milwaukee, WI
    Posts
    7
    Plugin Contributions
    0

    Default Re: 1146 Table doesn't exist

    Thank you very much.

    That took care of the error. Now I just get the message the the CC has been declined. I'll talk to usa_epay tomorrow about how to use the test CC number.

    ONE MORE problem though, if I enter a date earlier that todays date I get a error page:
    The server was unable to send acceptable data

    Code:
    Check that the address is spelled correctly, or try searching for the site.
    Search with Google
    http://thefishfactoryonline.com/shop/index.php?main_page=checkout_confirmation       -    	Search
    
    thefishfactoryonline.com 
    the fish factory online
    I noticed that I get that error even when I put in a bad CC number, IE says Internet Explorer cannot read this webpage format
    Last edited by Bryan G; 18 Apr 2011 at 06:25 AM.

  6. #6
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,762
    Plugin Contributions
    9

    Default Re: 1146 Table doesn't exist

    if I enter a date earlier that todays date I get a error page
    Don't do that...
    Zen-Venom Get Bitten

  7. #7
    Join Date
    Apr 2011
    Location
    Milwaukee, WI
    Posts
    7
    Plugin Contributions
    0

    Default Re: 1146 Table doesn't exist

    I don't get an error page saying wrong card, I get an error from Internet Explorer saying "Internet Explorer cannot read this webpage format"

    You can see the error, here is the cart http://thefishfactoryonline.com/shop
    I have one item in the store, just use a bad CC number or use a month/year earlier than this month.

    Why can't it just go to a page that tells the customer it's a bad CC, try again....

  8. #8
    Join Date
    Nov 2010
    Location
    Miami, Florida
    Posts
    57
    Plugin Contributions
    0

    help question Re: 1146 Table doesn't exist

    Hi All,
    I am so glad that I found this forum because I was having the same issue. The SQL Patch fixed the original problem but now I am receiving this message:

    Error Invalid Issuer - Your card has been declined. Please re-enter in your card information, try another card, or contact the store owner for assistance.

    Did anyone figure out the fix for this problem?

    Thanks in advance.

  9. #9
    Join Date
    Jan 2004
    Posts
    66,350
    Blog Entries
    7
    Plugin Contributions
    271

    Default Re: 1146 Table doesn't exist

    That's a message coming from the gateway. You need to talk to your gateway company, ie: whoever provides your merchant account.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  10. #10
    Join Date
    Nov 2010
    Location
    Miami, Florida
    Posts
    57
    Plugin Contributions
    0

    Default Re: 1146 Table doesn't exist

    Quote Originally Posted by DrByte View Post
    That's a message coming from the gateway. You need to talk to your gateway company, ie: whoever provides your merchant account.
    I spoke to my gateway company. They said that I cannot use test card numbers on a live site. I didn't know that. I then used a real card and it is working perfectly.

    Thanks a bunch!

 

 

Similar Threads

  1. 1146 Table doesn´t exist...
    By ppsoyal in forum General Questions
    Replies: 0
    Last Post: 29 Jan 2011, 10:37 PM
  2. 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
  3. 1146, table doesn't exist
    By swanriver in forum General Questions
    Replies: 4
    Last Post: 11 Dec 2010, 07:27 PM
  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