Paypal Error in Order Details

[Marotta1]

I setup Paypal Website Payments Standard today. When I click on Orders > Details that were paid through Paypal, I get the following error above where there would normally be the Order # and Order Date & Time. Then there are no Payment Method, and Products Ordered listings.

Customer: Ggggggg Mmmmmmm
999 Way St
Town,State 99999
United States


Telephone Number: 111-222-3333
FAX #:
E-Mail Address: xxxxxxxx@yyyyyyyyyyyyyyyyyy.com

1146 - Table 'db300000000000.TABLE_PAYPAL_IPN' doesn't exist

select * from TABLE_PAYPAL_IPN where paypal_ipn_id = '0'

[TEP STOP]

Order # 23
Order Date & Time 12/21/2009 21:00:37

Can someone tell me, is this due to the Gift Voucher Bug with Paypal. or is there something else that I need to fix/patch? Packing Slips and Invoices still work, as does the Order Editor.

[michael_s]

This is due to your hacked site . When fixing it up, you must have overwritten some of the constants defined.

You need to define TABLE_PAYPAL_IPN in database_tables.php

[Marotta1]

Michael, this is actually not the site that was hacked. It is a new site I am finishing up.

You are talking about /catalog/admin/includes/database_tables.php not /catalog/includes/database_tables.php, correct?

I added the following:

define('TABLE_PAYPAL_IPN', 'paypal_ipn');

I now get this:

1146 - Table 'db300000000000.TABLE_PAYPAL_IPN_TXN_TYPE' doesn't exist

select txn_type_name from TABLE_PAYPAL_IPN_TXN_TYPE where txn_type_id = '0 and language_id=1'

[TEP STOP]

That is a table field that should not have to be defined if I understand correctly. Is there something else I should be looking for?