http://bbpress.org/forums/ bbPress Support Forums Topic: 610 mysql query in front-page... en Sat, 10 Jan 2009 00:19:52 +0000 http://bbpress.org/forums/topic/610-mysql-query-in-front-page#post-18976 Fri, 05 Sep 2008 17:45:55 +0000 _ck_ 18976@http://bbpress.org/forums/ <p>Update: okay I have a work around.</p> <p>Look for 0.0.3 within the hour. </p> http://bbpress.org/forums/topic/610-mysql-query-in-front-page#post-18975 Fri, 05 Sep 2008 17:08:21 +0000 _ck_ 18975@http://bbpress.org/forums/ <p>Okay I've figured out why it happens.</p> <p>It's a very serious flaw in how the new 1.0 db caching system works. Apparently they now suddenly base everything about the WHERE clause. If the clause is slightly different for any two queries, it doesn't use the cache and instead does it a direct db query. It's stupid.</p> <p>There is absolutely no way I can fix it in the plugin, it has to be fixed inside bbPress 1.0 and I am not sure if or when they will bother. </p> http://bbpress.org/forums/topic/610-mysql-query-in-front-page#post-18973 Fri, 05 Sep 2008 16:38:37 +0000 meitershaker 18973@http://bbpress.org/forums/ <p><code><br /> $hidden_forums['hidden_forums']=array(10); // hide these forums, list by comma seperated number</p> <p>$hidden_forums['allow_roles']['all_forums']=array('keymaster','administrator','moderator'); // these roles can always see ALL forums regardless<br /> $hidden_forums['allow_roles'][500]=array('administrator','moderator'); // exact formal role name, *not* ability<br /> $hidden_forums['allow_roles'][501]=array('administrator','moderator'); // exact formal role name, *not* ability</p> <p>$hidden_forums['allow_users']['all_forums']=array(1); // these users can always see ALL forums regardless<br /> $hidden_forums['allow_users'][500]=array(5432,7654); // list of users by number<br /> $hidden_forums['allow_users'][501]=array(5432,7654); // list of users by number</p> <p>$hidden_forums['label']=""; // text, html, css or image to indicate hidden forums/topics, make it =""; if you don't want any label at all<br /> </code> </p> http://bbpress.org/forums/topic/610-mysql-query-in-front-page#post-18972 Fri, 05 Sep 2008 16:32:36 +0000 _ck_ 18972@http://bbpress.org/forums/ <p>Well it works for me.<br /> Show me your configuration inside <code>hidden-forums.php</code> and how many forums do you have? </p> <p>Are those queries happening on the front-page, forum-page or topic-page? </p> http://bbpress.org/forums/topic/610-mysql-query-in-front-page#post-18969 Fri, 05 Sep 2008 15:23:49 +0000 meitershaker 18969@http://bbpress.org/forums/ <p>i use the svn trunk </p> http://bbpress.org/forums/topic/610-mysql-query-in-front-page#post-18968 Fri, 05 Sep 2008 15:09:10 +0000 _ck_ 18968@http://bbpress.org/forums/ <p>Hidden Forums has not been tested yet again 1.0 alpha.<br /> I simply don't have time to modify every plugin for all the changes.</p> <p>This is why people should not use the alpha yet for regular sites.</p> <p>Update: I'm unable to reproduce your problem however.<br /> I have no extra queries with using Hidden Forums on the 1.0 trunk. Are you using the Alpha from the download on bbpress.org, or are you using the SVN trunk? </p> http://bbpress.org/forums/topic/610-mysql-query-in-front-page#post-18953 Fri, 05 Sep 2008 10:41:58 +0000 meitershaker 18953@http://bbpress.org/forums/ <p>i have found the bad plugin : hidden forums by you ck :p</p> <p>why your plugin do that?</p> <p>bye </p> http://bbpress.org/forums/topic/610-mysql-query-in-front-page#post-18942 Fri, 05 Sep 2008 07:31:55 +0000 _ck_ 18942@http://bbpress.org/forums/ <p>This is why it's called an alpha.<br /> There are bugs, some serious.</p> <p>So far I've seen a forum query bug and a tag query bug but not a topic query bug, so that's a new one.</p> <p>Make sure you update bb-topic-views which had a query bug too. In fact you should de-activate your plugins and see if the query problem persists before we blame it on bbPress. </p> http://bbpress.org/forums/topic/610-mysql-query-in-front-page#post-18925 Thu, 04 Sep 2008 20:35:40 +0000 meitershaker 18925@http://bbpress.org/forums/ <p>i think there is a serious bug in all pages of bbpress 1.0 trunk, because i have the same effect in a fresh install...</p> <p>i don't understand the number of query, why when i'm not login, there is over 100 query?</p> <p>bye </p> http://bbpress.org/forums/topic/610-mysql-query-in-front-page#post-18921 Thu, 04 Sep 2008 19:05:58 +0000 meitershaker 18921@http://bbpress.org/forums/ <p>Hi,</p> <p>i have a serious bug: when i'm not login, i have 610 mysql query, and there is a one query repeat:</p> <p><code> # 416 : 0.0004 seconds<br /> SELECT meta_key, meta_value FROM bb_meta WHERE object_type = 'bb_topic' AND object_id = 37 /* bb_append_meta */</p> <p> # 417 : 0.0005 seconds<br /> SELECT * FROM bb_topics WHERE topic_id = 37 AND topic_status = 0 AND forum_id NOT IN (10) </p> <p> # 418 : 0.0004 seconds<br /> SELECT meta_key, meta_value FROM bb_meta WHERE object_type = 'bb_topic' AND object_id = 37 /* bb_append_meta */</p> <p> # 419 : 0.0005 seconds<br /> SELECT * FROM bb_topics WHERE topic_id = 37 AND topic_status = 0 AND forum_id NOT IN (10) </p> <p> # 420 : 0.0005 seconds<br /> SELECT meta_key, meta_value FROM bb_meta WHERE object_type = 'bb_topic' AND object_id = 37 /* bb_append_meta */</p> <p> # 421 : 0.0005 seconds<br /> SELECT * FROM bb_topics WHERE topic_id = 37 AND topic_status = 0 AND forum_id NOT IN (10) </p> <p> # 422 : 0.0005 seconds<br /> SELECT meta_key, meta_value FROM bb_meta WHERE object_type = 'bb_topic' AND object_id = 37 /* bb_append_meta */</p> <p> # 423 : 0.0005 seconds<br /> SELECT * FROM bb_topics WHERE topic_id = 37 AND topic_status = 0 AND forum_id NOT IN (10)<br /> </code></p> <p>why?</p> <p>when i'm login at admin, i have no this!!</p> <p>i use mini track, bb_topic_wiews, bb_benchmark and topic_icons plugin</p> <p>please help me </p>