drupal_100
asked on
Drupal watchdog message display in administration Repport and MySQL SELECT different
When look at log details from http://website/admin/reports/dblog/event/12599, it shows as following:
Starting execution of search_cron(), execution of node_cron() took 5.26ms.
When use SQL select message from watchdog, it shows as following:
Starting execution of @module_cron(), execution of @module_previous_cron() took @time.
How to make SQL to display the same as seen from website log details.
CREATE TABLE `watchdog` (
`wid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique watchdog event ID.',
`uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The users.uid of the user who triggered the event.',
`type` varchar(64) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Type of log message, for example "user" or "page not found."',
`message` longtext NOT NULL COMMENT 'Text of log message to be passed into the t() function.',
`variables` longblob NOT NULL COMMENT 'Serialized array of variables that match the message string and that is passed into the t() function.',
`severity` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'The severity level of the event. ranges from 0 (Emergency) to 7 (Debug)',
`link` text COMMENT 'Link to view the result of the event.',
`location` text NOT NULL COMMENT 'URL of the origin of the event.',
`referer` text COMMENT 'URL of referring page.',
`hostname` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Hostname of the user who triggered the event.',
`timestamp` int(11) NOT NULL DEFAULT '0' COMMENT 'Unix timestamp of when event occurred.',
PRIMARY KEY (`wid`),
KEY `type` (`type`),
KEY `uid` (`uid`),
KEY `severity` (`severity`)
) ENGINE=InnoDB AUTO_INCREMENT=12614 DEFAULT CHARSET=utf8mb4 COMMENT='Table that contains logs of all system events.'
Starting execution of search_cron(), execution of node_cron() took 5.26ms.
When use SQL select message from watchdog, it shows as following:
Starting execution of @module_cron(), execution of @module_previous_cron() took @time.
How to make SQL to display the same as seen from website log details.
CREATE TABLE `watchdog` (
`wid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique watchdog event ID.',
`uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The users.uid of the user who triggered the event.',
`type` varchar(64) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Type of log message, for example "user" or "page not found."',
`message` longtext NOT NULL COMMENT 'Text of log message to be passed into the t() function.',
`variables` longblob NOT NULL COMMENT 'Serialized array of variables that match the message string and that is passed into the t() function.',
`severity` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'The severity level of the event. ranges from 0 (Emergency) to 7 (Debug)',
`link` text COMMENT 'Link to view the result of the event.',
`location` text NOT NULL COMMENT 'URL of the origin of the event.',
`referer` text COMMENT 'URL of referring page.',
`hostname` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'Hostname of the user who triggered the event.',
`timestamp` int(11) NOT NULL DEFAULT '0' COMMENT 'Unix timestamp of when event occurred.',
PRIMARY KEY (`wid`),
KEY `type` (`type`),
KEY `uid` (`uid`),
KEY `severity` (`severity`)
) ENGINE=InnoDB AUTO_INCREMENT=12614 DEFAULT CHARSET=utf8mb4 COMMENT='Table that contains logs of all system events.'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.