budd311 Posted May 24, 2007 Share Posted May 24, 2007 I just installed new contribution for UPS XML - LOOKS AWEOMSE!. First Question - Where would I find the VARCHAR(235) to replace as Text (I am new at this I am sory if that is a dumb question) Also - I did do the second option (b/c I didn't know how to do the first and virtually deleted ALL the UPS methods of shipping becuase I was having an issue which you can see below). I left these options: (\'Next Day Air\', \'2nd Day Air\', \'Ground\', \'Express\', \'Standard\', \'3 Day Select\', \'Expedited\') - which is only 107 Characters.... Second Question - When I go to click on Edit UPS in the SHipping Module I get this error at the top of the page: "Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in /home/content/u/n/i/uniquesquared/html/oscommerce/catalog/admin/modules.php(216) : eval()'d code on line 1" I don't know what that means.. Third Question - When I actually go to check out of my store when the UPS is set to true the webpage times out and won't load and says this: "2013 - Lost connection to MySQL server during query select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies [TEP STOP]" Does anyonehave any suggestions? GREATLY APPRECIATED!!!!!!! Quote Link to comment Share on other sites More sharing options...
djmonkey1 Posted May 25, 2007 Share Posted May 25, 2007 JanZ provides excellent support for UPS XML in the support thread: http://www.oscommerce.com/forums/index.php?showtopic=49382 Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
black0ut Posted May 25, 2007 Share Posted May 25, 2007 The first and second problem are actually linked. The easiest way to change the database is to go to phpMyadmin, go to the database you're working with, browse to set_function and click on the edit button (for me its the pencil), and change the dropdown menu to (TEXT). After doing that, you go to your osCommerce admin page, remove the ups module, then install it again. That should fix 1 and 2. I don't know about the third problem, sorry, though it seems that the connection to your db is too slow for you to turn on ups webpage timeouts. Quote Link to comment Share on other sites More sharing options...
budd311 Posted May 25, 2007 Author Share Posted May 25, 2007 The first and second problem are actually linked. The easiest way to change the database is to go to phpMyadmin, go to the database you're working with, browse to set_function and click on the edit button (for me its the pencil), and change the dropdown menu to (TEXT). After doing that, you go to your osCommerce admin page, remove the ups module, then install it again. That should fix 1 and 2. I don't know about the third problem, sorry, though it seems that the connection to your db is too slow for you to turn on ups webpage timeouts. Thanks for the response.. I have very potentional stupid question.... Where/How to I get to the phpMyadmin... I am using hosting through GoDaddy.. I try to open then Databaes Manager to log in... I get this error --> Error - Cannot log into the MySQL server... Sorry for the noob-ness. Thanks again...... Quote Link to comment Share on other sites More sharing options...
budd311 Posted May 25, 2007 Author Share Posted May 25, 2007 JanZ provides excellent support for UPS XML in the support thread: http://www.oscommerce.com/forums/index.php?showtopic=49382 Thanks for the reply....I have been surfing through that... I need to figure out to access phpMyAdmin, I am using GoDaddy for hosting. Do Ihave to go thought thier contral panel --> I go to loginto my databse for OsCommerese and get the follwoing error --> Errro Cannot log in to the MySQL server 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.
Note: Your post will require moderator approval before it will be visible.