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: 25
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: 25
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: 4332
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:
22 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Johnny B: 140

godie: 120

laburke: 94

NAIN KHAN: 93

salvig67: 84

kerdezo: 74

rude: 72

purplepaula: 72

gery: 71

WAYTOBAYWTB52: 71

Member Stats:

Guest Posters: 27

Members: 36410

Moderators: 2

Admins: 2

Forum Stats:

Groups: 1

Forums: 4

Topics: 6405

Posts: 29000

Newest Members:

ufuk, Reyan, Vince, a, Conrad Lopez, Chandra De Maistre, Lawrence Barreiro, Lionel Keister, Lyda Simpkinson, Roland Corkill

Moderators: awpcp: 7530, AWPCP Support: 4332

Administrators: wpengine: 0, awpcp: 297

Skip to toolbar