WordPress database error: [CREATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignpsp_link_builder']CREATE TABLE IF NOT EXISTS `smartdesignpsp_link_builder` (
`id` INT(10) NOT NULL AUTO_INCREMENT,
`hits` INT(10) NULL DEFAULT '0',
`phrase` VARCHAR(100) NULL DEFAULT NULL,
`url` VARCHAR(200) NULL DEFAULT NULL,
`rel` ENUM('no','alternate','author','bookmark','help','license','next','nofollow','noreferrer','prefetch','prev','search','tag') NULL DEFAULT 'no',
`title` VARCHAR(100) NULL DEFAULT NULL,
`target` ENUM('no','_blank','_parent','_self','_top') NULL DEFAULT 'no',
`post_id` INT(10) NULL DEFAULT '0',
`created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`publish` CHAR(1) NULL DEFAULT 'Y',
`max_replacements` SMALLINT(2) NULL DEFAULT '1',
`attr_title` TEXT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `unique` (`phrase`, `url`),
INDEX `url` (`url`),
INDEX `publish` (`publish`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
WordPress database error: [CREATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignpsp_link_redirect']CREATE TABLE IF NOT EXISTS `smartdesignpsp_link_redirect` (
`id` INT(10) NOT NULL AUTO_INCREMENT,
`hits` INT(10) NULL DEFAULT '0',
`url` VARCHAR(255) NULL DEFAULT NULL,
`url_redirect` VARCHAR(150) NULL DEFAULT NULL,
`created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`redirect_type` VARCHAR(25) NULL DEFAULT '',
`redirect_rule` VARCHAR(25) NULL DEFAULT 'custom_url',
`target_status_code` VARCHAR(25) NULL DEFAULT '',
`target_status_details` TEXT NULL,
`group_id` INT(5) NULL DEFAULT '1',
`post_id` INT(10) NULL DEFAULT '0',
`publish` CHAR(1) NULL DEFAULT 'Y',
PRIMARY KEY (`id`),
UNIQUE INDEX `unique` (`url`),
INDEX `url_redirect` (`url_redirect`),
INDEX `redirect_type` (`redirect_type`),
INDEX `redirect_rule` (`redirect_rule`),
INDEX `target_status_code` (`target_status_code`),
INDEX `group_id` (`group_id`),
INDEX `post_id` (`post_id`),
INDEX `publish` (`publish`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
WordPress database error: [CREATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignpsp_monitor_404']CREATE TABLE IF NOT EXISTS `smartdesignpsp_monitor_404` (
`id` INT(10) NOT NULL AUTO_INCREMENT,
`hits` INT(10) NULL DEFAULT '1',
`url` VARCHAR(200) NULL DEFAULT NULL,
`referrers` TEXT NULL,
`user_agents` TEXT NULL,
`data` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE INDEX `unique` (`url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
WordPress database error: [CREATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignpsp_web_directories']CREATE TABLE IF NOT EXISTS `smartdesignpsp_web_directories` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`directory_name` VARCHAR(255) NULL DEFAULT NULL,
`submit_url` VARCHAR(255) NULL DEFAULT NULL,
`pagerank` DOUBLE NULL DEFAULT NULL,
`alexa` DOUBLE NULL DEFAULT NULL,
`status` SMALLINT(1) NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE INDEX `submit_url` (`submit_url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
WordPress database error: [CREATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignpsp_post_planner_cron']CREATE TABLE IF NOT EXISTS `smartdesignpsp_post_planner_cron` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`id_post` BIGINT(20) NOT NULL,
`post_to` TEXT NULL,
`post_to-page_group` VARCHAR(255) NULL DEFAULT NULL,
`post_privacy` VARCHAR(255) NULL DEFAULT NULL,
`email_at_post` ENUM('off','on') NOT NULL DEFAULT 'off',
`status` SMALLINT(1) NOT NULL DEFAULT '0',
`response` TEXT NULL,
`started_at` TIMESTAMP NULL DEFAULT NULL,
`ended_at` TIMESTAMP NULL DEFAULT NULL,
`run_date` DATETIME NULL DEFAULT NULL,
`repeat_status` ENUM('off','on') NOT NULL DEFAULT 'off' COMMENT 'one-time | repeating',
`repeat_interval` INT(11) NULL DEFAULT NULL COMMENT 'minutes',
`timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`attempts` SMALLINT(6) NOT NULL,
`deleted` TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE INDEX `id_post` (`id_post`),
INDEX `status` (`status`),
INDEX `deleted` (`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
WordPress database error: [CREATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignpsp_report_log']CREATE TABLE IF NOT EXISTS `smartdesignpsp_report_log` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`log_id` VARCHAR(50) NULL DEFAULT NULL,
`log_action` VARCHAR(50) NULL DEFAULT NULL,
`desc` VARCHAR(255) NULL DEFAULT NULL,
`log_data_type` VARCHAR(50) NULL DEFAULT NULL,
`log_data` LONGTEXT NULL,
`source` TEXT NULL,
`date_add` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
INDEX `log_id` (`log_id`),
INDEX `log_action` (`log_action`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
WordPress database error: [CREATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignpsp_serprank_website']CREATE TABLE IF NOT EXISTS `smartdesignpsp_serprank_website` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`website` VARCHAR(255) NULL DEFAULT NULL,
`search_engine` VARCHAR(50) NOT NULL DEFAULT 'google.com',
`is_competitor` CHAR(1) NULL DEFAULT 'Y',
`created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE INDEX `website` (`website`, `search_engine`),
INDEX `search_engine` (`search_engine`),
INDEX `is_competitor` (`is_competitor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
WordPress database error: [CREATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignpsp_serprank_keyword']CREATE TABLE IF NOT EXISTS `smartdesignpsp_serprank_keyword` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`keyword` VARCHAR(255) NULL DEFAULT NULL,
`search_engine` VARCHAR(50) NOT NULL DEFAULT 'google.com',
`created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE INDEX `keyword` (`keyword`, `search_engine`),
INDEX `search_engine` (`search_engine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
WordPress database error: [CREATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignpsp_serprank_mainrank']CREATE TABLE IF NOT EXISTS `smartdesignpsp_serprank_mainrank` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`id_website` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`id_keyword` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`search_engine` VARCHAR(50) NOT NULL DEFAULT 'google.com',
`website_nbpages` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
`position` SMALLINT(3) NOT NULL DEFAULT '-1',
`position_prev` SMALLINT(3) NOT NULL DEFAULT '-1',
`position_worst` SMALLINT(3) NOT NULL DEFAULT '-1',
`position_best` SMALLINT(3) NOT NULL DEFAULT '-1',
`position_last_report` SMALLINT(3) NOT NULL DEFAULT '-1',
`top100` TEXT NULL,
`created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`publish` CHAR(1) NULL DEFAULT 'Y',
`last_check_status` VARCHAR(20) NULL DEFAULT NULL,
`last_check_msg` TEXT NULL,
`last_check_data` DATETIME NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `idx_unique` (`id_keyword`, `search_engine`, `id_website`),
INDEX `website_nbpages` (`website_nbpages`),
INDEX `position` (`position`),
INDEX `position_prev` (`position_prev`),
INDEX `position_last_report` (`position_last_report`),
INDEX `publish` (`publish`),
INDEX `last_check_data` (`last_check_data`),
INDEX `search_engine` (`search_engine`),
INDEX `id_website` (`id_website`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
WordPress database error: [CREATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignpsp_serprank_pagerank']CREATE TABLE IF NOT EXISTS `smartdesignpsp_serprank_pagerank` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`id_mainrank` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`page_link` VARCHAR(255) NULL DEFAULT NULL,
`rank_date` DATETIME NULL DEFAULT NULL,
`position` SMALLINT(3) NOT NULL DEFAULT '-1',
`top100` TEXT NULL,
PRIMARY KEY (`id`),
INDEX `id_mainrank` (`id_mainrank`),
INDEX `page_link` (`page_link`),
INDEX `rank_date` (`rank_date`),
INDEX `position` (`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
WordPress database error: [UPDATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignoptions']UPDATE `smartdesignoptions` SET `option_value` = 'a:2:{s:12:\"check_tables\";a:3:{s:7:\"timeout\";i:1601234052;s:6:\"status\";s:5:\"valid\";s:4:\"html\";s:226:\"Check plugin tables: all installed ( psp_link_builder, psp_link_redirect, psp_monitor_404, psp_post_planner_cron, psp_serprank_keyword, psp_serprank_mainrank, psp_serprank_pagerank, psp_serprank_website, psp_web_directories ).\";}s:18:\"check_alter_tables\";a:3:{s:7:\"timeout\";i:1597266943;s:6:\"status\";s:5:\"valid\";s:4:\"html\";s:32:\"Check plugin tables (alter): OK.\";}}' WHERE `option_name` = 'psp_integrity_check'
WordPress database error: [UPDATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignoptions']UPDATE `smartdesignoptions` SET `option_value` = 'a:2:{s:12:\"check_tables\";a:3:{s:7:\"timeout\";i:1597266943;s:6:\"status\";s:5:\"valid\";s:4:\"html\";s:226:\"Check plugin tables: all installed ( psp_link_builder, psp_link_redirect, psp_monitor_404, psp_post_planner_cron, psp_serprank_keyword, psp_serprank_mainrank, psp_serprank_pagerank, psp_serprank_website, psp_web_directories ).\";}s:18:\"check_alter_tables\";a:3:{s:7:\"timeout\";i:1601234052;s:6:\"status\";s:5:\"valid\";s:4:\"html\";s:32:\"Check plugin tables (alter): OK.\";}}' WHERE `option_name` = 'psp_integrity_check'
WordPress database error: [UPDATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignoptions']UPDATE `smartdesignoptions` SET `option_value` = 'a:2:{s:12:\"check_tables\";a:3:{s:7:\"timeout\";i:1597266943;s:6:\"status\";s:5:\"valid\";s:4:\"html\";s:226:\"Check plugin tables: all installed ( psp_link_builder, psp_link_redirect, psp_monitor_404, psp_post_planner_cron, psp_serprank_keyword, psp_serprank_mainrank, psp_serprank_pagerank, psp_serprank_website, psp_web_directories ).\";}s:18:\"check_alter_tables\";a:3:{s:7:\"timeout\";i:1601234052;s:6:\"status\";s:5:\"valid\";s:4:\"html\";s:32:\"Check plugin tables (alter): OK.\";}}' WHERE `option_name` = 'psp_integrity_check'
WordPress database error: [INSERT, UPDATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignoptions']INSERT INTO `smartdesignoptions` (`option_name`, `option_value`, `autoload`) VALUES ('psp_db_version', '2.0.4', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [INSERT, UPDATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignoptions']INSERT INTO `smartdesignoptions` (`option_name`, `option_value`, `autoload`) VALUES ('psp_db_version', '3.1.9', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [INSERT, UPDATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignwfconfig']INSERT INTO smartdesignwfconfig (name, val, autoload) values ('lastPermissionsTemplateCheck', '1601234052', 'yes') ON DUPLICATE KEY UPDATE val = '1601234052', autoload = 'yes'
WordPress database error: [INSERT, UPDATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignwfconfig']INSERT INTO smartdesignwfconfig (name, val, autoload) values ('previousWflogsFileList', '[\"config-transient.php\",\"config-livewaf.php\",\"GeoLite2-Country.mmdb\",\"config.php\",\"rules.php\",\"config-synced.php\",\"template.php\",\".htaccess\",\"attack-data.php\",\"ips.php\"]', 'yes') ON DUPLICATE KEY UPDATE val = '[\"config-transient.php\",\"config-livewaf.php\",\"GeoLite2-Country.mmdb\",\"config.php\",\"rules.php\",\"config-synced.php\",\"template.php\",\".htaccess\",\"attack-data.php\",\"ips.php\"]', autoload = 'yes'
WordPress database error: [INSERT, UPDATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignwfconfig']INSERT INTO smartdesignwfconfig (name, val, autoload) values ('serverDNS', '1601234052;221;188.165.53.185', 'yes') ON DUPLICATE KEY UPDATE val = '1601234052;221;188.165.53.185', autoload = 'yes'
WordPress database error: [UPDATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignoptions']UPDATE `smartdesignoptions` SET `option_value` = '1601234052.9173159599304199218750' WHERE `option_name` = '_transient_doing_cron'
WordPress database error: [INSERT, UPDATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignoptions']INSERT INTO `smartdesignoptions` (`option_name`, `option_value`, `autoload`) VALUES ('_wp_session_844f9642d2c75e35203690c4d6b373a9', 'a:2:{s:11:\"OriginalRef\";s:6:\"Direct\";s:11:\"LandingPage\";s:37:\"http://smart-design-twv.ch/portfolio/\";}', 'no') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [INSERT, UPDATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignoptions']INSERT INTO `smartdesignoptions` (`option_name`, `option_value`, `autoload`) VALUES ('_wp_session_expires_844f9642d2c75e35203690c4d6b373a9', '1601235841', 'no') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [INSERT, UPDATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignoptions']INSERT INTO `smartdesignoptions` (`option_name`, `option_value`, `autoload`) VALUES ('_wp_session_844f9642d2c75e35203690c4d6b373a9', 'a:2:{s:11:\"OriginalRef\";s:6:\"Direct\";s:11:\"LandingPage\";s:37:\"http://smart-design-twv.ch/portfolio/\";}', 'no') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [INSERT, UPDATE command denied to user 'sbtwvcomyk718'@'10.10.102.2' for table 'smartdesignoptions']INSERT INTO `smartdesignoptions` (`option_name`, `option_value`, `autoload`) VALUES ('_wp_session_expires_844f9642d2c75e35203690c4d6b373a9', '1601235841', 'no') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
