Problemas con indexacion de palabras..............Tema Solucionado

[Kaur]

Yo en su día me presente pero estoy viendo que este es mi primer mensaje, así que de nuevo gracias por este foro para solventar problemas un saludo a todos.

Al intentar indexar me da este error.....

WWW.spaintrainzrturas.com

PHPB 3.0.11

Mods instalados. yotube-spoiler-ArtodiaV3-Subsilver2

SQL ERROR [ mysql4 ]

137 when fixing table [1034]

SQL

ALTER TABLE phpbb3_posts ADD FULLTEXT (post_subject), MODIFY post_text mediumtext COLLATE utf8_unicode_ci NOT NULL, ADD FULLTEXT (post_text), ADD FULLTEXT post_content (post_subject, post_text)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/includes/search/fulltext_mysql.php
LINE: 779
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/includes/acp/acp_search.php
LINE: 365
CALL: fulltext_mysql->create_index()

FILE: [ROOT]/includes/acp/acp_search.php
LINE: 46
CALL: acp_search->index()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: acp_search->main()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()

Estuve mirando en varios sitio el tema del unicode, pero no hay manera de que me haga la indexacion de búsqueda.

Un saludo.

[ThE KuKa]

Tu página no aparece.

De todos modos entra a phpMyAdmin, y realiza un ANALIZE, REPAIR y OPTIMIZE TABLES de todas las tablas del foro.

[Kaur]

Perdón puse mal el enlace www.spaintrainzrutas.com

Hola acabo de realizar esto que me as comentado y he ido a realizar otra vez la indexacion de nuevo, creo que sale el mismo error.
Error General
SQL ERROR [ mysql4 ]

Column 'post_subject' cannot be part of FULLTEXT index [1283]

SQL

ALTER TABLE phpbb3_posts ADD FULLTEXT (post_subject), MODIFY post_text mediumtext COLLATE utf8_unicode_ci NOT NULL, ADD FULLTEXT (post_text), ADD FULLTEXT post_content (post_subject, post_text)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/includes/search/fulltext_mysql.php
LINE: 779
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/includes/acp/acp_search.php
LINE: 365
CALL: fulltext_mysql->create_index()

FILE: [ROOT]/includes/acp/acp_search.php
LINE: 46
CALL: acp_search->index()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: acp_search->main()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()

El error creo que es el mismo que el anterior, lo único que en la primera opción que me comentaste la de analizar tabla sale así no se si es correcto o no....


