Forums / Addon Payment Modules / 1146 Table doesn't exist

1146 Table doesn't exist

Started by bryan_g on 18 Apr 2011, 3:25 AM · Views: 2,880

Results 1 to 10 of 10
18 Apr 2011, 3:25 AM
#1
bryan_g avatar

bryan_g

New Zenner

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

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')]

**

18 Apr 2011, 3:41 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

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

18 Apr 2011, 4:40 AM
#3
bryan_g avatar

bryan_g

New Zenner

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

Re: 1146 Table doesn't exist

kobra:

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

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"

18 Apr 2011, 4:57 AM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

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

18 Apr 2011, 5:18 AM
#5
bryan_g avatar

bryan_g

New Zenner

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

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

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

18 Apr 2011, 5:24 AM
#6
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

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

18 Apr 2011, 5:34 AM
#7
bryan_g avatar

bryan_g

New Zenner

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

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

29 Jul 2011, 12:44 AM
#8
zc_newbie_1 avatar

zc_newbie_1

New Zenner

Join Date:
Nov 2010
Location:
Miami, Florida
Posts:
57
Plugin Contributions:
0

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.

29 Jul 2011, 1:40 AM
#9
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

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.

30 Jul 2011, 2:06 PM
#10
zc_newbie_1 avatar

zc_newbie_1

New Zenner

Join Date:
Nov 2010
Location:
Miami, Florida
Posts:
57
Plugin Contributions:
0

Re: 1146 Table doesn't exist

DrByte:

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. :oops: I didn't know that. I then used a real card and it is working perfectly.

Thanks a bunch!