rahulthipse

Hi Team,
In our log I am getting below error – “wp_admin_columns” Table is not getting Created.

WordPress database error Invalid default value for 'date_created' for query 
		CREATE TABLE wp_admin_columns (
			id bigint(20) unsigned NOT NULL auto_increment,
			list_id varchar(20) NOT NULL default '',
			list_key varchar(100) NOT NULL default '',
			title varchar(255) NOT NULL default '',
			columns mediumtext,
			settings mediumtext,
			date_created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
			date_modified datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
			PRIMARY KEY (id),
			UNIQUE KEY <code>list_id</code> (<code>list_id</code>)
		) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci made by dbDelta

Multi Site

WordPress database error Invalid default value for 'date_created' for query 
		CREATE TABLE wp_100_admin_columns (
			id bigint(20) unsigned NOT NULL auto_increment,
			list_id varchar(20) NOT NULL default '',
			list_key varchar(100) NOT NULL default '',
			title varchar(255) NOT NULL default '',
			columns mediumtext,
			settings mediumtext,
			date_created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
			date_modified datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
			PRIMARY KEY (id),
			UNIQUE KEY <code>list_id</code> (<code>list_id</code>)
		) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci made by dbDelta
[09-Mar-2022 07:26:23 UTC] WordPress database error Table 'news_blogs.wp_100_admin_columns' doesn't exist for query INSERT INTO <code>wp_100_admin_columns</code> (<code>title</code>, <code>list_id</code>, <code>list_key</code>, <code>columns</code>, <code>settings</code>, <code>date_modified</code>, <code>date_created</code>) VALUES ('Original', '6228569f6c54f', 'post', 'a:9:{s:5:\"title\";a:6:{s:4:\"type\";s:5:\"title\";s:5:\"label\";s:5:\"Title\";s:5:\"width\";s:0:\"\";s:10:\"width_unit\";s:1:\"%\";s:4:\"name\";s:5:\"title\";s:10:\"label_type\";N;}s:13:\"5d3db04f63220\";a:14:{s:4:\"type\";s:11:\"column-meta\";s:5:\"label\";s:4:\"Type\";s:5:\"width\";s:0:\"\";s:10:\"width_unit\";s:1:\"%\";s:5:\"field\";s:4:\"type\";s:10:\"field_type\";s:0:\"\";s:6:\"before\";s:0:\"\";s:5:\"after\";s:0:\"\";s:4:\"sort\";N;s:4:\"edit\";N;s:6:\"filter\";N;s:6:\"export\";N;s:4:\"name\";s:13:\"5d3db04f63220\";s:10:\"label_type\";N;}s:13:\"5d3db04f634e5\";a:14:{s:4:\"type\";s:11:\"column-meta\";s:5:\"label\";s:6:\"Author\";s:5:\"width\";s:0:\"\";s:10:\"width_unit\";s:1:\"%\";s:5:\"field\";s:6:\"author\";s:10:\"field_type\";s:0:\"\";s:6:\"before\";s:0:\"\";s:5:\"after\";s:0:\"\";s:4:\"sort\";N;s:4:\"edit\";N;s:6:\"filter\";N;s:6:\"export\";N;s:4:\"name\";s:13:\"5d3db04f634e5\";s:10:\"label_type\";N;}s:6:\"author\";a:6:{s:4:\"type\";s:6:\"author\";s:5:\"label\";s:6:\"Author\";s:5:\"width\";i:10;s:10:\"width_unit\";s:1:\"%\";s:4:\"name\";s:6:\"author\";s:10:\"label_type\";N;}s:10:\"categories\";a:6:{s:4:\"type\";s:10:\"categories\";s:5:\"label\";s:10:\"Categories\";s:5:\"width\";i:15;s:10:\"width_unit\";s:1:\"%\";s:4:\"name\";s:10:\"categories\";s:10:\"label_type\";N;}s:4:\"tags\";a:6:{s:4:\"type\";s:4:\"tags\";s:5:\"label\";s:4:\"Tags\";s:5:\"width\";i:15;s:10:\"width_unit\";s:1:\"%\";s:4:\"name\";s:4:\"tags\";s:10:\"label_type\";N;}s:4:\"date\";a:6:{s:4:\"type\";s:4:\"date\";s:5:\"label\";s:4:\"Date\";s:5:\"width\";s:0:\"\";s:10:\"width_unit\";s:1:\"%\";s:4:\"name\";s:4:\"date\";s:10:\"label_type\";N;}s:11:\"language_en\";a:6:{s:4:\"type\";s:11:\"language_en\";s:5:\"label\";s:948:\"<img src=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAALCAIAAAD5gJpuAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAHzSURBVHjaYkxOP8IAB//+Mfz7w8Dwi4HhP5CcJb/n/7evb16/APL/gRFQDiAAw3JuAgAIBEDQ/iswEERjGzBQLEru97ll0g0+3HvqMn1SpqlqGsZMsZsIe0SICA5gt5a/AGIEarCPtFh+6N/ffwxA9OvP/7//QYwff/6fZahmePeB4dNHhi+fGb59Y4zyvHHmCEAAAW3YDzQYaJJ93a+vX79aVf58//69fvEPlpIfnz59+vDhw7t37968efP3b/SXL59OnjwIEEAsDP+YgY53b2b89++/awvLn98MDi2cVxl+/vl6mituCtBghi9f/v/48e/XL86krj9XzwEEEENy8g6gu22rfn78+NGs5Ofr16+ZC58+fvyYwX8rxOxXr169fPny+fPn1//93bJlBUAAsQADZMEBxj9/GBxb2P/9+S/R8u3vzxuyaX8ZHv3j8/YGms3w8ycQARmi2eE37t4ACCDGR4/uSkrKAS35B3TT////wADOgLOBIaXIyjBlwxKAAGKRXjCB0SOEaeu+/y9fMnz4AHQxCP348R/o+l+//sMZQBNLEvif3AcIIMZbty7Ly6t9ZmXl+fXj/38GoHH/UcGfP79//BBiYHjy9+8/oUkNAAHEwt1V/vI/KBY/QSISFqM/GBg+MzB8A6PfYC5EFiDAABqgW776MP0rAAAAAElFTkSuQmCC\" title=\"English\" alt=\"English\" width=\"16\" height=\"11\" /><span class=\"screen-reader-text\">English</span>\";s:5:\"width\";s:0:\"\";s:10:\"width_unit\";s:1:\"%\";s:4:\"name\";s:11:\"language_en\";s:10:\"label_type\";N;}s:13:\"5d3db04f62ff6\";a:7:{s:4:\"type\";s:14:\"column-actions\";s:5:\"label\";s:7:\"Actions\";s:5:\"width\";i:10;s:10:\"width_unit\";s:1:\"%\";s:9:\"use_icons\";s:0:\"\";s:4:\"name\";s:13:\"5d3db04f62ff6\";s:10:\"label_type\";N;}}', 'a:0:{}', '2022-03-09 07:26:23', '2022-03-09 07:26:23') made by AC\Plugin\Update\V4000::insert

• This reply was modified 4 years, 3 months ago by rahulthipse.