ну так всю команду create table показывай тогда
Было так.
CREATE TABLE IF NOT EXISTS `#__wtproductbuilder_orders`
(
`id` int NOT NULL AUTO_INCREMENT,
`number` varchar(400) NOT NULL,
`products` json NOT NULL,
`layouts` json NOT NULL,
`layouts_json` json NOT NULL COMMENT 'Fabric js canvases after toJSON',
`note` text NOT NULL,
`customer_id` int UNSIGNED NOT NULL,
`created` datetime NOT NULL,
`created_by` int UNSIGNED NOT NULL,
`modified` datetime NOT NULL,
`modified_by` int UNSIGNED NOT NULL,
`state` tinyint NOT NULL,
`cart_id` varchar(400) NOT NULL,
`external_order_id` int NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET = utf8;
Я пустые значения передавал туда.