lat9:
When you inspect your database (via phpMyAdmin), you should have three configuration_key values:
- CHECKOUT_ONE_GUEST_BILLTO_ADDRESS_BOOK_ID
- CHECKOUT_ONE_GUEST_SENDTO_ADDRESS_BOOK_ID
- 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.
