Unable to get user-sync to work...

Hi,

I have tried to get the user-sync to work with my wordpress sites, but cannot get it to work whatsoever. I have even installed fresh installs of wordpress, incase it was other plugins that were causing the issue. I cannot get this plugin to work at all. I have put the error logs in a zip and sent these to Andrey.

I notice this in the master debug log: <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/mydirectory/wp-includes/wp-db.php</b> on line <b>787</b>
. I dont know much about what these errors mean, so any help would be really appreciated.

Many thanks in advance for any kind assistance.

  • Companion

    I am using standard wordpress. I dont get any error messages, the subsite shows up on the mastersite as connected. I get all the messages saying that syncranization has happened. It just doesnt sync. I have tried registering new users on the master site, but it does not sync. I have tried on the fresh install having the two sites on the same database and having different administrators etc. Its just doesnt seem to sync. The debug log for the master site shows the above error that I mentioned. I might be missing something, because I would say I am still a wordpress novice, but I just dont know what I am doing wrong as I believe I have followed the instructions and dont understand why its not even working on two fresh installations on the same database with no other plugins installed or activated.

    Thank you for such a quick response too. I really appreciate any help that can be offered.

  • Philip John

    Okay, can you do the following for me please;
    - click the "Uninstall Options" button to reset everything
    - check the box labelled "Use Debug Mode" when setting up the plugin again
    - ensure that there is a plugins/user-sync/log folder and that it's permissions are writeable (e.g. 777)

    If it doesn't work, take a look at the log file and paste it's contents in here so we can see what's going on.

    Thanks

  • Companion

    Hi,

    I have tried this again as you said and still no joy. The master sites debug log file is as follows:

    [2012-01-16 17:33:12][M] 0-10 - ajax actions***
    [2012-01-16 17:33:12][M] 07 - added new sub site***
    [2012-01-16 17:33:12][M] 0-10 - ajax actions***
    [2012-01-16 17:33:12][M] 08 - count of users= 2;;***
    [2012-01-16 17:33:12][M] 02 - sending request - url=http://www.mysite.org/sub1/wp-admin/admin-ajax.php?action=user_sync_api;;***
    [2012-01-16 17:33:12][M] 03 - sending request - response=78ce2c2a9b4a083513a50dd357e00273;;***
    [2012-01-16 17:33:12][M] 05 - checking key true;;***
    [2012-01-16 17:33:12][M] 09 - user sync***
    [2012-01-16 17:33:12][M] 02 - sending request - url=http://www.mysite.org/sub1/wp-admin/admin-ajax.php?action=user_sync_api;;***
    [2012-01-16 17:33:12][M] 03 - sending request - response=
    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/sub1/wp-includes/wp-db.php</b> on line <b>787</b>

    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/sub1/wp-includes/wp-db.php</b> on line <b>787</b>

    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/sub1/wp-includes/wp-db.php</b> on line <b>787</b>
    ok;;***
    [2012-01-16 17:33:12][M] 09 - user sync***
    [2012-01-16 17:33:12][M] 02 - sending request - url=http://www.mysite.org/sub1/wp-admin/admin-ajax.php?action=user_sync_api;;***
    [2012-01-16 17:33:12][M] 03 - sending request - response=
    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/sub1/wp-includes/wp-db.php</b> on line <b>787</b>

    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/sub1/wp-includes/wp-db.php</b> on line <b>787</b>

    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/sub1/wp-includes/wp-db.php</b> on line <b>787</b>
    ok;;***
    [2012-01-16 17:33:28][M] 02 - sending request - url=http://www.mysite.org/sub1/wp-admin/admin-ajax.php?action=user_sync_api;;***
    [2012-01-16 17:33:28][M] 03 - sending request - response=84adcbb9635c61966900b5098f5bb222;;***
    [2012-01-16 17:33:28][M] 05 - checking key true;;***
    [2012-01-16 17:33:28][M] 09 - user sync***
    [2012-01-16 17:33:28][M] 02 - sending request - url=http://www.mysite.org/sub1/wp-admin/admin-ajax.php?action=user_sync_api;;***
    [2012-01-16 17:33:28][M] 03 - sending request - response=
    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/sub1/wp-includes/wp-db.php</b> on line <b>787</b>

    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/sub1/wp-includes/wp-db.php</b> on line <b>787</b>

    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/sub1/wp-includes/wp-db.php</b> on line <b>787</b>
    ok;;***
    [2012-01-16 17:33:28][M] 09 - user sync***
    [2012-01-16 17:33:28][M] 02 - sending request - url=http://www.mysite.org/sub1/wp-admin/admin-ajax.php?action=user_sync_api;;***
    [2012-01-16 17:33:28][M] 03 - sending request - response=
    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/sub1/wp-includes/wp-db.php</b> on line <b>787</b>

    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/sub1/wp-includes/wp-db.php</b> on line <b>787</b>

    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/sub1/wp-includes/wp-db.php</b> on line <b>787</b>
    ok;;***

    The subsites debug log code is as follows:

    [2012-01-16 17:33:11][S] 01 - new subsite conection - central_url=http://www.mysite.org/wordpress;; replace_user=1;; overwrite_user=1;;***
    [2012-01-16 17:33:11][S] 02 - sending request - url=http://www.mysite.org/wordpress/wp-admin/admin-ajax.php?action=user_sync_api;;***
    [2012-01-16 17:33:12][S] 03 - sending request - response=ok;;***
    [2012-01-16 17:33:12][S] 01_2 - sync users for new subsite***
    [2012-01-16 17:33:12][S] 02 - sending request - url=http://www.mysite.org/wordpress/wp-admin/admin-ajax.php?action=user_sync_api;;***
    [2012-01-16 17:33:12][S] 0-10 - ajax actions***
    [2012-01-16 17:33:12][S] 0-10 - ajax actions***
    [2012-01-16 17:33:12][S] 5-10 - start sync_user***
    [2012-01-16 17:33:12][S] 15 - insert user - step 1***
    [2012-01-16 17:33:12][S] 16 - do not replace deleted users***
    [2012-01-16 17:33:12][S] 17 - insert user - step 2***
    [2012-01-16 17:33:12][S] 18 - insert user - ok***
    [2012-01-16 17:33:12][S] 0-10 - ajax actions***
    [2012-01-16 17:33:12][S] 5-10 - start sync_user***
    [2012-01-16 17:33:12][S] 15 - insert user - step 1***
    [2012-01-16 17:33:12][S] 16 - do not replace deleted users***
    [2012-01-16 17:33:12][S] 17 - insert user - step 2***
    [2012-01-16 17:33:12][S] 18 - insert user - ok***
    [2012-01-16 17:33:12][S] 03 - sending request - response=ok;;***
    [2012-01-16 17:33:28][S] 0-10 - ajax actions***
    [2012-01-16 17:33:28][S] 0-10 - ajax actions***
    [2012-01-16 17:33:28][S] 5-10 - start sync_user***
    [2012-01-16 17:33:28][S] 15 - insert user - step 1***
    [2012-01-16 17:33:28][S] 16 - do not replace deleted users***
    [2012-01-16 17:33:28][S] 17 - insert user - step 2***
    [2012-01-16 17:33:28][S] 18 - insert user - ok***
    [2012-01-16 17:33:28][S] 0-10 - ajax actions***
    [2012-01-16 17:33:28][S] 5-10 - start sync_user***
    [2012-01-16 17:33:28][S] 15 - insert user - step 1***
    [2012-01-16 17:33:28][S] 16 - do not replace deleted users***
    [2012-01-16 17:33:28][S] 17 - insert user - step 2***
    [2012-01-16 17:33:28][S] 18 - insert user - ok***

    If you need the full website path or any admin login details etc, please let me know as I will provide these privately if necessary.

    Thank you

  • aecnu

    Greetings Companion :slight_smile:

    I am very sorry and sincerely apologize for the delay in someone getting back to you on this - it seems your ticket somehow got buried in the system.

    If you are still having an issue with this please let us know so that we may try to get you fixed up as soon as possible by choosing to mark this ticket as unresolved.

    This will also bring your ticket up front back in plain view again.

    Joe :slight_smile:

  • aecnu

    Greetings Companion,

    Sorry for the delay here. This issue is difficult to track down because it requires multiple regular non MultiSite WordPress installs to perform the testing thereof plus a list of users and passwords to transfer from one to the others. This plugin does not work on MultiSite installs (nor with Buddy Press).

    Therefore it is really a tough setup to test.

    In addition, I have seen that the lead developer has twice been flagged on this issue and has yet to respond.

    I'll once again see if I can get the lead developer in here to assist / give you some advice and try to get this resolved one way or the other.

    Thank you for being a WPMU Dev member!

    Cheers, Joe :slight_smile:

  • Companion

    Hi Andrey,

    At the time I posted this, I could not get the user-sync plugin to work at all. So, because of potential plugin issues, I uploaded 2 seperate non-multisite wordpress installations. I deleted all the plugins and only had the template "twenty eleven", which comes as standard with any new installation. Therefore, the Wordpress installations were not multisite and are the latest version, 3.3.1.

    Currently, the /sub1 and /wordpress are deactived, because I have had to work around this issue to keep my site running until this issue is resolved.

    Therefore, to answer your question, I am fully aware this plugin is for non-multisite and have only been testing on these. The only difference for those particular error logs posted above was that neither of the installations were in the root folder.

    I hope this helps you and that we can reach a resolution soon.

    Many thanks

  • Companion

    Out of curiosity, I have just installed 2 fresh installations of Wordpress 3.3.1 and like before, only had the user-sync plugin active. Again, it is not working. The error log for the master site is as follows:

    [2012-02-16 18:46:27][M] 0-10 - ajax actions***
    [2012-02-16 18:46:27][M] 07 - added new sub site***
    [2012-02-16 18:46:28][M] 0-10 - ajax actions***
    [2012-02-16 18:46:28][M] 08 - count of users= 4;;***
    [2012-02-16 18:46:28][M] 02 - sending request - url=http://www.mysite.com/test1/wp-admin/admin-ajax.php?action=user_sync_api;;***
    [2012-02-16 18:46:28][M] 03 - sending request - response=87ee16fa144c56f4556267f46cd4c86e;;***
    [2012-02-16 18:46:28][M] 05 - checking key true;;***
    [2012-02-16 18:46:28][M] 09 - user sync***
    [2012-02-16 18:46:28][M] 02 - sending request - url=http://www.mysite.com/test1/wp-admin/admin-ajax.php?action=user_sync_api;;***
    [2012-02-16 18:46:28][M] 03 - sending request - response=
    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/test1/wp-includes/wp-db.php</b> on line <b>787</b>

    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/test1/wp-includes/wp-db.php</b> on line <b>787</b>

    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/test1/wp-includes/wp-db.php</b> on line <b>787</b>
    ok;;***
    [2012-02-16 18:46:28][M] 09 - user sync***
    [2012-02-16 18:46:28][M] 02 - sending request - url=http://www.mysite.com/test1/wp-admin/admin-ajax.php?action=user_sync_api;;***
    [2012-02-16 18:46:28][M] 03 - sending request - response=
    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/test1/wp-includes/wp-db.php</b> on line <b>787</b>

    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/test1/wp-includes/wp-db.php</b> on line <b>787</b>

    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/test1/wp-includes/wp-db.php</b> on line <b>787</b>
    ok;;***
    [2012-02-16 18:46:28][M] 09 - user sync***
    [2012-02-16 18:46:28][M] 02 - sending request - url=http://www.mysite.com/test1/wp-admin/admin-ajax.php?action=user_sync_api;;***
    [2012-02-16 18:46:28][M] 03 - sending request - response=
    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/test1/wp-includes/wp-db.php</b> on line <b>787</b>

    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/test1/wp-includes/wp-db.php</b> on line <b>787</b>

    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/test1/wp-includes/wp-db.php</b> on line <b>787</b>
    ok;;***
    [2012-02-16 18:46:28][M] 09 - user sync***
    [2012-02-16 18:46:28][M] 02 - sending request - url=http://www.mysite.com/test1/wp-admin/admin-ajax.php?action=user_sync_api;;***
    [2012-02-16 18:46:29][M] 03 - sending request - response=
    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/test1/wp-includes/wp-db.php</b> on line <b>787</b>

    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/test1/wp-includes/wp-db.php</b> on line <b>787</b>

    <b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, object given in <b>/home/mysite/public_html/test1/wp-includes/wp-db.php</b> on line <b>787</b>
    ok;;***

  • Companion

    and the subsites log is as follows:

    [2012-02-16 18:46:27][S] 01 - new subsite conection - central_url=http://www.mysite.com/test;; replace_user=0;; overwrite_user=0;;***
    [2012-02-16 18:46:27][S] 02 - sending request - url=http://www.mysite.com/test/wp-admin/admin-ajax.php?action=user_sync_api;;***
    [2012-02-16 18:46:27][S] 03 - sending request - response=ok;;***
    [2012-02-16 18:46:27][S] 01_2 - sync users for new subsite***
    [2012-02-16 18:46:27][S] 02 - sending request - url=http://www.mysite.com/test/wp-admin/admin-ajax.php?action=user_sync_api;;***
    [2012-02-16 18:46:28][S] 0-10 - ajax actions***
    [2012-02-16 18:46:28][S] 0-10 - ajax actions***
    [2012-02-16 18:46:28][S] 5-10 - start sync_user***
    [2012-02-16 18:46:28][S] 15 - insert user - step 1***
    [2012-02-16 18:46:28][S] 17 - insert user - step 2***
    [2012-02-16 18:46:28][S] 18 - insert user - ok***
    [2012-02-16 18:46:28][S] 0-10 - ajax actions***
    [2012-02-16 18:46:28][S] 5-10 - start sync_user***
    [2012-02-16 18:46:28][S] 15 - insert user - step 1***
    [2012-02-16 18:46:28][S] 17 - insert user - step 2***
    [2012-02-16 18:46:28][S] 18 - insert user - ok***
    [2012-02-16 18:46:28][S] 0-10 - ajax actions***
    [2012-02-16 18:46:28][S] 5-10 - start sync_user***
    [2012-02-16 18:46:28][S] 15 - insert user - step 1***
    [2012-02-16 18:46:28][S] 17 - insert user - step 2***
    [2012-02-16 18:46:28][S] 18 - insert user - ok***
    [2012-02-16 18:46:29][S] 0-10 - ajax actions***
    [2012-02-16 18:46:29][S] 5-10 - start sync_user***
    [2012-02-16 18:46:29][S] 15 - insert user - step 1***
    [2012-02-16 18:46:29][S] 17 - insert user - step 2***
    [2012-02-16 18:46:29][S] 18 - insert user - ok***
    [2012-02-16 18:46:29][S] 03 - sending request - response=ok;;***

    I hope this can offer some help to resolve this.

    Many thanks again