• Resolved Mihail D

    (@memberremember)


    was done next steps:

    1. Redirection database needs upgrading
    – ok, click Upgrade (Automatic mode)
    After some minutes:
    > Something went wrong. An unknown error occurred.

    > Error: undefined

    2. Refresh page and try Manual mode
    – connect to db and execurte suggested SQLs

    ALTER TABLE "***_redirection_logs" ADD "domain" VARCHAR(255) NULL DEFAULT NULL AFTER "url";
    ALTER TABLE "***_redirection_logs" ADD "http_code" INT(11) unsigned NOT NULL DEFAULT 0 AFTER "referrer";
    ALTER TABLE "***_redirection_logs" ADD "request_method" VARCHAR(10) NULL DEFAULT NULL AFTER "http_code";
    ALTER TABLE "***_redirection_logs" ADD "redirect_by" VARCHAR(50) NULL DEFAULT NULL AFTER "request_method";
    ALTER TABLE "***_redirection_logs" ADD "request_data" MEDIUMTEXT NULL DEFAULT NULL AFTER "request_method";
    ALTER TABLE "***_redirection_logs" CHANGE COLUMN "agent" "agent" MEDIUMTEXT NULL;
    ALTER TABLE "***_redirection_logs" DROP "module_id";
    ALTER TABLE "***_redirection_logs" DROP "group_id";
    ALTER TABLE "***_redirection_404" ADD "domain" VARCHAR(255) NULL DEFAULT NULL AFTER "url";
    ALTER TABLE "***_redirection_404" ADD "http_code" INT(11) unsigned NOT NULL DEFAULT 0 AFTER "referrer";
    ALTER TABLE "***_redirection_404" ADD "request_method" VARCHAR(10) NULL DEFAULT NULL AFTER "http_code";
    ALTER TABLE "***_redirection_404" ADD "request_data" MEDIUMTEXT NULL DEFAULT NULL AFTER "request_method";
    ALTER TABLE "***_redirection_404" DROP INDEX "url";
    ALTER TABLE "***_redirection_404" CHANGE COLUMN "url" "url" MEDIUMTEXT NOT NULL;

    3. Click on suggested button – “Complete again”
    As result:

    Error: Unexpected token < in JSON at position 0 (SyntaxError)
    Raw: <html>
    <head><title>504 Gateway Time-out</title></head>

    4. Refresh page and try Manual mode again
    Empty suggestions , click ‘Complete’ (again)

    endless requests (in web console)

    /blog/wp-admin/admin-ajax.php?action=rest-nonce
    return e24ac00020

    /blog?rest_route=/redirection/v1/plugin/&_wpnonce=e24ac00020 —
    return
    {“code”:”rest_cookie_invalid_nonce”,”message”:”Cookie nonce is invalid”,”data”:{“status”:403}}

    As result – admin page “Redirection database needs upgrading”

    ps: mysql Ver 14.14 Distrib 5.7.31-34, for debian-linux-gnu (x86_64) using 7.0
    PHP 7.3.19-1~deb10u1 (cli) (built: Jul 15 2020) ( NTS )

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Cookie nonce is invalid’ is closed to new replies.