Forums

Hello,

I have problem when generating a table with many fields(about 245).
Error message when trying to generate :

Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs SQL=CREATE TABLE IF NOT EXISTS `ztest__chronoengine_chronoforms_datatable_GXXXX` ( `id` ...............................

After changing datatype to TEXT, table is generated but stops at 154th field..

Can you confirm if its a bug please?

My solution was to create manually the fields in Phpmyadmin.

Thank you Bob.So there's a limitation on the number of columns and it is painful to modify the data type and/or length when you have many fields like in my case.

Instead of marking Bob's answer, i wrongly marked mine as Best Answer.
Moderator, if you could please modify....

Hi Fawaaz,

I agree it is tedious to edit a lot of records, You do get faster with practice though :-)

Bob