djmonkey1 Posted November 28, 2005 Share Posted November 28, 2005 Stew I can't thank you enough for all your help and all the countless time you've put into this for us!! Made the changes you stated above. I now have the PWA option displaying. However I have one small glitch showing up. In the table displaying PWA above the PWA checkout button this line appears "TEXT_PAYPALWPP_EC_HEADER2" screen cap below. I've found the section of login.php where this is mentioned -- <table><tr> <td class="infoboxHeading" valign="top"><b><?php echo TEXT_PAYPALWPP_EC_HEADER; ?></b> </td></tr> <tr> <td width="100%" colspan=2 valign="top" class="main"> <?php echo TEXT_PAYPALWPP_EC_HEADER2; ?></td></tr> <tr> <td width="100%" colspan=2 valign="top" class="main"><a href="<?php echo tep_href_link('ec_process.php', '', 'SSL'); ?>"> <img src="https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif" border=0></a></td></tr> <tr> <td width="100%" colspan=2 valign="top" class="main"><?php echo TEXT_PAYPALWPP_EC_BUTTON_TEXT; ?> </td> </tr></table> But my newbie eyes can't see anything wrong with it. Do you have any ideas how I can fix this part? Many Thanks -- Mindy Crikey- that's a language definition thing I never defined. In my site, in includes/languages/english/login.php I have define('TEXT_PAYPALWPP_EC_HEADER2', 'I have a PayPal account!'); But you can just change the code in login.php to say "HEADER" instead of "HEADER2" and that will work just fine. Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
Guest Posted November 28, 2005 Share Posted November 28, 2005 Thanks so much the above problem is fixed now. Just one more thing when I click on checkout for PWA the browser displays a 404 page not found. This is the file it's looking for -- https://www.bandinmyhand.com/store/FILENAME_CHECKOUT?osCsid=3975969e4a6649bd7d400a3f77c035ae I don't see this file in the v0.910 pack or in my install directory. Hitting the boards to search for it or an answer now. But thought I may catch you still on the boards if I asked about it now. Many Thanks -- Mindy Quote Link to comment Share on other sites More sharing options...
djmonkey1 Posted November 28, 2005 Share Posted November 28, 2005 (edited) Thanks so much the above problem is fixed now. Just one more thing when I click on checkout for PWA the browser displays a 404 page not found. This is the file it's looking for -- https://www.bandinmyhand.com/store/FILENAME_CHECKOUT?osCsid=3975969e4a6649bd7d400a3f77c035ae I don't see this file in the v0.910 pack or in my install directory. Hitting the boards to search for it or an answer now. But thought I may catch you still on the boards if I asked about it now. Many Thanks -- Mindy Wow- not a good day for Stew. There is no such file- references to FILENAME_CHECKOUT should not exist. In login.php, change FILENAME_CHECKOUT (around line 300) to FILENAME_ORDER_INFO. Edited November 28, 2005 by djmonkey1 Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
Guest Posted November 28, 2005 Share Posted November 28, 2005 Wow- not a good day for Stew. There is no such file- references to FILENAME_CHECKOUT should not exist. In login.php, change FILENAME_CHECKOUT (around line 300) to FILENAME_ORDER_INFO. You're my HERO!!! All is well and working great! Ran a test sale through and it worked perfectly. I'm so excited now thanks so much. Sorry that I pestered you repeatedly today. Know I'm new to the osC scene but hope it's okay to upload the tweaked login.php file to the contrib section for this. My login.php contains no extra contribs or modificatins just the straight one outta the box with all the tweaks you helped me with today. -- Mindy Quote Link to comment Share on other sites More sharing options...
djmonkey1 Posted November 28, 2005 Share Posted November 28, 2005 You're my HERO!!! All is well and working great! Ran a test sale through and it worked perfectly. I'm so excited now thanks so much. Sorry that I pestered you repeatedly today. Know I'm new to the osC scene but hope it's okay to upload the tweaked login.php file to the contrib section for this. My login.php contains no extra contribs or modificatins just the straight one outta the box with all the tweaks you helped me with today. -- Mindy That would be great- just be sure to identify it as being for use with PWA and WPP together. Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
Guest Posted November 28, 2005 Share Posted November 28, 2005 Released an updated version of Stew's v0.910 for using WPP and PWA together. http://www.oscommerce.com/community/contributions,355 Contains the same version and files v0.910 for combined use of WPP and PWA together as released by djmonkey1 on 11-06-2005. With added tweaks to the extras/wpp/catalog/login.php file to make them work seamlessly together. Make sure to read the instructions to use both contributions together in extras/wpp. Thanks to Stew this is working perfectly on my store tested and double checked before adding the update. -- Mindy Quote Link to comment Share on other sites More sharing options...
mr_absinthe Posted November 28, 2005 Share Posted November 28, 2005 Hi, I wonder if you could help me a little bit as my PHP knowledge is still bit limited. I was using v0.82 and updated to v0.910 thus merged contents of includes/login_pwa.php into login.php - no problem there. However because I use CCGV on my site, I had this bit of code in includes/login_pwa.php //Detect if there is a gift voucher in the basket $voucher_in_basket = false; foreach ($cart->contents as $prod_id=>$params) { $mod_q = "select * from products where products_id = '" . $prod_id . "'"; $mod_res = tep_db_query($mod_q); $mod_row = tep_db_fetch_array($mod_res); $model_code = $mod_row['products_model']; if (substr($model_code,0,4) == 'GIFT') $voucher_in_basket=true; } //End CCGV Code if (($cart->count_contents() > 0) && (!isset($HTTP_GET_VARS['my_account_f']) || $HTTP_GET_VARS['my_account_f'] !=1) && (!$voucher_in_basket)) // only display of box if something in cart I didn't want to offer PWA if GIFT was in the basket. However I'am unable to find the correct place in new login.php for this bit of code - no matter where I insert it, the PWA box is still displayed. I guess it has to be around $cart->count_contents() > 0 somewhere... Thanks alot. Alex Quote Absinthe Original Liquor Store Link to comment Share on other sites More sharing options...
djmonkey1 Posted November 28, 2005 Share Posted November 28, 2005 Has anyone tried the new version by IngoPhisto? It looks interesting. Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
Guest Posted November 28, 2005 Share Posted November 28, 2005 Has anyone tried the new version by IngoPhisto? It looks interesting. I would love to but I am timid :( since it's not all in english. Quote Link to comment Share on other sites More sharing options...
Guest Posted November 28, 2005 Share Posted November 28, 2005 Hello, I'm sorry if this has been asked before but I can't seem to find anything on it. I am trying to install the "Purchase without Account" and have come to a point where it tells you to "Go into your server's backend and use a SQL tool such as PHPMYADMIN to run the following SQL scripts. " I am not sure how to do that. I have never used the phpmyadmin and don't know where to start. Can anyone help me please. Thank you, Jay d Quote Link to comment Share on other sites More sharing options...
cdickson Posted November 28, 2005 Share Posted November 28, 2005 Hello, I'm sorry if this has been asked before but I can't seem to find anything on it. I am trying to install the "Purchase without Account" and have come to a point where it tells you to "Go into your server's backend and use a SQL tool such as PHPMYADMIN to run the following SQL scripts. " I am not sure how to do that. I have never used the phpmyadmin and don't know where to start. Can anyone help me please. Thank you, Jay d Easy stuff, jay d: Login to PHPMyAdmin Click on the SQL tab (sometimes you have to first click on a table in the left column for the SQL tab to show) Copy all of the text that is in the pwa_install.sql file Paste it into the SQL text field (titled "Run SQL query/queries on database yourdatabasename" or similar) Click Go Taa daaaah! You're done. Quote cdickson Link to comment Share on other sites More sharing options...
Guest Posted November 28, 2005 Share Posted November 28, 2005 I would love to but I am timid :( since it's not all in english. Nevermind I just have to look a little harder, it's all there not a problem. sorry. Quote Link to comment Share on other sites More sharing options...
Guest Posted November 28, 2005 Share Posted November 28, 2005 Thank you for your help. I did that and it said it was successful. Do I have to do anything else after that or do I just close myphpadmin and I'm done? Jay d Quote Link to comment Share on other sites More sharing options...
Guest Posted November 29, 2005 Share Posted November 29, 2005 Sorry for the spamming, but I have to try posting this again in case someone's come across an answer in the last month or so. From my previous message: "I'm running PWA 0.82 using the addition from March 25 called "PWA straight to checkout", which is supposed to eliminate even the choice of creating an account. This has been working quite well. However, I've now added in manufacturers, and when you try to click on the manufacturer's home page link, it just redirects to the order page rather than the manufacturer's URL. Has anyone else encountered this?" Thanks to anyone who can help! Quote Link to comment Share on other sites More sharing options...
primadude Posted November 29, 2005 Share Posted November 29, 2005 I am using PWA v.091 and added manufacturers as a test and am not seeing any problems with the links. Perhaps someone with v0.82 could do this and see if it is a bug in that version.... Quote Link to comment Share on other sites More sharing options...
cdickson Posted November 29, 2005 Share Posted November 29, 2005 Thank you for your help. I did that and it said it was successful. Do I have to do anything else after that or do I just close myphpadmin and I'm done? Jay d You're done! Pretty slick, B) eh? All this process does is add the appropriate fields and whatever content is necessary to implement the function. The alternative is to do it manually, so I think it's very cool that the authors of the contributions provide an SQL file to save time. It also insures accuracy. :thumbsup: Quote cdickson Link to comment Share on other sites More sharing options...
Guest Posted November 29, 2005 Share Posted November 29, 2005 Thank you very much for your help. Jay d Quote Link to comment Share on other sites More sharing options...
djmonkey1 Posted November 29, 2005 Share Posted November 29, 2005 Sorry for the spamming, but I have to try posting this again in case someone's come across an answer in the last month or so. From my previous message: "I'm running PWA 0.82 using the addition from March 25 called "PWA straight to checkout", which is supposed to eliminate even the choice of creating an account. This has been working quite well. However, I've now added in manufacturers, and when you try to click on the manufacturer's home page link, it just redirects to the order page rather than the manufacturer's URL. Has anyone else encountered this?" Thanks to anyone who can help! I'm not quite sure what this means, but I can't see how this function would be affected by PWA. How does the website know what the manufacturer's website address is? Perhaps this information is malformed or missing. Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
Guest Posted November 29, 2005 Share Posted November 29, 2005 I have added the PWA contribution and I am now getting the following error when I try to create a new account. What do I need to fix? 1054 - Unknown column 'purchased_without_account' in 'field list' select customers_id, customers_email_address, purchased_without_account from customers where customers_email_address = '****' [TEP STOP] Thanks Jay d Quote Link to comment Share on other sites More sharing options...
cdickson Posted November 29, 2005 Share Posted November 29, 2005 I have added the PWA contribution and I am now getting the following error when I try to create a new account. What do I need to fix? 1054 - Unknown column 'purchased_without_account' in 'field list' select customers_id, customers_email_address, purchased_without_account from customers where customers_email_address = '****' [TEP STOP] Thanks Jay d This means that somehow that field didn't get added when you ran your SQL command earlier. Which version of PWA are you installing? I have added the PWA contribution and I am now getting the following error when I try to create a new account. What do I need to fix? 1054 - Unknown column 'purchased_without_account' in 'field list' select customers_id, customers_email_address, purchased_without_account from customers where customers_email_address = '****' [TEP STOP] Thanks Jay d Actually I just checked the documentation and it doesn't matter which version - the SQL commands are the same. When you ran it earlier, did you make sure that all 4 commands were run? You don't have to do them individually, but all 4 must be included. The commands are: ALTER TABLE customers ADD purchased_without_account TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER customers_id; ALTER TABLE customers ADD INDEX (purchased_without_account); INSERT INTO configuration_group VALUES (40, 'Accounts', 'Configuration of Account settings', 40, 1); INSERT INTO configuration VALUES ('', 'Purchase Without Account', 'PWA_ON','true','Allow Customers to purchase without an account', 40, 1, '2003-04-08 13:07:44', '2003-04-08 12:10:51', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'); ALTER TABLE orders ADD purchased_without_account TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL; Quote cdickson Link to comment Share on other sites More sharing options...
Guest Posted November 29, 2005 Share Posted November 29, 2005 Hi, I am pretty sure I processed the whole thing. Is there a way to check? Quote Link to comment Share on other sites More sharing options...
cdickson Posted November 29, 2005 Share Posted November 29, 2005 Hi, I am pretty sure I processed the whole thing. Is there a way to check? Go into your PHP MyAdmin and look at the tables. Based on your SQL command you can view and analyze. Your error message indicates that you are missing a field called purchased_without_account. The first SQL command reads ALTER TABLE customers ADD purchased_without_account TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER customers_id; which means that your customers table should have this field. The last SQL command reads ALTER TABLE orders ADD purchased_without_account TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL; so there should be a purchased_without_account field in your orders table as well. If one of them is missing, run the SQL command for the table that is missing that field. Quote cdickson Link to comment Share on other sites More sharing options...
Guest Posted November 29, 2005 Share Posted November 29, 2005 Okay, I have a purchased without account in the fields column in both the customers and orders tables and it seems that everything is included in it. In the first command it says NOT NULL AFTER customers_id;. Should something have changed here? Thanks I checked the other two commands for configuration and configuration_groups and I don't see the information in there. Is it this that may be missing? Quote Link to comment Share on other sites More sharing options...
djmonkey1 Posted November 30, 2005 Share Posted November 30, 2005 Okay, I have a purchased without account in the fields column in both the customers and orders tables and it seems that everything is included in it. In the first command it says NOT NULL AFTER customers_id;. Should something have changed here? Thanks I checked the other two commands for configuration and configuration_groups and I don't see the information in there. Is it this that may be missing? Are you still getting errors? Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
Guest Posted November 30, 2005 Share Posted November 30, 2005 (edited) "I'm running PWA 0.82 using the addition from March 25 called "PWA straight to checkout", which is supposed to eliminate even the choice of creating an account. This has been working quite well. However, I've now added in manufacturers, and when you try to click on the manufacturer's home page link, it just redirects to the order page rather than the manufacturer's URL. Has anyone else encountered this?" I'm not quite sure what this means, but I can't see how this function would be affected by PWA. How does the website know what the manufacturer's website address is? Perhaps this information is malformed or missing. Well, it's not PWA alone - I think it's the "PWA straight to checkout" addon. It heavily modifies the redirect.php file, which also seems to be used in generating the manufacturer home page links (these are generated from the manufacturer info put into admin, and the info is all there and complete). I just haven't been able to figure out exactly how... Edited November 30, 2005 by teleute 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.