Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

aeontech

Archived
  • Posts

    1
  • Joined

  • Last visited

Profile Information

  • Real Name
    Aeon

aeontech's Achievements

  1. [bUG AND PATCH] I noticed a problem with the sql generated for the installation. The stock oscommerce configuration table can only hold up to 255 characters in the set_function field, however the MODULE_SHIPPING_USPS_TYPES_INTL configuration option has it longer than that. This leads to the set_function value being truncated, and an error shows up on the /admin/modules.php?set=shipping&module=usps&action=edit page when you attempt to edit the USPS module settings. The error text is: Parse error: syntax error, unexpected T_GLOBAL, expecting ')' in /var/www/mysite/osc/admin/modules.php(218) : eval()'d code on line 1 and makes it impossible to select which international shipping methods you want available. The solution is to run the following code in mysql console: alter table configuration change configuration_value configuration_value text; alter table configuration change set_function set_function text; update configuration SET 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'; This changes the configuration_value and set_function fields to be text fields, which has a much larger length limit, and resets the set_function field to the correct un-truncated value. This might or might not help with some of the international shipping problems, but at least it makes it possible to choose which options you want to show. You can now go to the shipping modules page and edit which international shipping options you want the customer to see.
×
×
  • Create New...