My Checkout Without Account Mod

Have been installed and happy and testing. Found a problem today:

If you try to send a Gift Voucher in admin, the page shows:

1054 Unknown column 'true' in 'where clause'
in:
[select customers_email_address, customers_firstname, customers_lastname from customers where COWOA_account != true order by customers_lastname, customers_firstname, customers_email_address ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I am on 1.36, have not started to look at anything to narrow the issue, dont know if its across or only in certain installation, but it should be COWOA related. Will be looking more into it. Does anyone else have encountered this or do you have no problem sending GVs?

Ron:

Eh, probably that true false vs. 1 0 issue that cropped up earlier. I notice that I don't have it on mine, is this the windows installation that was giving you problems earlier?

I'll provide an sql patch for you by PM this evening.

IntelCos:

*nods* It's good to go. At least a few people have it up and running on their live sites. I'm working on a compatibility mod for Super Orders at the moment, and that should be it.

Hope this helps,
Joe

Alright, I see where I went wrong with my original Super Orders mod. I've learned my lesson, though, and I'm putting the new one in the wiki presently. I've tested this one out. Please let me know if you have any problems with it.

Thanks for your patience.

--Joe

Quote:

---

Originally Posted by J_Schilz

Ron:

Eh, probably that true false vs. 1 0 issue that cropped up earlier. I notice that I don't have it on mine, is this the windows installation that was giving you problems earlier?

I'll provide an sql patch for you by PM this evening.

IntelCos:

*nods* It's good to go. At least a few people have it up and running on their live sites. I'm working on a compatibility mod for Super Orders at the moment, and that should be it.

Hope this helps,
Joe

---

Noted. Yeah, I am not really a keen eye programmer. So this issue is in the database? Cheers

Hej Schilz!

Thank you very much for this fix and compliancy update!!!
A great support of your mod.

However I have currently installed a few other modules (localhost testing) which I think could interefere with this mod:
I do not really know which one is sending what to whom or maybe just modifying the files... these mainly are:

Superorders 2.0
PDF Order Center
Email Archive Manager 1.2
Add Customer 1.0
Edit Orders 1.1
Email address exporter 1.2c
EU Standard Bank Transfer 1.1
Ty_Packer_Tracker 2.2b

I am guessing that Email Archive Manager (just for emails within admin), add Customer, edit orders, email adress export (modifying admin account) is fine, but what about PDF Order Center, Tyy_Packer_Tracker and the EU Bank transfer?

Does anybody know, can anybody confirm?

Thank you very much!

ps: I think it was ok to leave out the graphical addons like CSS bars/grids and the shipping modules (insurance, priority handling, national packaging) as well as IH2, Ordersteps and QBI

Hi TMontana we have ADD CUSTOMER, And EU BANK TRANSFER on our live site alongside JOEs MOD and they are working fine, we do have a problem with EDIT ORDERS but its not that dramatic and we will attack that when we have a bit of free time...
Hope this helps
Richie

Hey JMS Music... thx for your reply.
Can you post updates on how to fix the problem? That would be great!

Anyone any further comments, compliance issues (maybe with the mods stated above?).

Greetings.

T.

Hi Joe,

First of all thank you for the contribution. It is exactly what I am looking for.
I have been trying to install it for a few days now, and I must do something wrong (that's why I am bothering you here):oops:
I upload all the files in the appropriate directories (I checked, they are there) and I run the sql instructions.
When I try to login I am presented with exactly the same screen as before (the standard New Customer/Returning customers options).
I have not any other modification. It is a new install with just a custom template (yes, I renamed the YOUR_TEMPLATE directories, and yes, I cleaned the cache of both IE and Firefox)
I also tried to install your mod on the classic template, but still no luck.
If you want my url, I can give it to you, but the site is not live yet and the DNS as not been re-pointed to the new server yet (I am moving to a new host and in the meantime I am changing from Shopsite to Zen cart).
I have php version 5.0.4, not as cgi, as apache module, Linux OS, and I am using zen cart 1.3.7.

Any idea?
Thank you

vatel,

Thanks for your words of support. (;

One thing springs to mind as a possibility, you say "when I try to login". Do you have anything in your cart at that time?

--Joe

Joe,

Thank you for your fast reply.
I tried to start from scratch and uploaded the saved version of my site, but unfortunately it did not work anymore. So I am back to step one.:down:
I am re-installing Zen Cart and will try to install your mod before any other modification.
I will keep you posted.

Vatel