Jump to content

kymar

Members
  • Content count

    64
  • Joined

  • Last visited

  1. You may need to delete and re-install the module via Admin (or delete and re-create the database), not just replace the file, to get the changes to work. Otherwise (someone correct me if I'm wrong), the database may not be fully updated.
  2. Fix here: http://forums.oscommerce.com/index.php?showtopic=301960
  3. First Class International has also stopped working at my store - I'm not sure when it happened - I suspect it's some US Postal Service glitch or change. Will continue researching and will post or check back for any updates.
  4. kymar

    USPS PROBLEMS ANYONE? HERE IS THE FIX!

    If you follow all of the instructions at the COMPLETE fix (see prior post) at the link noted, it should work. Otherwise, much in this thread is irrelevant or mistaken, as previously noted (some good partial efforts, but not the complete solution). Various other problems have been noted on other threads, and you might want to search through them for more extensive discussion.
  5. kymar

    USPS PROBLEMS ANYONE? HERE IS THE FIX!

    Best check to see that you're using the add-on that includes the SQL file, not the most recent one that includes only the usps.php file. But it's been a couple of weeks, so maybe you've figured that out for yourself by now. If you need help with PHPADMIN or SQL, then that's another issue.
  6. kymar

    USPS Module Help Please!

    I believe the part that "draws the check boxes" - if I understand you correctly - is the function called by tep_cfg_select_multioption with the subsequent array variables. As you probably know, all it takes is a single missing quote or other mis-punctuation to throw the whole thing off The values look correct to me on first glance, but, if your table is corrupted or otherwise impaired, either as a result of your own edits or of other problems that can develop over time and use, then it might need either to be repaired or replaced. Without figuring out how the code and database interaction work in their entirety and why precisely they're written as they are - something I've never done and that might take a good bit of time for a mere hacker like me - it's probably worth going back to your last working database backup (or a true clean install if that's a workable option for you), and then re-installing from there using the contribution files or some other working version of usps.php exactly as written. Once you've got things appearing more or less as expected, even if it's a largely or partly obsolete version, then you can proceed to whatever remaining alterations you need to make, proceeding very carefully, of course.
  7. kymar

    USPS Module Help Please!

    Corrupted table? You might want to look into the PHPMYADMIN repair routines. Hard for me to say.
  8. kymar

    USPS Module Help Please!

    Possibly the tep_db_query section, where all of the variables appear again. I'd recommend that you start over again: Backup and uninstall your current settings and files. Replace them fully with the contribution files following the instructions to the letter, and not installing the module in admin or testing it until everything is set. If you're still getting the error, then it may be "above my paygrade" or at least beyond my expertise to help you. If you have custom changes to the files, re-insert them only after you've made sure that the "clean" (re-)install works properly.
  9. kymar

    Individual pricing mod that works

    What you're asking for there is very simple - it doesn't sound like you're worried about calculating specific weights, adding weights together accurately, or having different prices for different zones, countries, or delivery methods. If that's true, then all you'd need to do is an extra field to the products table - call it shipping_charge. Look for Products Extra Fields contribution for details, though, again, what you need to have done may lead you to apply it differently (i.e., more simply). Essentially, the bare minimum would be to create the extra field in your products table, and have it show up 1) somewhere in admin so you could edit it for each item, and 2) incorporate into your order total calculations at the appropriate time or times. If you want to be able to download it and upload it via Easypopulate, then you'd need to add the field variables in Easypopulate. If you want it to appear during checkout, then you'd need to alter and format the appropriate the relevant files in the appropriate locations - both the checkout-related files and the order calculation files, as well as potentially the product information files. It's not really that complicated. But you can't get anywhere until you know and can state exactly what you need and want. (I wanted to be able to calculate multiple "tare" weights for different kinds of items, so I added a tare_weight field, then hacked up some adequate (for me) formulas that could be added to the order classes and functions before shipping costs are calculated. If I were a little less busy right now, and if all of my files weren't already heavily modified, meaning they're useless for a public contribution as is - I'd put up a contribution in the hopes that someone more skilled and experienced would improve on some of the shortcuts I took to get something that worked. I do hope to get around to that one of these days - maybe during the post-Xmas lull.)
  10. kymar

    USPS Module Help Please!

    If what you pasted here is the file you're using, then you somehow missed or lost the upper case tags in the variable declaration section. $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'); should be $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'); same problem in the tep_db_query section, for both domestic and international variables refer to the usps-2.9.2a_1 contribution for details
  11. kymar

    USPS Module Help Please!

    Not having that problem on my site. I enable only 1st Class Int, Priority Int, and Express Int. I have to ask, have you proofread your typing very carefully and removed and re-installed the module in admin, or did you use the contribution files? Have you seen whether the same errors occur with identical options enabled across the multiple sites?
  12. kymar

    USPS Module Help Please!

    At this point, I'm not really sure what the problem is. I just hack and hack at this stuff myself. If your web-host doesn't have a tech department to help you with phpmyadmin and SQL stuff, and no one who's truly expert turns up in these parts, there are a lot of other things you could try, with a range of difficulty and time factors involved, but all likely to teach you a few things about the SQL and phpmyadmin even if they turned out to be blind alleys. First, of course, you'd want to search through the documentation to get clear on exactly what your message means. If that doesn't lead you to an easy fix, you might try checking and repairing the table. You might try replacing it with a back-up, and so on, and so on. If the site was new and unmodified, I'd try reinstalling it. You could even try a second install on a second database and see if you could duplicate the error. Sorry I can't be more help.
  13. kymar

    Individual pricing mod that works

    Can you be more specific about what it is exactly you're trying to achieve?
  14. kymar

    USPS Module Help Please!

    I referred to the above e-mail on my reply on the "HERE'S THE FIX" thread, instead of here, with other notes on variations in approaches. The main info for the newbie question is as follows: It shouldn't really make much difference whether you run a sql update before or after changing the php file, as long as you do both. Not sure why you were getting the error you mentioned, but if you're running phpmyadmin, you should be able to find your store database (you may have more than one database set up on your server, I don't know), probably named something like "youruserid_p_os2 (63)" - click on it, then either click import if you're using a sql update file as in the contribution at the link directly above, or go to SQL and paste in the update info if you're just cutting and pasting. If you go to the contribution link - http://addons.oscommerce.com/info/487 - and follow the instructions, it should work. If you've performed custom alterations to your usps.php module, you'll have to do a file compare, and maybe strain your eyes and scratch your head a little.
  15. kymar

    USPS PROBLEMS ANYONE? HERE IS THE FIX!

    Thanks for your work - BUT THIS IS NOT THE RIGHT FIX. Among other things the above changes (don't know whether you were being sloppy or what) include defunct international mail categories. As noted on other threads the simple fix, IF YOU HAVE A MODULE THAT WAS UP TO DATE UNTIL AROUND A WEEK AGO, requires only that you ensure that the "keys" are sent as capital letters. I'm not sure anyone knows at this moment exactly what the USPS did (much less why they did it), but in any event for the moment that seems to solve the problem. And even if they go back to a case-insensitive set-up, it won't hurt to have your keys in all-caps. I hope. Big note: If you just modify the keys to uppercase, you'll have to uninstall and reinstall your module to make sure the changes take effect. If you run the sql update, then I don't think you have to do it. I confess I'm not 100% clear on why the usps.php file is written the way that it is, but things seemed to work fine when I did both - uninstall and re-install, also just update the file and run the sql update. However, as others have noted, if you go the "quick" route and just modify to uppercase and re-install, be sure to locate or to copy your USPS userid, password, and module settings (at your admin modules page) before you remove the shipping module, since, when you reinstall it, you'll have to provide the info again. Here's the fix for updated USPS modules: My recommendation: go to http://addons.oscommerce.com/info/487 for working, updated modules and instructions. If you've performed custom alterations to your usps.php module, you'll have to do a file compare, and maybe strain your eyes and scratch your head a little. As for the "newbie" question: It shouldn't really make much difference whether you run a sql update before or after changing the php file, as long as you do both. Not sure why you were getting the error you mentioned, but if you're running phpmyadmin, you should be able to find your store database (you may have more than one database set up on your server, I don't know), probably named something like "youruserid_p_os2 (63)" - click on it, then either click import if you're using a sql update file as in the contribution at the link directly above, or go to SQL and paste in the update info if you're just cutting and pasting. If you go to the contribution link, and follow the instructions, it should work.
×