Table Op Msg_type Msg_text
spaintrastr.phpbb3_acl_groups analyze status Table is already up to date
spaintrastr.phpbb3_acl_options analyze status Table is already up to date
spaintrastr.phpbb3_acl_roles analyze status Table is already up to date
spaintrastr.phpbb3_acl_roles_data analyze status Table is already up to date
spaintrastr.phpbb3_acl_users analyze status Table is already up to date
spaintrastr.phpbb3_attachments analyze status Table is already up to date
spaintrastr.phpbb3_banlist analyze status Table is already up to date
spaintrastr.phpbb3_bbcodes analyze status Table is already up to date
spaintrastr.phpbb3_bookmarks analyze status Table is already up to date
spaintrastr.phpbb3_bots analyze status Table is already up to date
spaintrastr.phpbb3_captcha_answers analyze status Table is already up to date
spaintrastr.phpbb3_captcha_questions analyze status Table is already up to date
spaintrastr.phpbb3_config analyze status Table is already up to date
spaintrastr.phpbb3_confirm analyze status Table is already up to date
spaintrastr.phpbb3_disallow analyze status Table is already up to date
spaintrastr.phpbb3_drafts analyze status Table is already up to date
spaintrastr.phpbb3_extensions analyze status Table is already up to date
spaintrastr.phpbb3_extension_groups analyze status Table is already up to date
spaintrastr.phpbb3_forums analyze status Table is already up to date
spaintrastr.phpbb3_forums_access analyze status Table is already up to date
spaintrastr.phpbb3_forums_track analyze status Table is already up to date
spaintrastr.phpbb3_forums_watch analyze status Table is already up to date
spaintrastr.phpbb3_groups analyze status Table is already up to date
spaintrastr.phpbb3_icons analyze status Table is already up to date
spaintrastr.phpbb3_lang analyze status Table is already up to date
spaintrastr.phpbb3_log analyze status Table is already up to date
spaintrastr.phpbb3_login_attempts analyze status Table is already up to date
spaintrastr.phpbb3_moderator_cache analyze status Table is already up to date
spaintrastr.phpbb3_modules analyze status Table is already up to date
spaintrastr.phpbb3_poll_options analyze status Table is already up to date
spaintrastr.phpbb3_poll_votes analyze status Table is already up to date
spaintrastr.phpbb3_posts analyze status Table is already up to date
spaintrastr.phpbb3_privmsgs analyze status Table is already up to date
spaintrastr.phpbb3_privmsgs_folder analyze status Table is already up to date
spaintrastr.phpbb3_privmsgs_rules analyze status Table is already up to date
spaintrastr.phpbb3_privmsgs_to analyze status Table is already up to date
spaintrastr.phpbb3_profile_fields analyze status Table is already up to date
spaintrastr.phpbb3_profile_fields_data analyze status Table is already up to date
spaintrastr.phpbb3_profile_fields_lang analyze status Table is already up to date
spaintrastr.phpbb3_profile_lang analyze status Table is already up to date
spaintrastr.phpbb3_qa_confirm analyze status Table is already up to date
spaintrastr.phpbb3_ranks analyze status Table is already up to date
spaintrastr.phpbb3_reports analyze status Table is already up to date
spaintrastr.phpbb3_reports_reasons analyze status Table is already up to date
spaintrastr.phpbb3_search_results analyze status Table is already up to date
spaintrastr.phpbb3_search_wordlist analyze status Table is already up to date
spaintrastr.phpbb3_search_wordmatch analyze status Table is already up to date
spaintrastr.phpbb3_sessions analyze status Table is already up to date
spaintrastr.phpbb3_sessions_keys analyze status Table is already up to date
spaintrastr.phpbb3_sitelist analyze status Table is already up to date
spaintrastr.phpbb3_smilies analyze status Table is already up to date
spaintrastr.phpbb3_styles analyze status Table is already up to date
spaintrastr.phpbb3_styles_imageset analyze status Table is already up to date
spaintrastr.phpbb3_styles_imageset_data analyze status Table is already up to date
spaintrastr.phpbb3_styles_template analyze status Table is already up to date
spaintrastr.phpbb3_styles_template_data analyze status Table is already up to date
spaintrastr.phpbb3_styles_theme analyze status Table is already up to date
spaintrastr.phpbb3_topics analyze status Table is already up to date
spaintrastr.phpbb3_topics_posted analyze status Table is already up to date
spaintrastr.phpbb3_topics_track analyze status Table is already up to date
spaintrastr.phpbb3_topics_watch analyze status Table is already up to date
spaintrastr.phpbb3_users analyze status Table is already up to date
spaintrastr.phpbb3_user_group analyze status Table is already up to date
spaintrastr.phpbb3_warnings analyze status Table is already up to date
spaintrastr.phpbb3_words analyze status Table is already up to date
spaintrastr.phpbb3_zebra analyze status Table is already up to date

[ThE KuKa]

No es el mismo error, mira esta guía:
http://www.phpbb-es.com/biblioteca/kb_show.php?id=137

No sabemos la versión phpBB de tu foro (dato que no aportas a pesar de las normas de soporte).
Simplemente sigue los pasos de la guía.

Si esto no lo soluciona, aporta los datos oportunos de soporte, lee las Normas antes de postear, esta vez pasa, la próxima no.

[Kaur]

Quiera comentaros que al final hoy termine con el problema, con dos sencillos pasos que os explico ahora mismo. tuve que borrar la tabla de fulltex del Admin, y genere una nueva tabla fulltex con este comando;

ALTER TABLE `phpbb3_posts` ADD FULLTEXT (
`post_text`
)

despues me fue al foro y en ver de crear la busqueda en nativo la realice en MYSQL me l genero muy rapido y me la indexo sin problemas gracias por vuestra respuesta y si esto os vale para algo perfecto me alegra a ver contribuido en algo, a por cieto todas las tablas debe esta en UTF8 BIN, si no tambien pueden generar errores.

Un fuerte abrazo.

Atentamente.

Jordi.