[Plugin: phpbb_recent_topics] How to make it work

  • Resolved rate4d

    (@rate4d)


    15 years, 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 ??

    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. ??

Viewing 9 replies - 1 through 9 (of 9 total)

  • 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!

    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

    kjottbein

    (@kjottbein)

    Hello

    I also get this error: phpBB Error – phpbb_topics

    I have no php admin tool installed on my server so I haven’t been able to grant persmissions on my database, but I thought I could use the Insecure Database Connection instead?

    linickx

    (@linickx)

    yep kjottbein, that would work ??

    kjottbein

    (@kjottbein)

    Well, it didn’t in my case. Still get the phpBB Error – phpbb_topics error message. What else could cause this?

    linickx

    (@linickx)

    Hi kjottbein,

    phpBB Error – phpbb_topics means that the plugin cannot query the phpbb_topics table.

    If you are using “insecure mode”, check that you have copy/pasted the username & password from your phpbb config file correctly, then check that the table & db names are correct.

    If you can’t find anything wrong, pls paste the error message from your apache (httpd) error_log

    Cheers,
    Nick

    Hi,

    I see unchecked “Excluded Forums” on the setting site of phpBB Recent Topics, but they do not show up on the sidebar. There only appears the error message “phpBB Error -phpbb_topics”.

    I have tried all variations on the setting site. I also added “5” to “phpbb_topics()” in the code for the sidebar [=phpbb_topics(5)].

    The plugin still does not work…

    Thanks for all ideas in advance!

    well …

    in my case I point the plugin to the wrong database.

    And got the same error message.

    “phpBB Error -phpbb_topics”

    Peter

    Is there a way to have this plugin log in with another account (instead of wp_user) ?
    I have NO possibility, whatsoever, to grant access on my database (security of my hosting party).
    And to be honest; I do not like the ‘unsecure’ connection possibility.

    Cheers,
    Ruud

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘[Plugin: phpbb_recent_topics] How to make it work’ is closed to new replies.