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

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.

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.

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.

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.

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.

numinix:

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.

Numinix,
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.

I checked out the demo for version is 1.4.5. The checkbox for the shipping address does not change anything when it is unchecked.

Is there a way to add a checkbox for the returning customers and a checkbox to create an account? The website that I seen this on is thelaughterstore.com.

Weird problem and some suggestions:

The problem: When FEC is on the site does not show warnings - if for example there was a problem prossesing a credit card it just go back to the payment page without saying anything. if you do the same with FEC turned off you see the warning that the card was declined. Any ideas?

Also I had a customer today that had a problem to complete the order (card kept being declined) although there was no problem charging her card with the same info on the authorized.net virtual terminal. It is actually not the first time it happen and no correlations between the cases either (different card types, browsers etc...). Does this sounds familiar to someone?

Now for the suggestions - the 1.4.5 version is really great and almost perfect as I said before (an was told the 2.0 version will have it) an AJAX to update the coupon and shipping info would make this one perfect. another this that would be great is if one could control the order of the fields from admin. For example if I want the shopping cart to be at the bottom near the payment info instead at the top. Another cool thing would be that if shipping billing is the same it will show only one field at step 2 with the check box "same shipping and billing just in case someone changed their mind. it will make the page a bit tidier.

All in all this is the best mod for zen cart.

Thanks

I'm having the same problems...

No warnings or explanations that a credit card transaction has failed -- it just jumps back to the payment page with the credit card details blank.

Using the same details on eWAY's virtual terminal, the transaction is approved.

Also, for some reason, all pages of the FEC checkout are titled as 'Redeem Gift Certificate'. Any idea how to change it?

I have a wierd problem on here.

If you go through a transaction, the postage rate comes out normal.
For example. 2nd class rate.

If you go through another transaction without logging off and logging on, the postage rate comes out something totally different, for example as an airmail rate!

Any suggestions?

Thanks

smoke133:

I checked out the demo for version is 1.4.5. The checkbox for the shipping address does not change anything when it is unchecked.

Is there a way to add a checkbox for the returning customers and a checkbox to create an account? The website that I seen this on is thelaughterstore.com. Javascript is required for the "effects". If you need customizations, please PM me.

mbridges:

I'm having the same problems...

No warnings or explanations that a credit card transaction has failed -- it just jumps back to the payment page with the credit card details blank.

Using the same details on eWAY's virtual terminal, the transaction is approved.

Also, for some reason, all pages of the FEC checkout are titled as 'Redeem Gift Certificate'. Any idea how to change it? When you had us install the module you were using a different template. Now that you've changed your template, you need to also move all of the modifications that were made during the install to the new template. Also, some files were found in the extra_definitions folder which are loaded site-wide. These files should be in the english folder and loaded only by the gv_redeem page.

has anyone successfully integrated fec with jrox? It doesn't seem to matter where I put the code at, my checkout breaks.
Thanks!
1.3.8a

Are you talking about Jrox affiliate program? Fec does not use the same files as Jrox. Integrate Jrox into the tpl_footer.php. Here is the link to the page to tell you how to Integrate Jrox into Zencart into Zencart. http://jam.jrox.com/docs/index.php?article=111

Jrox has a footer template override file: /includes/templates/custom/checkout_success/tpl_footer.php.

Thanks, I thought I tried that, but I will try again!