При добавлении потока с русским названием выдает ошибку:
Цитата
Произошла ошибка
При выполнении запроса произошла ошибка: (error #1267) Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation '='
Адрес ошибки: /home/zpcity/public_html/modules/tv/admin/index.php[175].
Лог:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation '='
Query:SELECT `id` FROM `el_tv` WHERE `url`='5-канал' LIMIT 1
Line: 175 in file /home/zpcity/public_html/modules/tv/admin/index.php
URL: /admin.php?section=modules&key=51aca420a3287e11714061e9c4cae079&module=tv&SaveStation=New
Date: 2009-05-14 20:41:55
IP: ***
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation '='
Query:SELECT `id` FROM `el_tv` WHERE `url`='5-канал' LIMIT 1
Line: 175 in file /home/zpcity/public_html/modules/tv/admin/index.php
URL: /admin.php?section=modules&key=51aca420a3287e11714061e9c4cae079&module=tv&SaveStation=New
Date: 2009-05-14 20:42:06
IP: ***
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation '='
Query:SELECT `id` FROM `el_tv` WHERE `url`='5-канал' AND `id`!=1 LIMIT 1
Line: 175 in file /home/zpcity/public_html/modules/tv/admin/index.php
URL: /admin.php?section=modules&key=51aca420a3287e11714061e9c4cae079&module=tv&SaveStation=1
Date: 2009-05-14 20:43:06
IP: ***
Уже разобрался.Если у вас каналы с русским описанием\названием то sql запрос будет таким:
Цитата
CREATE TABLE `{p}tv` (
`id` int(11) NOT NULL auto_increment,
`url` varchar(50) NOT NULL,
`title` varchar(100) NOT NULL,
`img` varchar(100) NOT NULL,
`stream` varchar(200) NOT NULL,
`descr` text NOT NULL,
`status` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`)
) ENGINE=MyISAM DEFAULT CHARSET={ch};