Im using the paypal sandbox - payment works fine and i get returned to the correct checkout complete order page. However my order does not progress from "pending" and i have the following messages in my log:

firstly i get this message:

commerce_paypal	06/06/2011 - 18:01	Attempting to process IPN 5YF47342HY902501G. Array...	Anonymous (not verified)

then this error message:

DOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'artfo_dl7.commerce_paypal_ipn' doesn't exist: SELECT cpi.* FROM {commerce_paypal_ipn} cpi WHERE (cpi.txn_id = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 5YF47342HY902501G ) in commerce_paypal_ipn_load() (line 180 of /home/artfo/public_html/dl7/sites/all/modules/commerce_paypal/commerce_paypal.module).

I have tried using the dev version of commerce and the latest stable build, both have this problem. Obviously i'm missing the commerce_paypal_ipn table, but i'm not sure why.

Comments

amcc’s picture

amcc commented
Status: Active » Fixed

uninstalling the paypal modules and re-installing them fixed this problem.

Automatically closed -- issue fixed for 2 weeks with no activity.