problem when searching the forum

Discussion about forum rules, new moderators, website content, website layout, VideoLAN artwork etc..
Forum rules
Please read the forum's rules carefully before posting. This forum should not be used to post VLC usage related questions.
guille

problem when searching the forum

Postby guille » 23 Jul 2006 13:14

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
New Cone
New Cone
Posts: 1
Joined: 19 Oct 2006 09:51
Contact:

Re: problem when searching the forum

Postby seomaster » 19 Oct 2006 09:54

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
New Cone
New Cone
Posts: 6
Joined: 17 Oct 2006 10:16

Re: problem when searching the forum

Postby CorpseFeeder » 19 Oct 2006 10:30

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
New Cone
New Cone
Posts: 6
Joined: 17 Oct 2006 10:16

Postby CorpseFeeder » 26 Oct 2006 09:08

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

Asim
Cone that earned his stripes
Cone that earned his stripes
Posts: 151
Joined: 30 Mar 2005 05:58
Contact:

Postby Asim » 26 Oct 2006 11:39

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
New Cone
New Cone
Posts: 6
Joined: 17 Oct 2006 10:16

Postby CorpseFeeder » 28 Oct 2006 10:55

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


Return to “Forum, Website and Artwork discussion”

Who is online

Users browsing this forum: No registered users and 0 guests