WordPress.org

Ready to get started?Download WordPress

Forums

phpbb_recent_topics
Admin Screen doesn't Allow options to be filled in (14 posts)

  1. macmiller
    Member
    Posted 2 years ago #

    I installed the plug-in and then there appears a 'phpBB Recent Topics' option on the Settings panel. When I click that option it comes back and says 'Can't select database.......'. There are no options to fill in and set up the database.

    I would like to know how to get the screen as shown in screenshot-1.png so I can fill in the information.

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

  2. linickx
    Member
    Plugin Author

    Posted 2 years ago #

    Enable in-secure mode.

    Paste from the FAQ..

    What is Insecure MySQL Connectivity ?
    Some people cannot GRANT priveliges from one DB to another; insecure connectivity allows you to store the phpbb database credentials within the WordPress database.

    Why is Insecure MySQL Connectivity Insecure?
    The phpbb database credentials are stored in the WordPress database in CLEAR TEXT, this is bad, as anyone with access to the WP DB can get full access to phpbb. Another reason is that usually the credentials given to the phpbb application are FULL access, we only need to read the database, so it's much better to restrict access.

  3. macmiller
    Member
    Posted 2 years ago #

    There are no options shown other than the error, so I would be unable to enable in-secure mode if it is done from the 'phpBB Recent Topics' option on the Settings Panel.

  4. linickx
    Member
    Plugin Author

    Posted 2 years ago #

    eh???

    See this screenshot -> http://cl.ly/3X033b080R1k1E361q2t

    1) Tick the enable insecure mode checkbox
    2) Save

    See this screenshot -> http://cl.ly/420E150347211q0t0a2E

    3) Fill in credentials
    4) Save == done :-)

  5. macmiller
    Member
    Posted 2 years ago #

    I'm really not seeing the option boxes, like I said.
    Here is what I do in step 1, I click the as follows:
    phpBB Recent Topics in the settings
    In step two
    I see this screen

    There are no options to fill in and set up the database.

  6. linickx
    Member
    Plugin Author

    Posted 2 years ago #

    Now that is new :-D

    That can't select database error message is not one from the plugin, its a message from the WP core... and as you can see if very different from my screenshot.

    Is there anything in your apache error_log that can help us out?

    It might also be worth checking for a theme/plugin conflicts... my site (which the screenshots came from) is running the latest WP with no other plugins (and the twentyeleven theme).

    Cheers,
    Nick

  7. macmiller
    Member
    Posted 2 years ago #

    I have a test environment with a new install of WP 3.2.1. There are no other plug ins active during my test. The problem with the DB unable to connect happens each time I activate the plug in. There are only the register_sidebar and register_widget depreciated messages in the log (and one undefined variable). I have tried it under three different themes (2011, 2010 and one other) and the problem occurs under all themes.

  8. linickx
    Member
    Plugin Author

    Posted 2 years ago #

    How very odd.

    I wonder I don't know... or what's different. I have php 5.3.3 on linux, what do you have?

    Try commenting out line 40 to 49 of admin-options.php.

    Another thing to try is to uninstall the plugin via the dashboard. Do not just delete the folder via CLI/FTP as the dashboard runs uninstall.php which cleans out any old phpbb_recent_topics settings stored in the WordPress DB.

    I hope that helps,
    Kind Regards,
    Nick

  9. macmiller
    Member
    Posted 2 years ago #

    php 5.2.11 linux

    I have been using the admin to deactivate.

  10. linickx
    Member
    Plugin Author

    Posted 2 years ago #

    I have been using the admin to deactivate.

    That will disable the plugin functions from being called... hitting the "delete" button in the admin dashboard will remove the plugin files and clean up the database.

  11. macmiller
    Member
    Posted 2 years ago #

    OK, I will try the delete. I commented out 40 to 49 and got the normal plug-in admin screen.

  12. linickx
    Member
    Plugin Author

    Posted 2 years ago #

    I'm very confused on what's happening on your host.

    The plugin logic is as follows..

    1) phpbb_recent_topics.php - If U R an admin run admin.php
    2) admin.php - setup help, options validation & load /display/admin-options.php
    3) admin-options.php - try to connect to DB and print the form.

    Try commenting out the whole DB block (instead of just the 1st half) in admin-options and let me know if the form loads.

  13. macmiller
    Member
    Posted 2 years ago #

    I should say that by commenting out line 40 to 49 I got your plug-in form to load as normal.

  14. linickx
    Member
    Plugin Author

    Posted 2 years ago #

    Excellent! You should be able to go through the "tick insecure box" , save , "fill in credentials" and save loop.

    For some reason $wpdb->select($lnx_PRT_options['prt_phpbb_db']); doesn't fail gracefully on your host (like it does on mine).

    Any suggestions or tweaks you can do you on your test environment to keep the code in, but fail nicely would be very much appreciated.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic