We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine Logo ExpressionEngine
Features Pricing Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University
Log In or Sign Up
Log In Sign Up
ExpressionEngine Logo
Features Pro new Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University Blog
  • Home
  • Forums

A Database Error Occurred, Error Number: 1117, Too many columns

Development and Programming

Greg R's avatar
Greg R
7 posts
12 years ago
Greg R's avatar Greg R

I’m building a site in which the client wants every image and text built into EE’s content management system. Ok… Almost done. Currently have 1030 Channel Fields, across 20 Channel Field Groups, with in 20 Channels.

In trying to add Channel Field # 1031 I get the following error:

A Database Error Occurred Error Number: 1117

Too many columns

ALTER TABLE exp_channel_data ADD field_id_1036 text NULL

Filename: libraries/api/Api_channel_fields.php

Line Number: 675

I have spent the last 2 weeks creating these Channel Fields and I really don’t want to go back and restructure everything. So I’m wondering….

Is there a way to increase the number of columns to allow for the rest of the Channel Fields needed to complete this site?

Any suggestions would be greatly appreciated. Thank You

       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.