Support » Plugin: Admin Columns » Admin Columns – Latest version not working

  • Resolved rahulthipse

    (@rahulthipse)


    Admin Columns – Latest version 4.4.5 not working.

    We tried to upgrade from 3.4.8 => 4.4.5, it is not working for Post columns.

    We tried to change order of Category or Tags column to Seq as 2 or 3, then that sequence is not getting save & also post Page is also not getting change as per settings.

    Please let us know your comment to use it

    Thanks

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Stefan van den Dungen Gronovius

    (@dungengronovius)

    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?

    Thread Starter rahulthipse

    (@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 6 months, 3 weeks ago by rahulthipse.
    Plugin Contributor Stefan van den Dungen Gronovius

    (@dungengronovius)

    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.

    Thread Starter rahulthipse

    (@rahulthipse)

    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
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Admin Columns – Latest version not working’ is closed to new replies.