Поиск

ALTER TABLE `search_page_table` CHANGE `search_page_address` `search_page_address` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

Ответ MySQL: Документация
#1170 - BLOB/TEXT column 'search_page_address' used in key specification without a key length

Дело в том, что индекс не может быть бесконечной длины - только от 0 до 512 байт (в старых версиях и того ниже). Текстовые поля могут выступать в качестве индексов, но лишь часть, которую требуется указать, например первые 10 символов строки. Указывая TEXT вы сообщаете, что хотите проиндексировать 65536 символов - это слишком много для индекса.

ALTER TABLE `search_page_table` DROP INDEX `search_page_address`;
ALTER TABLE `search_page_table` CHANGE `search_page_address` `search_page_address` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `search_page_table` ADD INDEX ( `search_page_address` ( 255 ) );

<div onmouseover="myShow(318)" onmouseout="myHide(318)"><div class="mts" id="mtu_318"><b>1</b><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/" title="Услуги">Услуги</a></div><div class="pMts" id="pMtu_318"><div class="leftM"></div><div class="rightM"></div><div class="pMtsu"><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%A0%D0%B0%D0%B7%D1%80%D0%B0%D0%B1%D0%BE%D1%82%D0%BA%D0%B0_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/">1. Разработка сайта</a><div><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%A0%D0%B0%D0%B7%D1%80%D0%B0%D0%B1%D0%BE%D1%82%D0%BA%D0%B0_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/%D1%8D%D1%82%D0%B0%D0%BF%D1%8B_%D1%80%D0%B0%D0%B7%D1%80%D0%B0%D0%B1%D0%BE%D1%82%D0%BA%D0%B8_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/">Этапы разработки сайта</a><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%A0%D0%B0%D0%B7%D1%80%D0%B0%D0%B1%D0%BE%D1%82%D0%BA%D0%B0_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/Web-%D0%B4%D0%B8%D0%B7%D0%B0%D0%B9%D0%BD/">Web-дизайн</a><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%A0%D0%B0%D0%B7%D1%80%D0%B0%D0%B1%D0%BE%D1%82%D0%BA%D0%B0_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/Web-%D0%BF%D1%80%D0%BE%D0%B3%D1%80%D0%B0%D0%BC%D0%BC%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5/">Web-программирование</a><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%A0%D0%B0%D0%B7%D1%80%D0%B0%D0%B1%D0%BE%D1%82%D0%BA%D0%B0_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/%D0%A1%D0%B8%D1%81%D1%82%D0%B5%D0%BC%D0%B0_%D1%83%D0%BF%D1%80%D0%B0%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D1%8F_%D1%81%D0%B0%D0%B9%D1%82%D0%BE%D0%BC_CMS/">Система управления сайтом (CMS)</a><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%A0%D0%B0%D0%B7%D1%80%D0%B0%D0%B1%D0%BE%D1%82%D0%BA%D0%B0_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/%D0%A0%D0%B5%D0%B3%D0%B8%D1%81%D1%82%D1%80%D0%B0%D1%86%D0%B8%D1%8F_%D0%B4%D0%BE%D0%BC%D0%B5%D0%BD%D0%B0/">Регистрация домена</a><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%A0%D0%B0%D0%B7%D1%80%D0%B0%D0%B1%D0%BE%D1%82%D0%BA%D0%B0_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/%D0%A5%D0%BE%D1%81%D1%82%D0%B8%D0%BD%D0%B3/">Хостинг</a></div></div><div class="pMtsu"><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%9F%D1%80%D0%BE%D0%B4%D0%B2%D0%B8%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/">2. Продвижение сайта</a><div><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%9F%D1%80%D0%BE%D0%B4%D0%B2%D0%B8%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/%D0%B8%D0%BD%D1%81%D1%82%D1%80%D1%83%D0%BC%D0%B5%D0%BD%D1%82%D1%8B_%D0%BF%D1%80%D0%BE%D0%B4%D0%B2%D0%B8%D0%B6%D0%B5%D0%BD%D0%B8%D1%8F_%D1%81%D0%B0%D0%B9%D1%82%D0%BE%D0%B2/">Инструменты продвижения сайтов</a><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%9F%D1%80%D0%BE%D0%B4%D0%B2%D0%B8%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/%D0%90%D1%83%D0%B4%D0%B8%D1%82_%D1%81%D0%BE%D1%81%D1%82%D0%BE%D1%8F%D0%BD%D0%B8%D1%8F_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/">Аудит состояния сайта</a><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%9F%D1%80%D0%BE%D0%B4%D0%B2%D0%B8%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/%D0%9F%D0%BE%D0%B8%D1%81%D0%BA%D0%BE%D0%B2%D0%B0%D1%8F_%D0%BE%D0%BF%D1%82%D0%B8%D0%BC%D0%B8%D0%B7%D0%B0%D1%86%D0%B8%D1%8F/">Поисковая оптимизация</a><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%9F%D1%80%D0%BE%D0%B4%D0%B2%D0%B8%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/SEO_%D0%BA%D0%BE%D0%BF%D0%B8%D1%80%D0%B0%D0%B9%D1%82%D0%B8%D0%BD%D0%B3/">SEO-копирайтинг</a></div></div><div class="pMtsu"><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%9F%D0%BE%D0%B4%D0%B4%D0%B5%D1%80%D0%B6%D0%BA%D0%B0_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/">3. Поддержка сайта</a><div><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%9F%D0%BE%D0%B4%D0%B4%D0%B5%D1%80%D0%B6%D0%BA%D0%B0_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/%D0%9F%D0%B5%D1%80%D0%B2%D0%B8%D1%87%D0%BD%D0%BE%D0%B5_%D0%BD%D0%B0%D0%BF%D0%BE%D0%BB%D0%BD%D0%B5%D0%BD%D0%B8%D0%B5_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/">Первичное наполнение сайта</a><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%9F%D0%BE%D0%B4%D0%B4%D0%B5%D1%80%D0%B6%D0%BA%D0%B0_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/%D0%98%D0%BD%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%86%D0%B8%D0%BE%D0%BD%D0%BD%D0%B0%D1%8F_%D0%BF%D0%BE%D0%B4%D0%B4%D0%B5%D1%80%D0%B6%D0%BA%D0%B0_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/">Информационная поддержка сайта</a><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%9F%D0%BE%D0%B4%D0%B4%D0%B5%D1%80%D0%B6%D0%BA%D0%B0_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/%D0%9A%D0%BE%D0%BC%D0%BF%D0%BB%D0%B5%D0%BA%D1%81%D0%BD%D0%BE%D0%B5_%D1%81%D0%BE%D0%BF%D1%80%D0%BE%D0%B2%D0%BE%D0%B6%D0%B4%D0%B5%D0%BD%D0%B8%D0%B5_%D1%81%D0%B0%D0%B9%D1%82%D0%B0/">Комплексное сопровождение сайта</a></div></div><div class="pMtsu"><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%93%D1%80%D0%B0%D1%84%D0%B8%D1%87%D0%B5%D1%81%D0%BA%D0%B8%D0%B9_%D0%B4%D0%B8%D0%B7%D0%B0%D0%B9%D0%BD/">4. Графический дизайн</a><div><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%93%D1%80%D0%B0%D1%84%D0%B8%D1%87%D0%B5%D1%81%D0%BA%D0%B8%D0%B9_%D0%B4%D0%B8%D0%B7%D0%B0%D0%B9%D0%BD/%D0%A4%D0%B8%D1%80%D0%BC%D0%B5%D0%BD%D0%BD%D1%8B%D0%B9_%D1%81%D1%82%D0%B8%D0%BB%D1%8C/">Фирменный стиль</a><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%93%D1%80%D0%B0%D1%84%D0%B8%D1%87%D0%B5%D1%81%D0%BA%D0%B8%D0%B9_%D0%B4%D0%B8%D0%B7%D0%B0%D0%B9%D0%BD/%D0%A0%D0%B0%D0%B7%D1%80%D0%B0%D0%B1%D0%BE%D1%82%D0%BA%D0%B0_%D0%BB%D0%BE%D0%B3%D0%BE%D1%82%D0%B8%D0%BF%D0%B0/">Разработка логотипа</a><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%93%D1%80%D0%B0%D1%84%D0%B8%D1%87%D0%B5%D1%81%D0%BA%D0%B8%D0%B9_%D0%B4%D0%B8%D0%B7%D0%B0%D0%B9%D0%BD/%D0%94%D0%B8%D0%B7%D0%B0%D0%B9%D0%BD_%D0%B2%D0%B8%D0%B7%D0%B8%D1%82%D0%BE%D0%BA/">Дизайн визиток</a><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%93%D1%80%D0%B0%D1%84%D0%B8%D1%87%D0%B5%D1%81%D0%BA%D0%B8%D0%B9_%D0%B4%D0%B8%D0%B7%D0%B0%D0%B9%D0%BD/3D_%D0%BC%D0%BE%D0%B4%D0%B5%D0%BB%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5/">3D моделирование</a><a href="/%D0%A3%D1%81%D0%BB%D1%83%D0%B3%D0%B8/%D0%93%D1%80%D0%B0%D1%84%D0%B8%D1%87%D0%B5%D1%81%D0%BA%D0%B8%D0%B9_%D0%B4%D0%B8%D0%B7%D0%B0%D0%B9%D0%BD/%D0%92%D0%B5%D0%BA%D1%82%D0%BE%D1%80%D0%BD%D0%B0%D1%8F_%D0%B3%D1%80%D0%B0%D1%84%D0%B8%D0%BA%D0%B0/">Векторная графика</a></div></div></div></div>

