EllisLab text mark
Advanced Search
     
Error Number: 1117 Too many columns ? Have more colums ?
Posted: 25 July 2012 05:49 AM   [ Ignore ]
Avatar
Joined: 2006-08-09
62 posts

Hello,

I’d like your help about how to have more colums in EE more than 1000 fields, i’ve already checked in EE and MySQL forums and i don’t find yet the solution.. ?

I got this error below, because i’ve too much colums and i need more colums :

A Database Error Occurred
Error Number
1117 Too many columns
ALTER TABLE 
`exp_channel_dataADD `field_id_1019text NULL
Filename
libraries/api/Api_channel_fields.php
Line Number
578 

My database is MyISAM and i read that InnoDB can have more than 1000 colums. Do you know how to hard force the EE Limit of this smile ?

Is it possible if i create and connect the second “exp_channel_data” database table, so i’ve “exp_channel_data_1” and “exp_channel_data_2”. Any solution to connect it ? Or perhaps with a PHP Form to send the data to 2 different database ?

Thanks !

 
Posted: 26 July 2012 03:42 PM   [ Ignore ]   [ # 1 ]   [ Rating: 0 ]
Avatar
Joined: 2004-03-22
12298 posts

Hi Apfelfrucht,

I answered a thread last year on this type of issue which may be of help here

JH

 Signature 

John Henry’s Website | Follow me on Twitter

 
Posted: 26 July 2012 05:37 PM   [ Ignore ]   [ # 2 ]   [ Rating: 0 ]
Avatar
Joined: 2006-08-09
62 posts

Hello John,

Yeap, i’ve already read it a week ago, i did find the solution first before posting my question here wink

Wow, it seems that there is no solution at all for this ? :o

Regards.