COWOA (for ZC v1.5.x)

Since you're using v1.5.0 on your site, you need the /includes/modules/pages/password_forgotten/header_php.php file from either the original Zen Cart v1.5.0 code, or from a COWOA plugin properly designed for v1.5.0.
Using the v1.5.1 version of that file will cause the symptoms you posted.

Normally if one has a backup from before installing plugins, they can restore damaged files from that backup.

As far as I've been able to tell from the documentation, the most recent version of the COWOA plugin is supposed to work properly for both 1.5.0 and 1.5.1. But I'll dig up the original file, and install that, and see what happens. Thanks.

No, damn it, I can't...I overwrote the original one by accident by downloading the modified one so that I could check on line 48! :oops: I still have the full installation zip...guess I'll have to unpack that tomorrow, and upload the proper file from there.

That worked. If anyone is stuck on this, and needs a quick fix, just copy the original "password forgotten" file in to replace the COWOA version.

Thanks, everyone!

Hi, I'm trying to unistall COWOA but I keep getting an error when I run the uninstall sql. My debugging report says the following:

[31-Aug-2013 17:29:29 America/Los_Angeles] PHP Fatal error: 1054:Unknown column 'query_builder.query_name' in 'where clause' :: DELETE FROM zen_query_builder WHERE query_builder.query_name = 'Permanent Account Holders Only' LIMIT 1; in /home/.../query_factory.php on line 120

If you would be willing to share your expertise, I would really appreciate it. Thanks!!

Alaskan:

Hi, I'm trying to unistall COWOA but I keep getting an error when I run the uninstall sql. My debugging report says the following:

[31-Aug-2013 17:29:29 America/Los_Angeles] PHP Fatal error: 1054:Unknown column 'query_builder.query_name' in 'where clause' :: DELETE FROM zen_query_builder WHERE query_builder.query_name = 'Permanent Account Holders Only' LIMIT 1; in /home/.../query_factory.php on line 120

If you would be willing to share your expertise, I would really appreciate it. Thanks!!

I should also add, that I have replaced all the original files and deleted the COWOA core files. So, I think all I need to do is run the uninstall sql through the admin install sql patch page. But in doing so I get the following error: WARNING: An Error occurred, please refresh the page and try again.
Then the debugging report says what I've typed above.

Alaskan:

I should also add, that I have replaced all the original files and deleted the COWOA core files. So, I think all I need to do is run the uninstall sql through the admin install sql patch page. But in doing so I get the following error: WARNING: An Error occurred, please refresh the page and try again.
Then the debugging report says what I've typed above.

Do I have to run the uninstall sql to have my website running properly? Anybody out there? Please help as I don't understand what the error is saying.

Alaskan:

Do I have to run the uninstall sql to have my website running properly? Anybody out there? Please help as I don't understand what the error is saying.

Can you get at your database through phpMySQL interface vs thru zen cart admin?

I think so. I have MySQL Databases, MySQL Database Wizard, and phpMyAdmin. Which one do I use and what do I do? I haven't used the first two before.
Thank you for answering!!!

Can I run the uninstall sql through phpMyAdmin? If so, I have no idea how to do that. Or were you thinking of going through and deleting the COWOA files? Is there a way to search the folders that were affected by COWOA?

What does this mean?
[31-Aug-2013 17:29:29 America/Los_Angeles] PHP Fatal error: 1054:Unknown column 'query_builder.query_name' in 'where clause' :: DELETE FROM zen_query_builder WHERE query_builder.query_name = 'Permanent Account Holders Only' LIMIT 1; in /home/.../query_factory.php on line 120

Alaskan:

What does this mean?
[31-Aug-2013 17:29:29 America/Los_Angeles] PHP Fatal error: 1054:Unknown column 'query_builder.query_name' in 'where clause' :: DELETE FROM zen_query_builder WHERE query_builder.query_name = 'Permanent Account Holders Only' LIMIT 1; in /home/.../query_factory.php on line 120

So using phpMyAdmin, I have found the 'Permanent Account Holders Only' query_name in the query_builder folder (I am slowly learning!). Do I delete this query from the database??
The uninstall sql says: DELETE FROM query_builder WHERE query_builder.query_name = 'Permanent Account Holders Only' LIMIT 1;
So do I actually delete this from the database? Little nervous here...don't want to delete anything important.

Any advice would be greatly appreciate!

YEAH!!! I figured it out!!!
I had to change the following line in the uninstall Sql
from:
DELETE FROM query_builder WHERE query_builder.query_name = 'Permanent Account Holders Only' LIMIT 1;

to:
DELETE FROM query_builder WHERE zen_query_builder.query_name = 'Permanent Account Holders Only' LIMIT 1;

Then it worked perfectly!
Hope this helps someone else! I'm just excited I figured something out on my own!!

deleted

