User registration is broken in version 2.9.2

[Ezrael]

I assume that an error has occurred. At least from the backend, it looks as though the user was successfully registered. The transfer of the data to the forum should now only take place once the first login occurs.

[axew3]

ERROR DETECTED!
let see...

[Ezrael]

Is the problem relates to 2.9.2? Because I haven’t had any issues before and the plugin has worked quite well after we fixed most of the bugs.

[axew3]

No not only.
It is a long time bug i finally completely reversed.

PHP Fatal error: Uncaught Error: Call to a member function get_results() on string

The problem is that at the time the integration plugin function get_results() is called to retrieve data via a db query, so also when, after the user activation by Ultimate member the user is processed to update/insert data into the phpBB db
(AND IN MANY MORE REPORTED CASES)
the db connection is effectively NOT set because the database connection values have been lost.

The reason of problems:
When the plugin code has been changed to save the phpBB db connection values into the WP database and not anymore into a file it required to manage a big problem: if an user wrongly set the phpBB database connection values!?
Since the connection to phpBB is done using a direct call to the wpdb class, WordPress will fall into a DB CONNECTION ERROR and no way for a normal user to come out by this situation. So the code prevent the issue doing a (let me say) magic thing, and not causing this.
But since this change, somehow and sometime connection values are lost and the (i assumed it solved) long time bug
PHP Fatal error: Uncaught Error: Call to a member function get_results() on string
still is there.

DEFINITIVE 2.9.3 SOLUTION:
the definitive solution to this available since 2.9.3 will be so to include a custom phpBB config file in this way:

create the folder
/wp-content/plugins/wp-w3all-custom
open with a text editor the file
/wp-content/plugins/wp-w3all-phpbb-integration/addons/phpBB_config.php

set values for following vars

Code: Select all

$phpbb_dbhost = 'localhost';
$phpbb_dbport = ''; # maybe required leave blank if default 3306
$phpbb_dbname = '';
$phpbb_dbuser = '';
$phpbb_dbpasswd = '';
$phpbb_table_prefix = 'phpbb_';

then upload/paste it into the previously created folder
/wp-content/plugins/wp-w3all-custom

USE this temporary class.wp.w3all-phpbb.php (substitute/overwrite it on /wp-content/plugins/wp-w3all-phpbb-integration/)
until the 2.9.3 release:
FILE REMOVED: 2.9.3 has been released

Here we go.
All problems about this have been solved and for any other reported plugin and many reported bugs.

[axew3]

With Ultimate member, testing the new version of the plugin, there is a problem if the user exist in phpBB and go to login in WP (so he will be automatically added in wp).
But unfortunately, when the user is correctly added in WP, the Ultimate member plugin do not create for the user, into the wp_usermeta table, his own record um_member_directory_data which contain several info that UM plugin use to detect the state of the user.
So the user into the users page, appears as Status unknown until an admin do not click for him the Send again activation link.
This cause UM to create that record for the user, that until this step is not done, will result impossible to login using the UM front end login.
Using the WP default login page, the user is logged but redirected to the same login page (even is the user is logged in).
I will look how to work around, but existent old phpBB users that login in WP sot hey are added into WP, are causing issues due to this reported behavior with UM.

[Ezrael]

Does it mean I should downgrade to 2.9.3?