Пытался установить Аддон: Проверка IP для Polls Results FX
Ссылка: http://www.phpbbguru.net/community/view ... 81#p495881
но при запросе к базе данных:
Код: Выделить всё
CREATE TABLE `phpbb_poll_ip` (
`topic_id` mediumint( 8 ) unsigned NOT NULL default '0',
`poll_option_id` tinyint( 4 ) NOT NULL default '0',
`vote_user_id` mediumint( 8 ) unsigned NOT NULL default '0',
`vote_user_ip` varchar( 40 ) COLLATE utf8_bin NOT NULL default '',
KEY `topic_id` ( `topic_id` ) ,
KEY `vote_user_id` ( `vote_user_id` ) ,
KEY `vote_user_ip` ( `vote_user_ip` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
Код: Выделить всё
Ошибка
SQL-запрос:
`topic_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0', `poll_option_id` TINYINT( 4 ) NOT NULL DEFAULT '0', `vote_user_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0', `vote_user_ip` VARCHAR( 40 ) COLLATE utf8_bin NOT NULL DEFAULT '', KEY `topic_id` ( `topic_id` ) , KEY `vote_user_id` ( `vote_user_id` ) , KEY `vote_user_ip` ( `vote_user_ip` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin
Ответ MySQL: Документация
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`topic_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
`poll_option_id` TIN' at line 1
Заранее спасибо