So,,,,Why is my site www.candygoround.com going to a blank page at checkout?
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/
That Software Guy. My Store: Zen Cart Modifications
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.
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.
Are You Vulnerable for an Accessibility Lawsuit?
myZenCartHost.com - Zen Cart Certified, PCI Compatible Hosting by JEANDRET
Free SSL, Domain, and MagicThumb with semi-annual and longer hosting.
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 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?
Rick
RixStix (dot) com
aka: ChainWeavers (dot) com
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.
That Software Guy. My Store: Zen Cart Modifications
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.
That Software Guy. My Store: Zen Cart Modifications
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.
Are You Vulnerable for an Accessibility Lawsuit?
myZenCartHost.com - Zen Cart Certified, PCI Compatible Hosting by JEANDRET
Free SSL, Domain, and MagicThumb with semi-annual and longer hosting.
Bookmarks