Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Purchase Without Account Updated & Admin Functionality


Guest

Recommended Posts

Hi,

 

PWA 1.2.5a on OSC 2.2

 

in general no problems. works like a charm - BUT

if a customer comes back, and uses the same email = message: email already exists.

Why is that? Does PWA register the email adress somewhere?

 

any hints?

 

regards

kenneth

Link to comment
Share on other sites

  • 2 weeks later...

Hi all, I could use some help please :blush: ...

 

I wanted to install the PWA contrib plus the Login a la Amazon contrib. I followed the directions of mikelopez to install both (used the PWA complete package from 19 Oct 2006 and the Version 1.4 of Login a la Amazon package) - when I finished, the Amazon login contrib seemed to have worked, but not the PWA. I was still prompted to login, as if the PWA wasn't working at all, but otherwise the site worked fine.

 

I then saw that there was a new PWA contrib as of today, and used this as a guide to undo my work on the Amazon login and get the PWA to work (as I think this one will have the greater impact on completed sales...). I updated only the create account page and the login page (they now match exactly what the newest package has) & ran the common.sql file (was successful), and the PWA works! Kinda. Except whenever I try to login instead of going straight to checkout, I get the "Error: No match for E-Mail Address and/or Password." message, for accounts I've created both before the install and after. I restored the DB to before the point where I'd run common.sql (but after english.sql), but that just made things worse (got a 'where clause' problem when trying to login).

 

