bergmann Posted January 29, 2008 Share Posted January 29, 2008 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 Quote Link to comment Share on other sites More sharing options...
jbastow Posted February 8, 2008 Share Posted February 8, 2008 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 Quote Link to comment Share on other sites More sharing options...
jbastow Posted February 9, 2008 Share Posted February 9, 2008 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 Quote Link to comment Share on other sites More sharing options...
jbastow Posted February 9, 2008 Share Posted February 9, 2008 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 Quote Link to comment Share on other sites More sharing options...
adam777 Posted February 14, 2008 Share Posted February 14, 2008 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 ... Quote Link to comment Share on other sites More sharing options...
mstein Posted February 16, 2008 Share Posted February 16, 2008 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 Quote Link to comment Share on other sites More sharing options...
adam777 Posted February 21, 2008 Share Posted February 21, 2008 ... yes existing accounts seem to be broken ... Quote Link to comment Share on other sites More sharing options...
mstein Posted February 21, 2008 Share Posted February 21, 2008 (edited) ... 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 February 21, 2008 by mstein Quote Link to comment Share on other sites More sharing options...
ohama Posted March 3, 2008 Share Posted March 3, 2008 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. Quote Link to comment Share on other sites More sharing options...
ohama Posted March 6, 2008 Share Posted March 6, 2008 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted March 7, 2008 Share Posted March 7, 2008 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? Quote Link to comment Share on other sites More sharing options...
ohama Posted March 8, 2008 Share Posted March 8, 2008 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 Quote Link to comment Share on other sites More sharing options...
extreme-gadgets Posted March 10, 2008 Share Posted March 10, 2008 2) Use a file compare program to compare the included files. Look for Code surrounded by // PWA BOF and // PWA EOF. 0703238629 ================= WHat does this mean?? HELP! Quote Link to comment Share on other sites More sharing options...
Guest Posted March 11, 2008 Share Posted March 11, 2008 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted March 11, 2008 Share Posted March 11, 2008 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted March 11, 2008 Share Posted March 11, 2008 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. Quote Link to comment Share on other sites More sharing options...
Guest Posted March 11, 2008 Share Posted March 11, 2008 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] Quote Link to comment Share on other sites More sharing options...
Guest Posted March 11, 2008 Share Posted March 11, 2008 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted March 11, 2008 Share Posted March 11, 2008 Thanks for the link i think that might be my problem One thing i dnt understand the thread. how do i change the DB Cheers Quote Link to comment Share on other sites More sharing options...
ohama Posted March 12, 2008 Share Posted March 12, 2008 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted March 12, 2008 Share Posted March 12, 2008 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. Quote Link to comment Share on other sites More sharing options...
fillthemup Posted March 16, 2008 Share Posted March 16, 2008 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. Quote Link to comment Share on other sites More sharing options...
games4gamers Posted March 23, 2008 Share Posted March 23, 2008 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? Quote Link to comment Share on other sites More sharing options...
lildog Posted March 26, 2008 Share Posted March 26, 2008 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted March 26, 2008 Share Posted March 26, 2008 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.