我有mysql和我的drupal 7网站的问题 . 有许多模块想要在我的bdd中插入数据,我有以下错误:

PDOException : SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column 'field_image54_width' at row 1: INSERT INTO {field_data_field_image54} (entity_type, entity_id, revision_id, bundle, delta, language, field_image54_fid, field_image54_alt, field_image54_title, field_image54_width, field_image54_height) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 24 [:db_insert_placeholder_2] => 24 [:db_insert_placeholder_3] => flexslidertest [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => 51 [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => [:db_insert_placeholder_9] => [:db_insert_placeholder_10] => ) dans field_sql_storage_field_storage_write() (ligne 514 dans /home/sinus/Web/Mysite/modules/field/modules/field_sql_storage/field_sql_storage.module).

如果我将field_image54_width的类型从int更改为varchar它可以工作,但它不是一个好的解决方案,我想我需要更改我的sql配置 .

我在localhost上的archlinux(在我的电脑上) . mysql Ver 15.1使用readline 5.1分发10.1.18-MariaDB,用于Linux(x86_64)

服务器连接排序规则为utf8mb4_unicode_ci,排序规则表为utf8_general_ci