Thread

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_data` ADD `field_id_1019` text 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 😊 ?

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 !

Hi Apfelfrucht,

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

JH

Hello John,

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

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

Regards.