Error General SQL ERROR [ mysql4 ] en la busqueda
Publicado: 09 Ene 2014, 13:03
URL: http://descargasmax.com/
Plantilla(s) usuada(s): Artodia: Black (Estilo editado)
MODs instalados: board3 Portal 2.0.1
PM Spy 0.0.1
Thanks for posts 1.3.5
Anti-Spam ACP 1.0.5
Share On 2.1.1
Official Topic Index 2.0.2
AOS Estadísticas de temas 1.0.5
Versión de phpBB: 3.0.11
Servidor: bluehost
Si es una actualización desde otra versión: no
Si es una conversión desde otro tipo de Foro: no
hola gente. veran me ha aparecido un error en mi foro, al buscar ciertas palabras en la búsqueda me da error general, me e fijado que si cambio la opción de buscar título y texto del mensaje por cualquier otra el error desaparece, espero que me podéis ayudar, saludos.
Plantilla(s) usuada(s): Artodia: Black (Estilo editado)
MODs instalados: board3 Portal 2.0.1
PM Spy 0.0.1
Thanks for posts 1.3.5
Anti-Spam ACP 1.0.5
Share On 2.1.1
Official Topic Index 2.0.2
AOS Estadísticas de temas 1.0.5
Versión de phpBB: 3.0.11
Servidor: bluehost
Si es una actualización desde otra versión: no
Si es una conversión desde otro tipo de Foro: no
hola gente. veran me ha aparecido un error en mi foro, al buscar ciertas palabras en la búsqueda me da error general, me e fijado que si cambio la opción de buscar título y texto del mensaje por cualquier otra el error desaparece, espero que me podéis ayudar, saludos.
SPOILER_SHOW
SQL ERROR [ mysql4 ]
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay [1104]
SQL
SELECT p.post_id FROM (phpbb_search_wordmatch m1 CROSS JOIN phpbb_search_wordmatch m2 CROSS JOIN phpbb_search_wordmatch m3 CROSS JOIN phpbb_search_wordmatch m4 CROSS JOIN phpbb_search_wordmatch m0) LEFT JOIN phpbb_posts p ON (m0.post_id = p.post_id) WHERE m0.word_id = 8 AND m1.word_id = 9 AND m1.post_id = m0.post_id AND m2.word_id = 10 AND m2.post_id = m0.post_id AND m3.word_id = 11 AND m3.post_id = m0.post_id AND m4.word_id = 178 AND m4.post_id = m0.post_id GROUP BY p.post_id, p.post_time ORDER BY p.post_time DESC LIMIT 250
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/db/mysql.php
LINE: 222
CALL: dbal_mysql->sql_query()
FILE: [ROOT]/includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()
FILE: [ROOT]/includes/search/fulltext_native.php
LINE: 754
CALL: dbal->sql_query_limit()
FILE: [ROOT]/search.php
LINE: 580
CALL: fulltext_native->keyword_search()
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay [1104]
SQL
SELECT p.post_id FROM (phpbb_search_wordmatch m1 CROSS JOIN phpbb_search_wordmatch m2 CROSS JOIN phpbb_search_wordmatch m3 CROSS JOIN phpbb_search_wordmatch m4 CROSS JOIN phpbb_search_wordmatch m0) LEFT JOIN phpbb_posts p ON (m0.post_id = p.post_id) WHERE m0.word_id = 8 AND m1.word_id = 9 AND m1.post_id = m0.post_id AND m2.word_id = 10 AND m2.post_id = m0.post_id AND m3.word_id = 11 AND m3.post_id = m0.post_id AND m4.word_id = 178 AND m4.post_id = m0.post_id GROUP BY p.post_id, p.post_time ORDER BY p.post_time DESC LIMIT 250
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/db/mysql.php
LINE: 222
CALL: dbal_mysql->sql_query()
FILE: [ROOT]/includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()
FILE: [ROOT]/includes/search/fulltext_native.php
LINE: 754
CALL: dbal->sql_query_limit()
FILE: [ROOT]/search.php
LINE: 580
CALL: fulltext_native->keyword_search()