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.