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/fr/lib/core/phpDataMapper/Adapter/PDO.php [line:protected] => 233 [trace:Exception:private] => Array ( [0] => Array ( [file] => /home/amnir/public_html/wap/fr/lib/core/phpDataMapper/Adapter/PDO.php [line] => 233 [function] => exec [class] => PDO [type] => -> [args] => Array ( [0] => ALTER TABLE `audio` MODIFY `id_audio` int DEFAULT NULL, MODIFY `artist_audio` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `title_audio` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `album_audio` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `hit_audio` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `album_cover_audio` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `file_full_audio` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `file_year_audio` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `file_mpeg_audio` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `file_ogg_audio` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `file_wav_audio` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL; ) ) [1] => Array ( [file] => /home/amnir/public_html/wap/fr/lib/core/phpDataMapper/Adapter/PDO.php [line] => 149 [function] => migrateTableUpdate [class] => phpDataMapper_Adapter_PDO [type] => -> [args] => Array ( [0] => audio [1] => Array ( ) ) ) [2] => Array ( [file] => /home/amnir/public_html/wap/fr/lib/core/phpDataMapper/Base.php [line] => 703 [function] => migrate [class] => phpDataMapper_Adapter_PDO [type] => -> [args] => Array ( [0] => audio [1] => Array ( [id_audio] => Array ( [type] => int [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => 1 [index] => [unique] => [serial] => [relation] => ) [artist_audio] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [title_audio] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [album_audio] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [hit_audio] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [album_cover_audio] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [file_mpeg_audio] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [file_ogg_audio] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [file_wav_audio] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [file_full_audio] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [file_year_audio] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) ) ) ) [3] => Array ( [file] => /home/amnir/public_html/wap/fr/actions/multimedia.module.php [line] => 43 [function] => migrate [class] => phpDataMapper_Base [type] => -> [args] => Array ( ) ) [4] => Array ( [file] => /home/amnir/public_html/wap/fr/index.php [line] => 102 [function] => sound_action [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 ) )