One-Page Checkout [Support Thread]

[lat9]

I just re-uploaded the admin files. OPC is turned to FALSE. I go to the orders page - which is blank with the error and get the following adm file

Also -this is a pretty "vanilla" site with only a couple of mods.

[22-Jul-2020 17:23:24 UTC] Request URI: /catalog/2020/index.php?cmd=orders, IP address: 162.72.107.178
#1  trigger_error() called at [/home/afamblck/public_html/catalog/includes/classes/db/mysql/query_factory.php:170]
#2  queryFactory->show_error() called at [/home/afamblck/public_html/catalog/includes/classes/db/mysql/query_factory.php:142]
#3  queryFactory->set_error() called at [/home/afamblck/public_html/catalog/includes/classes/db/mysql/query_factory.php:269]
#4  queryFactory->Execute() called at [/home/afamblck/public_html/catalog/2020/includes/classes/observers/OnePageCheckoutAdminObserver.php:58]
#5  OnePageCheckoutAdminObserver->update() called at [/home/afamblck/public_html/catalog/includes/classes/class.base.php:118]
#6  base->notify() called at [/home/afamblck/public_html/catalog/2020/orders.php:1253]
#7  require(/home/afamblck/public_html/catalog/2020/orders.php) called at [/home/afamblck/public_html/catalog/2020/index.php:11]
--> PHP Fatal error: 1054:Unknown column 'is_guest_order' in 'field list' :: SELECT is_guest_order
                           FROM zen_orders
                          WHERE orders_id = 4582
                          LIMIT 1 ==> (as called by) /home/afamblck/public_html/catalog/2020/includes/classes/observers/OnePageCheckoutAdminObserver.php on line 58 <== in /home/afamblck/public_html/catalog/includes/classes/db/mysql/query_factory.php on line 170.

Somehow, part of OPC's installation didn't run. You need to run the database uninstall.sql provided in the plugin's /docs sub-directory. Then those missing database elements will be re-added on an admin-page refresh.

[stellarweb]

Somehow, part of OPC's installation didn't run. You need to run the database uninstall.sql provided in the plugin's /docs sub-directory. Then those missing database elements will be re-added on an admin-page refresh.

YOU DA BOSS, Girl!!!!!! That worked!!! Thank you SO MUCH for sticking with me until this was resolved!

[lat9]

YOU DA BOSS, Girl!!!!!! That worked!!! Thank you SO MUCH for sticking with me until this was resolved!

No problems, happy to have helped. The real question, though, is why that database installation didn't "take" initially.

Update: Remember, too, to change that OPC totals' selector in the admin configuration.

[stellarweb]

No problems, happy to have helped. The real question, though, is why that database installation didn't "take" initially.

Update: Remember, too, to change that OPC totals' selector in the admin configuration.

I don't know - I installed it correctly, so don't know why the orders page and the checkout was affected.

What do you mean about changing the OPC total's selector? Right now it says #ottotal > div:first-child

[lat9]

I don't know - I installed it correctly, so don't know why the orders page and the checkout was affected.

What do you mean about changing the OPC total's selector? Right now it says #ottotal > div:first-child

I thought that your site's Bootstrap template's tpl_modules_order_total.php had been updated to use #OPC as the selector for the order's total. Check the code before making changes.

[strelitzia]

I've discovered that this module doesn't work when EC Analytics is installed (https://www.zen-cart.com/downloads.php?do=file&id=1997)
I am just presented with the regular multiple page checkout.
Is this something you're aware of, and is there a solution other than switching to a different analytics module?

[lat9]

I've discovered that this module doesn't work when EC Analytics is installed (https://www.zen-cart.com/downloads.php?do=file&id=1997)
I am just presented with the regular multiple page checkout.
Is this something you're aware of, and is there a solution other than switching to a different analytics module?

I've not seen that before. Are there console logs generated? Debug-logs?