Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

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?

Posted

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

Posted

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.

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.

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...