MissCC Posted March 7, 2006 Posted March 7, 2006 I am getting this weird error everytime someone pay by money order or COD: 1146 - Table 'mysql524fea3009f5340b3940bfb9623.TABLE_PAYPALIPN_TXN' doesn't exist select o.orders_status,p.* from orders o LEFT JOIN TABLE_PAYPALIPN_TXN p on p.item_number = o.orders_id AND o.customers_id = '8' order by o.date_purchased desc limit 1 [TEP STOP] Any idea? Quote
MissCC Posted March 7, 2006 Author Posted March 7, 2006 Here is my full PAYPAL IPN config from my admin, I just don't know how to configurate.. Enable PayPal IPN Module Do you want to accept PayPal IPN payments? True False E-Mail Address The e-mail address to use for the PayPal IPN service My email Transaction Currency The currency to use for transactions Selected Currency Only USD Only CAD Only EUR Only GBP Only JPY No currency selected Payment Zone If a zone is selected, only enable this payment method for that zone. --none-- Set Preparing Order Status Set the status of prepared orders made with this payment module to this value Preparing [PayPal IPN] Set PayPal Acknowledged Order Status Set the status of orders made with this payment module to this value Processing Gateway Server Use the testing (sandbox) or live gateway server for transactions? Testing Live Transaction Type Send individual items to PayPal or aggregate all as one total item? Per Item Aggregate Page Style The page style to use for the transaction procedure (defined at your PayPal Profile page) None Debug E-Mail Address All parameters of an Invalid IPN notification will be sent to this email address if one is entered. My email Sort order of display. Sort order of display. Lowest is displayed first. 1 Enable Encrypted Web Payments Do you want to enable Encrypted Web Payments? True False Your Private Key The location of your Private Key to use for signing the data. (*.pem) None Your Public Certificate The location of your Public Certificate to use for signing the data. (*.pem) None PayPals Public Certificate The location of the PayPal Public Certificate for encrypting the data. None Your PayPal Public Certificate ID The Certificate ID to use from your PayPal Encrypted Payment Settings Profile. None Working Directory The working directory to use for temporary files. (trailing slash needed) None OpenSSL Location The location of the openssl binary file. /usr/bin/openssl Quote
dynamoeffects Posted March 7, 2006 Posted March 7, 2006 You're missing some defines in your /includes/database.php file. Compare the installation package's database.php file to your own and make changes as necessary. Quote Please use the forums for support! I am happy to help you here, but I am unable to offer free technical support over instant messenger or e-mail.
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.