mghay Posted September 9, 2009 Share Posted September 9, 2009 (edited) I've encountered a problem where a registered customer can see the order of the previous customer that did not create an account in the account_history.php. <snip> = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.public_flag = '1' order by orders_id DESC"; //EOF PWA Hi Paul, I have just used PWA autoinstaller 2.14 (30 June version) and the code in account_history.php does not appear to be amended. Have you used this version or an older one and should I now add this code (testing does not seem to reveal the problems you have)? Mike Edited September 9, 2009 by mghay Quote Link to comment Share on other sites More sharing options...
mghay Posted September 9, 2009 Share Posted September 9, 2009 (edited) I think there is a problem for returning customers on the Billing and Shipping Information page. PWA autoinstaller 2.14 seems to have worked OK, but for a returning customer, the email address box produces an error report (as for a new account) when an existing email address is entered. OK for new account situation but a pwa returning customer still has his previous email address and this should be acceptable on this page. Any ideas on how to solve this? Thks Mike Edited September 9, 2009 by mghay Quote Link to comment Share on other sites More sharing options...
cLin Posted September 21, 2009 Share Posted September 21, 2009 Has anyone been able to get country state selector and PWA to work correctly? The normal create account page works perfectly, it's just that if I want to checkout as a guest, the country state selector mod doesn't work. carol0611 1 Quote Link to comment Share on other sites More sharing options...
drumer979 Posted October 9, 2009 Share Posted October 9, 2009 Hello Problem in the 'includes/column_right.php' file. My column_right.php is : <?php /* $Id: column_right.php,v 1.15 2002/03/13 13:52:20 lango Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Released under the GNU General Public License */ $column_query = tep_db_query('select configuration_column as cfgcol, configuration_title as cfgtitle, configuration_value as cfgvalue, configuration_key as cfgkey, box_heading from ' . TABLE_THEME_CONFIGURATION . ' order by location'); while ($column = tep_db_fetch_array($column_query)) { $column['cfgtitle'] = str_replace(' ', '_', $column['cfgtitle']); $column['cfgtitle'] = str_replace("'", '', $column['cfgtitle']); if (($column[cfgvalue] == 'yes') && ($column[cfgcol] == 'right')) { define($column['cfgkey'], $column['box_heading']); if (file_exists(DIR_WS_BOXES . $column['cfgtitle'] . '.php')) { require(DIR_WS_BOXES . $column['cfgtitle'] . '.php'); } } } ?> and I cant replace if (tep_session_is_registered('customer_id')) include(DIR_WS_BOXES . 'order_history.php'); becouse I dont have this. thx, drumer Quote Link to comment Share on other sites More sharing options...
edukes Posted October 11, 2009 Share Posted October 11, 2009 I installed this mod and thought everything was working until I clicked on an order in the admin section. I re-checked the installation and ran the sql files. Here's the error: 1054 - Unknown column 'customers_dummy_account' in 'field list' select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, customers_dummy_account, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '1838' [TEP STOP] Is this the issue with the 'join' where you need to put a '(' after "from" and a ')' before "join"? TIA Quote Link to comment Share on other sites More sharing options...
Guest Posted October 11, 2009 Share Posted October 11, 2009 PWA_0.90 still works. Quote Link to comment Share on other sites More sharing options...
Guest Posted October 14, 2009 Share Posted October 14, 2009 (edited) Sorry this has been fixed, didn't know how to delete the post Can someone tell me what is going on here: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 'email_address_here'' at line 1 select count(*) as total from customerswhere customers_email_address = 'email_address_here' NOTE: 'email_address_here' was added instead of the customer's email address to prevent any span Thank in Advance! Ricardo Dacosta Edited October 14, 2009 by ricardodacosta Quote Link to comment Share on other sites More sharing options...
Guest Posted November 1, 2009 Share Posted November 1, 2009 Hi, I have just installed this mod. And i seem to be getting one or two problems, This shop has had a few mods installed, so reverting to a fresh installation is not the case. This shop also has a template purchased from template monsters, so some of the mods can be quite difficult, my problem as is below: 1) A customer gets to the checkout process page after entering there "Billing & Shipping" information on create_account.php 2) The customer is then redirected to checkout_process.php to which the below errors are shown: Warning: Cannot modify header information - headers already sent by (output started at */shop/includes/languages/english/checkout_process.php:31) in */shop/includes/functions/general.php on line 33 I have reviewed both called files to not find any errors, also i have reverted back the original checkout_process.php pages and the same error appears, general.php remained untouched. So this indicates that it was a previous hacked file, or the following: */shop/checkout_confirmation.php */shop/checkout_process.php */shop/checkout_success.php */shop/create_account.php */shop/login.php */shop/logoff.php */shop/admin/orders.php */shop/admin/includes/classes/order.php */shop/includes/application_top.php */shop/includes/column_right.php */shop/includes/form_check.js.php */shop/includes/header.php */shop/includes/classes/order.php */shop/includes/languages/english/checkout_process.php */shop/includes/languages/english/create_account.php */shop/includes/languages/english/login.php This is a live shop - so i am desperate to resolve quickly. The lines from the called files are below: #checkout_process.php <? // PWA BOF define('EMAIL_WARNING', 'ATTENTION: This email address was given to us by someone who visited our online store. If this was not done by you please email us at ' . STORE_OWNER_EMAIL_ADDRESS . ' Thank you for shopping with us and have a great day.'); // PWA EOF define('EMAIL_TEXT_SUBJECT', 'Order Process'); define('EMAIL_TEXT_ORDER_NUMBER', 'Order Number:'); define('EMAIL_TEXT_INVOICE_URL', 'Detailed Invoice:'); define('EMAIL_TEXT_DATE_ORDERED', 'Date Ordered:'); define('EMAIL_TEXT_PRODUCTS', 'Products'); define('EMAIL_TEXT_SUBTOTAL', 'Sub-Total:'); define('EMAIL_TEXT_TAX', 'Tax: '); define('EMAIL_TEXT_SHIPPING', 'Shipping: '); define('EMAIL_TEXT_TOTAL', 'Total: '); define('EMAIL_TEXT_DELIVERY_ADDRESS', 'Delivery Address'); define('EMAIL_TEXT_BILLING_ADDRESS', 'Billing Address'); define('EMAIL_TEXT_PAYMENT_METHOD', 'Payment Method'); define('EMAIL_SEPARATOR', '------------------------------------------------------'); define('TEXT_EMAIL_VIA', 'via'); ?> #general.php function tep_redirect($url) { if ( (strstr($url, "\n") != false) || (strstr($url, "\r") != false) ) { tep_redirect(tep_href_link(FILENAME_DEFAULT, '', 'NONSSL', false)); } if ( (ENABLE_SSL == true) && (getenv('HTTPS') == 'on') ) { // We are loading an SSL page if (substr($url, 0, strlen(HTTP_SERVER)) == HTTP_SERVER) { // NONSSL url $url = HTTPS_SERVER . substr($url, strlen(HTTP_SERVER)); // Change it to SSL } } header('Location: ' . $url); tep_exit(); } Any help would be appreciated. Gareth Rees Quote Link to comment Share on other sites More sharing options...
occybercafe Posted November 4, 2009 Share Posted November 4, 2009 Hello... hope someone can help with my problem. I have a storefront with PWA contribution installed..... decided to install a paid for iphone template hoping it would intergrate the contributions currently installed on storefront.... the iphone template hasn't picked up the purchase without account at all. I don't have php experience and really hope someone might be able to guide me in the right direction as to what I need to change to make PWA work on my mobile store... The mobile store is a subdirectory of the main store. So it pulls and works from the main storefront. Any help here would be greatly appreciated! Thanks in advance. Quote Link to comment Share on other sites More sharing options...
freckles Posted November 9, 2009 Share Posted November 9, 2009 Newbie Question installed this addon and followed all the steps to the T... uploaded the files to my site. The PWA Functionality is awesome... but suddenly when i go to my admin panel (admin/login.php) i get this error: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'mysql'@'localhost' (using password: NO) in /home/nicho14/public_html/store/admin/includes/functions/database.php on line 19 Unable to connect to database server! I did not have this problem before i installed this addon and i didnt modify the database.php... so am at a loss. please reply with suggestions or if you need more info from me... Quote Link to comment Share on other sites More sharing options...
carol0611 Posted November 9, 2009 Share Posted November 9, 2009 Has anyone been able to get country state selector and PWA to work correctly? The normal create account page works perfectly, it's just that if I want to checkout as a guest, the country state selector mod doesn't work. Hi, I'm having the same issue. Did you ever resolve it? Thanks! Carol Quote Link to comment Share on other sites More sharing options...
Envelo Posted January 9, 2010 Share Posted January 9, 2010 Hello, i have installed it but i have a quuestion, when the people use the PWA but don't finaly the purchase and don't logoff, the account don't delete any1 have any solution Thank you Quote Link to comment Share on other sites More sharing options...
cheloman09 Posted January 19, 2010 Share Posted January 19, 2010 I installed this contrib on my store. Everything seems fine until a customer tries to buy a digital/download product. I have a digital store and the problem is that the customer pays for the item succesfully and when he clicks on the file link to download the file, he gets a blank screen. If the customer creates an account he can normally download the file. Im only getting this error when trying to purchase without account. Please help me, im really stuck here Quote Link to comment Share on other sites More sharing options...
cheloman09 Posted January 21, 2010 Share Posted January 21, 2010 Please somebody help! Quote Link to comment Share on other sites More sharing options...
Munchies Posted January 25, 2010 Share Posted January 25, 2010 I installed this contrib on my store. Everything seems fine until a customer tries to buy a digital/download product. I have a digital store and the problem is that the customer pays for the item succesfully and when he clicks on the file link to download the file, he gets a blank screen. If the customer creates an account he can normally download the file. Im only getting this error when trying to purchase without account. Please help me, im really stuck here OSC is checking customer_id but with PWA no customer_id is set. (Email address works is an alternative) Look in download.php after: // Check that order_id, customer_id and filename match, Quote Link to comment Share on other sites More sharing options...
Munchies Posted January 25, 2010 Share Posted January 25, 2010 Installed PWA 2.1b: When someone would click checkout and slide there mouse over the table image, the alt text of "Account Information" was being shown. Not a big problem, but confusing people into thinking they were creating an account. instructions for create_account.php should be updated to read: ***FIND: <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_account.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> ****Replace with: // PWA BOF if (!isset($HTTP_GET_VARS['guest']) && !isset($HTTP_POST_VARS['guest'])){ ?> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td><td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_account.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> <?php }else{ ?> <td class="pageHeading"><?php echo HEADING_TITLE_PWA; ?></td><td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_account.gif', HEADING_TITLE_PWA, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> <?php } // PWA EOF This also allows for a Guest account image to be displayed; just change the second 'table_background_account.gif' to 'table_background_account_PWA.gif' after you upload a new image, named 'table_background_account_PWA.gif'. Will be back when I get the download without account working (DWA 1.0beta) Quote Link to comment Share on other sites More sharing options...
longhorn1999 Posted January 27, 2010 Share Posted January 27, 2010 Is anyone else experiencing the login/create account going to index.php? lildog Hi, I know this post is from a while ago but I'm having exactly this problem. Existing customers or new customers who create an account are sent back to index.php, even if there's something in the cart. Did something get messed up using the autoinstaller perhaps or am I missing something else? Thanks, Nick Quote Link to comment Share on other sites More sharing options...
longhorn1999 Posted January 29, 2010 Share Posted January 29, 2010 Hi, I know this post is from a while ago but I'm having exactly this problem. Existing customers or new customers who create an account are sent back to index.php, even if there's something in the cart. Did something get messed up using the autoinstaller perhaps or am I missing something else? Thanks, Nick Ok this maybe was even an issue in the stock layout but this post helped me fix my problem: http://www.oscommerce.com/forums/topic/349458-when-customer-signs-in-go-to-cart/page__p__1460619__hl__login%20to%20indexphp__fromsearch__1entry1460619 Basically I edited create_account_success and login.php so that when the cart isn't empty, customers go to checkout_shipping instead of index.php. Quote Link to comment Share on other sites More sharing options...
Michał Korzeniowski Posted February 12, 2010 Share Posted February 12, 2010 (edited) Hi,the script works great but I'm having some problems. The script shows only for example: TEXT_GUEST_INTRODUCTION instead of defined value(Hi,bla,bla,bla) which was written in the .xml. Any one knows how to change it? Edited February 12, 2010 by Michał Korzeniowski Equalizer 1 Quote Link to comment Share on other sites More sharing options...
lindendesign Posted April 24, 2010 Share Posted April 24, 2010 Hi there. I installed this mod to my cart and everything seemed to be working ok, other than when a registered customer logs in and uses the 'My Account' link. For some reason it just goes to the Shopping Cart instead of the account area. Has anyone else experienced this? If so, how can I solve it? Thanks, Craig Quote Craig Shaw Linden Design Link to comment Share on other sites More sharing options...
Guest Posted May 26, 2010 Share Posted May 26, 2010 i have SPPC 4.2.2 installed and i was trying to install PWA but there were a couple of files that the code conflicted with the SPPC i was wondering if anyone can give me some advice on how to do this as im sure it can be done i stopped editing files because my shop is live and i dont want to mess with it until i know it will work without creating any huge problems Quote Link to comment Share on other sites More sharing options...
Guest Posted July 15, 2010 Share Posted July 15, 2010 I was directed to this Add-on, and it looks to be what I need. The problem: The documentation from the download package is in French. Is there any English documentation for v2.1 or do I have to figure out (or guess) the French translation? I've already put in close to 50 hours and I'm still probably close to 250 away from being able to launch the cart, so learning words in a new language really isn't on my to-do list. I'm close to just giving up on osCommerce because whoever said "you don't need to know programming to use it" (which is how I was sold on using it) is the biggest liar to ever exist. Quote Link to comment Share on other sites More sharing options...
BryceJr Posted July 15, 2010 Share Posted July 15, 2010 I was directed to this Add-on, and it looks to be what I need. The problem: The documentation from the download package is in French. Is there any English documentation for v2.1 or do I have to figure out (or guess) the French translation? I've already put in close to 50 hours and I'm still probably close to 250 away from being able to launch the cart, so learning words in a new language really isn't on my to-do list. I'm close to just giving up on osCommerce because whoever said "you don't need to know programming to use it" (which is how I was sold on using it) is the biggest liar to ever exist. Click >>here. Pick the "AutoInstaller 2.14 for Purchase Without Account v2.1 --- 30 Jun 2009" download. If that doesn't work (read complaints about autoinstallers) use "Purchase Without Account v2.1 - FullPackage --- 9 Mar 2009" download. Quote Link to comment Share on other sites More sharing options...
rpdesign Posted July 19, 2010 Share Posted July 19, 2010 (edited) Hi all, I guess i don't have the time to look through 98 pages of his forum to see if this question has been answered, :blink: but i have loaded up the pwa ver 2.1 as suggested and installed it ok however when the customer just wants to check out my site looks funky check it out here This is a test site that i have set up to test add-ons before adding to my live website. It also helps in developing add-ons :thumbsup: This tip is easy : If your hosting company allows it, set up oscommerce on a subdomain called test or something else. Either that or use a free host for your test site. But anyhow back to my problem, it comes when the customer is required to enter in their info for billing. it works ok, but looks horrible. :'( Edited July 19, 2010 by rpetet Quote Always backup your files! You will be glad you didMy add-ons :SSPP Seperate Shipping Per Product v2.5| SupportGift vouchers for SPPC 4.22 v2.1 | Support |Catalog Infobox v1.0 | Sorry no support for Catalog Infobox |HTML Mail v2.0 | Support |Upcoming Add ons:Addon Manager | Separate Pricing Per Product Qty |Coupon Populate | EZ-PDF Catalog Link to comment Share on other sites More sharing options...
rpdesign Posted July 19, 2010 Share Posted July 19, 2010 ok so i just loaded up all the default files in the package and now it looks as well as behaves properly :lol: Unfortunately I have several other add ons to deal with on my live site and the install guide is long and tedius. It might be usefull to add a line of text on how to find the line of the code that needs to be replaced. :-" Quote Always backup your files! You will be glad you didMy add-ons :SSPP Seperate Shipping Per Product v2.5| SupportGift vouchers for SPPC 4.22 v2.1 | Support |Catalog Infobox v1.0 | Sorry no support for Catalog Infobox |HTML Mail v2.0 | Support |Upcoming Add ons:Addon Manager | Separate Pricing Per Product Qty |Coupon Populate | EZ-PDF Catalog 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.