How to change maxlength of Street Address?

Hi,

I need to know from where i can change maxlength="64" in Street Address given on Create Account or Edit Account.

I want to increase maxlength of Street Address and Address Line 2.

Thank you in advance.

PS: Im using ZenCart 1.3.8a.

~ Time

You'll need to access the database with phpMyAdmin from your hosting control panel and change the length of those fields. As always when working with the database, back it up first.

stevesh:

You'll need to access the database with phpMyAdmin from your hosting control panel and change the length of those fields. As always when working with the database, back it up first.

Thank you solved it.

Here is the tip for people who don't know what or how to change in database.

Step 1
Get into database by phpMyAdmin

Step 2
Locate database entry named as zen_address_book on left side and click it. Most probably it will be on top.

Step 3
Suppose you need to change maximum allowed characters length in Street Address lets say from 32 to 64. Locate entry_street_address on right side under Field column and under Type column, you will able to see how many characters allowed varchar(32). Now click Change (Pencil icon) in Action column on right.

Step 4
Here you will see Length/Values1 just change that to the desired value, lets say 64 then press Save.

Do not change anything else and Backup your database before doing this for just incase.

~Time

Note: you will want to review the address information in several databases to change the street address ...

address_book
orders (multiple fields for customer, delivery and billing)

Otherwise you will not have the longer address carry over when orders are made ... :eek:

Ajeh:

Note: you will want to review the address information in several databases to change the street address ...

address_book
orders (multiple fields for customer, delivery and billing)

Otherwise you will not have the longer address carry over when orders are made ... :eek:

Ok, tell me where all the address is given in database? I'll change.

~ Time

You should check your database to confirm these, but as a minimum:
Table: address_book
Field: entry_street_address

Table: orders
Fields:
customers_street_address
delivery_street_address
billing_street_address

You should check the structure of your database tables to ensure that there are no others to update ...

Ok that was quick reply. Thank you.

I changed, what all you given, trying to find others if any, not looking any so far. Is there any search tools to find such.

~ Time

You can export the structure of your database and then do a search on the file for:
street

and see if any other fields come up ...

It doesn't mean that there couldn't be other fields with other names, but that would be the most logical ...

Hallo,

I would like to ask who is responsible for setting the maxlength value. Is it zen-cart installation program or the owner of the database?

In my home server the value is 64, and in the server where my shop will be hosted, the value is 32 ...

Should I reinstall or contact the administrator?

Kind regards,
orange_juice

By default, Zen Cart is installed with a 64 character address_book entry_street_address and a 32 character entry_suburb ... and that matches in orders table ...

You can customize these values via phpMyAdmin ...

How they would of become truncated on your site I do not know ... :unsure:

OK... thank you, I will consider reinstalling!

Kind regards,
orange_juice

You don't have to reinstall to change the width of the field lengths ... this can be done in phpMyAdmin just be sure to fix it on all of the related fields ...

All right. I will try to follow the instructions of the previous post first.

At this point, reinstalling is not much of a burden since the database is empty.

Thank you for your support.

By the way, the new zen cart release, rocks!

Kind regards,
orange_juice

Well in that case ... reinstall from your v1.3.9c that you downloaded from SourceForge ...

This gives you practice in installing ... :cool:

Ajeh:

Well in that case ... reinstall from your v1.3.9c that you downloaded from SourceForge ...

This gives you practice in installing ... :cool:

:clap:

Kind regards,
orange_juice