Module working well but somehow I am not quiet happy with the tpl_login_default.php layout. I think the layout is somewhat confusing. I still want to rewrite some test but I am looking for input on the following layout changes. What do you think?

First cowoa.png is the original
cowoa-mod.png is minimally modified
cowoa-mod1.png even more modified

mydanilo:

Module working well but somehow I am not quiet happy with the tpl_login_default.php layout. I think the layout is somewhat confusing. I still want to rewrite some test but I am looking for input on the following layout changes. What do you think?

First cowoa.png is the original
cowoa-mod.png is minimally modified
cowoa-mod1.png even more modified

I have no feedback to offer as I am not clear on what you define as "confusing"..

I suppose it boils down to what you think makes sense to you customers.. but you should know that the current layout is based very much so on best practices in place with some of the largest online retailers..

The longer I was looking at it the more I felt the layout is a bit confusing. For one the button alignments are inconsistent. And I am unsure why PayPal and regular checkout share a box but Guest checkout does not? Just overall seems a bit odd to me. But please don't take any offense, as you say, it probably boils down to personal preference. So I am just asking for opinions.

mydanilo:

The longer I was looking at it the more I felt the layout is a bit confusing. For one the button alignments are inconsistent. And I am unsure why PayPal and regular checkout share a box but Guest checkout does not? Just overall seems a bit odd to me. But please don't take any offense, as you say, it probably boils down to personal preference. So I am just asking for opinions.The "Login" and "Continue" buttons all align right, the PayPal button is the only one centered, nd that is an EASY CSS change..

As for the location of the PayPal and regular check out.. I suspect that is to satisfy a PayPal requirement..

• Express Checkout button before login is required

• PayPal requires that you use Express Checkout button images hosted on PayPal's secure servers, rather than hosting copies of these images on your own servers.

• If your site has a Checkout button on pages other than the Shopping Cart page (such as on product pages), PayPal requires that you put a PayPal Express Checkout button next to these Checkout buttons as well.

Again.. Not sure why you think it's confusing.. (would help get you better feedback if you could verbalize your thoughts on this..)

Wanted to share something from a recent discussion I had with someone on this very topic:

Please look at how some of the top retailers do this.. Many top retailers have some kind of guest checkout feature. (Amazon is a BIG exception.. and frankly Amazon can get away with this..) They DO NOT need LONG headlines to help people understand when a guest checkout option is available.. Please note that they don’t emphasize or OVER emphasize when guest checkout options are available - nor do they have to. They don’t have to because they know that people GET IT. The top retailers DO NOT hit people over the head with guest checkout by using large headlines or gigantic buttons.. The MAJORITY of online shoppers understand how guest checkout works.

• Apple

• Macys

• LL Bean

• Best Buy

• Walmart

• J Jill

My original e-mail included screenshots of the checkout page for each of these retailers.. I left that out of this quote (too much work to include the screenprints inside a forum post), but you should look at what these and other retailers are doing..

Actually looking at what leading sites do is what I go by as well to improve what I can do with Zen Cart. But you made me look again and I realize that creating a few more better labeled buttons would not hurt. I now use Create Account and Continue as Guest buttons. I'll shorten the text as well. As you stated, it is pretty obvious to most shoppers if they read title and button text. That brings me again to having a title in the form of "<fieldset> <legend><?php echo COWOA_HEADING; ?></legend>" for each section or non at all. I want all 3 options for new customers (format, layout) the same. I'll play around with it a bit more. If somebody else happens to like it, I'll be more than happy to share.

I am done now with adjusting my checkout/registration. Have a look. New buttons and short as possible text, new title. Also removed the newsletter-email box completely on both registration and guest checkout to make things even shorter/leaner looking.

I'm having an issue with COWOA and a free, downloadable product. I have the attributes set up for the product to allow the customer to download a PDF file when they check out. Previously, I've had only for-sale downloadable products and customers have had no trouble downloading those.

However, when my customers go to check out with a FREE downloadable product, the order process stops at step 4 of 5, returning a blank screen where the order review information should be. The order process slider is there and says "order review" but there is nothing below this. I have tried changing the downloadable product settings in every combination possible (no shipping address required, always free, etc) and I get this error every time.

Does anyone have any suggestions??

grakowsky:

I'm having an issue with COWOA and a free, downloadable product. I have the attributes set up for the product to allow the customer to download a PDF file when they check out. Previously, I've had only for-sale downloadable products and customers have had no trouble downloading those.

However, when my customers go to check out with a FREE downloadable product, the order process stops at step 4 of 5, returning a blank screen where the order review information should be. The order process slider is there and says "order review" but there is nothing below this. I have tried changing the downloadable product settings in every combination possible (no shipping address required, always free, etc) and I get this error every time.

Does anyone have any suggestions??

Do these free downloads work if you turn off COWOA??