<div onmouseover="myShow(342)" onmouseout="myHide(342)"><div class="mts" id="mtu_342"><b>2</b><a href="/%D0%9E_%D0%BA%D0%BE%D0%BC%D0%BF%D0%B0%D0%BD%D0%B8%D0%B8/" title="О компании">О компании</a></div><div class="pMts" id="pMtu_342"><div class="leftM"></div><div class="rightM"></div><div class="pMtsuCenter"><a href="/%D0%9E_%D0%BA%D0%BE%D0%BC%D0%BF%D0%B0%D0%BD%D0%B8%D0%B8/%D0%9F%D0%BE%D0%BB%D0%B5%D0%B7%D0%BD%D1%8B%D0%B5_%D1%81%D1%82%D0%B0%D1%82%D1%8C%D0%B8/">1. Полезные статьи</a></div><div class="pMtsuCenter"><a href="/%D0%9E_%D0%BA%D0%BE%D0%BC%D0%BF%D0%B0%D0%BD%D0%B8%D0%B8/%D0%9D%D0%B0%D1%88%D0%B8_%D0%BF%D0%B0%D1%80%D1%82%D0%BD%D0%B5%D1%80%D1%8B/">2. Наши партнеры</a></div><div class="pMtsuCenter"><a href="/%D0%9E_%D0%BA%D0%BE%D0%BC%D0%BF%D0%B0%D0%BD%D0%B8%D0%B8/%D0%9E_%D0%BD%D0%B0%D1%81_%D0%BF%D0%B8%D1%88%D1%83%D1%82/">3. О нас пишут</a></div><div class="pMtsuCenter"><a href="/%D0%9E_%D0%BA%D0%BE%D0%BC%D0%BF%D0%B0%D0%BD%D0%B8%D0%B8/%D0%9D%D0%BE%D0%B2%D0%BE%D1%81%D1%82%D0%B8/">4. Новости</a></div><div class="pMtsuCenter"><a href="/%D0%9E_%D0%BA%D0%BE%D0%BC%D0%BF%D0%B0%D0%BD%D0%B8%D0%B8/%D0%92%D0%B0%D0%BA%D0%B0%D0%BD%D1%81%D0%B8%D0%B8/">5. Вакансии</a></div></div></div>
<div onmouseover="myShow(346)" onmouseout="myHide(346)"><div class="mts" id="mtu_346"><b>3</b><a href="/%D0%9F%D0%BE%D1%80%D1%82%D1%84%D0%BE%D0%BB%D0%B8%D0%BE/" title="Портфолио">Портфолио</a></div><div class="pMts" id="pMtu_346"><div class="leftM"></div><div class="rightM"></div><div class="pMtsu"><a href="/%D0%9F%D0%BE%D1%80%D1%82%D1%84%D0%BE%D0%BB%D0%B8%D0%BE/%D0%A1%D0%B0%D0%B9%D1%82%D1%8B/">1. Сайты</a><div><a href="/%D0%9F%D0%BE%D1%80%D1%82%D1%84%D0%BE%D0%BB%D0%B8%D0%BE/%D0%A1%D0%B0%D0%B9%D1%82%D1%8B/%D0%A1%D0%B0%D0%B9%D1%82%D1%8B_%D0%BF%D0%BE%D0%B4_%D0%BA%D0%BB%D1%8E%D1%87/">Сайты под ключ</a><a href="/%D0%9F%D0%BE%D1%80%D1%82%D1%84%D0%BE%D0%BB%D0%B8%D0%BE/%D0%A1%D0%B0%D0%B9%D1%82%D1%8B/Web_%D0%B4%D0%B8%D0%B7%D0%B0%D0%B9%D0%BD/">Web-дизайн</a><a href="/%D0%9F%D0%BE%D1%80%D1%82%D1%84%D0%BE%D0%BB%D0%B8%D0%BE/%D0%A1%D0%B0%D0%B9%D1%82%D1%8B/%D0%9F%D1%80%D0%BE%D0%B3%D1%80%D0%B0%D0%BC%D0%BC%D0%BD%D0%B0%D1%8F_%D1%80%D0%B0%D0%B7%D1%80%D0%B0%D0%B1%D0%BE%D1%82%D0%BA%D0%B0%D0%B0_%D1%81%D0%B0%D0%B9%D1%82%D0%BE%D0%B2/">Программная разработка сайтов</a></div></div><div class="pMtsu"><a href="/%D0%9F%D0%BE%D1%80%D1%82%D1%84%D0%BE%D0%BB%D0%B8%D0%BE/%D0%94%D0%B8%D0%B7%D0%B0%D0%B9%D0%BD/">2. Графический дизайн</a><div><a href="/%D0%9F%D0%BE%D1%80%D1%82%D1%84%D0%BE%D0%BB%D0%B8%D0%BE/%D0%94%D0%B8%D0%B7%D0%B0%D0%B9%D0%BD/%D0%9B%D0%BE%D0%B3%D0%BE%D1%82%D0%B8%D0%BF%D1%8B/">Логотипы</a><a href="/%D0%9F%D0%BE%D1%80%D1%82%D1%84%D0%BE%D0%BB%D0%B8%D0%BE/%D0%94%D0%B8%D0%B7%D0%B0%D0%B9%D0%BD/54/">Каталоги</a><a href="/%D0%9F%D0%BE%D1%80%D1%82%D1%84%D0%BE%D0%BB%D0%B8%D0%BE/%D0%94%D0%B8%D0%B7%D0%B0%D0%B9%D0%BD/%D0%9F%D0%BE%D0%BB%D0%B8%D0%B3%D1%80%D0%B0%D1%84%D0%B8%D1%8F/">Полиграфия</a></div></div></div></div>

<? ob_start(); ?>

<?
$x = (preg_replace_callback("/ href=\"([^\"]*)\"/i",create_function('$matches','return " href=\"".urldecode($matches[1])."\"";'),ob_get_clean()));
echo (preg_replace_callback("/ href=\'([^\']*)\'/i",create_function('$matches','return " href=\'".urldecode($matches[1])."\'";'),$x));
?>

<?
echo (preg_replace_callback("/ href=(\"|\')(.*)(\"|\')/iu",create_function('$matches','return " href=$matches[1]".urldecode($matches[2])."$matches[1]";'),ob_get_clean()));
?>