One-Page Checkout [Support Thread]

[mprough]

... and how do you go about that upgrading of the live site's database? I ask because what you said still doesn't make sense to me.

Was OPC previously installed on the live site? If so, what version? What version of OPC is installed on the upgrade site?

There are no tables, per se, created by OPC's installation script ... just additions to the database's configuration, customers and address_book tables.

The live site's database is upgraded to zc_install and then I bring over all of the customer, order and related tables to "refresh" the dev site's data. Then it's just a matter of moving the live (in maintenance mode) site's files out and the new files in. Right, I need to then add the changes for customers and address_book tables.

[lat9]

@mprough, you can have OPC re-generate those customers and address-book records by cutting and pasting the following into the store's Tools->Install SQL Patches:

DELETE FROM configuration WHERE configuration_key IN ('CHECKOUT_ONE_GUEST_CUSTOMER_ID', 'CHECKOUT_ONE_GUEST_BILLTO_ADDRESS_BOOK_ID', 'CHECKOUT_ONE_GUEST_SENDTO_ADDRESS_BOOK_ID');

That will cause the OPC auto-installer to create those customer/address-book records on the next admin login or screen refresh.

[mprough]

@mprough, you can have OPC re-generate those customers and address-book records by cutting and pasting the following into the store's Tools->Install SQL Patches:

DELETE FROM configuration WHERE configuration_key IN ('CHECKOUT_ONE_GUEST_CUSTOMER_ID', 'CHECKOUT_ONE_GUEST_BILLTO_ADDRESS_BOOK_ID', 'CHECKOUT_ONE_GUEST_SENDTO_ADDRESS_BOOK_ID');

That will cause the OPC auto-installer to create those customer/address-book records on the next admin login or screen refresh.

Thank you very much