Jump to content
Sign in to follow this  
allright

Limitation for Zone Shipping Table's Data

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

Share this post


Link to post
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!

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

Modify the data base table field limit.

 

 

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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
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

Share this post


Link to post
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!

Share this post


Link to post
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.

Share this post


Link to post
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

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×