One-Page Checkout [Support Thread]

[lankeeyankee]

The error is telling you that you are missing a column in the orders table called is_guest_order. Again, I don't know why upgrading OPC versions hasn't updated the orders table to add this column, I haven't looked at the code. But, to get you rolling on your merry way, you can easily add this column.

ALTER TABLE `orders` ADD COLUMN `is_guest_order` tinyint(1) NOT NULL DEFAULT '0';

You can paste this into tools>install sql patches.

[shags38]

The error is telling you that you are missing a column in the orders table called is_guest_order. Again, I don't know why upgrading OPC versions hasn't updated the orders table to add this column, I haven't looked at the code. But, to get you rolling on your merry way, you can easily add this column.

ALTER TABLE `orders` ADD COLUMN `is_guest_order` tinyint(1) NOT NULL DEFAULT '0';

You can paste this into tools>install sql patches.

thanks lankee - I will give that a try and report back.

cheers,
Mike

[lat9]

Hmm, that is_guest_order should have been added to the orders' table on an install/upgrade to v2.0.0 (or later). If that's not there, there's also the possibility that other database configuration items weren't added either.

@shags38, would you post a screenshot of your store's Configuration->One-Page Checkout Settings for review?

[shags38]

Hmm, that is_guest_order should have been added to the orders' table on an install/upgrade to v2.0.0 (or later). If that's not there, there's also the possibility that other database configuration items weren't added either.

@shags38, would you post a screenshot of your store's Configuration->One-Page Checkout Settings for review?

Hi Cindy - configuration settings below as requested - v2.0.4 settings were exactly the same
cheers,
Mike
Attachment 17989

[lat9]

Thanks for that, Mike. That is_guest_order field should have been created when all the guest-checkout-related configuration settings were created, so I'm still puzzled.

[royaldave]

Hi

Have installed latest version of OPC and am having issues with zipship module. When you first arrive at the checkout page it correctly displays a delivery rate, however if you update the shipping address postcode it then incorrectly says 'The delivery/shipping fee cannot be determined at this time' .

[dbltoe]

Since OPC 2.0.0 and later have been found to work with ZipShip, are you receiving any debug files in the logs directory? If so, enter them here using the # sign above.

[lat9]

Hi

Have installed latest version of OPC and am having issues with zipship module. When you first arrive at the checkout page it correctly displays a delivery rate, however if you update the shipping address postcode it then incorrectly says 'The delivery/shipping fee cannot be determined at this time' .

I just tried this (OPC 2.0.4, ZC 1.5.5f, ZipShip v2.0.1, responsive_classic template) without issue. I placed an item into my cart, clicked the "Checkout" button and then clicked "Guest Checkout" on the OPC-modified login screen.

Started out with guest zipcode as one value ("supported" by ZipShip); shipping cost properly displayed. Changed the guest zipcode to another one within the ZipShip configuration (but with a different price) and the shipping-cost was correctly updated upon pressing the "Save" button from the OPC's main screen.

Was the issue you found during "normal" checkout?

Note: I just tried "normal" checkout without issue.