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 `heures_prieres` MODIFY `ref` int DEFAULT NULL, MODIFY `fajr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `dhohr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `asr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `maghrib` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `ichaa` datetime DEFAULT NULL, MODIFY `date_debut` datetime DEFAULT NULL, MODIFY `date_fin` varchar(255) COLLATE utf8_unicode_ci NOT 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] => heures_prieres [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] => heures_prieres [1] => Array ( [ref] => Array ( [type] => int [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => 1 [index] => [unique] => [serial] => [relation] => ) [fajr] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [dhohr] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [asr] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [maghrib] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [ichaa] => Array ( [type] => datetime [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [date_debut] => Array ( [type] => datetime [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [date_fin] => Array ( [type] => string [default] => [length] => [required] => 1 [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) ) ) ) [3] => Array ( [file] => /home/amnir/public_html/wap/fr/actions/horairesprieres.module.php [line] => 52 [function] => migrate [class] => phpDataMapper_Base [type] => -> [args] => Array ( ) ) [4] => Array ( [file] => /home/amnir/public_html/wap/fr/index.php [line] => 102 [function] => list_action [class] => horairesprieresMultiActionController [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 ) )