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


LinkBack URL
About LinkBacks




Reply With Quote
Bookmarks