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