tbenyon

So typing in field name values isn’t updating the data but typing in the field values does.

That sounds like a bug in itself but I’ll come back to that because if the data is getting updated in that field, but when you press the save button you are not seeing it in the database that is the first issue to solve.

Let’s do a couple more checks:
In the wp_options table you can see the field “exlog_exclude_users_field_name_repeater” and in your case this has the “option_value” of “false”?

Could you please:

1. Delete the row entry for this field in the database
2. Update one of the field values in the options area
3. Check that the “exlog_repeater_data_source” value is updated with data
4. Click save
5. Check that the “exlog_exclude_users_field_name_repeater” has reappeared in your datbase options table
6. Confirm with me the value of that field in the database

Thanks,

Tom

Hey @piska,

Apologies for the delayed response.

The 500 should mean that you have got a connection to the server but it is returning an error.

Two things we can do:

1) PHP error logs
You are hitting the test button on site A and getting the 500 error. Can you please get me the PHP errors for site B that occurred at the time you clicked the Test button.

2) Get more information from the front end JS error

If you’re able, can you replace all the code in this file (/wp-content/plugins/external-login/js/exlog_test.js) on site A.

Could you please delete the previous code paste the following code in there instead.

console.log("EXLOG - Test file loaded.");
(function ($) {
    $(function () {
        console.log("EXLOG - Test file loaded jQuery.");
        var $modal = $(".exlog_modal");
        var $loader = $(".exlog_loader_container");
        var $modal_content_container = $(".exlog_test_results_inner_container", $modal);
        var $modal_test_results = $(".exlog_test_results", $modal);
        var $modal_error = $(".exlog_test_fail", $modal_content_container);
        var $modal_error_title = $(".exlog-error-title", $modal_error);
        var $modal_error_message = $(".exlog-error-message", $modal_error);
        var wordpressBaseUrl = $('[data-exlog-wp-base]').attr('data-exlog-wp-base');

        var error_messages = {
            unknown: {
                title: "Error",
                message: "This is an unknown error."
            },
            lost: {
              title: "Error",
              message: "Could not access the server to run the test."
            },
            server: {
                title: "Error",
                message: "There was an error on the server."
            },
            empty_result: {
              title: "Error",
              message: "No data returned from the server. Please check your settings."
            }
        };

        var error_codes = {
          100: error_messages.unknown,       // Ajax returned, unknown error
          101: error_messages.unknown,       // Unknown error passed to error handler
          404: error_messages.lost,          // 404 from Ajax
          500: error_messages.server,        // 500 from server - see test_results.php?
          501: error_messages.server,        // String of "0" returned - caused by missing function?
          502: error_messages.server,        // 500ish error from Ajax
          600: error_messages.empty_result,  // Empty AJAX response
          601: error_messages.empty_result   // Blank string AJAX response
//        999: ????????????????????????      // Hard coded in markup case this system fails
        };

        function errorMessageState(error_code) {
          if (!error_code) {
            $modal_error.hide();
          }

          if (!error_codes.hasOwnProperty(error_code)) {
            error_code = 101;
          }

          var error_data = error_codes[error_code];

          $modal_error_title.text(error_data.title + ": " + error_code);
          $modal_error_message.text(error_data.message);

          $modal_error.show();
        }

        $(".exlog_close_button", $modal).click(function () {
            $modal_error.hide();
            $modal.hide();
            $modal_test_results.text("");
        });

        $("input.exlog_test_connection").click(function () {
            console.log("EXLOG - Test button clicked.");
            $modal.show();
            $loader.show();
            var data = {
                'action': 'exlog_test_connection',
                'test_results': 10
            };

            console.log("EXLOG - About to make request.");
            $.ajax({
                type: "GET",
                url: wordpressBaseUrl + "/wp-admin/admin-ajax.php",
                data: data,
                success: function (data) {
                    if (typeof data === 'string') {
                      data = data.trim();
                    }

                    if (!data) {
                      console.log("EXLOG - NO DATA");
                      errorMessageState(600);
                      $modal_error.show();
                    } else if (data == "") {
                      console.log("EXLOG - EMPTY STRING DATA");
                      errorMessageState(601);
                      $modal_error.show();
                    } else if (data === "0") {
                      errorMessageState(501);
                    } else {
                      console.log("EXLOG - SUCCESS!!! WHOOP!");

                      $modal_error.hide();
                      $modal_test_results.append(data);
                    }
                    $loader.hide();
                },
                error: function (xhr, ajaxOptions, thrownError){
                  console.log("EXLOG - Request fail!!!");
                  console.log("Status: ", xhr.status);
                  console.log("Response Text: ", xhr.responseText);
                  if(xhr.status == 404) {
                    errorMessageState(404);
                  } else if (xhr.status === 500) {
                    errorMessageState(500);
                  } else if (Math.floor(xhr.status / 100) === 5) {
                    errorMessageState(502);
                  } else {
                    errorMessageState(100);
                  }
                  $loader.hide();
                }
            });
        });
    });
}(jQuery));

Can you then open the inspector and look at the browsers console.

I’m interested particularly to see the output that follows “Response Text: “.

Thanks,

Tom

If that is all you are seeing in the console, even after clicking the test button, it must be that the error that follow are preventing Javascript to continue running.

