Recordad que para pedir soporte alguno, debéis facilitar los datos de soporte oportunos por favor, mirad aquí y leer las Normas generales del foro, esto nos servirá de ayuda para dar el mejor soporte..

Gracias.

La Administración de phpBB España.

Can't find FULLTEXT index matching the column list [1191]Tema Solucionado

Foros donde podréis dejar vuestras dudas sobre phpBB 3.0.x
Cerrado
uruguayito
Ex Staff
Mensajes: 1435
Registrado: 04 Mar 2009, 16:17
Género:
Edad: 51

Can't find FULLTEXT index matching the column list [1191]  Tema Solucionado

#1

Mensaje por uruguayito »

Hola después de tanto tiempo.
Hoy tratando de instalar este mod: http://www.phpbb-es.com/foro/similar-to ... 20527.html
(MUY sencillo por cierto), luego de ejecutar la consulta SQL que pide: ALTER TABLE phpbb_topics ADD FULLTEXT (topic_title);

todo bien, hasta que al ir al foro y tratar de leer cualquier tema, me salta este error:

Código: Seleccionar todo

Error General
SQL ERROR [ mysqli ]

Can't find FULLTEXT index matching the column list [1191]

SQL

SELECT f.forum_id, f.forum_name, t.topic_id, t.topic_title, u.user_id, u.username, u.user_colour, t.topic_replies FROM (phpbb_topics t) LEFT JOIN phpbb_users u ON (u.user_id = t.topic_poster) LEFT JOIN phpbb_forums f ON (f.forum_id = t.forum_id) WHERE MATCH (t.topic_title) AGAINST ('Estilo para dispositivos móviles' ) >= 0.5 AND t.topic_status <> 2 AND t.topic_id <> 11 GROUP BY t.topic_id ORDER BY t.topic_last_post_time DESC LIMIT 5

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/mysqli.php
LINE: 189
CALL: dbal->sql_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 231
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/db/dbal.php
LINE: 170
CALL: dbal_mysqli->_sql_query_limit()

FILE: [ROOT]/viewtopic.php
LINE: 1889
CALL: dbal->sql_query_limit()
¿cómo lo soluciono?

Antes de pedir ayuda, recuerda poner tus datos de soporte.
Lee las: Normas de Soporte en phpBB España


Mis datos para Soporte: | Mostrar
Foro: http://amigosenlaruta.com/foro
Servidor: De pago
Versión phpbb: 3.2
Estilos: Prosilver

Extensiones habilitadas:
24 hour activity stats 1.0.3
Add User 1.0.3
Advanced Active Topics 1.0.2
Ajax Base 2.0.0
AJAX Registration check 1.0.0
Auto database backup (3.2) 2.1.0-rc2
Boardtalk Fixed Menu for Prosilver 0.0.2
Database Optimize & Repair Tool 1.1.1
Delete my registration 1.0.3
Detailed viewonline 1.0.0
E-mail on birthday 3.1.4
External Links Open in New Window 1.0.5
Favicon 0.0.2
File Download 1.0.2
First post on every page 2.0.2
Fixed footer navbar 1.0.3
Font 1.0.2
Forum Icons 1.0.2
Genders 1.1.1
Header Link 1.0.0_RC10
Inactive User Manager 0.9.8
Lightbox 1.0.4
LMDI Autolinks 1.1.0
Local URL To Text 1.1.0-beta1
Member Profile Views 1.0.3
Mobile Device 1.0.1
Multi Ranks 1.0.0
Newest members 1.0.2
News Scroll 1.0.1_RC3
New Topic Button in Topic 1.0.0
No Custom Profile for guests 1.0.2
phpBB.de - Move Message 1.0.0
phpBB 3.2 Advanced Board Announcements 0.9.0
phpBB 3.2 Birthday Control 1.0.2
phpBB Media Embed PlugIn 1.0.0-rc1
phpBB mentions 1.0.0-RC1
Posting Buttons 1.0.1
Post Numbers 1.1.0
Posts merging 2.0.2
Precise Similar Topics 1.4.1
Pretty Topic 1.0.1
Quick Mod Top 1.0.2
Quoted Images as Thumbnails 1.0.1
Read Members PM 1.0.0
Red title for new topic and new reply 1.0.3
ReIMG Image Resizer 3.0.0-b1
Show First Post Only to Guest 1.2.2
Site logo (3.2) 2.1.0-rc6
Smart Subjects 1.0.0-b3
Social Sharing w/Dyanmic Opengraph Tags 1.0.0
Subscribe Topic in footer 1.0.0
Tapatalk Plugin for phpBB 3.1/3.2 2.0.3
Thanks for posts 2.0.3-dev
TinyPic Link 1.0.0
Topic/Post Attachments on Index and View Forum pages 0.0.6-dev
Topic Age Day 1.0.2
Topic Author 1.0.2
Topic Restriction 1.0.1
Topics Hierarchy 2.0.0-RC1
Topic Solved 2.2.0
Topic Title Colour 1.0.0-a1
Upcoming Birthdays 1.0.3
User login redirect 1.1.0
User Recent Activity 2.0.0
VigLink 1.0.0
Who Visited This Topic 1.0.5
XML Sitemap 0.1.4
Встроенные изображения в приложении. Inline images in attachment

Cerrado

Volver a “Foros de Soporte 3.0.x”