Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › Sandbox test problem on pp_confirm.php page

Sandbox test problem on pp_confirm.php page

Thread began 9/18/2019 11:05 am by s.joiner74419001 | Last modified 9/19/2019 12:21 pm by s.joiner74419001 | 61 views | 3 replies

9/19/2019 12:21 pmRay BorduinWebAssist

Open the "Structure" tab of the Orders table and make sure they are the same.... Try checking the "Allow Null" checkbox for the OrderShipAddress2 table.

You could also update the default value for that column to be blank.

You could also update the line on your store cart summary in database from:
$ConditionalQuery->bindColumn("OrderShipAddress2", "d", "".(WA_coalesce(array(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Address_2_2'),WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Address_2')))) ."", "WA_DEFAULT");

to:
$ConditionalQuery->bindColumn("OrderShipAddress2", "d", "".(WA_coalesce(array(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Address_2_2'),WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Address_2')))) ."", "WA_BLANK");

That will insert a blank entry when the field is omitted instead of trying to use the database default.

Did this help? Tips are appreciated...

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.