H
H
html-css2020-02-17 03:45:32
MySQL
html-css, 2020-02-17 03:45:32

Phpmyadmin can't import database Error SQL query?

I can't import the database,
what does it want?

Error
SQL query:

-- --------------------------------------------------------

--
-- Table structure for table `lh0uv_modules`
--

CREATE TABLE `lh0uv_modules` (
  `id` int(11) NOT NULL,
  `asset_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `note` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `content` text COLLATE utf8_unicode_ci NOT NULL DEFAULT '\'\\\'\\\'\'',
  `ordering` int(11) NOT NULL DEFAULT 0,
  `position` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `checked_out` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL DEFAULT 0,
  `module` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `access` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `showtitle` tin[...]

MySQL said: Documentation

#1101 - BLOB, TEXT, GEOMETRY or JSON column 'content' can't have a default value

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexey Ukolov, 2020-02-17
@html-css

#1101 - BLOB, TEXT, GEOMETRY or JSON column 'content' can't have a default value

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question