Jump to content

jderouen

Members
  • Content count

    62
  • Joined

  • Last visited

Profile Information

  • Real Name
    Joe DeRouen
  1. jderouen

    Is USPS shipping module down

    I seem to have gotten mine to work - I still have the ** at the end of international options, but I'll live with it for now. But this whole mess brought up an issue I've had for a while now - sometimes foreign customers will choose priority mail flat rate envelope when the product couldn't possibly fit. Is there a note I could add to checkout checkout_shipping.php or something that would only show up for foreign orders that would remind them to make sure what they're ordering will actually fit in a priority flat rate envelope? I can't figure out how to do this/where to add it. Thanks!
  2. jderouen

    USPS Methods 4.14 Stopped Working

    Where/how exactly do you add the disclaimer listed above? I added it thusly in the uspsflat.php in /includes/languages/english/modules/shipping: define('MODULE_SHIPPING_USPSFLAT_TEXT_INFO', 'IMPORTANT - PLEASE READ<BR>Dec 7, 2009 - USPS is having a problem calculating the shipping. Please choose this shipping rate and we will adjust your total before charging your card if applicable. $8.80 applies to Priority rates within the US under 1 pound. <br>Rates to other countries vary and we will contact you with the total before processing your order'); But it doesn't come up. Thanks! Joe
  3. I'm trying to install the "will call with credit card" payment module, but it isn't showing up when you checkout. It seems to need code in checkout_payment.php, but the instructions don't mention adding anything there. I have installed everything and enabled it in the admin payment modules. Thanks! Joe
  4. jderouen

    Offical Google Checkout module for osCommerce Support Thread

    Make that OsCommerce 2.2, sorry, slip of the fingers
  5. jderouen

    Offical Google Checkout module for osCommerce Support Thread

    I am trying to install Google Checkout on a heavily modified OSCommerce v1.1 and am having a devil of a time. I think I have everything set up correctly, but it just don't show up as an option, even after I have installed it as a payment module. I am trying to get away from Paypal as a credit card processor. Is there anyone out there who can help me? I will gladly pay a fair hourly rate. It is just beyond me at this point. Thanks! Joe
  6. jderouen

    [Contribution] - USPS Methods

    I realized that I ran the query twice, but that shouldn't matter, should it? The file says it just changes the shipping from lower to upper case. I ran it once, it didn't seem to do anything, so I ran it again, and after that it totally stopped working and I get this: An error occured with the USPS shipping calculations. If you prefer to use USPS as your shipping method, please contact the store owner. Can someone please help me?
  7. jderouen

    [Contribution] - USPS Methods

    I am also having the same problem. I tried running the fix in usps methods 2.9.2 upper case fix, and now it won't work at all. Does anyone know how to fix that? It stopped working once I ran the update.sql file contained in the zip: UPDATE configuration SET configuration_value = UPPER(configuration_value), set_function='tep_cfg_select_multioption(array(''GLOBAL EXPRESS'', ''GLOBAL EXPRESS NON-DOC RECT'', ''GLOBAL EXPRESS NON-DOC NON-RECT'', ''EXPRESS MAIL INT'', ''EXPRESS MAIL INT FLAT RATE ENV'', ''PRIORITY MAIL INT'', ''PRIORITY MAIL INT FLAT RATE ENV'', ''PRIORITY MAIL INT FLAT RATE BOX'', ''FIRST-CLASS MAIL INT''), ' WHERE configuration_key='MODULE_SHIPPING_USPS_TYPES_INTL'; UPDATE configuration SET configuration_value = UPPER(configuration_value), set_function='tep_cfg_select_multioption(array(''EXPRESS'', ''PRIORITY'', ''FIRST CLASS'', ''PARCEL'', ''BPM'', ''LIBRARY'', ''MEDIA''), ' WHERE configuration_key='MODULE_SHIPPING_USPS_TYPES'
  8. jderouen

    Featured 1.5

    After numerous problems, I finally got this to work - however, it put it in a little box at the top of the right column. I assume it would put it on the main page, replacing the "New Product for ...." section. Is there any way to make it do that instead? Thanks, Joe
  9. jderouen

    Featured Product Support v1.5.4

    I've installed Featured Product v1.5.8 and get this error when I try to access the mod through the admin: 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 '-500, 500' at line 1 select p.products_id, pd.products_name, s.featured_id, s.featured_date_added, s.featured_last_modified, s.expires_date, s.date_status_change, s.status from products p, featured s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -500, 500 I get this error on the main page: 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 'MAX_DISPLAY_FEATURED_PRODUCTS' at line 1 select p.products_id, p.products_image, p.products_price, p.products_tax_class_id, s.specials_new_products_price, specials_new_products_price, p.products_date_added from products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit MAX_DISPLAY_FEATURED_PRODUCTS I've went through the instructions three times, checked everything, and read everything on here, and I'm nor sure what I'm doing wrong. Thanks, Joe
  10. jderouen

    [Contribution] - USPS Methods

    I finally got this to work! Hooray! Thanks to everyone who took the time to respond and offer advice! Joe
  11. jderouen

    [Contribution] - USPS Methods

    Thanks for the advice. I just checked the tables, and they were all fine. So I guess I'm going to go the whole uninstalling/reinstalling route. Joe
  12. jderouen

    [Contribution] - USPS Methods

    This is killing me. I cannot get this to work. When a foreign customer tries to check out, this is listed under USPS: An error occured with the USPS shipping calculations. If you prefer to use USPS as your shipping method, please contact the store owner. I've done everything I've read. I opened phpmyadmin, selected the configuration table (the one entitled configuration) on the left, checked the 'set_function' field on the right side and clicked the 'change' icon over to the left of it. I set the 'TYPE' to 'TEXT', blanked out the 'Length/Value' box so that it's empty, and left the 'Null' and 'Default' settings to 'NULL'. Then I saved. It seemed to go fine. Then I applied the other update my clicking "SQL" at the top and copying it into the "Run SQL query/queries on database" box and clicking "Go." I removed usps from my shipping modules and then reinstalled it. Set the options I wanted. But it still doesn't work. Any help would be very much appreciated. Thanks, Joe
  13. jderouen

    USPS Update Problems

    Ditto, I received the same error when trying to apply changes suggested in an update on the USPS contribution.
  14. When an international customer tries to check out, it shows this under usps shipping: An error occured with the USPS shipping calculations. If you prefer to use USPS as your shipping method, please contact the store owner. I've searched the forums and have seen others having similar problems and tried to suggested fixed, but nothing works. For the life of me, I cannot get this to work. Does anyone know what to do? I even downloaded a clean usps methods 2.8d in order to make sure I hadn't inadvertently changed something in my copy, but no dice. I made the suggested changes and nothing works. Thanks, Joe
  15. jderouen

    USPS International = NEW NAMES update

    It's not working for me either. Right now, when an international customer tries to check out, s/he sees this: An error occured with the USPS shipping calculations. If you prefer to use USPS as your shipping method, please contact the store owner. I made this change: $this->intl_types = array( 'Global Express' => 'Global Express Guaranteed', 'Global Express Non-Doc Rect' => 'Global Express Guaranteed Non-Document Rectangular', 'Global Express Non-Doc Non-Rect' => 'Global Express Guaranteed Non-Document Non-Rectangular', 'Express Mail Int' => 'Express Mail International (EMS)', 'Express Mail Int Flat Rate Env' => 'Express Mail International (EMS) Flat Rate Envelope', 'Priority Mail Int' => 'Priority Mail International', 'Priority Mail Int Flat Rate Env' => 'Priority Mail International Flat Rate Envelope', 'Priority Mail Int Flat Rate Box' => 'Priority Mail International Flat Rate Box', 'First-Class Mail Int' => 'First-Class Mail International'); But it's still not working. What else do I need to do? Thanks, Joe
×