State input length | Support Questions | Support Forum

A A A

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
State input length
January 10, 2017
5:32 pm
gocozpwlc
Member
Members
Forum Posts: 31
Member Since:
February 5, 2016
sp_UserOfflineSmall Offline

The Sate input seems to be limited to 64 characters as it’s column type is varchar(64)

 

I  need to increase this as not all my state values will fit in here. (Some of my customers will be nationwide)

 

Where should I be looking for the file to edit.

 

I’m aware of http://awpcp.com/documentation…..ion-guide/ but it doesn’t indicate where I would edit this.

January 10, 2017
7:03 pm
gocozpwlc
Member
Members
Forum Posts: 31
Member Since:
February 5, 2016
sp_UserOfflineSmall Offline

I changed it with an SQL query:

 

ALTER TABLE wp_awpcp_ad_regions  MODIFY state VARCHAR(500) NOT NULL;

 

Do you foresee anything in the plugin that might reset that after I’ve changed it? 

January 12, 2017
8:26 am
AWPCP Support
Moderator
Members

Moderators
Forum Posts: 4543
Member Since:
September 4, 2013
sp_UserOfflineSmall Offline

Hi gocozpwlc,

Yes that’s the way to do it. A plugin update would reset that I believe.

Forum Timezone: America/Denver

Most Users Ever Online: 163

Currently Online:
11 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Johnny B: 140

godie: 120

laburke: 94

NAIN KHAN: 93

kerdezo: 84

salvig67: 84

purplepaula: 72

rude: 72

gery: 71

WAYTOBAYWTB52: 71

Member Stats:

Guest Posters: 28

Members: 36843

Moderators: 2

Admins: 2

Forum Stats:

Groups: 1

Forums: 4

Topics: 6554

Posts: 29488

Newest Members:

toto, Mike Wilson, Melanie, andrea salis, Chardon, Mareks, Grégoire, Alex, bassam, antu lal

Moderators: awpcp: 7530, AWPCP Support: 4543

Administrators: wpengine: 0, awpcp: 298

Skip to toolbar