WordPress.org

1. rate4d
   Member
   Posted 3 months ago #

   You know, THIS PLUGIN IS DEVIL,
   Making this plugin work probably was the most diffucult thing I ve done with computer.I created this topic just share info with people like me, who are not very pro at php or wordpress but want it to work.
   I used 2.8.4 version of wordpress and phpbb3.
   So this is how to make it work:
   1.Download the plugin
   2.Upload via ftp to plugins folder (extract before doing that)
   3.Go to wordpress control panel > plugins > activate the plugin " phpbb_recent_topics"
   4.At the control panel of wordpress choose settings > phpbb recent topics.
   5.There is the most complicated situation, mysql, If you run your forum on the same mysql database as wordpress then in the first field of settings - phpbb MySQL Database Name : type "$PHPBBDB" (without quote)
   IF YOU HAVE 2 DATABASES 1 for wordpress and 1 for phpbb forum, then its situation like mine.In the field phpbb MySQL Database Name: you should type your phpbb database name, and this in not all, you should log in to your hosting providers control panel and allow GRANT function, it was turned off in my case.
   After that you should go to my php admin and press mysql icon in the left top after logging in, then window will pop up where you should type "GRANT SELECT ON REPLACE_THIS_TEXT_WITH_YOUR_PHPBB_DATABASE_NAME.phpbb_topics TO REPLACE_THIS_TEXT_WITH_WORDPRESS_USERNAME@localhost;" (wihtout quote)

   And luckily thats all, It took me a few days to do it, it felt good after seeing my topics in the wordpress after many fails :D

   P.S phpbb3 table name: phpbb_topics
   and i recommend to delete the stuff from the Date Formmating, it looks cooler and you can not give a s*it about how to set your local time. Thanks for reading, I hope this will help for someone. :)

2. linickx
   Member
   Posted 3 months ago #

   LOL Getting cross database connectivity is indeed a devil!

   I have long since known that getting GRANT access between two DB's has been the users biggest hurdle, I have just released ver 0.5 which offers a simpler connectivity method but I'd recommend all users go though your pain to ensure the best security :)

   Thanks for posting this!

3. inetmarketing
   Member
   Posted 2 months ago #

   Hey,

   I was told by my host techs to simply add each user to the other db.

   I'm still getting some kind of error : phpBB Error -phpbb_topics

   In the setting page for the plugin it did pull a list of topics to exclude, but it displays the rror in the widget.

   After that you should go to my php admin and press mysql icon in the left top after logging in, then window will pop up where you should type "GRANT SELECT ON REPLACE_THIS_TEXT_WITH_YOUR_PHPBB_DATABASE_NAME.phpbb_topics TO REPLACE_THIS_TEXT_WITH_WORDPRESS_USERNAME@localhost;" (wihtout quote)

   When I clicked on the top left SQL icon it brought up a pop-up to run a sql query. Thats not where you add that "Grant select" line is it?

   Robert

Reply

You must log in to post.