when checking out goes to blank page

[lrfowler24]

So,,,,Why is my site www.candygoround.com going to a blank page at checkout?

[swguy]

Please review the Blank Page troubleshooting guide:
https://docs.zen-cart.com/user/troub...ng/blank_page/

[lrfowler24]

I can't checkout.....I log in as new customer ...but it doesnt go anywhere....
here is the log file:
[27-Mar-2020 20:31:45 America/Boise] Request URI: /store/ipn_main_handler.php?type=ec, IP address: 76.14.185.186
#1 trigger_error() called at [/home4/twomuch1/public_html/other_websites/candygoround/store/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home4/twomuch1/public_html/other_websites/candygoround/store/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home4/twomuch1/public_html/other_websites/candygoround/store/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home4/twomuch1/public_html/other_websites/candygoround/store/includes/functions/functions_gvcoupons.php:110]
#5 is_coupon_valid_for_sales() called at [/home4/twomuch1/public_html/other_websites/candygoround/store/includes/modules/order_total/ot_coupon.php:611]
#6 ot_coupon->get_order_total() called at [/home4/twomuch1/public_html/other_websites/candygoround/store/includes/modules/order_total/ot_coupon.php:61]
#7 ot_coupon->process() called at [/home4/twomuch1/public_html/other_websites/candygoround/store/includes/classes/order_total.php:178]
#8 order_total->pre_confirmation_check() called at [/home4/twomuch1/public_html/other_websites/candygoround/store/includes/modules/payment/paypalwpp.php:1570]
#9 paypalwpp->ec_step1() called at [/home4/twomuch1/public_html/other_websites/candygoround/store/ipn_main_handler.php:76]
--> PHP Fatal error: 1054:Unknown column 'coupon_is_valid_for_sales' in 'field list' :: SELECT coupon_id, coupon_is_valid_for_sales
FROM coupons
WHERE coupon_id = 0 ==> (as called by) /home4/twomuch1/public_html/other_websites/candygoround/store/includes/functions/functions_gvcoupons.php on line 110 <== in /home4/twomuch1/public_html/other_websites/candygoround/store/includes/classes/db/mysql/query_factory.php on line 171.

[dbltoe]

https://www.zen-cart.com/showthread....ALID_FOR_SALES might help

[lat9]

You didn't identify the Zen Cart version being used for your site (or the site's upgrade history). The coupons::coupon_is_valid_for_sales database field was added for Zen Cart 1.5.6 and it's apparently missing from your database, as indicated by the log you posted:

--> PHP Fatal error: 1054:Unknown column 'coupon_is_valid_for_sales'  in 'field list' :: SELECT coupon_id, coupon_is_valid_for_sales

[RixStix]

You didn't identify the Zen Cart version being used for your site (or the site's upgrade history). The coupons::coupon_is_valid_for_sales database field was added for Zen Cart 1.5.6 and it's apparently missing from your database, as indicated by the log you posted:

--> PHP Fatal error: 1054:Unknown column 'coupon_is_valid_for_sales'  in 'field list' :: SELECT coupon_id, coupon_is_valid_for_sales

Which table? Before I go any further with the upgrade from 154 to 156c
I just searched all db tables from within phpmyadmin for coupon_is_valid_for_sales and came up with zero matches but I wouldn't rule out my incompetance.

Is it possible that a new db install creates it but a db upgrade does not?

[swguy]

Have you run the database upgrade? (zc_install)? That's where the field gets added.

If you *did* run the upgrade, did you check for log files afterwards? The operation that created the field might have failed.

[swguy]

https://www.zen-cart.com/showthread....ALID_FOR_SALES might help

The post you are linking refers to a language define problem (which produces a Warning at worst).
OP is receiving a fatal error.

[dbltoe]

The post you are linking refers to a language define problem (which produces a Warning at worst).
OP is receiving a fatal error.

Thanks for the clarification. I was using Google as the forum search is, IMHO, the pits. Looked like that might get the OP in the right area since we didn't know the version.

[lat9]

Which table? Before I go any further with the upgrade from 154 to 156c
I just searched all db tables from within phpmyadmin for coupon_is_valid_for_sales and came up with zero matches but I wouldn't rule out my incompetance.

Is it possible that a new db install creates it but a db upgrade does not?

It's the coupons table. FWIW, I've verified that the field is added within the zc_install upgrade script.