Okay
  Public Ticket #2453670
Redirect RI stuck on staging site URL
Closed

Comments

  •  1
    Cynthia started the conversation

    I am having the same issue as USTAXCENTRAL https://tmsplugins.ticksy.com/ticket/1847206/

    My Redirect URI should be https://halotax.com.au/wp-admin/admin.php?page=wpamelia-employees but it is set (and unchangable at) https://halota:8890/wp-admin/admin.php?page=wpamelia-employees 

    (halota:8890 is my MAMP staging local drive URL when I initially designed the website - it is VERY old data.)

    I have entered the latter URI as the RedirectURi in Oauth. When in Google Admin Console, you're not allowed to enter anything other than a top line url with a .com or .org in it. 

    I can't see how you corrected USTAXCENTRALS issue so I'd like to give you access to my php myadmin and then write out the solution in a public ticket. 

    Thanks


  •  2,572
    Aleksandar replied

    Hi Cynthia

    I will post what needs to be done here, in a public ticket, so hopefully it'll help others as well.

    To change the URI, you'll need to go into your database, but please be careful when you update the table, because if you delete or add anything else, it can cause the plugin not to work properly.

    When you access your database via PHPMyAdmin (or some other tool), access wp_options table:

    6172199762.png

    It is possible that your prefix is not "wp_", but something else, so if that is the case, please look for "your_prefix_options" table.

    When you access it, you can search through the column "option_name". Search for the term "amelia_settings":

    1791739968.png

    When you find that, you need to edit the property under "option_value" column and find the string "redirectURI". It will look something like this :

    2773446103.png

     So, all you need to do is replace it with your new website's URI:

    2131454090.png

    So basically you need to replace newsite.com with youroldsite.com and it will be shown in Google settings properly. Please note that if you use https you will need to update it also in redirectURI option. Please don't remove the escape characters ( \ ), it needs to stay in \/\/ format

    When you're done with this, please check if the URL from “Redirect URI” field and on "Create OAuth client ID" section are the same:

    7826777834.png

    It's not the first time we've shared this info in a public ticket, but I guess with over 100 tickets ariving every day, it's not that easy to find them.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables