Post by nextgenxx » Wed Oct 08, 2008 2:49 am

Under admin > extensions > shipping I installed the "Subtotal Based Shipping module" and like it so far but has some limitations. In the configuration where you can enter the price-to-shipcost it only can allow up to 128 characters in the text box, is there a way to up the 128 limit?

so it will only let me put in the below numbers:

20.00:8.95,30.00:9.95,40.00:10.95,50.00:11.95,60.00:12.95,70.00:13.95,80.00:14.95,90.00:15.95,100.0:16.95,125.0:17.95,150.0:18.9

And I want to put in this amount:

20.00:8.95,30.00:9.95,40.00:10.95,50.00:11.95,60.00:12.95,70.00:13.95,80.00:14.95,90.00:15.95,100.0:16.95,125.0:17.95,150.0:18.95,175.0:20.95,200.0:22.95,250.0:24.95,300.0:26.95,350.0:28.95,400.0:30.95,450.0:32.95,500.0:34.95,200000.0:0.00

Do I need to change something in phpmyadmin?

User avatar
New member

Posts

Joined
Tue Jul 15, 2008 1:13 am


Post by Qphoria » Wed Oct 08, 2008 3:55 am

Yes. You would need to change the limits of the table column from varchar(128) to varchar(255) (i believe 255 is the max)

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by malucklo » Sun Oct 19, 2008 11:05 am

How can I change the limits of the table column from varchar(128) to varchar(255)? Thanks!

Newbie

Posts

Joined
Thu Oct 16, 2008 9:35 am

Post by bruce » Sun Oct 19, 2008 8:33 pm

execute the following sql using (say) phpmyadmin on your database

Code: Select all

 ALTER TABLE `setting` CHANGE `value` `value` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL  

Active Member

Posts

Joined
Wed Dec 12, 2007 2:26 pm

Post by malucklo » Tue Oct 21, 2008 11:20 am

Got it! Thanks a lot!!!  :D

Newbie

Posts

Joined
Thu Oct 16, 2008 9:35 am
Who is online

Users browsing this forum: No registered users and 1 guest