[Plugin: phpbb_recent_topics] Admin Screen doesn't Allow options to be filled in

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.

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.

eh???

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

1) Tick the enable insecure mode checkbox
2) Save

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

3) Fill in credentials
4) Save == done ??

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.

Now that is new ??

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

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.

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

php 5.2.11 linux

I have been using the admin to deactivate.

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.

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

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.

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

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.