MidasMassage Posted January 9, 2008 Share Posted January 9, 2008 Could someone please help. I just installed USPS Methods 2_9_5_1 and it seems to work except, in the admin screen I have no options under " Int'l Shipping Methods Select the international services to be offered:" and when a user is buying from me all are given to them. How do I get these options under Intl shipping to show? It works fine with: Domestic Shipping Methods Select the domestic services to be offered: EXPRESS PRIORITY FIRST CLASS PARCEL BPM LIBRARY MEDIA Anybody? Quote Link to comment Share on other sites More sharing options...
Guest Posted January 10, 2008 Share Posted January 10, 2008 Here is some additional info: I'm having the same issue with 2.9.5.1 and I get the error Parse error: syntax error, unexpected T_GLOBAL, expecting ')' in /home/gssibra4/public_html/ausz/AUSZadmin/modules.php(216) : eval()'d code on line 1 on the admin screen for USPS just below the page banner when I select EDIT function. So I grabbed the module.php file from 2.9.2a_1 and replaced my manually edited version of modules.php and I get the same "bad" behavior. Quote Link to comment Share on other sites More sharing options...
olsonsp4c Posted January 10, 2008 Share Posted January 10, 2008 (edited) Here is some additional info: I'm having the same issue with 2.9.5.1 and I get the error Parse error: syntax error, unexpected T_GLOBAL, expecting ')' in /home/gssibra4/public_html/ausz/AUSZadmin/modules.php(216) : eval()'d code on line 1 on the admin screen for USPS just below the page banner when I select EDIT function. So I grabbed the module.php file from 2.9.2a_1 and replaced my manually edited version of modules.php and I get the same "bad" behavior. This is addressed in the Troubleshooting part of the readme/install txt file: "2. If you are getting a "parse error" you may need to open phpMyAdmin and update the database -> configuration table and change set_function to TEXT from VARCHAR." Also, if your International options are not showing, this is also the solution. do as number 2 says, then in the admin remove the usps module, then reinstall it and you will see all your options appear - I will add this to the readme file for future updates. Scott Edited January 10, 2008 by olsonsp4c Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox Link to comment Share on other sites More sharing options...
MidasMassage Posted January 11, 2008 Author Share Posted January 11, 2008 This is addressed in the Troubleshooting part of the readme/install txt file: "2. If you are getting a "parse error" you may need to open phpMyAdmin and update the database -> configuration table and change set_function to TEXT from VARCHAR." Also, if your International options are not showing, this is also the solution. do as number 2 says, then in the admin remove the usps module, then reinstall it and you will see all your options appear - I will add this to the readme file for future updates. Scott I am not getting a parse error, and running ALTER TABLE `configuration` CHANGE `set_function` `set_function` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; did not work for me. Any other ideas? Steve Quote Link to comment Share on other sites More sharing options...
olsonsp4c Posted January 12, 2008 Share Posted January 12, 2008 I am not getting a parse error, and running ALTER TABLE `configuration` CHANGE `set_function` `set_function` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; did not work for me. Any other ideas? Steve change configuration -> set_funtion to TEXT from VARCHAR in phpmySQL and it will work Scott Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox Link to comment Share on other sites More sharing options...
MidasMassage Posted January 12, 2008 Author Share Posted January 12, 2008 change configuration -> set_funtion to TEXT from VARCHAR in phpmySQL and it will work Scott Maybe I am confused. IS that not what the following will do: ALTER TABLE `configuration` CHANGE `set_function` `set_function` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; After doing that, there is no change. If this is not it, how are you saying to change it as I believe it is text at this point? Quote Link to comment Share on other sites More sharing options...
olsonsp4c Posted January 12, 2008 Share Posted January 12, 2008 Maybe I am confused. IS that not what the following will do: ALTER TABLE `configuration` CHANGE `set_function` `set_function` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; After doing that, there is no change. If this is not it, how are you saying to change it as I believe it is text at this point? with some people this sql statement does not work, you might need to manually go in and change it to TEXT (ingore everything past COLLATE). afterwards, remove the usps module in modules->USPS Methods "Remove" - then click "Install" after it is removed and re-insert your id and all, the intl options should be there. Scott Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox Link to comment Share on other sites More sharing options...
MidasMassage Posted January 12, 2008 Author Share Posted January 12, 2008 with some people this sql statement does not work, you might need to manually go in and change it to TEXT (ingore everything past COLLATE). afterwards, remove the usps module in modules->USPS Methods "Remove" - then click "Install" after it is removed and re-insert your id and all, the intl options should be there. Scott That is what I did the first time. It is set to TEXT. I removed the USPS methods. I re-installed. I still dont get the options to turn on and turn off under intl. They are always turned on. After I edit the settings, I can see all of the intl options, but when editing the settings, there are no check boxes or text for me to change. Is this driven by the USPS site, or in the DB? I find nothing in the DB and am wondering if driven by USPS, maybe my id does not have access to intl? Any other thoughts? I really think I have done exactly as you state and still nothing. Quote Link to comment Share on other sites More sharing options...
olsonsp4c Posted January 12, 2008 Share Posted January 12, 2008 That is what I did the first time. It is set to TEXT. I removed the USPS methods. I re-installed. I still dont get the options to turn on and turn off under intl. They are always turned on. After I edit the settings, I can see all of the intl options, but when editing the settings, there are no check boxes or text for me to change. Is this driven by the USPS site, or in the DB? I find nothing in the DB and am wondering if driven by USPS, maybe my id does not have access to intl? Any other thoughts? I really think I have done exactly as you state and still nothing. It is driven by the DB, then connects with USPS after the settings are saved. Try removing it and overwriting with the most recent files, then re-install and let me know if it is fixed - you should be using production rather than testing and make sure that both the userid and password are filled in with the userid (in other words, it appears 2x). also, this is the line that inserts the correct field in "configuration" table: tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Int\'l Shipping Methods', 'MODULE_SHIPPING_USPS_TYPES_INTL', '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', 'Select the international services to be offered:', '6', '15', '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\'), ', now())"); Scott Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox Link to comment Share on other sites More sharing options...
jasonabc Posted January 25, 2008 Share Posted January 25, 2008 Hey Scott - thanks for your work on this to date and for posting here. I was getting the exact same problems described in this thread but was able to get it working following your suggestions. thanks again Jason Quote Jason My Contributions: Paypal Payflow PRO | Rollover Category Images | Authorize.net Invoice Number Fix 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.