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 `horaires` MODIFY `ref` int DEFAULT NULL, MODIFY `nom_compagnie` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `depart` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `destination` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `jours` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `debut_date_validite` datetime DEFAULT NULL, MODIFY `fin_date_validite` datetime DEFAULT NULL, MODIFY `heure_depart` varchar(255) COLLATE utf8_unicode_ci NOT NULL, MODIFY `heure_arrivee` varchar(255) COLLATE utf8_unicode_ci NOT NULL, MODIFY `num_vol` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `avion` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MODIFY `classe` varchar(255) COLLATE utf8_unicode_ci NOT NULL, MODIFY `via` varchar(255) COLLATE utf8_unicode_ci NOT NULL, MODIFY `borne` int DEFAULT NULL, MODIFY `retards` varchar(255) COLLATE utf8_unicode_ci NOT NULL, MODIFY `suite` int DEFAULT NULL, MODIFY `hstatut` int 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] => horaires [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] => horaires [1] => Array ( [ref] => Array ( [type] => int [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => 1 [index] => [unique] => [serial] => [relation] => ) [nom_compagnie] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [destination] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [depart] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [jours] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [debut_date_validite] => Array ( [type] => datetime [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [fin_date_validite] => Array ( [type] => datetime [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [heure_depart] => Array ( [type] => string [default] => [length] => [required] => 1 [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [heure_arrivee] => Array ( [type] => string [default] => [length] => [required] => 1 [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [num_vol] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [avion] => Array ( [type] => string [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [classe] => Array ( [type] => string [default] => [length] => [required] => 1 [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [via] => Array ( [type] => string [default] => [length] => [required] => 1 [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [borne] => Array ( [type] => int [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => 1 [relation] => ) [hstatut] => Array ( [type] => int [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [retards] => Array ( [type] => string [default] => [length] => [required] => 1 [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [suite] => Array ( [type] => int [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) ) ) ) [3] => Array ( [file] => /home/amnir/public_html/wap/fr/actions/hvols.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] => list_action [class] => hvolsMultiActionController [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 ) )