My Checkout Without Account Mod

[J_Schilz]

vatel,

Sure, let me know how it goes.

Just to clarify, I asked if you had anything in your cart at the time because the checkout without account option will not show unless you have something in your shopping cart.

If you have any more problems installing shoot me a PM and we'll figure it out. (;

--Joe

[skypanther]

I was getting a SQL statement error with one of your queries. The error was unknown column 'true' in 'where clause'. The problem can be found in the following statement within modules/templatename/no_account.php about line 119

$check_email_query = "select count(*) as total
from " . TABLE_CUSTOMERS . "
where customers_email_address = '" . zen_db_input($email_address) . "'
and COWOA_account != true";

The COWA_account field is a tinyint field, so 'true' is not a valid value. I'm not sure about the != in SQL, but I know <> works. So, the following change makes the code work for me.

$check_email_query = "select count(*) as total
from " . TABLE_CUSTOMERS . "
where customers_email_address = '" . zen_db_input($email_address) . "'
and COWOA_account <> 1";

Tim

[J_Schilz]

Tim,

Thanks for pointing this out. I've been working with ronwong regarding this issue. Apparently the true false syntax is not valid across all SQL servers. I have most, if not all, of the instances fixed.

I'm on a bit of a vacation and unable to immediately repackage the fix. As it stands, the syntax works across most implementations.

If you're having the true false syntax problem, you'll want to use your developer's tool kit to search for instances of:

COWOA_account != true

and replace it with:

COWOA_account != 1

Thanks again,
Joe

[barnamania]

Joe,
I love this mod! It's awesome! Thanks man. I've customised it so it's a 2-page checkout... the customer enters their details, goes to checkout confirmation and bang, it's done. I personally find the 5 page checkout thing quite tedious, specially when you have to then go through paypal as in my store, so it works quite well.

If anyone wants to test it out, it's on http://www.dreamofrussia.com (live store - please use "testing" in your name so I know what's going on )

Cheers

[maza]

I'm sure I got all the files uploaded correctly, I checked few times. I ran the .SQL patch too.

All I get is the message after filling up details and continuing to the next page is this:

1054 Unknown column 'COWOA_account' in 'where clause'
in:
[select count(*) as total from customers where customers_email_address = '[email protected]' and COWOA_account != true]

Please help. Thanks.

[maza]

Hi Joe, thanks for your PM. I'd just post here to say finally I got it solved. It's about the .SQL patch which I incorrectly installed.

Now its ready and hope it will be OK when the site go 'live'.

BTW, this mod rocks! TWO Thumbs Up to Joe.

[Boggled]

Joe,
I love this mod! It's awesome! Thanks man. I've customised it so it's a 2-page checkout... the customer enters their details, goes to checkout confirmation and bang, it's done. I personally find the 5 page checkout thing quite tedious, specially when you have to then go through paypal as in my store, so it works quite well.

If anyone wants to test it out, it's on http://www.dreamofrussia.com (live store - please use "testing" in your name so I know what's going on )

Cheers

Hi Barnamania!

Looks great, but I did see one glitch for US buyers. There was no place to enter the State. I didn't do a screen shot...just copied/pasted what it showed on the confirmation page:

Delivery Address
Testing Checkoutmod
123 Main
Mcminnville, 37110
United States

Don't know if this is just because you modified it or if it's something in the original code (I haven't gotten around to installing it yet myself.)

[barnamania]

Thanks man - I'm actually targeting UK buyers at the moment, so it's not an issue. If I remember right, I disabled State from the admin, although I did edit bits of code on the login page itself.

[IntelCos]

Hi, just trying to figure out what state this mod is in before trying to install this. Should I wait until a few more bugs are worked out, or is it a good thing to install at this stage with 1.3.7?

[J_Schilz]

IntelCos,

This mod is good to go. I've finally got all of the proper version notes, etc., on it and upgraded it from beta to public. I think the only problem that's come up in the last couple weeks is this cross platform SQL tiny int true/false issue. I've got that all rooted out and quite a few people have said it's working well.

--Joe