Admin Columns – Latest version not working

I see that you upgraded the plugin from an old version. Can you check and confirm that none of your column settings are stored correctly? Are you also not able to change the labels for the column on other pages?

Can you install the plugin ‘Query Monitor’ and check if there are any Database errors on the settings page?

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 2 years, 8 months ago by rahulthipse.

You can go to our settings page and add the following to the URL

&ac-force-install=1

That should force to run the installation script that also creates the necessary table(s) in the database.

I have added in URL
wp-admin/options-general.php?page=codepress-admin-columns&tab=settings&ac-force-install=1

Still Getting same error – DB table is not created

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