I’m going to ask you to do something that I hate it when people ask me to do but I think may be the cause of your problem. I’m starting to think this is nothing to do with my plugin but your theme or another plugin that is causing a JS error which is blocking other JS from running.

The reason I think this is these two lines are very basic and they should execute when you click the test button:

        $("input.exlog_test_connection").click(function () {
            console.log("EXLOG - Test button clicked.");

–To Try–
Please set your theme back to the default 2019 theme and disable other plugins.
Keep turning all this off until you find this is all working.

If you disable all and reset your theme and find it works with just my plugin you can gradually include plugins again until you find the one that is causing the issue.

I may be wrong bit it is strange that this simple code is not running.

If this doesn’t work for you, we could start to find out why this JS isn’t running when you click the button.

Sorry this is taking time. It’s hard to solve when I can’t replicate.

I won’t give up on this 🙂

I may be wrong but it sounds like your PHP errors aren’t coming through.

The 500 error only appears if there is an error on the server.

There’s a few more things to do so that we can the required error information.

Test that your error logs are working
In your functions.php file, at the very top add:
error_log("-----------EXTERNAL LOGIN TESTING!!!!!------------");

If when you refresh your page you are not seeing this in your error logs then we need to fix that first. Make sure you’re looking at the logs for the server where you are pressing the test button from.

Test if we’re getting to the test query function in the plugin
If we are seeing the above error log that’s great.

Let’s see if we’re getting to the test function in the plugin.

Let’s add this line of code:
error_log("External Login - We're starting the test query!!!!!!!!!!!!");

. . . to this file:
wp-content/plugins/external-login/js/exlog_test.js

. . .in this function:
exlog_test_query()

. . . so that it now looks like this:

function exlog_test_query($limit = false) {
    error_log("External Login - We're starting the test query!!!!!!!!!!!!");
    $dbType = exlog_get_option('external_login_option_db_type');
    $db_data = exlog_get_external_db_instance_and_fields($dbType);
    if ($dbType == "postgresql") {
        $query_string =
            'SELECT *' .
            ' FROM "' . esc_sql($db_data["dbstructure_table"]) . '"';
        if ($limit && is_int($limit)) {
            $query_string .= ' LIMIT ' . $limit;
        }
        $rows = pg_query($query_string) or die('Query failed: ' . pg_last_error());
        $users = array();
        if (sizeof($rows) > 0) {
            while ($x = pg_fetch_array($rows, null, PGSQL_ASSOC)) {
                array_push($users, $x); //Gets the first row
            };
            pg_close($db_data["db_instance"]);
            return $users;
        }
    } else {
        $query_string =
            'SELECT *' .
            ' FROM ' . esc_sql($db_data["dbstructure_table"]) . '';
        if ($limit && is_int($limit)) {
            $query_string .= ' LIMIT ' . $limit;
        }
        $rows = $db_data["db_instance"]->get_results($query_string, ARRAY_A);
        $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;
        }
    }
    //If got this far, query failed
    error_log("External Login - No rows returned from test query.");
    return false;
}

Do we see that error in your logs?

Get more information from the front end JS error
We’re going to add a line of code to the front end JS so we can see more of what is going on.

We’re going to modify the file wp-content/plugins/external-login/js/exlog_test.js.

We’re going to add the line:
console.log("EXTERNAL LOGIN JS TESTING:", xhr.responseText);

We’re going to add this to the ajax call so that it looks like this:

            $.ajax({
                type: "GET",
                url: wordpressBaseUrl + "/wp-admin/admin-ajax.php",
                data: data,
                success: function (data) {
                    if (!data) {
                      errorMessageState(600);
                      $modal_error.show();
                    } else if (data == "") {
                      errorMessageState(601);
                      $modal_error.show();
                    } else if (data === "0") {
                      errorMessageState(501);
                    } else {
                      $modal_error.hide();
                      $modal_test_results.append(data);
                    }
                    $loader.hide();
                },
                error: function (xhr, ajaxOptions, thrownError){
                  console.log("EXTERNAL LOGIN JS TESTING:", xhr.responseText);
                  if(xhr.status == 404) {
                    errorMessageState(404);
                  } else if (xhr.status === 500) {
                    errorMessageState(500);
                  } else if (Math.floor(xhr.status / 100) === 5) {
                    errorMessageState(502);
                  } else {
                    errorMessageState(100);
                  }
                  $loader.hide();
                }
            });

Of course, this error will appear in your browsers console log.

Ok, apologies for slowing down this process for you, I just worried we were going to waste your time by looking at the wrong solution.

To get one thing solved at a time, let’s not worry about the plugin being installed on site A at the moment. Let’s just get Site B logging in using Site A users. For this we don’t even need the plugin installed on site A but just leave it there for now.

On site B, try setting the hashing method to “phpcrypt” or “phpass”.

I’m pretty sure WordPress uses one of these by default.

Let me know how you get on 🙂

Hey @xprojectsx,

Are you still experiencing this problem?

Could you tell me:

• Which browser you’re using
• Look at the browser console to see if there are any errors
• Look in your database wp_options table and tell me what is stored in the field named “exlog_exclude_users_field_name_repeater”

Thanks,

Tom

Hey @volt74,

This is now live and other users have told me it’s working. If you have any issues, please feel free to re-open this ticket but I’ll mark it as resolved for now.

Thanks,

Tom