Results 1 to 1 of 1

Thread: MISSING IN DATABASE alter table

  1. #1
    Kupido is offline Sugar Community Member
    Join Date
    Apr 2011
    Posts
    60

    Default MISSING IN DATABASE alter table

    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.

    Code:
    /*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 ;
    in phpmyadmin i make the direct in sql the command
    Code:
    alter table contacts_cstm add column innendaemmungart_c varchar(255)  NULL ;
    and get the following message
    #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
    Last edited by Kupido; 2011-06-06 at 12:23 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. "Query Failed:ALTER TABLE" while upgrading from 6.0.0 to 6.0.1
    By sourjya in forum Installation and Upgrade Help
    Replies: 1
    Last Post: 2011-08-04, 03:04 PM
  2. 5.5.4 to 6.0 silent install alter table error
    By leoleung in forum Installation and Upgrade Help
    Replies: 3
    Last Post: 2010-08-20, 04:56 AM
  3. Replies: 0
    Last Post: 2009-11-05, 07:11 AM
  4. Replies: 3
    Last Post: 2007-08-23, 10:42 AM
  5. Server error: ALTER TABLE ALTER COLUMN failed
    By barrandray in forum Installation and Upgrade Help
    Replies: 4
    Last Post: 2007-07-24, 10:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •