Your Build 202404241047 (Current build: 202404241047 ) PHP version 7.4.33 Mysql Version: 10.11.6-MariaDB
-------------------------------------------------------
В разделе Rotation - Site Search стоит MySQL Full Text
Но при этом вижу куча сообщений
Search engine
If you don't use Sphinx the script will use Mysql
Please, read the last WIKI about the search
Note, you want to use FullText search on field alt (table rot_gallery_data1)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data1)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data1)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data15)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data15)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data15)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data16)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data16)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data16)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data17)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data17)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data17)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data18)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data18)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data18)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data19)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data19)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data19)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data20)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data20)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data20)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data21)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data21)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data21)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data22)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data22)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data22)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data23)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data23)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data23)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data24)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data24)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data24)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data25)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data25)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data25)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data26)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data26)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data26)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data27)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data27)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data27)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data28)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data28)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data28)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data29)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data29)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data29)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data30)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data30)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data30)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data31)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data31)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data31)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data32)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data32)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data32)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data33)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data33)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data33)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data34)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data34)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data34)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data35)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data35)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data35)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data36)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data36)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data36)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data37)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data37)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data37)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data38)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data38)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data38)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data39)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data39)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data39)
but you didn't add index for this field.
Note, you want to use FullText search on field alt (table rot_gallery_data40)
but you didn't add index for this field.
Note, you want to use FullText search on field description (table rot_gallery_data40)
but you didn't add index for this field.
Note, you want to use FullText search on field custom_var2 (table rot_gallery_data40)
but you didn't add index for this field.
----------------------------------------
Можно эти индексы организовать одной галочкой?
Типа create indexes for selected fields in all rot_gallery_data tables.. и в Mass Edit сразу добавить
Чтобы не делать эту процедуру _ttp://smartcj.com/wiki/doku.php?id=tcms_install#search
Спасибо зараннее
Rotation - Site Search
Re: Rotation - Site Search
да, попробую сделать что б на всех базах было гут
Don't forget to run script update
Re: Rotation - Site Search
добавил в ап что б автосоздавались индексы при изменении настроек
смотрите плз то ли что надо
смотрите плз то ли что надо
Don't forget to run script update
Re: Rotation - Site Search
Спасибо.. Проблема ушла. Вроде и выдача по поиску улучшилась







