Zen Cart Logo
Forums / Installing on a Linux/Unix Server / Mysql error message on optimal payments

Mysql error message on optimal payments

Locked

Views: 1,537

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
29 Aug 2006, 1:52 PM
#1
krizzle avatar

krizzle

New Zenner

Join Date:
Aug 2006
Location:
Boston MA
Posts:
19
Plugin Contributions:
0

Mysql error message on optimal payments

I receive the following error message when I try to order something on my site"

1146 Table 'menofmo_zc1.zen_optimal_payments' doesn't exist
in:
[INSERT INTO zen_optimal_payments (txType, status, authCode, authTime, avsInfo, cvdInfo, curAmount, amount, txnNumber, clientVersion, zen_order_id) VALUES ('P', 'SP', '130286', '1156858149', 'B', 'M', '0', '211', '1000001', '1.1', '')]

Does anyone know if there's a fix for this?:unsure:

29 Aug 2006, 2:07 PM
#2
krizzle avatar

krizzle

New Zenner

Join Date:
Aug 2006
Location:
Boston MA
Posts:
19
Plugin Contributions:
0

Re: Mysql error message on optimal payments

I'm just noticing in PHPAdmin that the table does not exist. Has anyone had this problem before? Thanks so much.

29 Aug 2006, 2:14 PM
#3
drbyte avatar

drbyte

Sensei

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

Re: Mysql error message on optimal payments

Where did you get the "optimal payments" code from?
It appears that you've not installed the addon correctly

29 Aug 2006, 2:38 PM
#4
krizzle avatar

krizzle

New Zenner

Join Date:
Aug 2006
Location:
Boston MA
Posts:
19
Plugin Contributions:
0

Re: Mysql error message on optimal payments

Thanks for responding. The error message appeared when I clicked the "confirm purchase now" button in my cart. Did you want a url? I'm wondering if I need to reinstall the whole program or if there is some code I can add to the optimal_payments_database_tables.php.

Here is the code that's in the file that the error is pointing to:

<?php if (!defined('DB_PREFIX')) { define('DB_PREFIX', ''); } define('TABLE_OPTIMAL_PAYMENTS', DB_PREFIX . 'optimal_payments'); ?>

Any help is greatly appreciated.

29 Aug 2006, 2:54 PM
#5
krizzle avatar

krizzle

New Zenner

Join Date:
Aug 2006
Location:
Boston MA
Posts:
19
Plugin Contributions:
0

Re: Mysql error message on optimal payments

I just checked all of the files. The files were installed correctly. I am also noticing that the orders are going through, which is kind of odd. Any ideas anybody?

29 Aug 2006, 3:20 PM
#6
drbyte avatar

drbyte

Sensei

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

Re: Mysql error message on optimal payments

krizzle:

I'm just noticing in PHPAdmin that the table does not exist. Has anyone had this problem before? Thanks so much.
Back to my point.
Was there a .sql file with the module, which you failed to run in order to create the table in the database?

29 Aug 2006, 3:30 PM
#7
krizzle avatar

krizzle

New Zenner

Join Date:
Aug 2006
Location:
Boston MA
Posts:
19
Plugin Contributions:
0

Re: Mysql error message on optimal payments

ah, ok. i'm looking into it.