Plugin couldn't be installed because of: Error importSQL::spam_prot
/home/domain.com/xxxx/oc-content/plugins/spamprotection/assets/create_table.sql
what is this?
Удали все строки /spamprotection/assets/create_table.sql и вставь это:
CREATE TABLE IF NOT EXISTS `oc_t_spam_protection_ban_log` (
`pk_i_id` int(10) NOT NULL,
`i_user_id` int(10) DEFAULT NULL,
`s_user_email` varchar(100) DEFAULT NULL,
`s_user_ip` varchar(50) DEFAULT NULL,
`s_reason` text,
`dt_date_banned` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `oc_t_spam_protection_comments` (
`pk_i_id` int(10) NOT NULL,
`fk_i_comment_id` int(10) DEFAULT NULL,
`fk_i_item_id` int(10) DEFAULT NULL,
`fk_i_user_id` int(10) DEFAULT NULL,
`s_reason` text,
`s_user_mail` varchar(100) DEFAULT NULL,
`dt_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `oc_t_spam_protection_contacts` (
`pk_i_id` int(10) NOT NULL,
`fk_i_item_id` int(10) DEFAULT NULL,
`s_user` varchar(100) DEFAULT NULL,
`fk_i_user_id` int(10) DEFAULT NULL,
`s_user_mail` varchar(100) DEFAULT NULL,
`s_user_phone` varchar(100) DEFAULT NULL,
`s_user_message` text,
`s_reason` text,
`s_token` varchar(13) DEFAULT NULL,
`dt_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `oc_t_spam_protection_global_log` (
`pk_i_id` int(11) NOT NULL,
`s_reason` text,
`s_account` varchar(255) DEFAULT NULL,
`s_done` varchar(255) DEFAULT NULL,
`dt_date` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `oc_t_spam_protection_items` (
`pk_i_id` int(10) NOT NULL,
`fk_i_item_id` int(10) DEFAULT NULL,
`fk_i_user_id` int(10) DEFAULT NULL,
`s_reason` text,
`s_user_mail` varchar(100) DEFAULT NULL,
`dt_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `oc_t_spam_protection_logins` (
`pk_i_id` int(10) NOT NULL,
`s_name` varchar(100) DEFAULT NULL,
`s_email` varchar(100) DEFAULT NULL,
`s_ip` varchar(30) DEFAULT NULL,
`s_type` varchar(5) NOT NULL DEFAULT 'user',
`dt_date_login` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;