PDOException Object ( [message:protected] => SQLSTATE[42000]: Syntax error or access violation: 1171 All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead [string:Exception:private] => [code:protected] => 42000 [file:protected] => /home/amnir/public_html/wap/lib/core/phpDataMapper/Adapter/PDO.php [line:protected] => 233 [trace:Exception:private] => Array ( [0] => Array ( [file] => /home/amnir/public_html/wap/lib/core/phpDataMapper/Adapter/PDO.php [line] => 233 [function] => exec [class] => PDO [type] => -> [args] => Array ( [0] => ALTER TABLE `media` MODIFY `id_media` int DEFAULT NULL, MODIFY `type_media` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `code_media` int DEFAULT NULL, MODIFY `name_media` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `small_media` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `medium_media` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `artist_media` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `title_media` varchar(255) COLLATE utf8_unicode_ci NOT NULL, MODIFY `description_media` varchar(255) COLLATE utf8_unicode_ci NOT NULL, MODIFY `file_media` varchar(255) COLLATE utf8_unicode_ci NOT NULL; ) ) [1] => Array ( [file] => /home/amnir/public_html/wap/lib/core/phpDataMapper/Adapter/PDO.php [line] => 149 [function] => migrateTableUpdate [class] => phpDataMapper_Adapter_PDO [type] => -> [args] => Array ( [0] => media [1] => Array ( ) ) ) [2] => Array ( [file] => /home/amnir/public_html/wap/lib/core/phpDataMapper/Base.php [line] => 726 [function] => migrate [class] => phpDataMapper_Adapter_PDO [type] => -> [args] => Array ( [0] => media [1] => Array ( [id_media] => Array ( [type] => int [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => 1 [index] => [unique] => [serial] => [relation] => ) [type_media] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [code_media] => Array ( [type] => int [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => 1 [relation] => ) [name_media] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [small_media] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [medium_media] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [artist_media] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => 1 [relation] => ) [title_media] => Array ( [type] => string [default] => [length] => [required] => 1 [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [file_media] => Array ( [type] => string [default] => [length] => [required] => 1 [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [description_media] => Array ( [type] => string [default] => [length] => [required] => 1 [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) ) ) ) [3] => Array ( [file] => /home/amnir/public_html/wap/actions/multimedia.module.php [line] => 202 [function] => migrate [class] => phpDataMapper_Base [type] => -> [args] => Array ( ) ) [4] => Array ( [file] => /home/amnir/public_html/wap/index.php [line] => 100 [function] => iv_action_arabe [class] => multimediaMultiActionController [type] => -> [args] => Array ( ) ) ) [previous:Exception:private] => [errorInfo] => Array ( [0] => 42000 [1] => 1171 [2] => All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead ) )