My Checkout Without Account Mod

craftzombie:

Did you enter the SQL into Admin>Tools>Install SQL patches? (Step 4 from the install instuctions)

I'm just thinking that if you didn't, then there is no spot in the database for the info to go and maybe that would cause a blank page.

Yes I did. I double check that and actually went to the mysql and verified all of the entries at that level as well.

techdog:

I forgot to mention that whenever someone attempts to add an item to their shopping cart I get a blank page there too. I am not sure if these are related but I'm hopeful that 1 fix will cover both. Thanks. - Karl

What other mods are you using? Or what changes have you made that would mess with the shopping cart page? Because COWOA would not cause any problems with the shopping cart page like that. COWOA is only adding a new page (no_account) and adds a section to the login page. The shopping cart page is never touched when this mod is uploaded.

I noticed that when I click on "add to cart", it IS taking me to a blank page, but when I go back, that item has been added to the cart. That is also the case with the no_account page. After you get the blank page, go to http://annalena.com/shop/index.php?main_page=checkout_shipping and you can continue checkout. The information is being registered into the database.

Its really hard to say what could be doing this because I don't know what changes you have made. Have you added other mods? Have you gone into these two files attempting to change their appearance? I say this because I have noticed that, throughout my Zen experience, a blank page is usually the result of white space or an extra character where it shouldn't be, etc.

techdog, even clicking on your logoff links gives a blank page. You have some other issue not related to COWOA.

craftzombie:

What other mods are you using? Or what changes have you made that would mess with the shopping cart page? Because COWOA would not cause any problems with the shopping cart page like that. COWOA is only adding a new page (no_account) and adds a section to the login page. The shopping cart page is never touched when this mod is uploaded.

I noticed that when I click on "add to cart", it IS taking me to a blank page, but when I go back, that item has been added to the cart. That is also the case with the no_account page. After you get the blank page, go to http://annalena.com/shop/index.php?main_page=checkout_shipping and you can continue checkout. The information is being registered into the database.

Its really hard to say what could be doing this because I don't know what changes you have made. Have you added other mods? Have you gone into these two files attempting to change their appearance? I say this because I have noticed that, throughout my Zen experience, a blank page is usually the result of white space or an extra character where it shouldn't be, etc.

I will continue digging, I started noticing these issues through the checkout process and some of the COWOA files were not loaded completely. I fixed that and had a few different errors. Only other mods we have installed are Local Sales Tax (WA requires destination based sales tax - don't get me started) and CSS ClickShow Hide - for the category buttons/links. Thanks for your suggestions, I will dig through the code and see what I can find.

I've noticed that the system calls for "FILENAME_NO_ACCOUNT" but there is no such designation within the filenames.php file. Should there be?

techdog:

I've noticed that the system calls for "FILENAME_NO_ACCOUNT" but there is no such designation within the filenames.php file. Should there be?

No, that is in includes/extra_datafiles/no_account_filenames.php (or includes/extra_datafiles/YOUR_TEMPLATE/no_account_filenames.php)

Hi.

Sorry to say, I removed this after spending a lot of time installing it. Nothing the matter, it wasn't what I thought I needed.

Anyhoo, everything's fine after adjusting the files, but what about the SQL patch? Do I have to undo that...and if yes, how?

Cheers,

Robbie

The SQL patch adds the field COWOA_account to the customers table, and COWOA_order to the orders table. It also inserts one record into the query_builder table.

It certainly would not hurt to just leave those mods in there. However, if you are familiar with SQL, you could delete the added fields and record.

I deleted all the files from the mod. I'm not familiar with SQL, but I am good at following instructions...if it's not too complicated to undo/delete the patch and if it's even necessary (I don't want it to interfere with any other mods/adjustments down the road).

Robbie

I deleted all the files from the mod. I'm not familiar with SQL, but I am good at following instructions...if it's not too complicated to undo/delete the patch and if it's even necessary (I don't want it to interfere with any other mods/adjustments down the road).

Robbie

You would need to enter these SQL commands the same as you did for the original installation. That is, open the admin panel, open Tools -> Install SQL Patches. Copy the three lines below into the text box and hit 'send'.

IMPORTANT! You need to be sure to substitue "zc_" in the three lines below with whatever you used for your table prefix.

ALTER TABLE zc_customers DROP COWOA_account;
ALTER TABLE zc_orders DROP COWOA_order;
DELETE FROM zc_query_builder WHERE query_name = 'Permanent Account Holders Only';

I only used whatever the mod gave me. Just to be 100% certain, here's the sql from the mod that was patched in:
*
ALTER TABLE customers ADD COWOA_account tinyint(1) NOT NULL default 0;
ALTER TABLE orders ADD COWOA_order tinyint(1) NOT NULL default 0;
INSERT INTO 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');*

So I would replace your "zc_" with....I have no idea!

ALTER TABLE zc_customers DROP COWOA_account;
ALTER TABLE zc_orders DROP COWOA_order;
DELETE FROM zc_query_builder WHERE query_name = 'Permanent Account Holders Only';

Robbie

When you set up Zen Cart, it asks you to specify a "database prefix". It is optional. If the commands that you executed before worked successfully just as you have noted them in your last post, then you don't have a database prefix.

But you should really make sure before proceeding:

I could not figure out any way in the Admin to see what the database prefix is. The only way that I know of is to look at this file:
includes/configure.php

If you know how to open that and look at it, scroll down to near the bottom to find the line that defines "DB_PREFIX". For me, it's defined to 'zc_'. If you didn't set up a prefix, yours should be defined to ''. In that case, this is the SQL that you want to execute.

ALTER TABLE customers DROP COWOA_account;
ALTER TABLE orders DROP COWOA_order;
DELETE FROM query_builder WHERE query_name = 'Permanent Account Holders Only'; 

If it IS defined to something other than blank, let me know what it is. I'd be surprised because in that case the queries that you noted above should not have worked.

Let me know how you make out.

I appreciate your help. Now I understand the prefix. I made it "zen_" when I installed the cart. So I changed your zc_ to zen_ and tried to patch it in and got this message:

*1146 Table 'alexcagift.zen_zen_customers' doesn't exist
in:
[show fields from zen_zen_customers]
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 added the original patch from this mod as is, without adjusting any text. So now I should try your code without any prefix? I trust that this won't cause any problem which I'm trying to avoid. :wink:

R

Yes, that will work. I actually don't use the Admin to do SQL changes, but now I understand that it automatically tacks on the prefix for you. SO ... yes, use my code without any prefixes.

I apologize for my confusion! :blush:

Okay, that worked. Thanks!

Now let me know (hee-hee) if you're familiar with the Easy Sign-Up and Login mod, as I decided to go with that one and can't figure out something in the installation. ...And no response yet from the thread on his special site.

R

Sorry - no experience with that one. I've only used COWOA.

After doing that sql patch, I went to purchase a test item and, whether I entered my own made-up exisiting customer id or tried to create a new acc't, I got the following:

1054 Unknown column 'COWOA_account' in 'where clause'
in:
[select count(*) as total from zen_customers where customers_email_address =

This didn't happen last night. Any ideas? I'm thinking with this one I deleted (supposedly), installing two versions of Fast And Easy Checkout and not finishing the install of Easy Sign Up and Login, that I might as well delete everything, re-upload the untampered saved files and restore the database backup from right before all this.

R

Sounds to me like you didn't remove all of the COWOA. The quickest way out of this might be to just re-apply the original SQL patch.

Hi, I'm new to zen cart and I just recently added COWOA. Anyways, I would like to ask how I can change the text "TEXT_RATHER_COWOA"? Thanks :-)