migration hosting issue
Budget: ₹600 – ₹1,500 INR
when I am trying to import db
Error
SQL query:
-- --------------------------------------------------------
--
-- Table structure for table `error_logs`
--
CREATE TABLE `error_logs` (
`id` bigint(20) NOT NULL,
`sessionId` text NOT NULL DEFAULT '0',
`user_type` tinyint(1) NOT NULL DEFAULT 0,
`agent_id` text NOT NULL,
`conductor_id` int(20) NOT NULL DEFAULT 0,
`agent_name` text NOT NULL,
`agency_name` text NOT NULL,
`time_format` text NOT NULL,
`current_dates` text NOT NULL,
`records` text NOT NULL,
`created_date` timestamp NOT NULL DEFAULT current_timestamp(),
`status` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1
MySQL said: Documentation
#1101 - BLOB, TEXT, GEOMETRY or JSON column 'sessionId' can't have a default value
Server type: MariaDB
Error
SQL query:
-- --------------------------------------------------------
--
-- Table structure for table `error_logs`
--
CREATE TABLE `error_logs` (
`id` bigint(20) NOT NULL,
`sessionId` text NOT NULL DEFAULT '0',
`user_type` tinyint(1) NOT NULL DEFAULT 0,
`agent_id` text NOT NULL,
`conductor_id` int(20) NOT NULL DEFAULT 0,
`agent_name` text NOT NULL,
`agency_name` text NOT NULL,
`time_format` text NOT NULL,
`current_dates` text NOT NULL,
`records` text NOT NULL,
`created_date` timestamp NOT NULL DEFAULT current_timestamp(),
`status` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1
MySQL said: Documentation
#1101 - BLOB, TEXT, GEOMETRY or JSON column 'sessionId' can't have a default value
Server type: MariaDB