Extra Fields and MySQL Column Limits | FAQ | Support Forum


Please consider registering

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
Extra Fields and MySQL Column Limits
February 13, 2013
5:50 pm
Forum Posts: 7530
Member Since:
August 9, 2013
sp_UserOfflineSmall Offline

Extra Fields are great to add additional form fields in AWPCP. But it turns out that MySQL imposes a limit on the number of columns that a table can have.


This limit exists in all current versions of MySQL. Unfortunately, AWPCP can't control that limit, so if you exceed it, you will likely see errors like this:

AWPCP PHP Error [256] (SQL) (1054) Unknown column 'field_name' in'field list'Fatal error called by line 32 in file /......./wp-content/plugins/another-wordpress-classifieds-plugin/functions_awpcp.php,error in /....../wp-content/plugins/another-wordpress-classifieds-plugin/functions_awpcp.phpat line 32, PHP 5.2.17 (Linux)Aborting...

The only way to work around this is to delete the field that is causing the problem from the Extra Fields admin panel (the example above shows 'field_name').

Forum Timezone: America/Denver

Most Users Ever Online: 163

Currently Online:
17 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Johnny B: 140

godie: 120

kerdezo: 99

laburke: 94


salvig67: 84

sctpfwape: 75

rude: 72

purplepaula: 72


Member Stats:

Guest Posters: 32

Members: 38136

Moderators: 3

Admins: 2

Forum Stats:

Groups: 1

Forums: 4

Topics: 7036

Posts: 31284

Newest Members:

kurnailstop, motordkrental, nailsjuliitaxd, Mark, Rachael, SHERI, bhawanaconsultancy, alexlug, ludniko, Matakoi

Moderators: awpcp: 7530, AWPCP Support: 5362, Bobbie Devereux: 0

Administrators: wpengine: 0, awpcp: 300

Skip to toolbar