Plesk error: MySQL query failed: Unknown column "s.click_time" in "field list"

[Jithin M]

Hi all,

In certain instances, upgrading the Parallels Plesk Panel (Plesk) control panel to version 12 makes it unavailable, throwing out the following error while accessing it:

Code: [Select]

MySQL query failed: Unknown column "s.click_time" in "field list"


The reason for the same is that the 'click_time' column is missing from the 'psa.sessions' table.


This issue can be resolved by following the steps given below:

1) Access the Plesk database:

Code: [Select]

# plesk db

2) Drop the 'sessions' table and recreate it with the following SQL query:

Code: [Select]

mysql> drop table sessions;

mysql> CREATE TABLE `sessions` (
  `sess_id` varchar(33) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `type` smallint(5) unsigned NOT NULL,
  `login` varchar(255) NOT NULL,
  `ip_address` varchar(39) CHARACTER SET ascii NOT NULL,
  `ip_dual_stack` varchar(39) CHARACTER SET ascii DEFAULT NULL,
  `login_time` datetime NOT NULL,
  `click_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modified` int(10) unsigned DEFAULT NULL,
  `lifetime` int(10) unsigned DEFAULT NULL,
  `data` mediumblob,
  PRIMARY KEY (`sess_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


It works