1146 - 'TABLE_PAYPAL_IPN' doesn't exist

[iberkner]

Hi,

In brief, doing an install of osMax from another one of our osMax working stores. Keeping everything, just data is coming in from a non-oscMax store (oscMax 2.2). Date went into oscMax db very nicely, everything seems to be working as it should. When I go to check orders, those that were paid with PayPal in the previous osMax installation, generate this error on the orders.php page:

1146 - Table 'dbname_oscmax.TABLE_PAYPAL_IPN' doesn't exist
select * from TABLE_PAYPAL_IPN where paypal_ipn_id = '0'
[TEP STOP]

Those orders that were paid with a credit card are fine. This only happens when I'm looking at an order that was paid with PayPal.

The paypal_IPN table is present but is empty as the previous store used a difference paypal module (I think).

Help??

I've looked everywhere... very some have suggested that it's a missing tax column in the orders table, but its there.

hope to find a resolution here...

[michael_s]

The problem is you need to define this constant = TABLE_PAYPAL_IPN

Whenever you see a constant like that (all caps with underscores) it means that the correct constant name has not been properly defined in your database_tables.php file.

PHP Code:

   define('TABLE_PAYPAL_IPN', 'paypal_ipn'); 


[iberkner]

Hi Michael,

Thanks for the response!

Ok, so I added the database table definition. Now it is giving me this error:

1146 - Table 'dbname_oscmax.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'

What I don't understand is the following:

1. I looked at my other oscMax installs and didn't see this type of table definition in the database_tables.php files, and I do have the paypal module installed and running.

2. How important are these tables for running paypal IPN transactions? are they legacy tables tied to prior data from my previous version of osCommerce that I was using?

Does it make sense to install a module that is specific to these tables to get them and the php files all squared away, if so, which version of paypal IPN that would work with oscMax?

Any help...

Thanks

[michael_s]

Add a definition for TABLE_PAYPAL_IPN_TXN_TYPE to database_tables.php.

I think it has something to do with you moving this from another install. I can't reproduce this on a stock install of osCMax, so I think it is specific to something you have done, but what I have no idea.

[iberkner]

I'm sure it has to do with how we transferred our install, more so with the data in the tables that's causing the system to look for these tables. I added the table definition, now I get this error:

1146 - Table 'dbname_oscmax.paypal_ipn_txn_type' doesn't exist

which reflects the fact that the table is not in the db. Do you know what the schema for this table should be?

[iberkner]

Hey,

Just wanted to say that I was able to solve this problem by updating the "payment_method" from "Paypal" to the full module name of "PayPal (Credit Card / Debit)". In our prior install, we had changed the name to "Paypal" only as we wanted to differentiate between the regular merchat account credit processing we had and the standard paypal payment method.

[michael_s]

I knew it had to be something with the imported data! Thanks for the update.

[calistared]

This has happened to me so thanks for the replies above.

How does it work though? I can only find the payment method name defined in the language file. What does it do with it that would produce the error? I would really appreciate any insight!

[iberkner]

Ok,

So we're still seeing this issue, I thought we had fixed it, but I was wrong. In a nutshell, here's what I think is happening:
- We are only using the basic PayPal payment module (not IPN)
- Order goes through ok, we get payment, etc. (provided they "confirmed") the order after making the paypal payment
- When we try to edit the order on the admin side, we get this error:

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

select * from TABLE_PAYPAL_IPN where paypal_ipn_id = '0'

[TEP STOP]

I think what is happening is that the order screen "thinks" that this is a paypal_ipn module order when in fact its not. I also can't find definitions anywhere for the paypal_ipn type of tables, etc.

I think that if I change the module name, somewhere, from just "PayPal" to "PayPal Payments" for example, it may work, but where / how do I make these changes?

Any help would be appreciated...

Thanks

[iberkner]

Just another update... in order to avoid this error, I went into the order.php file in the admin directory and changed where it was checking for 'paypal' to 'paypal_ipn' (2 places). What was happening is that the order.php file was equating a standard paypal transaction as a paypal ipn transaction.