Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Limitation for Zone Shipping Table's Data


allright

Recommended Posts

Hi all,

 

I am using Zone Shipping Table mode, currently, there are 25 pairs of rate data as following:

0.5:16.54,1.0:19.85,1.5:23.16,2.0:26.47,2.5:29.78,3.0:33.09,3.5:36.4,4.0:39.71,4

.5:43.01,5.0:46.32,5.5:49.63,6.0:52.94,6.5:56.25,7.0:59.56,7.5:62.87,8.0:66.18,8.

5:69.49,9.0:72.79,9.5:76.1,10.0:79.41,10.5:82.72,11.0:86.03,11.5:89.34,12.0:92.65

,12.50:95.96

 

It is very strange that, more data rate can NOT be added after the endding pair: "12.50:95.96"

 

If some more rate data are forced to be added after the endding pair: "12.50:95.96", after I click the "update", the data will not be displayed, which means that any rate data after the endding pair: "12.50:95.96" can not be added.

 

It seems that there is a limitation of 25 pairs of rate data, but I could not find where to modify this limitation.

 

Your kind advice is greatly appreciated! thank you.

 

Best regards,

allright

Link to comment
Share on other sites

Hi all,

 

I am using Zone Shipping Table mode, currently, there are 25 pairs of rate data as following:

0.5:16.54,1.0:19.85,1.5:23.16,2.0:26.47,2.5:29.78,3.0:33.09,3.5:36.4,4.0:39.71,4

.5:43.01,5.0:46.32,5.5:49.63,6.0:52.94,6.5:56.25,7.0:59.56,7.5:62.87,8.0:66.18,8

.

5:69.49,9.0:72.79,9.5:76.1,10.0:79.41,10.5:82.72,11.0:86.03,11.5:89.34,12.0:92.6

5

,12.50:95.96

 

It is very strange that, more data rate can NOT be added after the endding pair: "12.50:95.96"

 

If some more rate data are forced to be added after the endding pair: "12.50:95.96", after I click the "update", the data will not be displayed, which means that any rate data after the endding pair: "12.50:95.96" can not be added.

 

It seems that there is a limitation of 25 pairs of rate data, but I could not find where to modify this limitation.

 

Your kind advice is greatly appreciated! thank you.

 

Best regards,

allright

 

 

Any body can help me out of this problem ? thank you very much!

Link to comment
Share on other sites

Any body can help me out of this problem ? thank you very much!

 

Hi

 

I tried to add 42 pairs and it does not work Then I checked the database.

There is a limit of 255 characters on each of the Zone

Shipping Tables and Zone Countries.

 

cheers

Link to comment
Share on other sites

  • 4 weeks later...

cpanel >> mysql >> phpMyAdmin.

 

Ask Your hosting company as to How You can reach there are different hosting companies use a bit different cpanel interface.

 

Satish

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

OK got that far and have managed to get hold of my "web guy"

 

He asks:

 

Could you please explain exactly what entry needs to be changed please. What database entry are these values under?

 

 

?

 

cpanel >> mysql >> phpMyAdmin.

 

Ask Your hosting company as to How You can reach there are different hosting companies use a bit different cpanel interface.

 

Satish

Link to comment
Share on other sites

I am also confused by this. I am using phpMyAdmin, but I see no table associated with the module in the OSCommerce database. Which table do I edit?

 

Or, am I supposed to edit the table field limit for the entire database? If so, what is the command to do it?

 

I'm fairly new at this, so any help would be appreciated.

 

Thanks!

Link to comment
Share on other sites

for any configuration matter its the configuration table.

But if not aware make a back up and then try.

 

Satish

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

for any configuration matter its the configuration table.

But if not aware make a back up and then try.

 

Satish

 

 

OK we have found the config table but there are 6 entries none of them listed as field limit and all set as 255! We don't know if its one of these or all or none that need changing to the increased limit?

 

They are:

configuration_title

configuration_key

configuration_value

configuration_description

use_function

set_function

 

 

Please if anyone has done this before can they point it out to the resident idiot in a way Ill be able to follow easily

Edited by cooperman435
Link to comment
Share on other sites

tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Shipping Table', 'MODULE_SHIPPING_TABLE_COST', '25:8.50,50:5.50,10000:0.00', 'The shipping cost is based on the total cost or weight of items. Example: 25:8.50,50:5.50,etc.. Up to 25 charge 8.50, from there to 50 charge 5.50, etc', '6', '0', now())");

 

configuration_title is Shipping Table

configuration_key is MODULE_SHIPPING_TABLE_COST

configuration_value is 25:8.50,50:5.50

 

so this configuration_value field length needs to be increased.

 

Satish

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...