ERROR! No user data was found.

Hey @kumarsmishra,

I’m more than happy to look into this for you. I’m just reading up on this now.

I presume you don’t have an example database that I can demo this with?

Thanks,

Tom

Hey Santosh,

I’ve just tried to be hacky to test this out live on the site by changing the test code in the wp-admin area. Unfortunately I’m getting the error when I try to save the code:

“Unable to communicate back with site to check for fatal errors, so the PHP change was reverted. You will need to upload your PHP file change by some other means, such as by using SFTP.”

Can I have a copy of your DB and codebase so that I can test locally?

Alternatively, to test if your theory is correct here is the code blocks that need changing so that the query is using mysqli.

In the the plugin root, go to the login directory and open dp.php. There are two blocks that need changing.
— 1) Changing from this:

    $data = array(
        "db_instance" => new wpdb(
            exlog_get_option("external_login_option_db_username"),
            exlog_get_option("external_login_option_db_password"),
            exlog_get_option("external_login_option_db_name"),
            exlog_get_option("external_login_option_db_host")
        ),
        "dbstructure_table" => exlog_get_option('exlog_dbstructure_table'),
        "dbstructure_username" => exlog_get_option('exlog_dbstructure_username'),
        "dbstructure_password" => exlog_get_option('exlog_dbstructure_password'),
        "dbstructure_first_name" => exlog_get_option('exlog_dbstructure_first_name'),
        "dbstructure_last_name" => exlog_get_option('exlog_dbstructure_last_name'),
        "dbstructure_role" => exlog_get_option('exlog_dbstructure_role'),
        "dbstructure_email" => exlog_get_option('exlog_dbstructure_email'),
    );

— 1) to this:

    $data = array(
        "db_instance" => new mysqli(
            exlog_get_option("external_login_option_db_host"),
            exlog_get_option("external_login_option_db_username"),
            exlog_get_option("external_login_option_db_password"),
            exlog_get_option("external_login_option_db_name")
        ),
        "dbstructure_table" => exlog_get_option('exlog_dbstructure_table'),
        "dbstructure_username" => exlog_get_option('exlog_dbstructure_username'),
        "dbstructure_password" => exlog_get_option('exlog_dbstructure_password'),
        "dbstructure_first_name" => exlog_get_option('exlog_dbstructure_first_name'),
        "dbstructure_last_name" => exlog_get_option('exlog_dbstructure_last_name'),
        "dbstructure_role" => exlog_get_option('exlog_dbstructure_role'),
        "dbstructure_email" => exlog_get_option('exlog_dbstructure_email'),
    );

— 2) From this:

    $users = array();
    if (sizeof($rows) > 0) {
        foreach ($rows as $user_data) {
            array_push($users, exlog_build_wp_user_data($db_data, $user_data));
        };
        return $users;
    }

— 2) To this:

    $rows = $db_data["db_instance"]->query($query_string);

    $users = array();
    while ($user = $rows->fetch_assoc()) {
        array_push($users, $user);
    }
    return $users;

Thanks,

Tom

Hey Santosh,

I completely understand what Jan is saying so I’m going to spend some time tomorrow adding in some additional error logging to help me diagnose your problem. Will get back to you in here once I’ve made an updated version of the plugin with the extra error logs and will instruct you on the info I need then.

Thanks for your patience and apologies for not being more aware of the ww.wp.xz.cn rules. I should have thought to read up on this stuff.

Will get back to you soon.

Tom

I haven’t heard from you so I’m marking this as resolved. Let me know if you have any more questions as I’m more than happy to help.