Extra Fields and MySQL Column Limits | FAQ | 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
Extra Fields and MySQL Column Limits
February 13, 2013
5:50 pm
awpcp
Moderator
Moderators
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.

http://dev.mysql.com/doc/refma…..limit.html

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: UTC 0

Most Users Ever Online: 163

Currently Online:
12 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Johnny B: 140

godie: 120

laburke: 94

NAIN KHAN: 93

salvig67: 84

rude: 72

purplepaula: 72

WAYTOBAYWTB52: 71

gery: 71

kerdezo: 68

Member Stats:

Guest Posters: 26

Members: 33816

Moderators: 2

Admins: 2

Forum Stats:

Groups: 1

Forums: 4

Topics: 6353

Posts: 28800

Newest Members:

Minerva Lusk, Simone Duke, Greg Reye, Denny Ali, Virgilio Broadus, Rita Loper, Deborah Rosser, Elisabeth Balson, Nelle Scrymgeour, Kandy McGuffog

Moderators: awpcp: 7530, AWPCP Support: 4247

Administrators: wpengine: 0, awpcp: 297

Skip to toolbar