Error al crear indiceTema Solucionado

[ahh72]

holas, tengo este problemita que cuando le doy crear indice me sale este error:

Código: Seleccionar todo

Error General
SQL ERROR [ mysql4 ]

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

SQL

ALTER TABLE phpbb_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: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

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

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

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

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

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

alguna idea del porque podria darse este error y como corregirlo?

saludos

[jakk]

mirate este tema http://www.phpbb.com/community/viewtopi ... 6&t=926905 , fijate especialmente en el mensaje de "Stucco" , creo que es la solucion a tu problema

[ahh72]

te refieres a esto jakk?

paso 1:

Código: Seleccionar todo

ALTER TABLE phpbb_acl_groups CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_acl_options CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_acl_roles CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_acl_roles_data CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_acl_users CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_attachments CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_banlist CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_bbcodes CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_bookmarks CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_bots CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_config CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_confirm CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_disallow CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_drafts CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_extensions CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_extension_groups CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_forums CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_forums_access CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_forums_track CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_forums_watch CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_groups CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_icons CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_lang CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_log CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_moderator_cache CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_modules CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_poll_options CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_poll_votes CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_posts CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_privmsgs CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_privmsgs_folder CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_privmsgs_rules CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_privmsgs_to CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_profile_fields CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_profile_fields_data CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_profile_fields_lang CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_profile_lang CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_ranks CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_reports CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_reports_reasons CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_search_results CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_search_wordlist CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_search_wordmatch CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_sessions CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_sessions_keys CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_sitelist CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_smilies CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles_imageset CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles_imageset_data CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles_template CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles_template_data CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles_theme CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_topics CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_topics_posted CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_topics_track CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_topics_watch CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_users CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_user_group CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_warnings CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_words CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_zebra CONVERT TO CHARACTER SET utf8;

paso 2:

Código: Seleccionar todo

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

he tenido que modificarle el prefijo de la tabla porque yo lo tengo como phpbb_ y no como phpbb3_ tal como aparece en el mensaje

saludos

[jakk]

si a eso me referia
te ha servido de algo?

[ahh72]

me salio este error al aplicar el primer paso:

Código: Seleccionar todo

Error

consulta SQL:

ALTER TABLE phpbb_search_wordlist CONVERT TO CHARACTER SET utf8;

MySQL ha dicho: Documentación
#1062 - Duplicate entry 'rud' for key 2

pero no se porque razon es

[ahh72]

si a eso me referia
te ha servido de algo?

salvo por el error ese pues ahora me dejo indexar toda la base de datos

pero aun sigo con la duda de a que se debe ese error y si afecta en algo

saludos

[jakk]

de mysql la verdad que no entiendo demasiado, lo unico que veo es que hay una entrada duplicada en esa tabla, pero nose decirte la razon y si afecta en algo
aver si alguien te puede decir exactamete que pasa

[ahh72]

pues no me queda otra que estar en espera de algun experto sobre el tema SQL

saludos y gracias jakk

[ahh72]

holas, revivo nuevamente este tema que consulte hace unos meses y es que al crear el indice para Fulltext mysql me sale el mismo error que indique en mi primer mensaje

esto sucede en la nueva base de datos que he creado ya que migre a un nuevo hosting, la url de referencia al foro es la que doy soporte y esta en mi firma.

saludos

[ahh72]

solucionado, volvi a seguir los pasos que me dejo ivan y esta vez si se pudo, ni idea porque razon pero la cosa que ya funciona

saludos

[Zombie Podrido]

te refieres a esto jakk?

paso 1:

Código: Seleccionar todo

ALTER TABLE phpbb_acl_groups CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_acl_options CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_acl_roles CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_acl_roles_data CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_acl_users CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_attachments CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_banlist CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_bbcodes CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_bookmarks CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_bots CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_config CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_confirm CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_disallow CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_drafts CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_extensions CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_extension_groups CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_forums CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_forums_access CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_forums_track CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_forums_watch CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_groups CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_icons CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_lang CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_log CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_moderator_cache CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_modules CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_poll_options CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_poll_votes CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_posts CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_privmsgs CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_privmsgs_folder CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_privmsgs_rules CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_privmsgs_to CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_profile_fields CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_profile_fields_data CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_profile_fields_lang CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_profile_lang CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_ranks CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_reports CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_reports_reasons CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_search_results CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_search_wordlist CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_search_wordmatch CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_sessions CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_sessions_keys CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_sitelist CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_smilies CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles_imageset CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles_imageset_data CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles_template CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles_template_data CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_styles_theme CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_topics CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_topics_posted CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_topics_track CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_topics_watch CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_users CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_user_group CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_warnings CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_words CONVERT TO CHARACTER SET utf8;
ALTER TABLE phpbb_zebra CONVERT TO CHARACTER SET utf8;

paso 2:

Código: Seleccionar todo

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

he tenido que modificarle el prefijo de la tabla porque yo lo tengo como phpbb_ y no como phpbb3_ tal como aparece en el mensaje

saludos

Hola, bueno, resulta que yo tambien ando teniendo el problema del topic y urgando en el foro hallé esta solución. El tema es que no entiendo que hay que hacer. Soy muy principiante en esto así que si me pueden ayudar se los agradecería.

Tengo que ir al phpmyadmin, busco esas tablas, y?

Acá algunos datos que pedian en las normas:
URL: Posesos.freeoda.com
Plantilla(s) usuada(s): Subsilver2
MODs instalados:
- Prime Quick Login 1.2.5
- Prime Quick Reply 1.0.8
Versión de phpBB: 3.0.7-PL1
Servidor: Free Web Hosting Area, gratuito

Saludos!

[jakk]

la URL que has puesto no lleva a ningun foro, por favor pon la url a tu foro

[Zombie Podrido]

Perdón!

No me aparece el botón para editar, así que copio los datos acá:

URL: http://posesos.freeoda.com/forum/
Plantilla(s) usuada(s): Subsilver2
MODs instalados:
- Prime Quick Login 1.2.5
- Prime Quick Reply 1.0.8
Versión de phpBB: 3.0.7-PL1
Servidor: Free Web Hosting Area, gratuito

[jakk]

eso son consultas SQL, en mi firma verás un enlace Crear una Consulta SQL , ahi te explica como se ejecutan, creo que está facil de entender

[Zombie Podrido]

Ok, si, se ve facil! Y entre el paso 1 y paso 2 que diferencia hay? Hago primero lo que dice en el paso 1 y despues repito lo mismo con el 2?

Edito: Ahí lo hice y me salió lo más bien, hasta pude indexar sin problemas. Muchas gracias!!!