Sobre este proyecto
it-programming / web-development
Abierto
Tenemos una instalación de Suite CRM ya funcionando y al realizar las ultimas actualizaciones ha surgido un error en la base de datos que aparece al intentar hacer una reparación rápida:
/* Table : kab_sweetactivities */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - description - ROW [name] => 'description' [type] => 'mediumtext' */
/* VARDEF - description - ROW[name] => 'description' [vname] => 'LBL_DESCRIPTION' [type] => 'text' [comment] => 'Full text of the note' [rows] => '6' [cols] => '80' [dbType] => 'text' [len] => '' [required] => '' */
/*MISMATCH WITH DATABASE - record_type - ROW [name] => 'record_type' [type] => 'varchar' [len] => '8' [required] => 'true' */
/* VARDEF - record_type - ROW[name] => 'record_type' [vname] => 'LBL_RECORD_TYPE' [dbType] => 'varchar' [type] => 'varchar' [len] => '50' [comment] => 'The type of record this is' [required] => '' */
/*MISMATCH WITH DATABASE - duration_hours - ROW [name] => 'duration_hours' [type] => 'bigint' */
/* VARDEF - duration_hours - ROW[name] => 'duration_hours' [vname] => 'LBL_DURATION_HOURS' [type] => 'int' [len] => '2' [comment] => 'Call duration, hours portion' [required] => '' [dbType] => 'int' */
/*MISMATCH WITH DATABASE - duration_minutes - ROW [name] => 'duration_minutes' [type] => 'bigint' */
/* VARDEF - duration_minutes - ROW[name] => 'duration_minutes' [vname] => 'LBL_DURATION_MINUTES' [type] => 'int' [len] => '2' [group] => 'duration_hours' [importable] => 'required' [comment] => 'Call duration, minutes portion' [dbType] => 'int' [required] => '' */
/*MISMATCH WITH DATABASE - date_end - ROW [name] => 'date_end' [type] => 'varchar' [len] => '19' */
/* VARDEF - date_end - ROW[name] => 'date_end' [vname] => 'LBL_DATE_END' [type] => 'datetime' [dbType] => 'datetime' [massupdate] => '' [comment] => 'Date is which call is scheduled to (or did) end' [enable_range_search] => '1' [options] => 'date_range_search_dom' [len] => '' [required] => '' */
/* INDEXES */
ALTER TABLE kab_sweetactivities modify COLUMN description text NULL , modify COLUMN record_type varchar(50) NULL , modify COLUMN duration_hours int(2) NULL , modify COLUMN duration_minutes int(2) NULL , modify COLUMN date_end datetime NULL ;
Categoría Programación y Tecnología
Subcategoría Programación Web
Plazo de Entrega: No definido
Habilidades necesarias