Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: [SOLVED] 2.7.2 state dropdown truncated

[SOLVED] 2.7.2 state dropdown truncated 13 years 11 months ago #11638

  • jharkin
  • jharkin's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 26
  • Thank you received: 0
2.7.2 has a state field defined with dropdown data. Unfortunately, the varchar(255) is too short to hold the whole list. It cuts off at Nebrask.

What's the easiest fix for this? Our existing customer database uses postal abbreviations, so I could replace full state names with abbreviations.

Please Log in or Create an account to join the conversation.

[SOLVED] 2.7.2 state dropdown truncated 13 years 11 months ago #11639

  • jharkin
  • jharkin's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 26
  • Thank you received: 0
I changed the list to USPS abbreviations.

AL|AK|AZ|AR|CA|CO|CT|DE|DC|FL|GA|HI|ID|IL|IN|IA|KS|KY|LA|ME|MD|MA|MI|MN|MS|MO|MT|NE|NV|NH|NJ|NM|NY|NC|ND|OH|OK|OR|PA|RI|SC|SD|TN|TX|UT|VT|VA|WA|WV|WI|WY

Country has the same problem. I changed it to text like it used to be in 2.6.

Please Log in or Create an account to join the conversation.

[SOLVED] 2.7.2 state dropdown truncated 13 years 11 months ago #11641

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
Fresh installs do not have this limitation. You have this as you have been a longer time user. Back in the day, this limitation existed in the database so you inherited it :) Lucky you! Go into the database to the table jos_dtregister_fields. Change the type from VARCHAR(255) to TEXT.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.139 seconds