Fast and Easy Checkout

I installed the new version of fast and easy checkout on a site today.

I then decided to upgrade my old site.

Rather foolishly i decided to uninstall using the uninstall.sql file thinking i could easily use the install.sql file to get the new version up and running without using the update sql files as i was unsure if i needed to run just the latest update sql file or the last two as the version i was running was at least three updates old.

Now i have all the files in the correct folders but i cannot get the install sql to work and fast and easy checkout has gone from the admin section and i get this.

1062 Duplicate entry 'Permanent Account Holders Only' for key 2
in:
[INSERT INTO zen_query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( '', 'email,newsletters', 'Permanent Account Holders Only', 'Send email only to permanent account holders ', 'select customers_email_address, customers_firstname, customers_lastname from TABLE_CUSTOMERS where COWOA_account != 1 order by customers_lastname, customers_firstname, customers_email_address');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I tried looking in MyPHPAdmin but i'm unsure what search terms to use to get rid of all the old data so i can run the install sql again.

Can you help please.

I just tried to install the latest (1.4.4) version in a new Zencart installation (twice) and got a 1064 error when I ran the install.sql. Anybody install this version without a problem?

As long as I'm here, what am I supposed to do with update_1_4_4.sql? I tried running it after running install.sql, but got another error (don't remember the number, but it had to do with an element already existing).

I have a customer who emailed me with the issue below, I cannot seem to duplicate this error on my computer or any others. Other customers also seem to have this issue. Can anyone find out what is going on here?

Customer email:

"I have been trying for 2 days to order a product from your website with no luck. I load it into my cart, click checkout without setting up an account, and fill in my name, address, phone #, etc then click "continue" but it gets locked up every time and I never get any further. I have ordered other products from other websites during the same time with no problem so it must be your site. Please let me know if you get the site working in the next couple days."

Like I said, I can't even duplicate the error, for us, we can go all the way to PayPal's Payment page with no errors. Is it something to do with her browser settings?

Site: www.~~~Beyon~~Lounge~~~.com Without the ~'s

Thanks

Quote:

---

Originally Posted by Kunal

I have a customer who emailed me with the issue below, I cannot seem to duplicate this error on my computer or any others. Other customers also seem to have this issue. Can anyone find out what is going on here?

Customer email:

"I have been trying for 2 days to order a product from your website with no luck. I load it into my cart, click checkout without setting up an account, and fill in my name, address, phone #, etc then click "continue" but it gets locked up every time and I never get any further. I have ordered other products from other websites during the same time with no problem so it must be your site. Please let me know if you get the site working in the next couple days."

Like I said, I can't even duplicate the error, for us, we can go all the way to PayPal's Payment page with no errors. Is it something to do with her browser settings?

Site: www.~~~Beyon~~Lounge~~~.com Without the ~'s

Thanks

---

I just tried your site without an account and i got all the way through to PayPal. I tried using Firefox.

Perhaps your store has cookies required and they have security set high to disallow cookies ?

Ask them to clear their browser cache and try again.

I got through ok so i think it's not your store.

Quote:

---

Originally Posted by stevesh

I just tried to install the latest (1.4.4) version in a new Zencart installation (twice) and got a 1064 error when I ran the install.sql. Anybody install this version without a problem?

As long as I'm here, what am I supposed to do with update_1_4_4.sql? I tried running it after running install.sql, but got another error (don't remember the number, but it had to do with an element already existing).

---

I installed it fine on a new store. You only run the install.sql if it's a brand new install and the update is intended for those updating from a previous version.

My issues are with my old store and i hope Numinix can offer advice on that as i wish to re-install the new module but my problems are documented above.

OK, thanks, but I just tried for the third time, in a brand-new installation of Zencart, no changes except the latest security patch, and when I pasted the install.sql into the box, I got (for the third time) this:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL, 'Checkout Without Account', 'FEC_NOACCOUNT_SWITCH', 'false', 'Activate Che' at line 1
in:
[(NULL, 'Checkout Without Account', 'FEC_NOACCOUNT_SWITCH', 'false', 'Activate Checkout Without an Account?', @configuration_group_id, 30, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Hide Email Options For No Account', 'FEC_NOACCOUNT_HIDEEMAIL', 'true', 'Hide "HTML/TEXT-Only" for checkout without account?', @configuration_group_id, 31, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Automatic LogOff for No Account', 'FEC_NOACCOUNT_LOGOFF', 'true', 'Automatically logoff customers without accounts?', @configuration_group_id, 32, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Telephone Number', 'ACCOUNT_TELEPHONE', 'true', 'Display telephone number field during account creation and with account information', '5', '8', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields

I can't see what I might be doing wrong, and I'm not mySQL-friendly enough to know exactly what this means.

Quote:

---

Originally Posted by need_help

I installed the new version of fast and easy checkout on a site today.

I then decided to upgrade my old site.

Rather foolishly i decided to uninstall using the uninstall.sql file thinking i could easily use the install.sql file to get the new version up and running without using the update sql files as i was unsure if i needed to run just the latest update sql file or the last two as the version i was running was at least three updates old.

Now i have all the files in the correct folders but i cannot get the install sql to work and fast and easy checkout has gone from the admin section and i get this.

1062 Duplicate entry 'Permanent Account Holders Only' for key 2
in:
[INSERT INTO zen_query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( '', 'email,newsletters', 'Permanent Account Holders Only', 'Send email only to permanent account holders ', 'select customers_email_address, customers_firstname, customers_lastname from TABLE_CUSTOMERS where COWOA_account != 1 order by customers_lastname, customers_firstname, customers_email_address');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I tried looking in MyPHPAdmin but i'm unsure what search terms to use to get rid of all the old data so i can run the install sql again.

Can you help please.

---

I fixed this by simply running my backup file. Then i upgraded to the latest SQL update and everything is now fine.

Good tip for everyone is always backup before making changes to your site. It can save your store much time and heartache.

Quote:

---

Originally Posted by smoke133

I was also wondering if there is a way to change this module so that it looks the set up that is on thelaughterstore website. It looks similar to this module with some nice addictions. It has it so that has a checkbox for returning customers and the default is set so that the customer does not create an account, but on the bottom they click a checkbox to create an account. When you check the boxes, it expanse to show the new fields.

Also, is there a way so that the checkbox for the shipping address that the default is that the shipping address is the same unless you click on the box to show the shipping fields if it different from the billing address?

---

Does anyone know how to do this to this module?

I too would love to see how I can get the the shipping address hidden and "same billing shipping" to be checked by default instead the other way around.

I know how to make it checked yet it does not seem to hide the shipping address field.


Also for a future version maybe add the hide/show to the coupon code field too.

Even better would be AJAX for the shipping method and coupon to update the total without refreshing the page.

In any case this is a great mod.

Quote:

---

Originally Posted by erezw

I too would love to see how I can get the the shipping address hidden and "same billing shipping" to be checked by default instead the other way around.

I know how to make it checked yet it does not seem to hide the shipping address field.


Also for a future version maybe add the hide/show to the coupon code field too.

Even better would be AJAX for the shipping method and coupon to update the total without refreshing the page.

In any case this is a great mod.

---

Version 2.0 will use Ajax instead of page reloads. The checkbox being checked is a feature already included in the 1.4.x series. The latest version is 1.4.5.

If you run the uninstall.sql in hopes of running the install.sql, do not include the table alterations at the top of the install.sql file as these are not removed with the uninstall.sql.