One-Page Checkout [Support Thread]

Does "Order Delivery Date" supply any files that should be placed in the /includes/modules/pages/checkout_shipping or checkout_payment pages? If so, have you copied those files to the checkout_one page's directory?

I've just submitted v2.0.4 of *OPC *to the Zen Cart Plugins for review and will post back here once it's available for download.

This release contains changes associated with the following GitHub issues:

#143: "Suburb" and "Company" changes not saved on address update.
#144: Maximum address-book entries not honored for account-holders.
#145: Downloads result in a 0-byte file.
#146: Guest-customer can't download from the "checkout_success" page.
#147: Payments can't be made with methods that "collectCardDataOnSite".

lat9:

Does "Order Delivery Date" supply any files that should be placed in the /includes/modules/pages/checkout_shipping or checkout_payment pages? If so, have you copied those files to the checkout_one page's directory?

yes It does. I have copied the file such as the mootools calendar as per the instructions of OPC.

nicksab:

yes It does. I have copied the file such as the mootools calendar as per the instructions of OPC.

nevermind. The files were in the wrong folder. I got the calendar to appear. I am still having issue like when a date is selected on the order, the date on the admin side is not being updated.

I will ask in the order delivery thread as this appears to be a module issue.

Thank you

Hi Cindy - I have just completed a clean rebuild of another site to 155f with your latest OPC version 2.0.4 - I do not believe this is related to OPC but possibly something I have missed in the install of OPC or more likely elsewhere? OPC settings have Guest checkout enabled in admin/configuration

at the cart when I select checkout it takes me to index.php?main_page=login with choices for checkout - on clicking on Guest >> checkout I get the 'login time out' page with the message 'Whoops! Your session has timed out'.

on the index.php?main_page=login page mouseover on 'sign in' and 'sign up' buttons changes button color but not on checkout button.

the checkout process via sign in and via paypal work well, no problems.

I have searched FAQ's and the Forum (found very old thread 2013 but no answer to the issue) and cannot find a solution - I used admin/developer searching time_out and there are 67 matching lines however I am loathe to fiddle with any php files affecting checkout or payment.

myDEBUG-admin error shows this and have no idea if it is related ```
[17-Jul-2018 12:20:26 Australia/Melbourne] PHP Fatal error: Cannot destroy active lambda function in [no active file] on line 0

I did a Google search using that error message as a search term and there are a number of entries - I read some and they mention 'time out' faults regularly however the type of language used and context was out of my league - but there seems to be a possible fit?

site <https://www.harmonyballpendant.com>

If this is not an OPC issue please let me know and I can post a query in general questions.


cheers,
Mike

Mike, that "button not changing color" is due to your stylesheet(s); there's specific styling for the login and create-account buttons ... but not for the guest-checkout one.

I'm at a loss to identify why the guest-checkout would result in a time-out. You could generate an OPC log for that guest-checkout mis-handling and send it to me directly.

That other lambda-related issue (in the admin) wouldn't have anything to do with OPC as it's contribution to the admin-side of things is minimal.

lat9:

I've just submitted v2.0.4 of *OPC *to the Zen Cart Plugins for review and will post back here once it's available for download.

This release contains changes associated with the following GitHub issues:

#143: "Suburb" and "Company" changes not saved on address update.
#144: Maximum address-book entries not honored for account-holders.
#145: Downloads result in a 0-byte file.
#146: Guest-customer can't download from the "checkout_success" page.
#147: Payments can't be made with methods that "collectCardDataOnSite".
Now available for download from the Zen Cart plugins.

Hello Cindy - I am getting 2.0.3 to work perfectly now as I am rebuilding my sites to 1.5.5f one by one. With the most recent I used your new 2.0.4 however I had an issue with it that I thought you may be interested to know about (assuming here that I haven't done anything wrong :smile: ) - the site is using PHP 5.6 as there is a problem with one part of the template I am using (Westminster New) not loading correctly on PHP 7.1 so I am unsure if it is related to PHP version.

Upon clicking 'confirm order' in checkout a blank white page comes up with an error message 'WARNING: An Error occurred, please refresh the page and try again.' Refreshing didn't work, just kept bring back that error page. The transaction(s) actually went through successfully, a credit card checkout and a paypal checkout - same error showed after both transactions.

I uninstalled 2.0.4 and installed 2.03 (with the jscript fixes from you) and it works perfectly. Unfortunately I didn't have the DEBUG log turned on in OPC settings so I didn't capture a log file - as it is still a test site I am more than happy to revert to 2.0.4 with log turned on if you think it would be useful.

I retraced my steps a few times with the 2.0.4 install and nothing glaringly stood out as being wrong on my part (but stranger things have happened).

cheers,
Mike

Mike, when you receive the "Warning: An error occurred" message, a myDEBUG-*.log file should have been created in the site's /logs directory ... that's outside of the control of the OPC's debug (which provides informational logging).

Would you post the contents of one of those logs?

lat9:

Mike, when you receive the "Warning: An error occurred" message, a myDEBUG-*.log file should have been created in the site's /logs directory ... that's outside of the control of the OPC's debug (which provides informational logging).

Would you post the contents of one of those logs?

Hi Cindy,

here is a myDEBUG - I should have posted this in the first place, sorry.

cheers, Mike

[27-Jul-2018 06:08:23 UTC] Request URI: /teststore/index.php?main_page=checkout_process, IP address: 203.221.72.3
#1  trigger_error() called at [/home/cliponearrings/public_html/teststore/includes/classes/db/mysql/query_factory.php:171]
#2  queryFactory->show_error() called at [/home/cliponearrings/public_html/teststore/includes/classes/db/mysql/query_factory.php:143]
#3  queryFactory->set_error() called at [/home/cliponearrings/public_html/teststore/includes/classes/db/mysql/query_factory.php:270]
#4  queryFactory->Execute() called at [/home/cliponearrings/public_html/teststore/includes/classes/observers/class.checkout_one_observer.php:258]
#5  checkout_one_observer->update() called at [/home/cliponearrings/public_html/teststore/includes/classes/class.base.php:103]
#6  base->notify() called at [/home/cliponearrings/public_html/teststore/includes/classes/order.php:685]
#7  order->create() called at [/home/cliponearrings/public_html/teststore/includes/modules/checkout_process.php:88]
#8  require(/home/cliponearrings/public_html/teststore/includes/modules/checkout_process.php) called at [/home/cliponearrings/public_html/teststore/includes/modules/pages/checkout_process/header_php.php:14]
#9  require(/home/cliponearrings/public_html/teststore/includes/modules/pages/checkout_process/header_php.php) called at [/home/cliponearrings/public_html/teststore/index.php:36]

[27-Jul-2018 06:08:23 UTC] PHP Fatal error:  1054:Unknown column 'is_guest_order' in 'field list' :: UPDATE orders
                            SET is_guest_order = 1
                          WHERE orders_id = 37
                          LIMIT 1 ==> (as called by) /home/cliponearrings/public_html/teststore/includes/classes/observers/class.checkout_one_observer.php on line 258 <== in /home/cliponearrings/public_html/teststore/includes/classes/db/mysql/query_factory.php on line 171

If you look at the debug log, can you get an idea of what's wrong? Hint: it's where it says fatal error. What would you want to do first from looking at this error message? I bet you can figure this one out on your own!👍

lankeeyankee:

If you look at the debug log, can you get an idea of what's wrong? Hint: it's where it says fatal error. What would you want to do first from looking at this error message? I bet you can figure this one out on your own!������
many thanks for responding lankee -
I am going to engage you as my Motivational consultant lankeeyankee - the expression of your confidence in my ability has driven me to new heights! :cool:
So the problem I have is understanding the context of what that line means and hence trying to decipher the issue;

            // $p2 ... (r/w) A reference to the newly-created order's ID value.
            //
            case 'NOTIFY_ORDER_DURING_CREATE_ADDED_ORDER_HEADER':
                if (zen_in_guest_checkout()) {
                    $GLOBALS['db']->Execute(
                        "UPDATE " . TABLE_ORDERS . "
                            SET is_guest_order = 1
                          WHERE orders_id = " . (int)$p2 . "
                          LIMIT 1"
                    );
                }
                break;

Interpretation of someone who is not a coder - it means that a 'guest' has a limit of '1' order per visit (login) ?? somehow I think it means something different/more than that but let's assume I am right - why would that trigger on just one login and why would the transaction actually process?

Most of the time I do try to work out the logic of issues within my limited knowledge of coding however other times I reach for the panic button - gotta get out of that habit :bangin:

thanks again,
Mike

I think you're missing what I meant:```php
PHP Fatal error: 1054:Unknown column 'is_guest_order' in 'field list' :: UPDATE orders....

