My Checkout Without Account Mod

[giftmeister]

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

[giftmeister]

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

[alicia1234]

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';

[giftmeister]

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

[alicia1234]

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.

[giftmeister]

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.

R

[alicia1234]

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!

[giftmeister]

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

[alicia1234]

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

[giftmeister]

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