close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

500 Error on ppconfirm.php page

Thread began 8/16/2017 12:04 am by jlowery | Last modified 8/25/2017 12:37 pm by Ray Borduin | 65 views | 19 replies |

jlowery

500 Error on ppconfirm.php page

After completing PayPal payment, I'm getting a 500 Server Error when I hit the ppconfirm.php page. I added the error_reporting(E_ALL) line, but no more info was provided. Any thoughts how to resolve this?

Sign in to reply to this post

Ray BorduinWebAssist

Your store cart summary and store cart details in database server behaviors are corrupt. It looks like they were created by running the checkout wizard without a working connection to the database. They will have to be reapplied.

Sign in to reply to this post

jlowery

Okay, will do. I also want to store customer info in a separate table. Should that Store Details server behavior come after the eCart details?

Sign in to reply to this post

Ray BorduinWebAssist

You could just apply another store cart summary in database server behavior for the users table. It wouldn't really matter the order.

Sign in to reply to this post

jlowery

Thanks. The client is leaning toward a customer back-end so returning customers could log-in to have their shipping info automatically populate the form and maybe eventually show an order history. Can I do this with just one customer table?

If I'm using such a table, how do I get the cust_id for the Orders Summary?

Sign in to reply to this post

Ray BorduinWebAssist

If you are going that route the easiest thing is to force registration or login before checkout. Then store the customer id in the session during login.

Sign in to reply to this post

jlowery

I think that's down the road. So currently, I should insert a Store Cart Summary for customers. How do I get that ID for the order summary?

Sign in to reply to this post

Ray BorduinWebAssist

You could use their email address as the ID so that if the same email address is used it updates the record instead of inserting a new one. Or just use an insert into table instead of store cart summary into database if you want to insert a new record every time.

Sign in to reply to this post

jlowery

The previous site used the record ID from the customers table, so I followed that path and set cust_id to the customer_ID session variable. I'm closer - it now goes through PayPal (although the payment doesn't seem to be immediately recorded) but when I am sent back to the site, I get this error "Column 'cust_id' cannot be null"

What next?

Sign in to reply to this post

Ray BorduinWebAssist

Go to the database and update that column to allow null.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...