Mysql error message on optimal payments

[krizzle]

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?

[krizzle]

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

[DrByte]

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

[krizzle]

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.

[krizzle]

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?

[DrByte]

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?

[krizzle]

ah, ok. i'm looking into it.