Index: branches/unlabeled/unlabeled-1.82.2/core/kernel/db/db_event_handler.php =================================================================== diff -u -r7837 -r7842 --- branches/unlabeled/unlabeled-1.82.2/core/kernel/db/db_event_handler.php (.../db_event_handler.php) (revision 7837) +++ branches/unlabeled/unlabeled-1.82.2/core/kernel/db/db_event_handler.php (.../db_event_handler.php) (revision 7842) @@ -1807,7 +1807,7 @@ // 2. create fields (for customdata item) $fields = $this->Application->getUnitOption($event->Prefix, 'Fields', Array()); - $field_options = Array('type' => 'string', 'formatter' => 'kMultiLanguage', 'not_null' => 1, 'db_type' => 'text', 'default' => ''); + $field_options = Array('type' => 'string', 'formatter' => 'kMultiLanguage', 'db_type' => 'text', 'default' => ''); foreach ($custom_fields as $custom_id => $custom_params) { if (isset($fields['cust_'.$custom_id])) continue; $fields['cust_'.$custom_id] = $field_options; Index: branches/unlabeled/unlabeled-1.10.2/core/units/general/helpers/multilanguage.php =================================================================== diff -u -r7636 -r7842 --- branches/unlabeled/unlabeled-1.10.2/core/units/general/helpers/multilanguage.php (.../multilanguage.php) (revision 7636) +++ branches/unlabeled/unlabeled-1.10.2/core/units/general/helpers/multilanguage.php (.../multilanguage.php) (revision 7842) @@ -140,8 +140,15 @@ $field_mask['type'] = $field_options['db_type']; } $field_mask['default'] = 'DEFAULT '.$default_value; - $field_mask = $field_mask['name'].' '.$field_mask['type'].' '.$field_mask['null'].' '.$field_mask['default']; - + + if (strtoupper($field_mask['type']) == 'TEXT') { + // text fields in mysql doesn't have default value + $field_mask = $field_mask['name'].' '.$field_mask['type'].' '.$field_mask['null']; + } + else { + $field_mask = $field_mask['name'].' '.$field_mask['type'].' '.$field_mask['null'].' '.$field_mask['default']; + } + $sqls[] = 'ALTER TABLE '.$table_name.( $this->generateAlterSQL($field_mask, $created_count + 1, $create_count) ); } }