problem when searching the forum

[guille]

Hi,

I get an error while trying to search a specific query in the forum. If I type "internet radio using command line" I get the following error. There are many more numbers, I dont post here them all. I'm using XP and firefox 1.5.0.4. I dont know whether the problem is phpBB or not.

guille

Could not obtain search results

DEBUG MODE

SQL Error : -1 ERREUR: expression trop complexe DETAIL: La profondeur de l'imbrication dépasse la profondeur maximale de l'expression (10000). HINT: Augmenter le paramètre "max_expr_depth".

SELECT t.*, f.forum_id, f.forum_name, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time FROM phpbb_topics t, phpbb_forums f, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 WHERE t.topic_id IN (10239, 20479, 16383, 2045, 16380, 14331, 12282, 20474, 16377, 18424, 18423, 6134, 20470, 18422, 16374, 20469, 20468, 16372, 20467, 16371, 22514, 22513, 8177, 20465, 14319, 22511, 20463, 18414, 16366, 1226911013, 1285, 14852, 3076, 1539, 2050, 1794, 5634, 18944, 5376, 16639, 14079, 14590) AND t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id ORDER BY p2.post_time DESC LIMIT 50 OFFSET 0

Line : 787
File : search.php

[seomaster]

Hi,

I get an error while trying to search a specific query in the forum. If I type "internet radio using command line" I get the following error. There are many more numbers, I dont post here them all. I'm using XP and firefox 1.5.0.4. I dont know whether the problem is phpBB or not.

guille

Could not obtain search results

DEBUG MODE

SQL Error : -1 ERREUR: expression trop complexe DETAIL: La profondeur de l'imbrication dépasse la profondeur maximale de l'expression (10000). HINT: Augmenter le paramètre "max_expr_depth".

SELECT t.*, f.forum_id, f.forum_name, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time FROM phpbb_topics t, phpbb_forums f, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 WHERE t.topic_id IN (10239, 20479, 16383, 2045, 16380, 14331, 12282, 20474, 16377, 18424, 18423, 6134, 20470, 18422, 16374, 20469, 20468, 16372, 20467, 16371, 22514, 22513, 8177, 20465, 14319, 22511, 20463, 18414, 16366, 1226911013, 1285, 14852, 3076, 1539, 2050, 1794, 5634, 18944, 5376, 16639, 14079, 14590) AND t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id ORDER BY p2.post_time DESC LIMIT 50 OFFSET 0

Line : 787
File : search.php

problem when searching the phrase : 'videolan'

[CorpseFeeder]

Hi,

I get an error while trying to search a specific query in the forum. If I type "internet radio using command line" I get the following error. There are many more numbers, I dont post here them all. I'm using XP and firefox 1.5.0.4. I dont know whether the problem is phpBB or not.

guille

Could not obtain search results

DEBUG MODE

SQL Error : -1 ERREUR: expression trop complexe DETAIL: La profondeur de l'imbrication dépasse la profondeur maximale de l'expression (10000). HINT: Augmenter le paramètre "max_expr_depth".

SELECT t.*, f.forum_id, f.forum_name, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time FROM phpbb_topics t, phpbb_forums f, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 WHERE t.topic_id IN (10239, 20479, 16383, 2045, 16380, 14331, 12282, 20474, 16377, 18424, 18423, 6134, 20470, 18422, 16374, 20469, 20468, 16372, 20467, 16371, 22514, 22513, 8177, 20465, 14319, 22511, 20463, 18414, 16366, 1226911013, 1285, 14852, 3076, 1539, 2050, 1794, 5634, 18944, 5376, 16639, 14079, 14590) AND t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id ORDER BY p2.post_time DESC LIMIT 50 OFFSET 0

Line : 787
File : search.php

problem when searching the phrase : 'videolan'

Also, this error is generated by searching for ANY phrase containing the word "video"

[CorpseFeeder]

is this going to get fixed? It's a pain not being able to search anything containing the word video.

[Asim]

the problem is when you type in videolan or video... there are a billion results (ok maybe not a billion...)... the server gets overwhelmed by the complexity of the query... and number of results... and voila... the error... that's as far as i can reckon

edit:
narrow your search down... e.g. narrow down search per category instead... and it will work...

[CorpseFeeder]

i see. The solution is to select "search for all terms" instead of the default "search any"