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 `news` MODIFY `news_ref` int DEFAULT NULL AUTO_INCREMENT, MODIFY `news_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, MODIFY `news_body` text COLLATE utf8_unicode_ci NOT NULL, MODIFY `news_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL, MODIFY `news_excerpt` varchar(255) COLLATE utf8_unicode_ci NOT NULL, MODIFY `news_status` int DEFAULT NULL, MODIFY `news_langue` varchar(255) COLLATE utf8_unicode_ci NOT NULL, MODIFY `news_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL, MODIFY `news_thumbnail` 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] => news [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] => news [1] => Array ( [news_ref] => Array ( [type] => int [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => 1 [index] => [unique] => [serial] => 1 [relation] => ) [news_title] => Array ( [type] => string [default] => [length] => [required] => 1 [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [news_excerpt] => Array ( [type] => string [default] => [length] => [required] => 1 [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [news_body] => Array ( [type] => text [default] => [length] => [required] => 1 [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [news_date] => Array ( [type] => string [default] => [length] => [required] => 1 [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [news_status] => Array ( [type] => int [default] => [length] => [required] => [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => 1 [relation] => ) [news_langue] => Array ( [type] => string [default] => [length] => [required] => 1 [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [news_url] => Array ( [type] => string [default] => [length] => [required] => 1 [null] => 1 [unsigned] => [primary] => [index] => [unique] => [serial] => [relation] => ) [news_thumbnail] => 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/news.module.php [line] => 305 [function] => migrate [class] => phpDataMapper_Base [type] => -> [args] => Array ( ) ) [4] => Array ( [file] => /home/amnir/public_html/wap/fr/index.php [line] => 102 [function] => read_action [class] => newsMultiActionController [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 ) )