Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How to unlimited filled zone shipping table?


wibisono

Recommended Posts

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

Link to comment
Share on other sites

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 :)

Link to comment
Share on other sites

  • 2 weeks later...
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:

Link to comment
Share on other sites

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.

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

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...