title: Using ExpressionEngine and getting this error: A Database Error Occurred, Error Number: 1117, Too many columns
body: <p>I’m building a site in ExpressionEngine where the client wants every image and text built into EE’s content management system as an editable field. Ok… Almost done. Currently have 1030 Channel Fields, across 20 Channel Field Groups, with in 20 Channels.</p>
  
  <p>In trying to add Channel Field # 1031 and continue adding Channel Fields I get the following error:</p>
  
  <p>A Database Error Occurred
  Error Number: 1117</p>
  
  <p>Too many columns</p>
  
  <pre><code>ALTER TABLE `exp_channel_data` ADD `field_id_1036` text NULL
  </code></pre>
  
  <p>Filename: libraries/api/Api_channel_fields.php</p>
  
  <p>Line Number: 675</p>
  
  <p>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….</p>
  
  <p>Is there a way to increase the number of columns to allow for the rest of the Channel Fields needed to complete this site? Or what ever needs to be done to allow me to add more channel fields? </p>
  
  <p>Any suggestions would be greatly appreciated. Thank You</p>