Hello
i created many custom fields, and with the last i had a problem.
In the Studio i get no error msg.
But then i change some data in contacts, the changes were not saved in the contact.
In the admin i make a fastrepair and get this error message.
in phpmyadmin i make the direct in sql the commandCode:/*Checking Custom Fields for module : Contacts */ /*MISSING IN DATABASE - innendaemmungart_c - ROW*/ alter table contacts_cstm add column innendaemmungart_c varchar(255) NULL ; /*MISSING IN DATABASE - aussendaemmungart_c - ROW*/ alter table contacts_cstm add column aussendaemmungart_c varchar(255) NULL ; ; /*MISSING IN DATABASE - kerndaemmungart_c - ROW*/ alter table contacts_cstm add column kerndaemmungart_c varchar(255) NULL ; /*MISSING IN DATABASE - kellerdeckeart_c - ROW*/ alter table contacts_cstm add column kellerdeckeart_c varchar(255) NULL ; /*MISSING IN DATABASE - dachschraegeart_c - ROW*/ alter table contacts_cstm add column dachschraegeart_c varchar(255) NULL ; /*MISSING IN DATABASE - deckeletztesgeschossart_c - ROW*/ alter table contacts_cstm add column deckeletztesgeschossart_c varchar(255) NULL ; /*MISSING IN DATABASE - falchdachartdaemmung_c - ROW*/ alter table contacts_cstm add column falchdachartdaemmung_c varchar(255) NULL ; /*MISSING IN DATABASE - einstellunggesrpaech_c - ROW*/ alter table contacts_cstm add column einstellunggesrpaech_c varchar(100) DEFAULT 'leer' NULL ; /*MISSING IN DATABASE - infosverstaendlich_c - ROW*/ alter table contacts_cstm add column infosverstaendlich_c varchar(100) DEFAULT 'leer' NULL ; /*MISSING IN DATABASE - arbeitsweise_c - ROW*/ alter table contacts_cstm add column arbeitsweise_c varchar(100) DEFAULT 'leer' NULL ; /*MISSING IN DATABASE - vorteilgespraech_c - ROW*/ alter table contacts_cstm add column vorteilgespraech_c varchar(100) DEFAULT 'yes' NULL ; /*MISSING IN DATABASE - arbeitsweiseempfehlen_c - ROW*/ alter table contacts_cstm add column arbeitsweiseempfehlen_c varchar(100) DEFAULT 'leer' NULL ; /*MISSING IN DATABASE - empfehlungerhalten_c - ROW*/ alter table contacts_cstm add column empfehlungerhalten_c varchar(100) DEFAULT 'leer' NULL ;
and get the following messageCode:alter table contacts_cstm add column innendaemmungart_c varchar(255) NULL ;
#1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
i read http://dev.mysql.com/doc/refman/5.0/...unt-limit.html
So i had the limit reached?
any Idea were i can add my custom fields in another way?
System
ubuntu
SugarCRM 6.1.4
and also tested with 6.1.6
thanks and best regards


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks