How to unlimited filled zone shipping table?

[wibisono]

Hi..everyone there!!

 

Any could help me to solve my problem.

I'm new here...start to join here and perhaps could learn more a lot.

I'm oscommerce-2.2rc2a

When i try it and doing in the module shipping, instal zone rate i got the stuck in fill in zone shipping table.

 

i got stuck 5 entry kg only.

 

Plezzz any one could help me?!! :rolleyes:

 

Thank you

Wibisono

[wibisono]

Here the message noticed that i had problem!!!

 

After i try to find and to do fix by my self, i'm just got the information below!,

 

Lastly, there is a limit of 255 characters on each of the Zone Shipping Tables and Zone Countries.

 

is that may be the condition i can't to entry field with all data ( bold text above )??

 

Lastly, there is a limit of 255 characters on each of the Zone Shipping Tables and Zone Countries.

 

any idea to modified the condition above to make each of the Zone Shipping Tables and Zone Countries

unlimited!!

 

1406 - Data too long for column 'configuration_value' at row 148

 

update configuration set configuration_value = '0.5:15.72,1:19.4,1.5:23.09,2:26.78,2.5:30.46,3:34.29,3.5:38.25,4:42.20,4.5:46.16

,5:50.11,

5.5:53.13,6:56.15,6.5:59.17,7:62.20,7.5:65.22,8:68.24,8.5:71.26,9:74.28,9.5:77.3

0,10:80.32,

10.5:81.32,11:82.32,11.5:83.32,12:84.31,12.5:85.31,13:86.31,13.5:87.31,14:88.31,

14.5:89.31,

15:90.30,15.5:91.30,16:92.30,16.5:93.30,17:94.30,17.5:95.30,18:96.29,18.5:97.29,

19:98.29,19.5:99.29,20:100.29'

where configuration_key = 'MODULE_SHIPPING_ZONES_COST_1'

 

[TEP STOP]

 

I'm really appriciate anyone who could help me!!

Thank you

Wibisono :)

[wibisono]

Here the message noticed that i had problem!!!

 

After i try to find and to do fix by my self, i'm just got the information below!,

 

Lastly, there is a limit of 255 characters on each of the Zone Shipping Tables and Zone Countries.

 

is that may be the condition i can't to entry field with all data ( bold text above )??

 

Lastly, there is a limit of 255 characters on each of the Zone Shipping Tables and Zone Countries.

 

any idea to modified the condition above to make each of the Zone Shipping Tables and Zone Countries

unlimited!!

 

1406 - Data too long for column 'configuration_value' at row 148

 

update configuration set configuration_value = '0.5:15.72,1:19.4,1.5:23.09,2:26.78,2.5:30.46,3:34.29,3.5:38.25,4:42.20,4.5:46.16

,5:50.11,

5.5:53.13,6:56.15,6.5:59.17,7:62.20,7.5:65.22,8:68.24,8.5:71.26,9:74.28,9.5:77.3

0,10:80.32,

10.5:81.32,11:82.32,11.5:83.32,12:84.31,12.5:85.31,13:86.31,13.5:87.31,14:88.31,

14.5:89.31,

15:90.30,15.5:91.30,16:92.30,16.5:93.30,17:94.30,17.5:95.30,18:96.29,18.5:97.29,

19:98.29,19.5:99.29,20:100.29'

where configuration_key = 'MODULE_SHIPPING_ZONES_COST_1'

 

[TEP STOP]

 

I'm really appriciate anyone who could help me!!

Thank you

Wibisono :)

 

 

 

any idea to solve that problem??

 

thanks

wibisono :blush:

[♥geoffreywalton]

Changing the would also impact all the configuration data and as such could have unpredicable results elsewhere.

 

You have 380 odd characters.

 

You could merge your higher rates to reduce the length.

[wibisono]

i see,

ok,thank you very much

for your advise buddy!!

 

Best Regard

Wibisono