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: 4388
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:
18 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Johnny B: 140

godie: 120

laburke: 94

NAIN KHAN: 93

salvig67: 84

kerdezo: 80

rude: 72

purplepaula: 72

WAYTOBAYWTB52: 71

gery: 71

Member Stats:

Guest Posters: 27

Members: 36527

Moderators: 2

Admins: 2

Forum Stats:

Groups: 1

Forums: 4

Topics: 6443

Posts: 29135

Newest Members:

Ashish, Octavia Wilfred, Alex, sahai office, Morg, Mike Russ, Sarah, Ariel, Gérald, Subham Pathak

Moderators: awpcp: 7530, AWPCP Support: 4388

Administrators: wpengine: 0, awpcp: 297

Skip to toolbar