I've fully backed up several times throughout the process and can simply revert back, but I'd really prefer to just finish the job - I'm hoping someone might alert me to an obvious problem that I can fix to get this up and running. At this point in time, I'm not even bothered about trying to get the two installs to work together - I just want to get the PWA going for now. (although if someone can help me figure out the both, i'd be deeply thankful ;) )

 

Please let me know if you have any idea on what to fix.. Thanks in advance!

 

Janna

Link to comment
Share on other sites

Hi all, I could use some help please :blush: ...

 

I wanted to install the PWA contrib plus the Login a la Amazon contrib. I followed the directions of mikelopez to install both (used the PWA complete package from 19 Oct 2006 and the Version 1.4 of Login a la Amazon package) - when I finished, the Amazon login contrib seemed to have worked, but not the PWA. I was still prompted to login, as if the PWA wasn't working at all, but otherwise the site worked fine.

 

I then saw that there was a new PWA contrib as of today, and used this as a guide to undo my work on the Amazon login and get the PWA to work (as I think this one will have the greater impact on completed sales...). I updated only the create account page and the login page (they now match exactly what the newest package has) & ran the common.sql file (was successful), and the PWA works! Kinda. Except whenever I try to login instead of going straight to checkout, I get the "Error: No match for E-Mail Address and/or Password." message, for accounts I've created both before the install and after. I restored the DB to before the point where I'd run common.sql (but after english.sql), but that just made things worse (got a 'where clause' problem when trying to login).

 

I've fully backed up several times throughout the process and can simply revert back, but I'd really prefer to just finish the job - I'm hoping someone might alert me to an obvious problem that I can fix to get this up and running. At this point in time, I'm not even bothered about trying to get the two installs to work together - I just want to get the PWA going for now. (although if someone can help me figure out the both, i'd be deeply thankful ;) )

 

Please let me know if you have any idea on what to fix.. Thanks in advance!

 

Janna

 

Hi again, I've triple checked my files with the PWA package from yesterday, and I still haven't fixes the problem. Based on this, I think it has something to do with the common.sql that I ran.... in particular the customers_password field which is altered:

 

ALTER TABLE `customers` MODIFY COLUMN `customers_password` VARCHAR(40) CHARACTER SET utf8 COLLATE utf8_general_ci;

 

 

..... I looked at the backup version I have and it seems to define the customers_password field as VARCHAR(40), but no mention of utf8 COLLATE utf8_general_ci..... What are these values, and how are they affecting the site? Could this be the cause? I was really hoping for advice before delving in and altering my actual DB, since I really don't know much about how it works.

 

My site is here (contains adult content, but not porn/nudity). It's 'live' to take orders, but I've set up the only payment method as cash on delivery (nothing can currently be billed by processing the order) - I'll disregard any orders from test accounts if anyone needs to have a look to see what I'm talking about....

 

Any advice would be appreciated... thanks!

 

 

Janna

Link to comment
Share on other sites

Hi, me again... I think I fixed it!!!

 

Although I could be wrong. :blush:

I'd appreciate if someone could validate that by testing my site, especially since I'm not 100% sure how it's *supposed* to work anyways....

 

To fix it, I went into the login.php page, and swtiched the PWA addition BACK to what I started with, so:

 

// Check if email exists
// PWA BOF
// using customers_login instead of customers_email_address
$check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_login = '" . tep_db_input($email_address) . "'");
// PWA EOF
if (!tep_db_num_rows($check_customer_query)) {
  $error = true;
} else {
  $check_customer = tep_db_fetch_array($check_customer_query);*/

 

became this again:

// Check if email exists
$check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");
if (!tep_db_num_rows($check_customer_query)) {
  $error = true;
} else {
  $check_customer = tep_db_fetch_array($check_customer_query);

 

 

i kinda realized that my customers_login field was all NULL, but not the customers_email_address field.... is that supposed to happen?

 

anyways, I hope the above story (3 posts, sorry) helped someone if anyone else finds the same problem... please let me know if i've changed something that was vitally important ;)

 

thanks again,

Janna

Link to comment
Share on other sites

Hi

 

Does the PWA contribution actually use the application_top.php file?

 

I found this file in the latest contribution download pack, but I can't see how it is different to the standard application_top.php ...

Link to comment
Share on other sites

Hi, me again... I think I fixed it!!!

 

Although I could be wrong. :blush:

I'd appreciate if someone could validate that by testing my site, especially since I'm not 100% sure how it's *supposed* to work anyways....

 

To fix it, I went into the login.php page, and swtiched the PWA addition BACK to what I started with, so:

 

// Check if email exists
// PWA BOF
// using customers_login instead of customers_email_address
$check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_login = '" . tep_db_input($email_address) . "'");
// PWA EOF
if (!tep_db_num_rows($check_customer_query)) {
  $error = true;
} else {
  $check_customer = tep_db_fetch_array($check_customer_query);*/

 

became this again:

// Check if email exists
$check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");
if (!tep_db_num_rows($check_customer_query)) {
  $error = true;
} else {
  $check_customer = tep_db_fetch_array($check_customer_query);

i kinda realized that my customers_login field was all NULL, but not the customers_email_address field.... is that supposed to happen?

 

anyways, I hope the above story (3 posts, sorry) helped someone if anyone else finds the same problem... please let me know if i've changed something that was vitally important ;)

 

thanks again,

Janna

 

I have run into the exact same problem. I have backed out this contribution for now. It looks to me like the change you made could fix the create account but break the purchase without account. I think the problem is the update to the password field in the common.sql. It may work with new accounts (I didn't try it) but might break existing accounts. I would like to hear from the author of this contribution (marquinho) PWA-v2.0a as to why the modify customers_password column is needed and what the impact will be on existing accounts.

 

Please let me know if your change works fully or if you hear anything else. Thanks!

Mike

Link to comment
Share on other sites

... yes existing accounts seem to be broken ...

The author has put out an update on the pwa contribution page that modifies the password column update in the common.sql. It partially fixed my problem but I still needed to change the login.php back so that the query looked like:

----------

// Check if email exists

$check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");

if (!tep_db_num_rows($check_customer_query)) {

$error = true;

} else {

$check_customer = tep_db_fetch_array($check_customer_query);

-------

as described by Janna above. Otherwise my existing accounts could not log in. I've been running with this modified code now for a few days and it seems to be working ok but I'm a bit nervous. I have tried to contact marquito about this but havn't gotten a reply yet. Please let me know if anyone finds out more info.

 

Thanks!

 

Mike

Edited by mstein
Link to comment
Share on other sites

  • 2 weeks later...

Hi, everyone. I've spent the last 3 days on a somewhat different version of PWA. Basically, it lets you enter all your information into a different database table (NOACCOUNT instead of CUSTOMERS), but it does not ask you for a password, so you can't come back and retrieve it.

 

Here's where I'm stuck. I enter my name, email, address, and phone number after having put something in the shopping cart. But the next page, checkout_shipping.php, does not have my address.

 

How exactly is the current session's user info passed along to the checkout_shipping.php page? Can anyone tell me which bit of the code is responsible for this pass through?

 

It seems like the bit below should be the answer, but it isn't working (this is on the checkout_shipping.php page):

 

// if no shipping destination address was selected, use the customer's own address as default

if (!tep_session_is_registered('sendto')) {

tep_session_register('sendto');

$sendto = $noaccount_default_address_id;

} else {

// verify the selected shipping address

$check_address_query = tep_db_query("select count(*) as total from " . TABLE_NOACCOUNT_ADDRESS_BOOK . " where customer_id = '" . (int)$customer_id . "' and address_book_id = '" . (int)$sendto . "'");

$check_address = tep_db_fetch_array($check_address_query);

 

THANK YOU IN ADVANCE. I'm so tired. I am using Online Merchant v2.2 RC1, which is why I had to cobble together my own version of all this.

Link to comment
Share on other sites

Hi, everyone. I've spent the last 3 days on a somewhat different version of PWA. Basically, it lets you enter all your information into a different database table (NOACCOUNT instead of CUSTOMERS), but it does not ask you for a password, so you can't come back and retrieve it.

 

Here's where I'm stuck. I enter my name, email, address, and phone number after having put something in the shopping cart. But the next page, checkout_shipping.php, does not have my address.

 

........

 

OMG, nevermind. I just came up with the world's simplest solution to this entire 5-year PWA discussion. In the end, it took only a few minutes to accomplish. If anyone's curious, just ask me.

 

DiAnn

Link to comment
Share on other sites

OMG, nevermind. I just came up with the world's simplest solution to this entire 5-year PWA discussion. In the end, it took only a few minutes to accomplish. If anyone's curious, just ask me.

 

DiAnn

You mean you installed PWA_0.910?

Link to comment
Share on other sites

You mean you installed PWA_0.910?

 

No, I couldn't seem to find a PWA version that matched my system. So I used Barry McEwan's idea for adding the PWA option to the login page, but then the only other change I needed to make was to have a separate version of create_account.php (create_noaccount.php) that doesn't ask you for a password and doesn't send you a confirmation email.

 

Does anyone see any huge flaws in that idea? The store owner still needs all the buyer's to be in their database, but we're removing any negative feelings a potential customer may have about creating an "account".

 

DiAnn

Link to comment
Share on other sites

No, I couldn't seem to find a PWA version that matched my system. So I used Barry McEwan's idea for adding the PWA option to the login page, but then the only other change I needed to make was to have a separate version of create_account.php (create_noaccount.php) that doesn't ask you for a password and doesn't send you a confirmation email.

 

Does anyone see any huge flaws in that idea? The store owner still needs all the buyer's to be in their database, but we're removing any negative feelings a potential customer may have about creating an "account".

 

DiAnn

Don't know of Barry McEwan's idea

Link to comment
Share on other sites

Hi

 

I have installed this contrib and i would like to uninstall it how would i go about doing this.

Would i just upload and override the files that were changed.

And how do i change my DB so it is back to how it was with out the change.

 

James

Link to comment
Share on other sites

Hi

 

I have installed this contrib and i would like to uninstall it how would i go about doing this.

Would i just upload and override the files that were changed.

And how do i change my DB so it is back to how it was with out the change.

 

James

Just restore the backup files that you made before making any changes.

Link to comment
Share on other sites

is that all i need to do.

 

this is the reason i want to put it back it because i get this error on my account page when you are logged in

 

I think it is this contrib that made it do this but I'm not sure.

 

1054 - Unknown column 's.public_flag' in 'where clause'

 

select count(*) as total from orders o, orders_status s where o.customers_id = '119' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1'

 

[TEP STOP]

Link to comment
Share on other sites

is that all i need to do.

 

this is the reason i want to put it back it because i get this error on my account page when you are logged in

 

I think it is this contrib that made it do this but I'm not sure.

Maybe this

Link to comment
Share on other sites

Don't know of Barry McEwan's idea

 

He's the one who started this thread. I'm guessing the original contribution is his. What I borrowed from him was the change to the login page that gives you 3 options:

 

- Purchase without Account

- Create a new Account

- Log into existing Account

Link to comment
Share on other sites

He's the one who started this thread. I'm guessing the original contribution is his. What I borrowed from him was the change to the login page that gives you 3 options:

 

- Purchase without Account

- Create a new Account

- Log into existing Account

Thank you for explaining.

That is what version 9.10 does.

Link to comment
Share on other sites

Ever since I installed the PWA contribution. my customers cannot see the shipping or billing addresses they enter during checkout (only when using PWA). It is also not being sent through email. However, it is being stored as when I print the invoices, the addresses are showing up perfectly.

Link to comment
Share on other sites

Don't know if this has been addressed or not, but when I am testing PWA, I try to checkout w/no account and it gives me the following error:

 

Parse error: parse error, unexpected $ in /home/content/g/a/m/games4gamers/html/catalog/create_account.php on line 632

 

Line 632 is blank, so I have no clue.

 

I've used ExamDiff and can't find anything different. I've uploaded all the files...what gives?

Link to comment
Share on other sites

Anyone have any input on osCommerce v2.2rc2a - Purchase Without Account v2.0a by marquinho? I have had PWA installed for a couple of years and now I am doing updates.....should I update? is this going to be the new supported version or not?

 

Thanks for any input,

 

lildog

Link to comment
Share on other sites

Don't know if this has been addressed or not, but when I am testing PWA, I try to checkout w/no account and it gives me the following error:

 

Parse error: parse error, unexpected $ in /home/content/g/a/m/games4gamers/html/catalog/create_account.php on line 632

 

Line 632 is blank, so I have no clue.

 

I've used ExamDiff and can't find anything different. I've uploaded all the files...what gives?

There is probably an unclosed tag further up. Re check the edits.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...