Hello,
I have a ExpressionEngine runing, and I want to migrate of hosting.
The issue is: when I import the data-base into the new hosting/phpMyAdmin, I got this error:
Error
consulta SQL:
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `crm_items`
--
CREATE TABLE `crm_items` (
`id` int(11) NOT NULL,
`description` mediumtext NOT NULL,
`long_description` text DEFAULT NULL,
`rate` decimal(15,2) NOT NULL,
`tax` int(11) DEFAULT NULL,
`tax2` int(11) DEFAULT NULL,
`unit` varchar(40) DEFAULT NULL,
`group_id` int(11) NOT NULL DEFAULT 0,
`commodity_code` varchar(100) NOT NULL,
`commodity_barcode` text DEFAULT NULL,
`commodity_type` int(11) DEFAULT NULL,
`commodity_vendor` varchar(200) NOT NULL,
`warehouse_id` int(11) DEFAULT NULL,
`origin` varchar(100) DEFAULT NULL,
`color_id` int(11) DEFAULT NULL,
`style_id` int(11) DEFAULT NULL,
`model_id` int(11) DEFAULT NULL,
`size_id` int(11) DEFAULT NULL,
`unit_id` int(11) DEFAULT NULL,
`sku_code` varchar(200) DEFAULT NULL,
`sku_name` varchar(200) DEFAULT NULL,
`purchase_price` decimal(15,2) DEFAULT NULL,
`sub_group` varchar(200) DEFAULT NULL[...]
MySQL ha dicho: Documentación
#1067 - Valor por defecto invalido para 'mk_date'
Do you know how to fix it?