One-Page Checkout [Support Thread]

[llemberg]

Sorry I omitted the OnePage version. In the zen cart configuration it is reported as 2.3.7-beta2 (2021-01-17). I downloaded it from the "Download Latest" button at https://www.zen-cart.com/downloads.p...2095&styleid=2
Lars

[lat9]

@llemberg, in that log you posted, what Request URI was included?

[llemberg]

Here is the Request URI from the log
[14-Apr-2021 14:29:42 America/Los_Angeles] Request URI: /ipn_main_handler.php?type=ec, IP address: <my.ip.add.ress>

[lat9]

When you inspect your database (via phpMyAdmin), you should have three configuration_key values:

1. CHECKOUT_ONE_GUEST_BILLTO_ADDRESS_BOOK_ID
2. CHECKOUT_ONE_GUEST_SENDTO_ADDRESS_BOOK_ID
3. CHECKOUT_ONE_GUEST_CUSTOMER_ID

The CHECKOUT_ONE_GUEST_CUSTOMER_ID should be associated with the "Guest Customer"'s customers-table record and the two ADDRESS_BOOK_ID values should refer to a valid entry (associated with that Guest Customer) in the site's address_book table.

[lat9]

Hmm, re-looking at that log posted:

--> PHP Fatal error: Unknown/invalid billto address # for customer#. in /includes/classes/OnePageCheckout.php on line 2323.

That highlighted line is not the line on which that trigger_error is thrown. Are you sure you have the most up-to-date version of that class-file?

[llemberg]

Hmm, re-looking at that log posted:

--> PHP Fatal error: Unknown/invalid billto address # for customer#. in /includes/classes/OnePageCheckout.php on line 2323.

That highlighted line is not the line on which that trigger_error is thrown. Are you sure you have the most up-to-date version of that class-file?

You fixed it. Not the file reporting the error, but my tpl_modules_opc_shopping_cart.php was two characters shorter than the one contained in one_page_checkout-2.3.7.zip. I don't know why, and probably never will. Thanks for your help, I was getting close to a clean start-from-scratch rebuild, so now I am moving forward again.
Lars

[lat9]

You fixed it. Not the file reporting the error, but my tpl_modules_opc_shopping_cart.php was two characters shorter than the one contained in one_page_checkout-2.3.7.zip. I don't know why, and probably never will. Thanks for your help, I was getting close to a clean start-from-scratch rebuild, so now I am moving forward again.
Lars

Lars, that still doesn't explain the line-number discrepancy for the /includes/classes/OnePageCheckout.php where that error was reported.

[llemberg]

When you inspect your database (via phpMyAdmin), you should have three configuration_key values:

1. CHECKOUT_ONE_GUEST_BILLTO_ADDRESS_BOOK_ID
2. CHECKOUT_ONE_GUEST_SENDTO_ADDRESS_BOOK_ID
3. CHECKOUT_ONE_GUEST_CUSTOMER_ID

The CHECKOUT_ONE_GUEST_CUSTOMER_ID should be associated with the "Guest Customer"'s customers-table record and the two ADDRESS_BOOK_ID values should refer to a valid entry (associated with that Guest Customer) in the site's address_book table.

@lat9,
The database entries you refer to look like they are lined up correctly. The three configuration key values:

mysql> select configuration_id,configuration_key,configuration_value from configuration where configuration_key like 'CHECKOUT_ONE_GUEST_%_ID';
+------------------+-------------------------------------------+---------------------+
| configuration_id | configuration_key                         | configuration_value |
+------------------+-------------------------------------------+---------------------+
|              719 | CHECKOUT_ONE_GUEST_BILLTO_ADDRESS_BOOK_ID | 11807               |
|              718 | CHECKOUT_ONE_GUEST_CUSTOMER_ID            | 9335                |
|              720 | CHECKOUT_ONE_GUEST_SENDTO_ADDRESS_BOOK_ID | 11808               |
+------------------+-------------------------------------------+---------------------+
3 rows in set (0.00 sec)

The GUEST_CUSTOMER_ID in the customers table:

mysql> select customers_id,customers_firstname,customers_lastname from customers where customers_firstname='Guest';
+--------------+---------------------+-----------------------------+
| customers_id | customers_firstname | customers_lastname          |
+--------------+---------------------+-----------------------------+
|         9335 | Guest               | Customer, **do not remove** |
+--------------+---------------------+-----------------------------+
1 row in set (0.00 sec)

and the two ADDRESS_BOOK_IDs in the address_book table:

mysql> select address_book_id,entry_firstname,entry_lastname from address_book where entry_firstname='Guest';
+-----------------+-----------------+-----------------------------+
| address_book_id | entry_firstname | entry_lastname              |
+-----------------+-----------------+-----------------------------+
|           11807 | Guest           | Customer, **do not remove** |
|           11808 | Guest           | Customer, **do not remove** |
+-----------------+-----------------+-----------------------------+
2 rows in set (0.00 sec)

I've experimented a bit more and discovered that if from the cart I use the Zen Cart buttons to get me to the Checkout page (index.php?main_page=checkout_one), fill in the Contact Info, click Shopping Cart at the top of the page to get back to the cart, THEN the "Pay With PayPal" button successfully takes me to the PayPal log in. It makes sense, since I've entered the missing data causing the error, but I can't determine why the checkout fails trying to use the "Checkout With PayPal" button alone.