WordPress.org

1. mistermobile
   Member
   Posted 6 months ago #

   Please provide where we can find phpbb MySQL Server?

   On my forum config it says,

   phpbb MySQL Server = localhost

   Is that corrrect? Beacuse when I put localhost on phpbb MySQL Server, my website have become super slow.

   http://wordpress.org/extend/plugins/phpbb-recent-topics/

2. linickx
   Member
   Posted 6 months ago #

   Hello,

   On my forum config it says,

   phpbb MySQL Server = localhost

   Is that corrrect?

   Yes.

   my website have become super slow.

   Do you have some kind of WP caching (memcache / wp-super-cache / etc) ?
   Have you exceeded the mem / cpu limits of your host?

   rgds,
   Nick

3. mistermobile
   Member
   Posted 6 months ago #

   I am using W3 Total Cache and cloudflare.

   I didn't exceeded my memory and cpu limits, the values are in normal condition.

4. linickx
   Member
   Posted 6 months ago #

   PRT will add about 4 queries each time it is called.

   I don't use W3, from reading their features page I can guess that for W3 to have any benefit with PRT you would need page caching enabled and to have PRT setup in secure mode (to use their DB object cache within the WP DB Object).

   I've not had any other reports of significant slow down; if you are on a VPS/AWS style host I assume you are monitoring your %steal or have used something like mysqltuner.

   If you have a patch to speed up the plugin, I'd be happy to implement it.

   rgds,
   Nick

5. mistermobile
   Member
   Posted 6 months ago #

   I have been searching on the net the whole day and i found this code,

   <?php
   $dbms = 'mysql';
   $dbhost = '122.122.122.122';
   $dbport = '';
   $dbname = 'emanuele';
   $dbuser = 'triqui';
   $dbpasswd = 'banana';
   
   $table_prefix = 'phpbb_';
   $acm_type = 'file';
   $load_extensions = '';
   
   @define('PHPBB_INSTALLED', true);
   // @define('DEBUG', true);
   // @define('DEBUG_EXTRA', true);
   ?>

   $dbhost is a database address, do have an idea where can I see the database address of my site?

6. linickx
   Member
   Posted 6 months ago #

   ^^ that file is ...../public_html/phpBB3/config.php

7. mistermobile
   Member
   Posted 6 months ago #

   Sorry, wrong code, here is the correct one,

   <?php
   $connection = mysql_connect(localhost,"your_login","your password") or die("Service temporairly unavailable");
   $db = mysql_select_db("your_db_name",$connection) or die("Service temporairly unavailable");
   $sql = "select * from phpbb_topics order by topic_last_post_time desc limit 0,10";
   $result = mysql_query($sql) or die("Service temporairly unavailable");
   for($x=1;$x<=10;$x++){
   	$row = mysql_fetch_array($result);
   	echo "<a href = \"http://www.yourforumdomain.com/viewtopic.php?f=$row[forum_id]&t=$row[topic_id]\" target = \"_blank\">$row[topic_title]</a><br>";
   }
   ?>

   I found it on this site,

   http://www.emanueleferonato.com/2008/02/08/how-to-show-latest-phpbb3-posts-in-your-wordpress-sidebar/

8. mistermobile
   Member
   Posted 6 months ago #

   Already fixed. I disabled W3TC before I install/configure phpbb_recent_topics.

   Thanks.

9. linickx
   Member
   Posted 6 months ago #

   Thanks.

   I've tagged this with w3-total-cache so that others can find your solution.

   rgds,
   Nick

Reply

You must log in to post.