Hello Numinix
Registered on your site for Support - confirmation email wasn't sent from your site to me so I cannot login to lodge a support ticket regarding FEC (see above posts).
I really need your help.
cheers, Mike
Printable View
Hello Numinix
Registered on your site for Support - confirmation email wasn't sent from your site to me so I cannot login to lodge a support ticket regarding FEC (see above posts).
I really need your help.
cheers, Mike
Please keep in mind that the store and the support center are two different systems and will require you to register twice. We hope to improve that in the future.Quote:
Originally Posted by shags38
Once you register for the support system, an email link to confirm your account will be sent. You can create a support account here:
https://www.numinix.com/support/account.php?do=create
Try disabling your SEO URLs mod and if that corrects the issue, then re-enable and try disabling it only for the checkout pages. How you achieve that will depend on the mod you are using.
If that's not the problem, have there been any customizations to your shipping modules? The checkout will redirect back on itself to select a shipping method automatically if one isn't already selected. If it's unable to make a selection, this could cause the infinite loop. Normally if there are no methods, it'll display an error message. But if there are methods and one of those methods isn't coded properly, it can lead to this bug.
Thanks for the response,Quote:
Originally Posted by numinix
1. installed FEC initially on another site as a test, a site using standard ZC template, everything works fine
2. that site above has Ultimate SEO Urls installed - no problems
3. neither site has any mods to shipping module, stock standard
4. above suggests bad install on site in question with problem (have reinstalled and checked it 5 times now) or possibly a loader conflict - Anne at Picaflor Azul who developed the template is suggesting file merge between CSS/JSLOADER and FEC ? - am awaiting details - what can you input re this?
5. I will install it on another Abbington Mega site and see if the problem reoccurs - if not then it would prove it was a bad install on current problem site that can only be fixed by uninstalling FEC which I will do as per your instructions.
6. I purposely have not uninstalled it until such time as I got some advice from you
7. if the problem does reoccur then I can try disabling Ultimate SEO from the files you mentioned albeit as it is not causing an issue on the test site in 1. above then it kind of eliminates this as a causal factor?
I would appreciate maybe some dialogue by you with Anne to see which files she merges to have FEC work correctly in her builds, something which may be useful to you for future situations or install instruction modifications?
cheers,
Mike
To Numinix and Larry,
problem indeed turned out to be the Ultimate SEO URLS mod - Thanks for your advice, much appreciated.
cheers, Mike
hello, i installed the freightquote.com shipping module and having a problem with the customers selected value does not change. when i disable fec it works as should.
this line of code is what is the problem is.
anyway of fixing this so i can use fec again?Code:$shipping_form .= '<select name="freightquote_delivery_location" onchange="window.location.href=\'' . zen_href_link(FILENAME_CHECKOUT_SHIPPING, 'freightquote_delivery_location=') . '\'+this.value">';
js loader is installed and cant change shipping option on a newly installed freight shipping module, other shipping module advanced shipper shipping options work.
if it works on another module i suspect it's that module.
What version of ZenCart are you using?
Also
the Freight module looks like it was only working with 1.3.7
http://www.zen-cart.com/downloads.php?do=file&id=1268
1.51 if i turn off fec it works fine. i read all 191 pages looking for a fix and there are other posts with same issue,cant select second shipping option, and there have been no responses to fixing it
Hi.
I have a problem with the login page in some browsers, for example Internet Explorer 8 on Windows XP. Only the half of the create account shows and the login is not visible at all.
It's works very well in other browsers.
See screenshot. Tips?
Attachment 14724
This is the section of code that is not working in my module
The part in red works if fec is turned off, how to make this work with fec if it is turned on?Code:$shipping_form = '';
if ($_POST['action'] != 'process') {
$shipping_form = '<table border="0" cellspacing="0" cellpadding="2">';
$shipping_form .= '<tr><td class="main" width="200">Please Choose Your Delivery Location:</td><td class="main">';
$shipping_form .= '<select name="freightquote_delivery_location" onchange="window.location.href=\'' . zen_href_link(FILENAME_CHECKOUT_SHIPPING, 'freightquote_delivery_location=') . '\'+this.value">';
$shipping_form .= '<option value="0"' . ($delivery_location == '0' ? ' SELECTED' : '') . '>Residential Delivery (Curbside drop off only)</option>';
$shipping_form .= '<option value="1"' . (!isset($delivery_location) || $delivery_location == '1' ? ' SELECTED' : '') . '>Business Delivery:(no loading dock) Home Businesses do not quality</option>';
$shipping_form .= '<option value="2"' . ($delivery_location == '2' ? ' SELECTED' : '') . '>Business Delivery:(with loading dock) Home Businesses do not quality</option>';
$shipping_form .= '<option value="3"' . ($delivery_location == '3' ? ' SELECTED' : '') . '>Jobsite Delivery</option>';
$shipping_form .= '</select></td></tr>';
$shipping_form .= '</table>';
} else {
$shipping_form = '<br>Delivery Location: ';
switch ($delivery_location) {
case '0':
$shipping_form .= 'Residence';
break;
case '2':
$shipping_form .= 'Commercial (with loading dock)';
break;
case '3':
$shipping_form .= 'Construction Site';
break;
case '1':
default:
$shipping_form .= 'Commercial (no loading dock)';
break;
}
}
I'm trying to get a stable test setup of ZC 1.5.3 before converting my live site.Quote:
Originally Posted by bislewl
I've committed to using Numinix Tableau as the theme and a small set of plugins to support it. So far I've installed Edit Orders (EO), Super Orders (SO), Add New Customer (ANC), Reset Client Password From Admin (RCP), OzPost MultiQuote (OZPost). These all worked fine until I installed Fast And Easy Checkout (FEC/FEAC).
My first attempt to install FEAC seemed successful - it appeared in the configuration menu - but I then encountered difficulties with OZPost and to diagnose the problems I disabled FEAC by running the uninstaller from the package (pasted into SQL patcher). Returning to the Configuration menu (which should have run the installer) showed the FEC entry was missing. I've since run the uninstaller a couple of times, merged the various files and code snippets a couple of times without success before embarking on the exploration described below. (Sorry about the long post - there's no happy ending yet, but some partial success which may help you).
I then examined the scripts and database structure for clues. Firstly, it seems there is a history of name changes in the configuration options which hasn't been carried through. Some options are prefixed FEC others FEAC. The uninstaller seems to fail for this reason.
Secondly, I could find no entry in the ADMIN_PAGES table. It isn't being inserted so it's not appearing in the Configuration Menu. It was created the first time I installed but not since, so I'm guessing there's some rogue process blocking it. Perhaps the Uninstaller isn't a complete cleaner.
This is the uninstall script from the FEC/FEAC v1.15.3 package:
I have only a rudimentary understanding of SQL but this is what I think it does:Code:SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration
WHERE configuration_key= 'FAST_AND_EASY_CHECKOUT_VERSION'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
#Zen Cart v1.5.0+ only Below! Skip if using an older version!
DELETE FROM admin_pages WHERE page_key = 'configFastandEasyCheckout' LIMIT 1;
- Three tables will be affected.
- The CONFIGURATION table is searched for a record where the configuration_key field contains 'FAST_AND_EASY_CHECKOUT_VERSION'.
- The corresponding configuration_group_id (i.e. the 'gID') is then retrieved and used to find and delete relevant records in the tables: CONFIGURATION, CONFIGURATION_GROUP and ADMIN_TABLE_PAGES.
When I look in my CONFIGURATION table there is no record with the configuration_key='FAST_AND_EASY_CHECKOUT_VERSION' - but there is a configuration_key='FEAC_VERSION'
Running the uninstaller with that change actually does work as expected (I checked result via phpMyAdmin) but now, when I try to access admin I get this message:
The error log shows this:Quote:
WARNING: An Error occurred, please refresh the page and try again.
Presumably the FEC installer is trying to run but then dies when it encounters the pre-existing field (how it is created before the FEAC script does I don't yet know).Quote:
PHP Warning: mysql_num_fields() expects parameter 1 to be resource, boolean given in /blah/admin/includes/functions/extra_functions/nmx_disk_cache.php on line 8
PHP Fatal error: 1060 Duplicate column name 'COWOA_account' :: ALTER TABLE customers ADD COWOA_account tinyint(1) NOT NULL default 0; ==> (as called by) /blah/admin/includes/installers/fec/1_12_0.php on line 29 <== in /blah/includes/classes/db/mysql/query_factory.php on line 155
If I run the uninstaller script, then delete the COWOA _account column (via phpMyAdmin), then try to access Admin I still get the error. There must be a mechanism that prevents auto-installer scripts from running every time you make a menu selection, but I don't know what it is where to find it nor how to disable / reset it.
Not sure where to go from here.
For some reason, I cannot get Store Pickup to stay selected on final order total before confirming the order. I have a fresh install, and I am not live yet because I am working through all my issues and custom configurations first. I am doing all test orders for different customer scenarios. However, I can not get Store Pickup to stay selected on the final checkout page before confirming. It shows up as a possible shipping selection on Checkout Step 2 of 3 page with the other selection Flat Rate. It always defaults to Flat Rate. It never defaults to Store Pickup. I can select Store Pickup as the chosen radio button, but then when I click Continue and go to Checkout 3 of 3 page, it switches to Flat Rate. I cannot get it to stay on Store Pickup! This is not good, because some customers will not want shipping at all and want to pick up their products at the store. At this rate, I am not able to know if they want Store Pickup, just looking at their checkout results. Am I doing something wrong in the setup of the products or shipping modules, or configuration settings? I have no idea where to start digging to look for the solution to this problem. I have Stirling Grand template and Fast and Easy Checkout installed. I am using the latest ZC version 1.5.3. In Modules > Order Total > Shipping, I have Shipping set to "Free shipping for orders over $100". But that does not seem to affect anything. I am testing with orders way under $100, and it still does not work properly. I can let you know any more configuration settings that you need to know, and also let you look at my store site. Please help!
I would like to go live with a more up to date version of Zencart but the reason it has sat around for so long is that I have a couple of Fast and Easy Checkout Issues on the checkout page.
1) The edit button appears in the wrong position on the page. Is it possible to move it to a better position within the box ?
2) How can I remove the Order Options Box. As it is empty and I dont know what it is used for.
Hi,
A happy new year to all users!
I have installed FEC 1.15.3 on Zencart 1.5.3 on Tableau Reponsive template.
Everything is working nicely except the Order total alignment on Checkout page 2.
Attachment 14822
I need to arrange this properly.
Please help!
HiQuote:
Originally Posted by kapil_sb
I have checked with previous version tpl_checkout_stacked.php, and code is ok.
But somehow, the Order Total is not displaying correctly because of CC (may be). I checked fec_global.css and this is not picking the css form there.
Can you please help me ?
Hello Lucidlee -
Took me ages to find it - but there is a new (posted 10th December 2014) uninstall.sql that explicitly looks for both keys:
======= This is not the actual script - it's just to illustrate===========
configuration_key= 'FAST_AND_EASY_CHECKOUT_VERSION'
and
configuration_key= 'FEAC_VERSION'
=======================================================
I ran the script - and on reloading FEC was back in admin :)
(Latest FEC + ZenCart 1.5.4)
To get the script, go here:
https://github.com/numinix/fec/blob/.../uninstall.sql
Cut & paste the script (all 18 lines) from the main box into, say, Notepad - then save as an .sql file - 'uninstall.sql'
Then you can paste the script into the SQL Query Executor at Admin - Tools - Install SQL Patches..
Then, if you haven't deleted any files, the FEC is restored and reappears in Admin - Configuration menu as soon as the page is refreshed twice (first time runs the uninstall, second time rebuilds it as the files are all still there)
Be good if Numinix included this version of uninstall.sql in their current release :O
Hope this helps,
Mr Sensible
Y'all,
Are there any plans to add a plain and simple "Purchase Order Number" field to FEC? (on the Confirmation page)
And yes it would need to propagate to the other appropriate forms.
With all the other GREAT features this module has I'm surprised a PO Number field wasn't there from day one.........
I have checked out three of the other PO Number mods and they all have some additional feature which make them undesirable.
Looked into moding a mod like "Ship Date" but they are too complex for what I need.
After reading many posts on PO Number it seems there is a need for it separate from any other hooks like payment etc. or at least an easy way to disable features.
Thanks, for Your time.
Me Again.....
I can't seem to find any documentation on the function of the Optional Check box in FEC.
Like where do I configure it.
The reason I ask is I may be able to modify the code and use it for a simplified PO Number entry box.
Thanks,
<!-- bog FEC v1.27 CHECKBOX -->
<fieldset class="fec-fieldset fec-block-checkout split" id="checkoutFECCheckbox">
<legend>Optional Checkbox</legend>
<span class="fec-fieldset-legend">Optional Checkbox</span>
<label>Signature Option?</label>
<input type="checkbox" name="fec_checkbox" value="1" id="fec_checkbox" /> </fieldset>
<!-- eof FEC v1.27 CHECKBOX -->
FEC is written, maintained, and supported by www.numinix.com
They can answer your questions most effectively.
getting back to FEC. How do you get the information supplied in the dropdown heading?
The PO discussion has been migrated to https://www.zen-cart.com/showthread....-Orders-in-FECQuote:
Originally Posted by linuxguy2
How easy is it to upgrade from 1.11.0 to the latest version ..
I tried it on a new test site and it is hands down better than the last... Although doesn't seem to work on a responsive template ...made the template fill the page
I have uninstalled FEC (addd484) due to issues - I followed the uninstall procedure and uploaded the uninstall.sql however I am still having issues so I really would appreciate some help please;
1. the login page doesn't load according to the determining files includes/english/login.php and includes/templates/template_default/templates/tpl_template_login_default.php which are exactly identical on both sites
2. FEC still shows up in admin/configuration which it shouldn't, right?
I got this error message after doing uninstall.sql -
1146 Table 'harmony2_database_admin_pages' doesn't exist
in:
[DELETE FROM database_admin_pages WHERE page_key = 'configFastandEasyCheckout' LIMIT 1;]
following are 'source' data for the page from the site (www.harmonyball.net.au) that I have uninstalled FEC from and the second being another site (a clone of the first www.harmonyballpendant.com) which I did not install FEC and which is the example as it should be;
harmonyball.net.au source;
<div class="centerColumn" id="loginDefault">
<h1 id="loginDefaultHeading">HEADING_TITLE</h1>
<!--BOF normal login-->
<div class="advisory">TEXT_VISITORS_CART</div>
<form name="login" action="https://www.harmonyball.net.au/login.html?action=process" method="post" id="loginForm"><fieldset>
<legend>HEADING_RETURNING_CUSTOMER</legend>
<label class="inputLabel" for="login-email-address">Email Address:</label>
<input type="text" name="email_address" size = "41" maxlength= "96" id="login-email-address" /><br class="clearBoth" />
<label class="inputLabel" for="login-password">Password:</label>
<input type="password" name="password" size = "41" maxlength = "40" id="login-password" /><br class="clearBoth" />
<input type="hidden" name="securityToken" value="cd8baf19b7e7feccc8f0f58768bffcc7" /></fieldset>
<div class="buttonRow forward"><input type="image" src="includes/templates/responsive_all_business/buttons/english/button_login.gif" alt="Sign In" title=" Sign In " /></div>
<div class="buttonRow back important"><a href="https://www.harmonyball.net.au/password_forgotten.html">TEXT_PASSWORD_FORGOTTEN</a></div>
</form>
<br class="clearBoth" />
<form name="create_account" action="https://www.harmonyball.net.au/create_account.html" method="post" onsubmit="return check_form(create_account);" id="createAccountForm"><input type="hidden" name="action" value="process" /><input type="hidden" name="email_pref_html" value="email_format" /><fieldset>
<legend>HEADING_NEW_CUSTOMER</legend>
<div class="information">TEXT_NEW_CUSTOMER_INTRODUCTION</div>
<div class="alert forward">* Required information</div>
<br class="clearBoth" />
Harmonyballpendant.com source (correct result on page)
<div class="centerColumn" id="loginDefault">
<h1 id="loginDefaultHeading">Welcome to Login page / Express Checkout page</h1>
<!--BOF PPEC split login- DO NOT REMOVE-->
<fieldset class="floatingBox back">
<legend><a style="color:#0080FF">New Customers</legend>
<div class="information"><center><h2><a href="https://harmonyballpendant.com/ipn_main_handler.php?type=ec" style="color:blue"><u>EXPRESS CHECKOUT</u></a></h2><font size="2">use <b><u>PayPal</u></b> OR <b>pay with a <u>Credit Card</u></b> <p>Click the PayPal button below to use <u><b><a href="https://harmonyballpendant.com/ipn_main_handler.php?type=ec">Express Checkout</a></u></b></p><u><i>you DO NOT NEED to have a PayPal account to use your Credit Card with this EXPRESS CHECKOUT</u></i></p></div>
<div class="center"><div id="PPECbutton" class="buttonRow">
<a href="http://www.harmonyballpendant.com/ipn_main_handler.php?type=ec"><img src="https://www.paypalobjects.com/en_US/i/btn/btn_xpressCheckout.gif" alt="Click here to pay via PayPal Express Checkout" /></a>
</div>
</div>
<hr />
<span class="larger">Or</span><br /><div class="information">Create a Customer Profile with <strong>HarmonyBallPendant.com</strong> which allows you to shop faster, track the status of your current orders, review your previous orders and take advantage of our other member's benefits.</div>
<form name="create" action="http://www.harmonyballpendant.com/create_account.html" method="post"><div class="buttonRow forward"><input type="image" src="includes/templates/responsive_all_business/buttons/english/button_create_account.gif" alt="Sign Up" title=" Sign Up " name="registrationButton" /></div>
</form>
</fieldset>
<fieldset class="floatingBox forward">
<legend><a style="color:#0080FF">Returning Customers</a style></legend>
<div class="information">In order to continue, please login to your <strong>HarmonyBallPendant.com</strong> account.</div>
<form name="login" action="http://www.harmonyballpendant.com/login.html?action=process" method="post" id="loginForm"><label class="inputLabel" for="login-email-address">Email Address:</label>
<input type="text" name="email_address" size="18" id="login-email-address" /><br class="clearBoth" />
<label class="inputLabel" for="login-password">Password:</label>
<input type="password" name="password" size="18" id="login-password" /><input type="hidden" name="securityToken" value="a5e849228cc3e130bca27b7079b00a66" /><br class="clearBoth" />
<div class="buttonRow forward"><input type="image" src="includes/templates/responsive_all_business/buttons/english/button_login.gif" alt="Sign In" title=" Sign In " /></div>
<div class="buttonRow back important"><a href="http://www.harmonyballpendant.com/password_forgotten.html">Forgot your password?</a></div>
</form>
</fieldset>
<br class="clearBoth" />
<!--EOF PPEC split login- DO NOT REMOVE-->
looks like you may have done something wrong somewhere ...
I'm still waiting for a response about how to upgrade as I cannot find any info on it at all
You should find more info at www.numinix.comQuote:
Originally Posted by Andy-C27
OR
Go to the unzipped directory docs/fec/readme.html and way at the end is this entry.
UNINSTALL
1.Remove edits performed in the installation procedure above.
2.Delete all uploaded files from your store.
3.Patch your database by copying and pasting the contents of uninstall.sql into ADMIN->TOOLS->INSTALL SQL PATCHES
So in other words you can't just update files you have to un-install first as have read the readme.html from top to bottom
To uninstall, you will need to follow the instructions in the documentation. First you need to delete the files, especially those in the admin, or the plugin will just reinstall itself.Quote:
Originally Posted by shags38
FEC does modify some core pages, such as login. After uninstalling, you may need to restore your original login page files in includes/modules/pages/login and includes/templates/YOUR_TEMPLATE/templates/tpl_login_default.php.
Very old versions like 1.11.0 and prior need to run the uninstall.sql. Then just upload the package and it should self install. Refer to the change logs for files you will need to remove between the old version and the current version. Our GIT repository for FEC is public if you are familiar with using GIT to output a change log.Quote:
Originally Posted by Andy-C27
Not really familiar to GIT ,have also read the above post ... Maybe will pay for someone to do it ....As trying to go responsive and things aren't working in that department either
thanks
Thanks for that - I had uninstalled exactly in line with your documentation - this information is additional to your documentation.Quote:
Originally Posted by numinix
I replaced includes/modules/pages/login files with originals and page now loads correctly - why is this advice not part of the uninstall procedure in your documentation? it would save a lot of heartache. Maybe just instead of 'Delete all uploaded files from your store' include 'and replace with original files' - pretty simple really. (the file includes/templates/YOUR_TEMPLATE/templates/tpl_login_default.php does not exist in non FEC site so does not need to be replaced).
I am happy with the end result - I am disappointed though that I had to shake your tree to get this sorted out.
The whole thing was brought about by the inability of this plugin to work with Ultimate SEO URLs which I and many thousands of ZenCart users have installed - works with CEON, why not Ultimate?
cheer, Mike
FEC is still showing in admin/configuration - how do I get rid of it?Quote:
Originally Posted by shags38
I am now getting gogglydook in order confirmation emails, my customers must think I am so unprofessional - please advise which file did FEC modify that would have caused this so that I can replace it with the original,
thanks.
[NEW ORDER] EMAIL_TEXT_SUBJECTEMAIL_ORDER_NUMBER_SUBJECT570
[NEW ORDER] EMAIL_TEXT_SUBJECTEMAIL_ORDER_NUMBER_SUBJECT570
HarmonyBall.net.au
11:17 AM
[Keep this message at the top of your inbox]
To: dazzlers2009##########################
[email protected]
TransID: xxxxxxxxxxxxxxxx
EMAIL_TEXT_HEADEREMAIL_TEXT_FROMHarmonyBall.net.au
customer name
EMAIL_THANKS_FOR_SHOPPING
EMAIL_DETAILS_FOLLOW
EMAIL_SEPARATOR
EMAIL_TEXT_ORDER_NUMBER 570
EMAIL_TEXT_DATE_ORDERED Friday 20 February, 2015
EMAIL_TEXT_INVOICE_URL
https://www.harmonyball.net.au/accou...l?order_id=570
EMAIL_TEXT_PRODUCTS
EMAIL_SEPARATOR
1 x Harmony Ball 925 Sterling Silver with Balinese Flower Designs (HBP460)
= $49.95
EMAIL_SEPARATOR
Sub-Total: $49.95
Zone Rates (Shipping to AU (0.05lb(s))): $8.30
Total: $58.25
EMAIL_TEXT_DELIVERY_ADDRESS
EMAIL_SEPARATOR
Looks like at least /includes/languages/english/checkout_process.php is missing.
RULE OF THUMB: Whenever a plugin author like Numinix says "just delete the files" for uninstall instructions, DON'T BELIEVE THEM!!!!! (ref: http://www.zen-cart.com/showthread.p...65#post1273965 ). Always first make sure their files didn't replace files you originally had in that folder by the same name, and be sure to then put back the originals that you had replaced.
I wish plugin authors would put their additions in non-core files more reliably; that's what the extra_definitions folder is for.
Hello Doc - many thanks for responding - you were spot on !! replacing that file worked a treat.I will take your advice on boardQuote:
Originally Posted by DrByte
As much as I am appreciative that many authors do the best they can I too am dismayed at what some authors DO NOT PROVIDE, especially those that have a commercial interest in potential sales of their premium pay for it versions of the freebie - these have a ready made audience of thousands of eCommerce clients. Anyway I will get off my soap box (soon).
The greater majority of my posts in here are because of lack of easy to follow detailed information in the docs of a plugin. The nutty professor factor comes into play all too often - the contributor assumes that the user is at their level, understands what he or she is 'trying to say' or just cannot put the instructions in words effectively such that others can follow them.
This particular plugin has caused me untold heartache because it has a conflict with Ultimate SEO URL's, something they well know but do not bother to put in their docs.
Is there an avenue at some point down the track to set up a 'template' so to speak that contributors must complete with all the necessary information that a non coder user would need including core files modified explicit install and uninstall instructions that actually work, as part of the approval process? I must admit I love Anne's docs (Picaflur Azul), extremely informative and with all the information needed - of course not everyone can provide docs to that extent however the minimum required 'content' should be achievable by all, fill in he spaces in the template.
Anyway - thanks again.
cheers,
Mike
If the module is not working with USU, you shouldshould ask about that in the USU thread. My experience though with fec and USU is that they work perfectly fine together. Maybe explaining a bit what is not working might help.Quote:
Originally Posted by shags38
ihungil (author) has recently( last week) released an upgraded version of USU incorporating code which will allow it and FEC to get along fine, for v1.5.1 onwards - prior to this for a long time the two were not compatible.
I mention it in here because it is not mentioned at all in the docs for FEC so users of FEC who use USU (thousands) find out the hard way - so it is an FEC (Numinix) issue and belongs in this thread.
ihungil's new version is not backwards compatible - I am using v1.3.9h on most of my sites so FEC will not work on them (pity, it is a nice plugin) - modification(s) to their code would allow it to work.
My big beef , aside from not letting potential users know that it wouldn't work with one of the most popular url plugins, is the lack of correct detail in the uninstall instructions which has caused me a lot of grief and that Numinix rarely visit the support forum - so I hope that appraises you :smile:
cheers,
Mike
p.s. why am I still using 1.3.9h which is technically no longer supported? - by choice, at present.
Upgrading is really not that difficult. I got into zencart at 138, had a completed fluid-designed store by 139h, only to find there were several key things missing or incomplete, mostly concerning security. Since 139h I have virtually used the same template and language files with only slight modifications (eg addition of responsive code and more fluid design). Very few of the upgraded files impact heavily upon the template and language files. Now I am almost up to date with 154, bar a few mods, having started the upgrade from 151 only a few weeks ago.Quote:
Originally Posted by shags38
My 2c re FEC, USU and similar mods is do not even bother. Your stores already rank highly (more than most) on google, not through these mods but through your articles and associated websites.
Now is the time to upgrade.
and as authors of these mods will tell you themselves, there are other BUSINESS reasons to use a re-write module that have ABSOLUTELY NOTHING to do with search engine ranking..Quote:
Originally Posted by dw08gm
Funny thing is these kinds of "don't use pretty URLs" discussions NEVER happen on WordPress, Joomla, Drupal, OpenCart, or PrestaCart forums where re-writing is BUILT IN to the core code.. yet here in the land of Zen Cart folks cling TIGHTLY to the belief that everyone should RUN RUN RUN form these modules.. Cracks me up.. The sentiment is as outdated as some of the code in the Zen Cart admin.. IJS..
If individual pages are well written/structured and supported by good navigation, it should not really matter what the URL reads. On some sites, such as this forum, I often take advantage of the numerical system for skipping pages/rapid return to pages, and further exploration. Often much easier to type in a relatively short number than a lengthy description (especially since some sites require the complete lengthy description in order to even find the valid page, if the number is missing).
Right.. and good for you.. that works for YOU.. a shopowner should be able to CHOOSE if they want to re-written URLs for their store, for whatever their business reasons are.. Again.. cracks me up that this is the ONLY open source community that STILL has folks debating the re-written URLs "issue" and folks working HARD trying to convince folks that "their side" is right for some of the WEAKEST reasons/arguments I've ever seen.. Silly really.. Not gonna see ANYONE in the Joomla, WordPress, Drupal, OpenCart, PrestaCart, or Magento communities engaging in these kinds of discussions AT ALL.. Because re-written URLs are part of the core of all of these mods, and siteowners can CHOOSE and nobody debates the choice or the option to CHOOSE..Quote:
Originally Posted by dw08gm
Bottomline is that despite assertions to the CONTRARY, USU works just fine with this module IF you follow the instructions.. It even works with UNSUPPORTED versions of Zen Cart (v1.3.9) with FEC installed.. again, if you follow the posted instructions..In the event that one isn't successful withan installation, posting the EXACT issues they are having instead of vague "it doesn't work" messages will go a long way to getting those issues resolved..
Two things Diva,Quote:
Originally Posted by DivaVocals
1. I agree totally with your viewpoint regarding re-written url's. What everyone ignores is that using it for may, me included, has absolutely nothing to do with ranking (or not) - those that argue that standard url's will rank a site just as well as re-written ones are absolutely correct, absolutely - the benefit, the enormous benefit is the benefit to SEARCHERS and hence the site owner. Seeing in bold font the targeted keywords in the url address just below the Title that hopefully is indicating what the searcher is looking for only goes to reinforce in the searchers mind that this site likely has what they are looking for (more so than a bunch of gogglydook) - it is like flashing neon signs. There are a bunch of examples where mysite/KEYWORD CATEGORY/KEYWORD SUB-CATEGORY/PRODUCT WITH KEYWORD(S) stands out on a search page. It is about the USER EXPERIENCE, not coding ... we need to listen more closely to Google says if we want our customers to have an optimal experience using Google to find our products.
2. I am yet to get FEC working successfully on v1.3.9h even with the latest version of USU - maybe now that I have finally got FEC uninstalled maybe it is time to give it another go and if it works then fine, if it doesn't at least I know how to get rid of it (although it is still showing up in admin/configuration so it obviously has some code still lurking - waiting for Numinix to get back with some support on this)
cheers, Mike
v1.5.1
on the login page, Checkout step 1 of 2 when set to 'vertical' (not split-login) how can I move the containers 'Guest Checkout' and 'PayPal Express Checkout' to the top of the page to be above 'Create Account' container?
is it done in fec_global.css ? what code needs to be moved?
cheers, Mike
Running 1.5.3
I have finally got fast easy checkout working ,well about 95% ... On Checkout - step 2 / 3 the edit button on Shopping Cart Contents is sitting right over Cart Contents
and hiding the words ,is there a way to move this. If you want to take a look pewterworld .co .uk you will need a account [email protected] pas is 1111111111 (10 number ones)
The 2nd issue is rather worse.We had it working once then had issues and went back to backup database since then the admin side has not updated I tried un-installing it and found out it would not install again ... I replaced the database from a backup again the updates ran fine as I saw it happen but it did not update to the new style .. Is this OK to leave as it is or is it better to update it
Hi All
having trouble with the styling on this module.
All the admin stuff seems to have installed correctly.
I have checked the pages that are being loaded when going through checkout and the FEC pages are being loaded.
However none of the default styling is being loaded, its just the bog standard log in styles that are being loaded.
Also when i change the page to plit login nothing seems to happen?
Just one long page of login details to fill in.
I am unable to give a link as this is being developed on localhost.
Any help appreciated.
Realised after a bit more investigation that the only CSS file being loaded relating to this was the login.css which was empty. Therefore i copied the fec global to this file and all now appears as it should.Quote:
Originally Posted by Matthew Kin
Since we can not see the site this is a wild guess, but did you also install the css/java loader, as told in the installation instructions???Quote:
Originally Posted by Matthew Kin
Hi yes followed the instructions exactly.Quote:
Originally Posted by Design75
Already had the css/js loader installed
I have used soms search words but could not find the answer to my question. Sorry if it has been asked before.
I have installes Fast and easy checkout with CSS/JS Loader. Finaly it is working.
I like that now customers don't get page after page after page anymore.
Second thing i want to change is the "create account/login/geust" thing. The only option I would like to have is, quest.
Is it posible to skip this page and go from shoppingcart to checkout step 1, where the geust fills in there name and adress?
I have managed to get this to work with v1.5.4
You must make sure you have loaded and running 'css_js_loader' before you even think about uploading 'Fast and Easy Checkout'. Without the loader, as I can testify, Fast and Easy Checkout will not work on any version of zencart.
You can get css_js_loader, as a plugin or direct from numinix. The only file I have found that needs to be merged is '/includes/templates/YOUR-TEMPLATE/common/html_header.php'.
Now this is the very important bit; make sure that the merger package is very good. I have used countless packages and none of them worked for the merger of this file. I found that when I did a merger and then uploaded 'html_header.php' I got a blank screen. Then I used CompareIt.
You must do a manual merge of the files. Merge YOUR file to 'html_header.php' in 'css_js_loader' and not the other way around.
This is the way I did it and it works. You do not need to un-install 'Fast and Easy Checkout'.
If you wish to look at my 'Fast and Easy Checkout' install go here.
I am using v1.5.4 with template carlisle fresh (with modified stylesheet.css)
I hope this helps.
Hello,
I need a bit of help. My order total is not showing up completely. What i mean by that is that the last number is partially cut off.
My site is missingcord.com. I had another crash and i am trying to get everything back up. I had fast and easy checkout working before so i don't know whats wrong. This is a fresh install of zencart and FEC.
My zen cart version is 1.5.3 and i am using Fec 1.15.3.
I have added a photo of the problem.Attachment 15113
I'm using FEC and today i got a warning message. In my log it says:
SET dropdown = '',
gift_message = ''
WHERE orders_id = 5
LIMIT 1 ==> (as called by) C:\xampp\htdocs\zencart\includes\classes\observers\class.drop_down.php on line 62 <== in C:\xampp\htdocs\zencart\includes\classes\db\mysql\query_factory.php on line 155
Now I see that it has something to do with the gift message, but other then that I can't read what it means (i'm from holland so al this engelish stuff is very difficult)
Does somebody knows what this means and would try to explane it to me and where to fix this?
I am using zencart v1.5.4 & FEC v1.15.3.
Two questions;
1. I did have Guest checkout displayed now it has gone - I have ticked all the boxes and still nothing
2. With creat an account I would like to move Country below zip code - Which php file do I need to modify
Thanks in advance
You need to try and widen the /includes/your template/css rows to make it work as I had to do the same thing .. I did it a while ago so can't quite remember .. I found it by downloading fec looking in the install css files and used that as a reference ...Quote:
Originally Posted by jasonshanks
I think you can also use admin / config / Layout Settings to widen the rows as well
I think I have found the reason why my guest checkout has gone, my site says 'login to shop'. What have I turned on/off so that the site says this? Click here to see what I am trying to say.Quote:
Originally Posted by adb34
Hi,
Have installed FEC on a test site with 1.5.4 which.
Followed the process ( a few time) but I continually get a blank front store page.
Back end Admin is fine, just store front is a completely blank page.
Have these mods already installed,
CEON URI Mapping
OZPOST Shipping Module
Direct Bank Deposit
I did note one point in the instructions;
I also found this folderQuote:
Before uploading, rename these folders to your specific folder names:
/YOUR_ADMIN -> Rename to your admin folder name
/includes/templates/YOUR_TEMPLATE -> Rename to your template folder name
/includes/languages/english/YOUR_TEMPLATE -> Rename to your template folder name
/includes/languages/english/extra_definitions/YOUR_TEMPLATE ->
Assume that too should have been amended, though it made no difference, I still get a blank page
Any clues as to what the issue might be ??
Thanks,
Mike
I did have a few problems with this plugin myself. After a lot of digging I found that is was the template and not the plugin that was at fault. Well I say fault it wasn't it was the way the template was configured and I had to put the files in different locations than the upload package.Quote:
Originally Posted by Mike_Dean
I have a couple of questions?
1. which template are you using
2. did you just do an upload of your files in to include or
3. did you do a merge of files
4. if you did a merge files, which software did you use
Quote:
Originally Posted by adb34
1. I'm using the Westminster New Template
2. Just performed an upload
At the end of the day, I'm going to side step this mod.. It really only takes one of the 4 pages out of the equation, sure that's 25%. But I'm really looking for a one pager for pure simplification.
Cheers,
Mike
OK no problem. When you come back to it, check which files of the plugin overwrite and do a merge insteadQuote:
Originally Posted by Mike_Dean
Is this version of FEC compatible with responsive templates please
Short answer - If you are using the latest version, yes.Quote:
Originally Posted by Andy-C27
Long answer - When installing the FEC make sure that you merger and not just replace the files. It all depends on which responsive template you are using. I am using carlisle refresh and some of the files are not in the location the upload wants to put the replacement file. The way I did the installation of FEC was to do a website backup & then search the backup for the file to be changed. Then a MUST do a merger of the two files (probably telling you something you already know) merge the FEC file into your website file.
More help? just ask :smile:
thanks ... I was just wondering as you can buy the responsive fec ,but I suppose that means it's more responsive than the the free 1
ZC 1.5.3 / FEC 1.15.3
If a postal code is incorrect, FedEx gives the error message:
But does not force warehouse pickup to be selected as the shipping option. If the customer does not select warehouse pickup, FEC is allowing the customer to checkout without any shipping option chosen.Code:Error in processing transaction.
WARNING: There are no valid services available
I need to specify that warehouse pickup is chosen if no other method is available, as well as require that a shipping method is chosen before allowing the customer to go to the confirmation page.
Can anyone assist me with this?
FEC is what it indicates quick checkout, eliminates about 2 pages has nothing to do with the Shipping Mod. What you set up in the Shipping mod is what FEC or FEAC (my preference) will display as options for the customer.
You can offer UPS,USPS, FedEx, Flat Rate, ZipCode Zone, Will Call being controlled by zipcodes. I use for example all with Flat Rate set at $6.95 but if one of the other shippers price is actually less, then no matter who the shipper is the shipping cost that is displayed will show no lower than the Flat Rate price.... none of which has to do with FEC.
Quote:
Originally Posted by abcisme
Let me simplify my issue. If there's no shipping method selected, FEC still allows the customer to go to the order confirmation page without selecting a shipping method. This should not be the case. If there is no shipping method selected, it should give an error saying that they need to select a shipping method. I need to know how to make sure that customers cannot proceed to the confirmation page without first selecting a shipping method.Quote:
Originally Posted by EZorb
It's been a few years since I have used FEC. I use FEAC and this is not a issue. I may be wrong but I believe if you turn off FEC you will find same thing happens. The shopping cart will default on least expensive method of shipping but if you don't have any shipping method install or turn on I don't know what it would do. Go to Numinix web site and ask that question since they wrote the mod. There may be a newer ver. there.
After digging, I found an answer.
https://www.zen-cart.com/showthread....11#post1036811
Quote:
I'm confused because when I look at the cheapest_method function, it explicitly checks for storepickup and will not use that as the cheapest rate. However, I think this is a bug because if storepickup is the ONLY rate, it still will not get selected as the cheapest. This causes issues with mods like FEC.
Here is my fix.
Change line 172 to:
and line 176 to:PHP Code:if (($rates[$i]['cost'] < $cheapest['cost'] and $rates[$i]['module'] != 'storepickup') || $size == 1) {
PHP Code:if ($rates[$i]['module'] != 'storepickup' || $size == 1) {
Hi
I would like to install thus but there is no install.sql in the zip file. There are loads of previous sql updates but I don't know which one to use.
I am using v1.5.1 - any help would be appreciated.
Thanks
Alan
Will this plugin work without the css/js loader? When I install css/js loader it messes up the css on my site.
You can find the SQL in the your_admin/includes/installers/fec folder. It automatically loads. You don't have to manually run it. Just install the module and it will run the SQL if needed.Quote:
Originally Posted by DigiBooks
I have installed FEC and lets say that I will only use the checkout as a guest, than you have the login and create account buttons everywhere, for instance on the far top, next to the items and the shoppingcart, or under the customers service button, and so on.
Is it oke to remove of all these, or am I missing something and do still need them?
Upload the files.Quote:
Originally Posted by DigiBooks
once uploaded load your admin the module will install it self. No need for an install.sql
I suspect if your site has issues with CSS/JS loader than it isn't configured/installed correctly, including building the auto_loadersQuote:
Originally Posted by llmcdonald
However you could...use the auto loaders in the includes/templates/YOUR_TEMPLATE/auto_loaders/ to piece together, the files needed for each page.
And then add them into the html_header.php or my personal preference tpl_footer.php both located in the includes/templates/YOUR_TEMPLATE/common/
HOWEVER. one benefit of CSS/JS loader is avoiding loading CSS/JS files twice. So make sure you are only running 1 version of jQuery, and 1 migrate file if needed.
For PCI compliance you should be running the most recent version of jquery which is 1.11.2 as of this post. My personal choice is to load from a CDN. But you could load from your site as well, try to load a minified copy example below. The migrate only need to be run if there is older code that doesn't work ideally if you could load without it that would be preferred.
HTML Code:<script src="//code.jquery.com/jquery-1.11.2.min.js"></script>
<script src="//code.jquery.com/jquery-migrate-1.2.1.min.js"></script>
to get the SQL files out of there is quite difficult as it uses the $db->Execute, and you would have to change all the constants. Like the TABLE_CONFIGURATION would need to change to configuration, and the quotes would need to be removed as well as the $configuration_group would need to be found and then replaced in a similar matter.
Additionally there are several uses of the $sniffer class to determine if a column already exists. So to pull out the SQL is quite a difficult task.
Also it does not install until the admin page loads, and if already logged into the admin it will show a message in the message stack that it has install the version it has installed, and if it has added the configuration menu. Also it will check to see if there is a more recent version of the module on zen-cart.com
You can modify FEC to make it responsive, I have done it.Quote:
Originally Posted by Andy-C27
You will need to re-arrange several of the columns and do some styling changes. It doesn't work the same as the other mentioned.
As it wasn't designed for responsive but with some modifications you can make it "work"
You should be able to select force guest checkout in Configuration - > Fast and easy checkout. Also you will want to set it for customers to automatically be logged off upon checkout.Quote:
Originally Posted by Pompidompie
Does this problem exist when FEC is turned off?Quote:
Originally Posted by abcisme
Fast and easy checkout hangs on the following screen:
Home :: Checkout :: Confirmation
Your order is being processed, please wait...
I am using zen-cart 1.5.4 and using the responsive sheffield blue template.
here is a link to my website LHAL Sportscards & Collectibles
Any help would be appreciated.
Just based on the fact you are using 1.5.4, I suspect the issue is that in 1.5.4 there is ajax processing which hasn't been worked into FEC. And the jquery/javascript just by itself will conflict. as of 1.16.8, it isn't ready for 1.5.4 as the checkout payment has changed slightly.Quote:
Originally Posted by llmcdonald
I know it's "in the works" but it hasn't yet been completed.
So I would need to go back to using zc 1.5.3 for Fast and Easy checkout to work.
Does anyone have Fast and Easy Checkout working with Zc 1.5.4? If so, could you let me know what needs to be done to get it to work.
It sounds like FEC for 1.5.4 should be coming shortly/very soon.Quote:
Originally Posted by llmcdonald
Any idea of an ETA on this for 1.5.4? Just curious as some of us would love to be able to use this mod.
Also any tips to get this to work in a responsive template would be great.
Thanks.
And all the above on this page - I have it working on v1.5.4. What problems are you having? Here is my pageQuote:
Originally Posted by ravynw34
It could be a payment module issue, with the ZenCart 1.5.4 Ajax?Quote:
Originally Posted by adb34
My checkout hangs on the following screen:Quote:
Originally Posted by adb34
Home :: Checkout :: Confirmation
Your order is being processed, please wait...
Is there anything that you had to do differently to get it to work?
Here is a link to my site LHAL Sportscards & Collectibles
Not a payment issue at all. Its the way it looks in mobile that is the issue.
Mobile side of fec is squished In portrait mode and useable in landscapeonly.
Any ideas. Thanks for the help.
Here is a screenshot of how it looks
Attachment 15240
Thank you. I know where to find all that, but my question is, if I use only guest checkout, can I than remove the login button on the top of my website (which turns into logoff and my account when logged in) and the same thing under customer service. I would say, these buttons are not needed when only offering checkout as a guest, but i'm a little scared that I think to simple and still need them. Am I right that I can remove them when only using checkout as a guest?Quote:
Originally Posted by bislewl
I have a little (big) problem. For some reason when I add something to the shoppingcart, the checkout button loops.
When shopping I click "add to cart" it nicely goes to the shoppingcart. Clicking "checkout" also gives me the upportunity to login, after that it returns to the shoppingcart again, but clicking on the checkout button, keeps refreshing the page. It doesn't go forward.
In chrome elements I get this error:
I don't know what that means :blush:PHP Code:Uncaught Reference
Error: $ is not definedzcJS.ajax @ index.php?main_page=shopping_cart:38(anonymous function) @ index.php?main_page=shopping_cart:147
jquery-1.11.1.min.js:4 Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience. For more help, check http://xhr.spec.whatwg.org/.
Is it at all possible to use the split page on page 2/3 of the checkout as atm it can't be done on my responsive website so everything is in 1 long line ..still using 1.5.3 with latest fec
if customer chooses another shipping option, other than defaulted selection, and than chooses confirm the order, before waiting for the new totals to refresh it will send the defaulted selection to the payment option.
How to fix this?
jimmie
Edited for errors
I got some error with paypal and the "one page checkout" set to true. Maybe it's related to this.Quote:
Originally Posted by jimmie
I've this HUGE debug error:
It should be related to this:HTML Code:[26-May-2015 09:59:00] #1 trigger_error(1054:Unknown column 'COWOA_order' in 'field list' :: INSERT INTO orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_vat, billing_cf, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address, COWOA_order) VALUES ('1692', 'Sergio RICCIO', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '3286486400', '[email protected]', '5', 'Sergio RICCIO', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '5', 'Sergio RICCIO', '', '', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '5', 'Contrassegno', 'cod', 'Corriere espresso (2.86kg.) (Consegna 24/48 ore, sabato e festivi esclusi.)', 'tnt', '', '', '', '', '', now(), '1', '51.5', '0', 'EUR', '1.00000000', '79.56.112.118 - 79.56.112.118', '1') ==> (as called by) /var/www/vhosts/laviadellincenso.it/httpdocs/includes/functions/functions_general.php on line 965 <==, 256) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/classes/db/mysql/query_factory.php:155]
#2 queryFactory->show_error() called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/classes/db/mysql/query_factory.php:132]
#3 queryFactory->set_error(1054, Unknown column 'COWOA_order' in 'field list', 1) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/classes/db/mysql/query_factory.php:262]
#4 queryFactory->Execute(INSERT INTO orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_vat, billing_cf, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address, COWOA_order) VALUES ('1692', 'Sergio RICCIO', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '3286486400', '[email protected]', '5', 'Sergio RICCIO', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '5', 'Sergio RICCIO', '', '', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '5', 'Contrassegno', 'cod', 'Corriere espresso (2.86kg.) (Consegna 24/48 ore, sabato e festivi esclusi.)', 'tnt', '', '', '', '', '', now(), '1', '51.5', '0', 'EUR', '1.00000000', '79.56.112.118 - 79.56.112.118', '1')) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/functions/functions_general.php:965]
#5 zen_db_perform(orders, Array ([customers_id] => 1692,[customers_name] => Sergio RICCIO,[customers_company] => ,[customers_street_address] => Trav. Fiume Savuto, 9,[customers_suburb] => ,[customers_city] => CATANZARO,[customers_postcode] => 88100,[customers_state] => Catanzaro,[customers_country] => Italy,[customers_telephone] => 3286486400,[customers_email_address] => [email protected],[customers_address_format_id] => 5,[delivery_name] => Sergio RICCIO,[delivery_company] => ,[delivery_street_address] => Trav. Fiume Savuto, 9,[delivery_suburb] => ,[delivery_city] => CATANZARO,[delivery_postcode] => 88100,[delivery_state] => Catanzaro,[delivery_country] => Italy,[delivery_address_format_id] => 5,[billing_name] => Sergio RICCIO,[billing_company] => ,[billing_vat] => ,[billing_cf] => ,[billing_street_address] => Trav. Fiume Savuto, 9,[billing_suburb] => ,[billing_city] => CATANZARO,[billing_postcode] => 88100,[billing_state] => Catanzaro,[billing_country] => Italy,[billing_address_format_id] => 5,[payment_method] => Contrassegno,[payment_module_code] => cod,[shipping_method] => Corriere espresso (2.86kg.) (Consegna 24/48 ore, sabato e festivi esclusi.),[shipping_module_code] => tnt,[coupon_code] => ,[cc_type] => ,[cc_owner] => ,[cc_number] => ,[cc_expires] => ,[date_purchased] => now(),[orders_status] => 1,[order_total] => 51.5,[order_tax] => 0,[currency] => EUR,[currency_value] => 1.00000000,[ip_address] => 79.56.112.118 - 79.56.112.118,[COWOA_order] => 1)) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/classes/order.php:796]
#6 order->create(Array ([0] => Array ([code] => ot_subtotal,[title] => Totale parziale:,[text] => €41.00,[value] => 41,[sort_order] => 100),[1] => Array ([code] => ot_shipping,[title] => Corriere espresso (2.86kg.) (Consegna 24/48 ore, sabato e festivi esclusi.):,[text] => €10.50,[value] => 10.5,[sort_order] => 200),[2] => Array ([code] => ot_total,[title] => Totale:,[text] => €51.50,[value] => 51.5,[sort_order] => 999),[3] => Array ([code] => ot_reward_points_display,[title] => Punti guadagnati:,[text] => 20,[value] => 0,[sort_order] => 1000)), 2) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/modules/checkout_process.php:86]
#7 require(/var/www/vhosts/laviadellincenso.it/httpdocs/includes/modules/checkout_process.php) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/modules/pages/checkout_process/header_php.php:14]
#8 require(/var/www/vhosts/laviadellincenso.it/httpdocs/includes/modules/pages/checkout_process/header_php.php) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/index.php:36]
[26-May-2015 09:59:00] PHP Fatal error: 1054:Unknown column 'COWOA_order' in 'field list' :: INSERT INTO orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_vat, billing_cf, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address, COWOA_order) VALUES ('1692', 'Sergio RICCIO', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '3286486400', '[email protected]', '5', 'Sergio RICCIO', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '5', 'Sergio RICCIO', '', '', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '5', 'Contrassegno', 'cod', 'Corriere espresso (2.86kg.) (Consegna 24/48 ore, sabato e festivi esclusi.)', 'tnt', '', '', '', '', '', now(), '1', '51.5', '0', 'EUR', '1.00000000', '79.56.112.118 - 79.56.112.118', '1') ==> (as called by) /var/www/vhosts/laviadellincenso.it/httpdocs/includes/functions/functions_general.php on line 965 <== in /var/www/vhosts/laviadellincenso.it/httpdocs/includes/classes/db/mysql/query_factory.php on line 155
I've seen tha on Numix site there is a 2.0 version availabe, i haven't test it yet so i don't know if it address some of this problemsHTML Code:015-05-26 01:34:42
-------------------
(live transaction) --> https://api-3t.paypal.com/nvp
Request Headers:
Array
(
[0] => Content-Type: text/namevalue
[1] => X-VPS-Timeout: 90
[2] => X-VPS-VIT-Client-Type: PHP/cURL
[3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart(R) - PayPal/NVP
[4] => X-VPS-VIT-Integration-Version: 1.5.4
)
Request Parameters: {DoExpressCheckoutPayment}
Array
(
[AMT] => 26.30
[ITEMAMT] => 16.80
[SHIPPINGAMT] => 9.50
[L_NUMBER0] => ICPBA93210000
[L_NAME0] => Bastoncini Palo Santo [210] Confezione: Semplice 30g
[L_QTY0] => 1
[L_AMT0] => 5.00
[L_NUMBER1] => ICPBA98214000
[L_NAME1] => Bastoncini Pino [214] Confezione: Semplice 30g
[L_QTY1] => 1
[L_AMT1] => 5.00
[L_NUMBER2] => INCPIN3180000
[L_NAME2] => Pino Resina Grezzo(Pinus pinaster) [117] QuantitÃ##: 50 grammi
[L_QTY2] => 1
[L_AMT2] => 3.30
[L_NUMBER3] => INCOLI2490000
[L_NAME3] => Olibano D'Etiopia (Boswellia rivae) [16] QuantitÃ##: 50 grammi
[L_QTY3] => 1
[L_AMT3] => 3.50
[SHIPTONAME] => giulio yary piccarreta
[SHIPTOSTREET] => caldopiano,42
[SHIPTOCITY] => Roma
[SHIPTOSTATE] => RM
[SHIPTOZIP] => 00118
[SHIPTOCOUNTRYCODE] => IT
[BUTTONSOURCE] => IT_zencart-ECS
[RETURNFMFDETAILS] => 0
[CUSTOM] => EC-1623-1432640078
[INVNUM] => 1623-1432640078-[LaViadellincenso]
[TOKEN] => EC-2J485786GW343062M
[PAYERID] => ME5VBKSUHGADJ
[PAYMENTACTION] => Authorization
[NOTIFYURL] => http://www.laviadellincenso.it/ipn_main_handler.php
[METHOD] => DoExpressCheckoutPayment
[CURRENCYCODE] => EUR
[USER] => *****
[PWD] => ****************
[VERSION] => 61.0
[SIGNATURE] => ****************************************************we-0
)
Response:
Array
(
[TIMESTAMP] => 2015-05-26T11:34:42Z
[CORRELATIONID] => 50d0908b5e644
[ACK] => Failure
[VERSION] => 61.0
[BUILD] => 16751317
[L_ERRORCODE0] => 10486
[L_SHORTMESSAGE0] => This transaction couldn't be completed.
[L_LONGMESSAGE0] => This transaction couldn't be completed. Please redirect your customer to PayPal.
[L_SEVERITYCODE0] => Error
[CURL_ERRORS] =>
)
DoExpressCheckoutPayment, Elapsed: 3492ms -- Failure
TIMESTAMP=2015%2d05%2d26T11%3a34%3a42Z&CORRELATIONID=50d0908b5e644&ACK=Failure&VERSION=61%2e0&BUILD=16751317&L_ERRORCODE0=10486&L_SHORTMESSAGE0=This%20transaction%20couldn%27t%20be%20completed%2e&L_LONGMESSAGE0=This%20transaction%20couldn%27t%20be%20completed%2e%20Please%20redirect%20your%20customer%20to%20PayPal%2e&L_SEVERITYCODE0=Error&CURL_ERRORS=
i get no errors, orders will go through, it is related to the cheapest (whatever, local pickup, check or money order, anything like that) being selected as default. the only time i get paypal errors are when customers bank doesnt authorize transaction or they put in a wrong address.
**Removed some of the quote to make reply shorter, and added bold to most important part**Quote:
Originally Posted by izar74
There is an issue because you are missing "COWOA_order" in the orders table. The "best" solution as I suspect there are other issues is to leave the files in place however in the tools->install SQL patches run the uninstall.sql from the module. That will uninstall the DB changes in the module, and then upon next admin page load re-install the module. I suspect that somehow that column was missed, however the $sniffer class allows it to check the column and add if needed.
Sorry bislew i've made e quite stupid VERY LONG reply, just addint that bold line would be enough.
Your suggestion make sense but i've checked the uninstall that is as follow:
From what i see it completly ignore the order table. I've also checked the installation and there is no modification to the Order table either.PHP Code:SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration
WHERE configuration_key= 'FAST_AND_EASY_CHECKOUT_VERSION'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
#Zen Cart v1.5.0+ only Below! Skip if using an older version!
DELETE FROM admin_pages WHERE page_key = 'configFastandEasyCheckout' LIMIT 1;
Does it have any meaning after seeing this to do as You suggested?
The last thing you wrote "the $sniffer class allows it to check the column and add if needed" how should i use this suggestion? :P
Ok, let's step back you should be using Fast & easy Check version 1.16.8.
in there the uninstall.sql should look like
And in the YOUR_ADMIN/includes/installers/fec/1_12_0.php there is a snippet:PHP Code:SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration
WHERE configuration_key= 'FAST_AND_EASY_CHECKOUT_VERSION'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id <> 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id <> 0;
#Zen Cart v1.5.0+ only Below! Skip if using an older version!
DELETE FROM admin_pages WHERE page_key = 'configFastandEasyCheckout' LIMIT 1;
SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration
WHERE configuration_key= 'FEAC_VERSION'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id <> 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id <> 0;
So, upgrade the module. THEN run the uninstall.sql that looks like the one above. Then load the admin, and it should resolve the issue.PHP Code:global $sniffer;
if (!$sniffer->field_exists(TABLE_CUSTOMERS, 'COWOA_account')) $db->Execute("ALTER TABLE " . TABLE_CUSTOMERS . " ADD COWOA_account tinyint(1) NOT NULL default 0;");
if (!$sniffer->field_exists(TABLE_ORDERS, 'COWOA_order')) $db->Execute("ALTER TABLE " . TABLE_ORDERS . " ADD COWOA_order tinyint(1) NOT NULL default 0;");
The uninstall.sql doesn't touch the TABLE_ORDERS however the installer for version 1.12.0 does. And it uses the sniffer class to make sure the column is there.
Ohhh my my... i've litterally lost the compass... where the 1.16.8 came from?Quote:
Originally Posted by bislewl
on the plugin it is at 1.15.3 (https://www.zen-cart.com/downloads.php?do=file&id=594)
and on the Numix site it goes from 1.15.3 to 2.0 directly.. this last one would do fine? (https://www.numinix.com/downloads/ze...-easy-checkout)
Hi again,
thanks to bislewl help i was able to fix the problem, at least i hope so. I used the plugin from numix site.
Now i'm trying to add a little modification, i would like to have add a column in the order page in admin, after status, thas swow if a order is COWOA.
The simpliest way i thought is to add some line to the /admin/orders.php, first i followed the instruction in the readme where it state: 8. OPTIONAL TO SEE IF AN ORDER WAS PLACED BY GUEST. It add some lines but not to diplay if the order is placed by guest (like the X shown in the customer page).
So i added this line:
around line 845 after the <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>
I added also the define for the TABLE_ORDER_HEADING_COWOAPHP Code:<td class="dataTableHeadingContent" align="center"><?php echo TABLE_ORDER_HEADING_COWOA; ?></td>
around line 969 after <td class="dataTableContent" align="right"><?php echo $orders->fields['orders_status_name']; ?></td>
The problem is that it doesn't work :PPHP Code:<td class="dataTableContent" align="center"><?php echo ($orders->fields['COWOA_order'] == 1 ? 'x' : ''); ?></td>
What did i fortget? :D
I did IT!! :P
First you need not to edit any ../class/order.php file, simply find the lines in /admin/orders.php:
and add the field you need to be searched at the end, for me it is:PHP Code:// eof: search orders or orders_products
$new_fields = ", o.customers_company, o.customers_email_address, o.customers_street_address, o.delivery_company, o.delivery_name, o.delivery_street_address, o.billing_company, o.billing_name, o.billing_street_address, o.payment_module_code, o.shipping_module_code, o.ip_address ";
:DPHP Code:// eof: search orders or orders_products
$new_fields = ", o.customers_company, o.customers_email_address, o.customers_street_address, o.delivery_company, o.delivery_name, o.delivery_street_address, o.billing_company, o.billing_name, o.billing_street_address, o.payment_module_code, o.shipping_module_code, o.ip_address, o.COWOA_order ";