steve_s Posted October 2, 2010 Share Posted October 2, 2010 thanks steve, i updated the files and sql. do not i have to do any other amendments to upgrade from 1.3 to 1.4? i have one question. when going to the checkout process if i log in it seems to work fine but when i do not log in after putting all info ie address and so on i get this message "shipping selection error" "Must select a shipping method". the trouble is that there is no shipping method to be selected. i use TABLE RATE (bes tway) this problems was also present before the update thanks valeri Hi Valeri no other changes are needed to be made, for now set require login to be true, it should offer that shipping option after address details enetered reupload making sure overwrite is selected Steve Quote Link to comment Share on other sites More sharing options...
WirthWeb Posted October 3, 2010 Share Posted October 3, 2010 I have tried searching this thread but I didn't see anything about sorting products. Is there anyway to sort products via the product name? Thanks for any assistance. Ed Quote Link to comment Share on other sites More sharing options...
steve_s Posted October 3, 2010 Share Posted October 3, 2010 I have tried searching this thread but I didn't see anything about sorting products. Is there anyway to sort products via the product name? Thanks for any assistance. Ed Hi Ed on the checkout page, where it lists the products in cart? should be possible although i cant see where the select is to add order by product_name Steve Quote Link to comment Share on other sites More sharing options...
WirthWeb Posted October 4, 2010 Share Posted October 4, 2010 Hi Ed on the checkout page, where it lists the products in cart? should be possible although i cant see where the select is to add order by product_name Steve On includes/classes/shopping_cart.php there are these lines, which is where I believe the search comes from around line 315 (mine is already slightly modified): $products_array = array(); reset($this->contents); while (list($products_id, ) = each($this->contents)) { $products_query = tep_db_query("select p.products_id, pd.products_name, p.product_description, p.products_unit_price, p.products_name, p.units, p.thumb, p.products_image, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$products_id . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' ORDER by pd.products_name"); if ($products = tep_db_fetch_array($products_query)) { $prid = $products['products_id']; $products_price = $products['products_price']; $specials_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int)$prid . "' and status = '1'"); if (tep_db_num_rows($specials_query)) { $specials = tep_db_fetch_array($specials_query); $products_price = $specials['specials_new_products_price']; } $products_array[] = array('id' => $products_id, 'name' => $products['products_name'], 'description' => $products['product_description'], 'units_price' => $products['products_unit_price'], 'image' => $products['products_image'], 'thumb' => $products['thumb'], 'units' => $products['units'], 'price' => $products_price, 'quantity' => $this->contents[$products_id]['qty'], 'final_price' => ($products_price + $this->attributes_price($products_id)), 'tax_class_id' => $products['products_tax_class_id'], 'attributes' => (isset($this->contents[$products_id]['attributes']) ? $this->contents[$products_id]['attributes'] : '')); } } return $products_array; } I added an "order by pd.products_name"; however, that didn't seem to work...is there somewhere else I may be missing? Quote Link to comment Share on other sites More sharing options...
dreaminggates Posted October 5, 2010 Share Posted October 5, 2010 (edited) I've found a problem while testing the "One Page Checkout" module. Can someone please help me to fix it? (I am running OPC v.1.4 with the corrected SQL from 1.3 and paypal_standard.php manually added, to fix problems.) How to recreate the problem: 1.) Use Internet Explorer 8 and shop without logging in. (my cart, for reference, is located here: http://dreaminggates.com/catalog ) 2.) Put any item(s) into the shopping cart and click "Check Out" button. 3.) Enter any name in the first and last name area, then enter "test@test.com" into the email address. 4.) The system will prompt you that "test@test.com" is taken, please log in or use a different address. 5.) Go back into the email field, backspace over the last "m" then retype it and hit tab (so that you are insisting on using "test@test.com" for your email address). EDIT: actually I have found that this problem occurs even without step #5. 6.) IE will lock up and, after a few minutes, the error message will pop up: "a script is causing Internet Explorer to run slowly" blah blah. Pressing either yes, stop the script or no, don't stop the script, has no effect. Can anyone else please recreate this and, if possible, help me find a solution? Thank you :) Edited October 5, 2010 by dreaminggates Quote Link to comment Share on other sites More sharing options...
sumitson Posted October 5, 2010 Share Posted October 5, 2010 Nice contribution, I have messed around with it for a week now - but with so many bugs as STS compatibility issues, login problems, discount coupon issues calculation issues and the applications own features not working well and no support from the contributor OnePage Checkout should not be used on live shops. I have fixed several issues by myself but there are still many things buried deep inside js. I will wait until a updated version with bug fixes for all those issues is available and will give it another try then. Cheers Roland Yes I agree. It has numerous issues throughout. Not sure how anyone can release this out for distribution. Code is difficult to grasp and quirky when changed. A better version from the creator of OPC will be appreicated. Otherwise, better not to use it. Quote Link to comment Share on other sites More sharing options...
sehwm Posted October 5, 2010 Share Posted October 5, 2010 I am sure this issue has been discussed before and I am sorry for this kind of dumb question. I installed a fresh copy of oscommerce RC2.2 with STS. OPC installed, but when I click at login box, box doesn't appear. Also nothing happens when I click at "Change Shipping Address". Can some one help me on this. I am running OPV 1.4 Quote Link to comment Share on other sites More sharing options...
steve_s Posted October 5, 2010 Share Posted October 5, 2010 (edited) On includes/classes/shopping_cart.php there are these lines, which is where I believe the search comes from around line 315 (mine is already slightly modified): I added an "order by pd.products_name"; however, that didn't seem to work...is there somewhere else I may be missing? Hi im sure its this file includes/checkout/cart.php but where i have no idea one you selected will do normal shopping cart Steve Edited October 5, 2010 by steve_s Quote Link to comment Share on other sites More sharing options...
steve_s Posted October 5, 2010 Share Posted October 5, 2010 I've found a problem while testing the "One Page Checkout" module. Can someone please help me to fix it? (I am running OPC v.1.4 with the corrected SQL from 1.3 and paypal_standard.php manually added, to fix problems.) How to recreate the problem: 1.) Use Internet Explorer 8 and shop without logging in. (my cart, for reference, is located here: http://dreaminggates.com/catalog ) 2.) Put any item(s) into the shopping cart and click "Check Out" button. 3.) Enter any name in the first and last name area, then enter "test@test.com" into the email address. 4.) The system will prompt you that "test@test.com" is taken, please log in or use a different address. 5.) Go back into the email field, backspace over the last "m" then retype it and hit tab (so that you are insisting on using "test@test.com" for your email address). EDIT: actually I have found that this problem occurs even without step #5. 6.) IE will lock up and, after a few minutes, the error message will pop up: "a script is causing Internet Explorer to run slowly" blah blah. Pressing either yes, stop the script or no, don't stop the script, has no effect. Can anyone else please recreate this and, if possible, help me find a solution? Thank you :) Hi if you goto normal login are you able to login ? Steve Quote Link to comment Share on other sites More sharing options...
sehwm Posted October 5, 2010 Share Posted October 5, 2010 I am sure this issue has been discussed before and I am sorry for this kind of dumb question. I installed a fresh copy of oscommerce RC2.2 with STS. OPC installed, but when I click at login box, box doesn't appear. Also nothing happens when I click at "Change Shipping Address". Can some one help me on this. I am running OPV 1.4 I found a solution on these pages and resolved this issue Quote Link to comment Share on other sites More sharing options...
Gonzola Posted October 6, 2010 Share Posted October 6, 2010 I have one very strange problem, my OPC is very slow...it takes forever for the loading window to show the billing and shipment options after customer fill in their name and adress fields and also shows the checkout button in the end, frustrating and many customers leaves before closing order How can i speed this up, is there any settings i can do I read something about cache and session settings All advice is helpful Quote Link to comment Share on other sites More sharing options...
verngren Posted October 6, 2010 Share Posted October 6, 2010 Hello. Having some issues to use this contrib with Quantity Pro. The errors im getting are: Warning: Missing argument 3 for tep_check_stock(), called in /storage/content/90/108490/sexigtunder.se/public_html/includes/checkout/cart.php on line 14 and defined in /storage/content/90/108490/sexigtunder.se/public_html/includes/functions/general.php on line 131 The function tep_check_stock is: function tep_check_stock($products_id,$products_attributes_id, $products_quantity) { $stock_left = tep_get_products_stock($products_id, $products_attributes_id) - $products_quantity; The line i have issue with on one_page_checkout is: function checkStock(){ global $cart; $products = $cart->get_products(); for ($i=0, $n=sizeof($products); $i<$n; $i++) { if (tep_check_stock($products[$i]['id'], $products[$i]['quantity'])) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART)); break; } } } If i instead use: if (tep_check_stock($products[$i]['id'],$products[$i][$option]['products_attributes_id'], $products[$i]['quantity'])) { All that happens is i get redirected, although im not out of stock on that item.. Pls advise :) Quote Link to comment Share on other sites More sharing options...
steve_s Posted October 6, 2010 Share Posted October 6, 2010 I have one very strange problem, my OPC is very slow...it takes forever for the loading window to show the billing and shipment options after customer fill in their name and adress fields and also shows the checkout button in the end, frustrating and many customers leaves before closing order How can i speed this up, is there any settings i can do I read something about cache and session settings All advice is helpful Hi recheck install, in checkout.php change any calls to javascript files to fixed ie adding http://yoursite.com before the folder Steve Quote Link to comment Share on other sites More sharing options...
steve_s Posted October 6, 2010 Share Posted October 6, 2010 (edited) Hello. Having some issues to use this contrib with Quantity Pro. The errors im getting are: Warning: Missing argument 3 for tep_check_stock(), called in /storage/content/90/108490/sexigtunder.se/public_html/includes/checkout/cart.php on line 14 and defined in /storage/content/90/108490/sexigtunder.se/public_html/includes/functions/general.php on line 131 The function tep_check_stock is: function tep_check_stock($products_id,$products_attributes_id, $products_quantity) { $stock_left = tep_get_products_stock($products_id, $products_attributes_id) - $products_quantity; The line i have issue with on one_page_checkout is: function checkStock(){ global $cart; $products = $cart->get_products(); for ($i=0, $n=sizeof($products); $i<$n; $i++) { if (tep_check_stock($products[$i]['id'], $products[$i]['quantity'])) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART)); break; } } } If i instead use: if (tep_check_stock($products[$i]['id'],$products[$i][$option]['products_attributes_id'], $products[$i]['quantity'])) { All that happens is i get redirected, although im not out of stock on that item.. Pls advise :) hi try changing this if (tep_check_stock($products[$i]['id'], $products[$i]['quantity'])) { to this if (tep_check_stock($products[$i]['id'],$products[$i][$option]['products_attributes_id'], $products[$i]['quantity']) <=0) { or if above gives an error if ((tep_check_stock($products[$i]['id'],$products[$i][$option]['products_attributes_id'], $products[$i]['quantity'])) <=0) { Edited October 6, 2010 by steve_s Quote Link to comment Share on other sites More sharing options...
kalcable Posted October 7, 2010 Share Posted October 7, 2010 Hello, I know people have had this problem and seems to not be fixed. I have credit card with cvv2 but the text input fields do not show. I was able to make it so they would but only if you refreshed the page. Also a few times they would show up until all the areas loaded (shipping and Order Total) and then it would go back to having no text fields. Does anyone know how to make the text fields show up again? Thank you Quote Link to comment Share on other sites More sharing options...
steve_s Posted October 7, 2010 Share Posted October 7, 2010 Hello, I know people have had this problem and seems to not be fixed. I have credit card with cvv2 but the text input fields do not show. I was able to make it so they would but only if you refreshed the page. Also a few times they would show up until all the areas loaded (shipping and Order Total) and then it would go back to having no text fields. Does anyone know how to make the text fields show up again? Thank you try adding in function confirmation() add $_POST or $HTTP_VAR_POST; to end of global $order ie global $order, $_POST; Steve Quote Link to comment Share on other sites More sharing options...
kalcable Posted October 7, 2010 Share Posted October 7, 2010 Ok thanks, I tried that but it didnt work. ine onepagecheck.php I changed /* Comment line below for oscommerce versions before MS2.2 RC2a */ $confirmation = $GLOBALS[$payment]->confirmation(); /* Uncomment line below for oscommerce versions before MS2.2 RC2a */ //$confirmation = $GLOBALS[$payment]->selection(); break; } to: /* Comment line below for oscommerce versions before MS2.2 RC2a */ //$confirmation = $GLOBALS[$payment]->confirmation(); /* Uncomment line below for oscommerce versions before MS2.2 RC2a */ $confirmation = $GLOBALS[$payment]->selection(); break; } when i did this it showed but an error pops up saying, "There was an error setting payment method, please inform "storename" about this error. After you click ok, you can checkout successfully. Is there a way to eliminate that error message? thank you Quote Link to comment Share on other sites More sharing options...
sportstolen Posted October 7, 2010 Share Posted October 7, 2010 (edited) Hi guys, im trying to design my checkout.php Got one problem, in the top i´ve got the table_heading_products but i cant find the table for that, i belive that the table is made with this function $header = TABLE_HEADING_PRODUCTS; but how can i change that table?? I also managed to get that table split in two its hard to explain in firebug it looks like this' <tbody><tr> <td width="100%" height="14" class="infoBoxHeading">"this is wher the TABLE_HEADING_PRODUCTS is</td> <td nowrap="" height="14" class="infoBoxHeading"><img width="11" height="14" border="0" alt="" src="/shopping/shop/DIR_WS_CACHE5ec4c9bf8983b77a7afc655742c88686_11x14.gif"></td> </tr> </tbody> I dont have a clue why its prints an image in the other one :D please help EDIT: Okey so i get that its print out pixel_trans inte the corners, But where can i chang this?? Edited October 7, 2010 by sportstolen Quote Link to comment Share on other sites More sharing options...
dreaminggates Posted October 8, 2010 Share Posted October 8, 2010 Hi if you goto normal login are you able to login ? Steve Hi Steve, thank you for replying. To answer your question, yes, I can log in. The problem occurs 100% of the time when a person is not logged in (ie the system is making an account for them as they check out). Quote Link to comment Share on other sites More sharing options...
steve_s Posted October 8, 2010 Share Posted October 8, 2010 Ok thanks, I tried that but it didnt work. ine onepagecheck.php I changed /* Comment line below for oscommerce versions before MS2.2 RC2a */ $confirmation = $GLOBALS[$payment]->confirmation(); /* Uncomment line below for oscommerce versions before MS2.2 RC2a */ //$confirmation = $GLOBALS[$payment]->selection(); break; } to: /* Comment line below for oscommerce versions before MS2.2 RC2a */ //$confirmation = $GLOBALS[$payment]->confirmation(); /* Uncomment line below for oscommerce versions before MS2.2 RC2a */ $confirmation = $GLOBALS[$payment]->selection(); break; } when i did this it showed but an error pops up saying, "There was an error setting payment method, please inform "storename" about this error. After you click ok, you can checkout successfully. Is there a way to eliminate that error message? thank you What payment module are you using? it might be that now and not OPC Steve Quote Link to comment Share on other sites More sharing options...
steve_s Posted October 8, 2010 Share Posted October 8, 2010 Hi Steve, thank you for replying. To answer your question, yes, I can log in. The problem occurs 100% of the time when a person is not logged in (ie the system is making an account for them as they check out). Yet they cant login on OPC, i had this i think on 1.12 or 1.13 and decided not to upgrade i take it your not using STS? does it do it on other browsers too? Steve Quote Link to comment Share on other sites More sharing options...
steve_s Posted October 8, 2010 Share Posted October 8, 2010 Hi guys, im trying to design my checkout.php Got one problem, in the top i´ve got the table_heading_products but i cant find the table for that, i belive that the table is made with this function $header = TABLE_HEADING_PRODUCTS; but how can i change that table?? I also managed to get that table split in two its hard to explain in firebug it looks like this' <tbody><tr> <td width="100%" height="14" class="infoBoxHeading">"this is wher the TABLE_HEADING_PRODUCTS is</td> <td nowrap="" height="14" class="infoBoxHeading"><img width="11" height="14" border="0" alt="" src="/shopping/shop/DIR_WS_CACHE5ec4c9bf8983b77a7afc655742c88686_11x14.gif"></td> </tr> </tbody> I dont have a clue why its prints an image in the other one :D please help EDIT: Okey so i get that its print out pixel_trans inte the corners, But where can i chang this?? try includes/checkout/cart.php Steve Quote Link to comment Share on other sites More sharing options...
verngren Posted October 8, 2010 Share Posted October 8, 2010 hi try changing this if (tep_check_stock($products[$i]['id'], $products[$i]['quantity'])) { to this if (tep_check_stock($products[$i]['id'],$products[$i][$option]['products_attributes_id'], $products[$i]['quantity']) <=0) { or if above gives an error if ((tep_check_stock($products[$i]['id'],$products[$i][$option]['products_attributes_id'], $products[$i]['quantity'])) <=0) { Hey. I dont get any error codes. Although im getting redirects back to shopping_cart.php while having the actual items well in stock. have tried both going in there out of stock and in stock. both redirects back with no errors... Quote Link to comment Share on other sites More sharing options...
hhitch Posted October 10, 2010 Share Posted October 10, 2010 I am having the same problem with OPC "Address Errors: The confirmation password does not match the password" when the customer clicks the "continue" button to checkout. Are you saying that was solved at the URL below? Because I can't find any solution on that page. Unless you mean the person who said to roll back to 1.3 from 1.4. I would really prefer not to go to that length. I think we should solve this issue :) Please let me know if that was what you meant, or if you actually do know of a fix that was posted. thanks :) Hi the after checkout problem is solved here http://www.oscommerce.com/forums/topic/333292-one-page-checkout-support/page__view__findpost__p__1532611 as coupon i have no idea dont use that add on Steve Quote Link to comment Share on other sites More sharing options...
hhitch Posted October 10, 2010 Share Posted October 10, 2010 Ok I will post the complete issue so hopefully we can come to a solution since a few people have reported the same problem. I have installed OPC I assume it's 1.4, it's marked as such and is the latest download from http://addons.oscommerce.com/info/6646 dated 25 Aug 2010. I'm running PHP 5.3.3 in Windows Server 2003 and MySql 5 using Paypal web payments standard. In general OPC works great, except for one issue which I describe here. If the customer is not logged in and they add a product to the cart and then go to checkout, OPC loads fine. When the customer clicks on the log in button, the popup login opens up and the customer can log in, and all the tables load the correct data for shipping, addresses, payment, etc. But then when the customer clicks on the "continue" button which should take them to Paypal, this annoying javascript alert box pops up saying "Address errors: Confirmation Password doesn't match the password!" And the customer is denied from checking out (and I don't get the sale :( ) I have noticed that if the customer then browses to another page and then returns to the checkout page, this error does NOT occur again, and checkout can proceed normally. It seems only to occur when the user is forced to log in on the checkout page, some value is not transmitted to the javascript (ajax I assume) code. In fact, I did a test on the values: /catalog/includes/checkout.js if($(':password[name=password]').val() != '') { if($(':password[name=confirmation]').val() == '' || $(':password[name=confirmation]').val() != $(':password[name=password]').val() ) { // I added this to see what was going on: alert("1:" + $(':password[name=confirmation]').val() + "; 2: " + $(':password[name=password]').val() ); // end of my add errMsg += 'Confirmation password does not match the password.' + "\n"; } } my alert revealed that the value of $(':password[name=password]').val() does contain the customer's password but the value of $(':password[name=confirmation]').val() equals "undefined". I can continue to reverse-engineer this to try to get to the bottom of it but I was hoping that the developer or a developer out there might already be able to tell us exactly what is going wrong here... would sure appreciate any assistance... I have so many other bug fixes I have to get done, it would sure shorten my workload if someone out there could solve this easily. Otherwise I will keep hacking away... thanks profusely in advance.... screen shot: 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.