Fast and Easy Checkout

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

[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).

[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

[need_help]

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.

[need_help]

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.

[stevesh]

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.

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