Results 1 to 1 of 1

Thread: MySQL error 1118: Row size too large.

  1. #1
    endergonic is offline Junior Member
    Join Date
    Aug 2010
    Posts
    2

    Default MySQL error 1118: Row size too large.

    Sugar Version 6.1.3 (Build 5640)
    Sugar: CE Edition
    Category: Custom Module?
    CentOS release 5.4 (Final)
    PHP 5.2.10
    MySQL client version: 5.0.77
    Apache/2.2.3

    Steps taken
    1. Deployed Custom Module from Module Builder
    2. Clicked on the "Module Load" link in the Administration
    3. Clicked on "install" button for custom module that was Deployed in step 1.

    Which resulted

    Rebuilding Modules...
    Installing Images
    Installing Variable Definitions
    Rebuilding Vardefs...
    Installing Subpanel Layouts
    Rebuilding Layoutdefs...
    Installing Relationships
    Rebuilding Vardefs...
    Rebuilding Layoutdefs...
    Rebuilding administration Section...
    Installing Language Packs
    Rebuilding Language...en_us
    Installing Bean : proc_Client_Process
    Database failure. Please refer to sugarcrm.log for details.

    sugarcrm.log

    Thu Mar 31 13:14:39 2011 [19974][1][FATAL] Error creating table: proc_process_client: Query Failed: CREATE TABLE proc_process_client (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime .......... MySQL error 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

    4. Clicked Quick Repair and Rebuild

    Differences found between database and vardefs

    /* Table : proc_client_process */
    /* MISSING TABLE: proc_client_process */
    CREATE TABLE proc_client_process (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,account_id_c char(36)

    5. Clicked execute
    Database failure. Please refer to sugarcrm.log for details.
    same MySQL error 1118

    Even with the above errors the module appears to be installed and functioning, not sure if I should ignore the error or what.

    Any help or ideas on how to remedy this error would be appreciated

    Thanks
    Last edited by endergonic; 2011-03-31 at 09:00 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 2011-03-21, 04:56 AM
  2. Getting Error Exporting Large Report
    By hadoob024 in forum Help
    Replies: 3
    Last Post: 2011-02-11, 03:15 PM
  3. Replies: 0
    Last Post: 2008-02-06, 11:09 PM
  4. Replies: 0
    Last Post: 2006-04-01, 08:28 AM
  5. mySQL database too large
    By guz843 in forum Help
    Replies: 0
    Last Post: 2006-01-28, 09:00 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
  •