So,,,,Why is my site www.candygoround.com going to a blank page at checkout?
Printable View
So,,,,Why is my site www.candygoround.com going to a blank page at checkout?
Please review the Blank Page troubleshooting guide:
https://docs.zen-cart.com/user/troub...ng/blank_page/
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.
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:
Code:--> 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 156cQuote:
Originally Posted by lat9
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?
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.
The post you are linking refers to a language define problem (which produces a Warning at worst).Quote:
Originally Posted by dbltoe
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.Quote:
Originally Posted by swguy
It's the coupons table. FWIW, I've verified that the field is added within the zc_install upgrade script.Quote:
Originally Posted by RixStix
Hypothesis:
- OP had bad dates in his coupon table.
- zero_dates_cleanup.sql script was not run
- ALTER TABLE failed for that reason.
To test, in phpMyAdmin, run
ALTER TABLE orders_products ADD products_quantity_mixed tinyint(1) default NULL;
verify that it fails. The run
zc_install/sql/install/zero_dates_cleanup.sql
Then you can re-run that ALTER TABLE and it will work. But you'll have to figure out what worked and what didn't - it would be easier to restore your pre-upgrade database, run zero_dates_cleanup, then run zc_install so you'd be sure to get all the schema changes for 1.5.6.
Or did you perhaps add another date column to the coupons table that would need the zero_date fix?