bbPress support forums Tag: IIS

bbPress support forums Tag: IIS http://bbpress.org/forums/ bbPress support forums Tag: IIS en Tue, 02 Dec 2008 23:59:58 +0000 mvds on "INSERT queries for new Topic and new Post" http://bbpress.org/forums/topic/insert-queries-for-new-topic-and-new-post#post-21109 Fri, 28 Nov 2008 18:09:14 +0000 mvds 21109@http://bbpress.org/forums/ It also seems to be working if you initialize the value of 'topic_id' as 0 (zero) instead of false. I found no problems with it so far. mvds on "INSERT queries for new Topic and new Post" http://bbpress.org/forums/topic/insert-queries-for-new-topic-and-new-post#post-21100 Fri, 28 Nov 2008 15:12:48 +0000 mvds 21100@http://bbpress.org/forums/ Just a question: do you include your wp functions in bbpress? I see calls to wp functions in several bb functions (also in bb_insert_topic and bb_insert_post) and I can imagine that if you dont include wp functions in bbpress, that these statements fail. I cannot include wp functions with the <pre><code>$bb->WP_BB = true; if (file_exists('../wp-blog-header.php')) require_once('../wp-blog-header.php'); else if (file_exists('../../wp-blog-header.php')) require_once('../../wp-blog-header.php');</code></pre> part because then my forums don't work. I can't access my bb-admin pages and bbpress doesn't recognize my users. mvds on "INSERT queries for new Topic and new Post" http://bbpress.org/forums/topic/insert-queries-for-new-topic-and-new-post#post-21098 Fri, 28 Nov 2008 11:18:24 +0000 mvds 21098@http://bbpress.org/forums/ Same problem here, with an Apache server on Windows. Latest versions of all applications. I will try your solutions and see what happens. peterve on "bbpress 0.9.0.2 slow" http://bbpress.org/forums/topic/bbpress-0902-slow#post-20409 Sun, 02 Nov 2008 14:52:35 +0000 peterve 20409@http://bbpress.org/forums/ thanks a lot ! _ck_ on "bbpress 0.9.0.2 slow" http://bbpress.org/forums/topic/bbpress-0902-slow#post-20408 Sun, 02 Nov 2008 14:43:18 +0000 _ck_ 20408@http://bbpress.org/forums/ You can make my bb-benchmark work on WordPress with a few changes. Most notably you'd have to add the line: <code>add_action('wp_footer', 'bb_benchmark_output',999);</code> <code>if (bb_current_user_can( 'administrate' ) )</code> you just have to take off the <code>bb_</code> part and make it <code>current_user_can</code> Oh and all <code>$bbdb</code> has to be changed to <code>$wpdb</code> It won't be able to calculate the timing between sections until all the hook names are added which unfortunately I don't have the time right now to lookup. But it will still show you overall times and mysql queries. _ck_ on "bbpress 0.9.0.2 slow" http://bbpress.org/forums/topic/bbpress-0902-slow#post-20407 Sun, 02 Nov 2008 14:39:17 +0000 _ck_ 20407@http://bbpress.org/forums/ You are getting an error with <code>admin_email</code> because in bbPress 0.9 they decided to change it to <code>from_email</code> with no support for the old variable (bad move). That plugin obviously never got updated. peterve on "bbpress 0.9.0.2 slow" http://bbpress.org/forums/topic/bbpress-0902-slow#post-20406 Sun, 02 Nov 2008 14:37:53 +0000 peterve 20406@http://bbpress.org/forums/ by the way (and perhaps off-topic) : is there a benchmark plugin for wordpress ? can't seem to find one in the plugins directory for wp tx _ck_ on "bbpress 0.9.0.2 slow" http://bbpress.org/forums/topic/bbpress-0902-slow#post-20404 Sun, 02 Nov 2008 14:37:09 +0000 _ck_ 20404@http://bbpress.org/forums/ That's better but your query counts are still too high. Way too high. You could post the list of queries from bb-benchmark here and I can take a look at what's causing that. eAccelerator is probably the way too go. It's a tad slower than Xcache but it's far more stable. Assuming you are using a 2ghz+ cpu that is only lightly loaded, you should be seeing page render times around 100ms on an optimized setup with proper mysql and php opcode caches. peterve on "bbpress 0.9.0.2 slow" http://bbpress.org/forums/topic/bbpress-0902-slow#post-20403 Sun, 02 Nov 2008 13:57:01 +0000 peterve 20403@http://bbpress.org/forums/ have a look at the forum now (http://forums.corelan.be:8800) runs a lot faster now, doesn't it ? I have made a couple of changes to the php.ini file : register_long_arrays=off output_buffering=4096 variables_order = "GPCS" (still need to verify that this doesn't break stuff) disabled engine=on closed & saved the file, and php runs must faster now (windows 2008, IIS7) Also, one of the plugins that I'm using (EnhancedRegistration) was reporting repeated errors in my php log file "bbPress ER: Failed to send report" I looked up the function, replaced the bb_get_option('admin_email') with a static email address, and now the errors went away as well Not sure whether this has improved the code as well, but it certainly couldn't hurt, could it wtih regards to the opcode cache : what would you recommend using ? _ck_ on "bbpress 0.9.0.2 slow" http://bbpress.org/forums/topic/bbpress-0902-slow#post-20401 Sun, 02 Nov 2008 13:35:34 +0000 _ck_ 20401@http://bbpress.org/forums/ Your front page is now showing 56 queries which is excessive. Something is very wrong there too. I'll know more after I see what plugins you have installed. _ck_ on "bbpress 0.9.0.2 slow" http://bbpress.org/forums/topic/bbpress-0902-slow#post-20400 Sun, 02 Nov 2008 12:50:54 +0000 _ck_ 20400@http://bbpress.org/forums/ By the way, even when we fix the plugin problem, your setup could benefit greatly from a PHP opcode cache (eaccelerator, xcache, APC, etc.) We just have to find one that's compatible with Windows and IIS which will take some research. It should cut your page times in half, on both bbPress and WordPress. Here's one possibility: <a href="http://www.sitebuddy.com/PHP/Accelerators/eAccelerator" rel="nofollow">http://www.sitebuddy.com/PHP/Accelerators/eAccelerator</a> That site has pre-built windows binaries for eAccelerator as well as good install directions. _ck_ on "bbpress 0.9.0.2 slow" http://bbpress.org/forums/topic/bbpress-0902-slow#post-20399 Sun, 02 Nov 2008 12:45:08 +0000 _ck_ 20399@http://bbpress.org/forums/ Give me a list of what plugins you are using and I'll guess at the culprit. If you are using firefox you can copy just the column of the plugin names from the admin menu by using control-click on the table cells. peterve on "bbpress 0.9.0.2 slow" http://bbpress.org/forums/topic/bbpress-0902-slow#post-20398 Sun, 02 Nov 2008 11:37:58 +0000 peterve 20398@http://bbpress.org/forums/ update : benchmark results : total page time: 5.3 seconds. time to reach each section: bb_underscore_plugins_loaded = 0.172 bb_plugins_loaded = 5.210 bb_init = 5.211 bb_index.php_pre_db = 5.215 front-page.php = 5.217 header.php = 5.220 logged-in.php = 5.247 footer.php = 5.298 so apparently one of the plugins takes a long time to run how can I find the plugin without having to disable all plugins ? peterve on "bbpress 0.9.0.2 slow" http://bbpress.org/forums/topic/bbpress-0902-slow#post-20397 Sun, 02 Nov 2008 11:31:40 +0000 peterve 20397@http://bbpress.org/forums/ this is a dedicated host, running at home - no option to move it because of too much integration with other stuff... I have full access to all components anything I can do to get you more info ? _ck_ on "bbpress 0.9.0.2 slow" http://bbpress.org/forums/topic/bbpress-0902-slow#post-20395 Sun, 02 Nov 2008 10:38:04 +0000 _ck_ 20395@http://bbpress.org/forums/ Are you on a shared host or do you have access to the mysql cache and adding PHP modules? Install <a href="http://bbpress.org/plugins/topic/bb-benchmark/">bb-benchmark</a> and tell me how long it takes for a page to render. update: I found your forums and you're correct, there is definitely something wrong: 10.275 - 24 queries There is probably a configuration issue with your server. Let me know if you have root access. It's going to be difficult to help because you are on Microsoft IIS 7.0 but I'll see if there's anything we can do. ps. are you running this on your home computer? If so, consider moving your hosting setup to xampp, though it still might be remotely possible to install eaccelerator with your IIS configuration. peterve on "bbpress 0.9.0.2 slow" http://bbpress.org/forums/topic/bbpress-0902-slow#post-20393 Sun, 02 Nov 2008 10:07:33 +0000 peterve 20393@http://bbpress.org/forums/ Hello, I have been running wordpress 2.6.x and bbpress 0.9.0.2 on the same server While wordpress (with many plugins) runs pretty fast, my bbpress forum appears to be very slow Even without plugins, I had the impression bbpress runs much slower than wordpress (with plugins) How can I troubleshoot this ? thanks chrishajer on "INSERT queries for new Topic and new Post" http://bbpress.org/forums/topic/insert-queries-for-new-topic-and-new-post#post-20278 Mon, 27 Oct 2008 15:27:17 +0000 chrishajer 20278@http://bbpress.org/forums/ So much for my IIS guess. I am not having this trouble on a Linux server, MySQL 4.0.28-log, Apache 1.3.x, PHP 5.2.6 with Alpha 2. rowoot on "INSERT queries for new Topic and new Post" http://bbpress.org/forums/topic/insert-queries-for-new-topic-and-new-post#post-20237 Sat, 25 Oct 2008 18:13:50 +0000 rowoot 20237@http://bbpress.org/forums/ i am using apache 2.2.9. php 5.2.6 chrishajer on "INSERT queries for new Topic and new Post" http://bbpress.org/forums/topic/insert-queries-for-new-topic-and-new-post#post-20087 Tue, 21 Oct 2008 14:43:40 +0000 chrishajer 20087@http://bbpress.org/forums/ Sounds like both of you are on IIS web servers? rowoot on "INSERT queries for new Topic and new Post" http://bbpress.org/forums/topic/insert-queries-for-new-topic-and-new-post#post-20079 Tue, 21 Oct 2008 08:29:29 +0000 rowoot 20079@http://bbpress.org/forums/ I too am facing the same problem. I am trying on a local server (apache) wp2.6.2+bbpress alpha releases and also the latest version from the trunk I have tried on , mysql version 5.0.16-nt mysql version is 5.0.67-community nt I think it is a bug. ikailo on "INSERT queries for new Topic and new Post" http://bbpress.org/forums/topic/insert-queries-for-new-topic-and-new-post#post-19586 Wed, 01 Oct 2008 13:18:10 +0000 ikailo 19586@http://bbpress.org/forums/ Ver 14.12 Distrib 5.0.45, for Win32 (ia32) 5.0.45-community-nt MySQL Community Edition (GPL) chrishajer on "INSERT queries for new Topic and new Post" http://bbpress.org/forums/topic/insert-queries-for-new-topic-and-new-post#post-19581 Wed, 01 Oct 2008 03:32:12 +0000 chrishajer 19581@http://bbpress.org/forums/ What is your MySQL version? ikailo on "INSERT queries for new Topic and new Post" http://bbpress.org/forums/topic/insert-queries-for-new-topic-and-new-post#post-19579 Wed, 01 Oct 2008 03:05:04 +0000 ikailo 19579@http://bbpress.org/forums/ This was originally going to be an "It's not working!" post, but I made some progress. Now it's "Is what I did ok?" post. I kept getting a"This Topic is Closed" error every time I tried to create a new topic. Traced it back to the insert statement in 'bb_insert_topic' in functions.php. The database was responding with the error of "The value ' ' is not a valid integer for column 'topic_id'. (I am paraphrasing, I don't have the exact response in front of me) I suspected it had something to do with the fact that the topic_id value is being supplied to MySql, but it is set to be an auto-increment / not null field. So, I commented out in the $default array definition in 'bb_insert_topic': <code>// 'topic_id' => false, // accepts ids or slugs</code> and I changed this line: <code>unset( $default['topic_id'], $defaults['tags'] );</code> to this: <code>unset( $args['topic_id'], $defaults['tags'] );</code> Did the same thing under the 'bb_insert_post' function in the same file, but for the 'post_id' variables. Presto. Everything seems to work OK now. Could this issue be specific to my version of MySql? Although it is strange, because the original query works just fine using a third party tool (SQLyog). Has anyone encountered this issue before? Or - can anyone comment on the validity of my changes, and if they might cause issues going forward? Finally - should this be logged as a bug? Thanks! WP 2.6, BB 1.0, IIS 6. chrishajer on "Infinite Loops on posts and profiles with IIS" http://bbpress.org/forums/topic/infinite-loops-on-posts-and-profiles#post-17406 Fri, 18 Jul 2008 02:38:04 +0000 chrishajer 17406@http://bbpress.org/forums/ Awesome _ck_ - thank you. Anonymous on "Infinite Loops on posts and profiles with IIS" http://bbpress.org/forums/topic/infinite-loops-on-posts-and-profiles#post-17399 Thu, 17 Jul 2008 21:48:10 +0000 Anonymous 17399@http://bbpress.org/forums/ You sir, are an absolute GENIUS! It works! I cannot thank you enough, thanks very much. Just to confirm that this is only need for IIS7 as IIS6 works just fine with Bbpress. Seriously, thank you _ck_ I owe you a drink or something! M _ck_ on "Infinite Loops on posts and profiles with IIS" http://bbpress.org/forums/topic/infinite-loops-on-posts-and-profiles#post-17396 Thu, 17 Jul 2008 16:14:59 +0000 _ck_ 17396@http://bbpress.org/forums/ I have a crazy idea to try to "fake out" bbPress and make it think request_uri actually exists on the IIS server so it doesn't try to (incorrectly) calculate it itself. Try saving and installing this as a plugin with a leading underscore, ie. <code>_IIS-fix.php</code> <pre><code><?php /* Plugin Name: IIS request_uri fix */ if (isset($_SERVER['HTTP_REQUEST_URI'])){ $_SERVER['REQUEST_URI'] = $_SERVER['HTTP_REQUEST_URI']; } else{ if(isset($_SERVER['SCRIPT_NAME'])) $_SERVER['HTTP_REQUEST_URI'] = $_SERVER['SCRIPT_NAME']; else $_SERVER['HTTP_REQUEST_URI'] = $_SERVER['PHP_SELF']; if($_SERVER['QUERY_STRING']){ $_SERVER['HTTP_REQUEST_URI'] .= '?' . $_SERVER['QUERY_STRING']; } $_SERVER['REQUEST_URI'] = $_SERVER['HTTP_REQUEST_URI']; } ?></code></pre> no activation required, should auto-activate - just delete if it causes problems _ck_ on "Infinite Loops on posts and profiles with IIS" http://bbpress.org/forums/topic/infinite-loops-on-posts-and-profiles#post-17395 Thu, 17 Jul 2008 15:44:29 +0000 _ck_ 17395@http://bbpress.org/forums/ I'm taking a look at this now for what it's worth. Not sure if I'll be able to help but let's see. IIS is sending a refresh header: <code>Refresh 0;url=http://www.louisecooper.com/journal/messageboard/topic.php?id=20</code> content length is zero, so nothing is being sent Apparently IIS returns "request_uri" differently than other servers. I suspect it's a similar problem to what they went through with drupal here: <a href="http://drupal.org/node/166095" rel="nofollow">http://drupal.org/node/166095</a> Unfortunately it's way over my head to fix. I suspect it will take someone like MDA to fix it. chrishajer on "Infinite Loops on posts and profiles with IIS" http://bbpress.org/forums/topic/infinite-loops-on-posts-and-profiles#post-17311 Tue, 15 Jul 2008 19:42:50 +0000 chrishajer 17311@http://bbpress.org/forums/ How about IIS access logs or error logs? Anonymous on "Infinite Loops on posts and profiles with IIS" http://bbpress.org/forums/topic/infinite-loops-on-posts-and-profiles#post-17291 Tue, 15 Jul 2008 07:43:19 +0000 Anonymous 17291@http://bbpress.org/forums/ Yeah I've tried what you've tried there with the re-directs and yep, it just dies. But no meta-redirects are used in my sites at all. For experimentation I tried the domain with two different domain bindings, multiple domain bindings. But no difference. I tried an older version of bbpress, same problem. I installed bbpress fresh into a different domain, same problem. I noticed this guy here had a similar prob a while back: <a href="http://bbpress.org/forums/topic/forum-and-topic-pages-redirects-to-page-1" rel="nofollow">http://bbpress.org/forums/topic/forum-and-topic-pages-redirects-to-page-1</a> But never said how he solved it, I might join up to his forum and ask him.... But yes this is driving me crazy...on a plus note when I finally fix it I can fresh install bbpress in about two minutes ;-) Any other suggestions from folk greatly appreciated. And thanks for ongoing help Chris. chrishajer on "Infinite Loops on posts and profiles with IIS" http://bbpress.org/forums/topic/infinite-loops-on-posts-and-profiles#post-17282 Mon, 14 Jul 2008 23:32:06 +0000 chrishajer 17282@http://bbpress.org/forums/ I see :-) So you turn on permalinks to prevent people from viewing anything and putting their request into an infinite loop. Got it. I see now that it's still broken. Are you sure there is nothing causing a meta redirect? The only thing that stops the looping for me is to disable meta redirects in my browser. Other than that, it loops forever.