Limitation for Zone Shipping Table's Data

[allright]

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

[allright]

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!

[impressa]

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

[satish]

Modify the data base table field limit.

 

 

Satish

[allright]

Modify the data base table field limit.

 

 

Satish

 

Thank you! Yes, it works!

[cooperman435]

Please could someone give me a little more details as to the changes n where they need to be made please?

 

I assume there will be a 255 in the file that needs to be changed to my desired value but whereabouts is that illusive 255 and in which file?

[cooperman435]

Where will I find the database though?

 

Sorry but Im not the usual guy who does this side of the shop.

[satish]

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

[cooperman435]

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

[TeeG]

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!

[satish]

for any configuration matter its the configuration table.

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

 

Satish

[cooperman435]

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 August 28, 2008 by cooperman435

[satish]

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