It looks like there is a missing column in the orders table. That is what this error message is telling you. "Unknown column 'is_guest_order'"

Sometimes the logs can be confusing and it would be nice if there was a "basic log" showing just the error and a "complete log" such as it currently is. While it's good to be able to back trace where the error is being called from, the chain of events, it can also be perhaps "too much information" for many regular (non-developer) users when all they need is that last line of the log showing the actual error.

So, in the interest of helping you get a better understanding of what's occurred, do you have more insight into the issue? Just from what that bit that I pasted above is saying. I do not know why this is happening in terms of upgrading from a lower version, and Cindy is the best person to address it moving forward, but you can remedy this so you can progress with your site update once you see what the error is telling you.

lankeeyankee:

I think you're missing what I meant:```php
PHP Fatal error: 1054:Unknown column 'is_guest_order' in 'field list' :: UPDATE orders....

> It looks like there is a missing column in the orders table. That is what this error message is telling you. "Unknown column 'is_guest_order'"
> 
> Sometimes the logs can be confusing and it would be nice if there was a "basic log" showing just the error and a "complete log" such as it currently is. While it's good to be able to back trace where the error is being called from, the chain of events, it can also be perhaps "too much information" for many regular (non-developer) users when all they need is that last line of the log showing the actual error.
> 
> So, in the interest of helping you get a better understanding of what's occurred, do you have more insight into the issue? Just from what that bit that I pasted above is saying. I do not know why this is happening in terms of upgrading from a lower version, and Cindy is the best person to address it moving forward, but you can remedy this so you can progress with your site update once you see what the error is telling you.

Thanks again lankee - I can't tell you any more about what is happening than what I described in the post on the previous page. So you are aware, the site is upgraded using 2.0.3 with some jscript file modifications provided  by Cindy that solved a particular problem. Cindy then had some other improvements she did and released 2.0.4 a few days later but for some reason or other I am having an issue with it so I reverted to 2.0.3 - I suppose I was just letting Cindy know. 2.0.3 (modified) is working fine for me.

The reference to upgrade was in relation to PHP versions, from 5.6 used on the previous v1.5.1 to upgrading it to 7.1 when I upgraded the site to v1.5.5f and the problem it is causing on the template I am using and the off chance it may have been an influence - if you are so inclined maybe you might be able to offer an opinion on the cause of the PHP conflict, see this thread >> <https://www.zen-cart.com/showthread.php?213334-Westminster-New&p=1347942#post1347942>

thanks again for your support.

cheers,
Mike

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';

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';

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

cheers,
Mike

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?

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?

Hi Cindy - configuration settings below as requested - v2.0.4 settings were exactly the same
cheers,
Mike
[Attachment no longer available]

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.

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' .