Database Error after update during upgrade database stage

  • Resolved StandOutSites

    (@standoutsites)


    4 years, 1 month ago

    So far, we have never had any problems with upgrading database during Redirection updates, up to version 4.8. However, after the latest update 4.9.1. We getting an error during the database upgrade. I had to rollback to 4.8 version to get back to the functioning plugin.

    
Unexpected token G in JSON at position 0 (SyntaxError)

WordPress returned an unexpected message. This could be a PHP error from another plugin, or data inserted by your theme.

Something went wrong when upgrading Redirection.

Plugin: 4.9
WordPress: 5.5.1 (multi)
PHP: 7.3.23
Browser: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.111 Safari/537.36
JavaScript: https://www.xxxxxxxxxxxx.net/wp-content/plugins/redirection/redirection.js?ver=4.9-2dd41d397208f86537f3e2656caeb502
REST API: https://www.xxxxxxxxxxxx.net/wp-json/
Query: ?page=redirection.php

Error: Unexpected token G in JSON at position 0 (SyntaxError)
Raw: Goodbye
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author John Godley

    (@johnny5)

    As shown above, the message ‘Goodbye’ is appearing on your site. I don’t know what it is or what is causing it.

    Thread Starter StandOutSites

    (@standoutsites)

    Thank you for pointing it out. I now know what it is. The “goodbye” message is the 7G Perishing Press .htaccess firewall. There must be a rule that is blocking this query. but it didn’t block it during the previous updates. something in the query must have changed.

    Plugin Author John Godley

    (@johnny5)

    Interesting, I will look into that. For now you’ll need to disable the firewall, perform the upgrade, and then restore it.

    Thread Starter StandOutSites

    (@standoutsites)

    Here’s the exact logged call that was blocked

    POST - HTTP/1.0 - /wp-json/redirection/v1/plugin/database/ - _wpnonce=3a1ed5f4e6 - - https://stage.xxxxxxxxxxx.net/wp-admin/tools.php?page=redirection.php
    Plugin Author John Godley

    (@johnny5)

    I wasn’t able to reproduce the problem with the 7G .htaccess rules, and cannot find the text ‘goodbye’ in that file. Is there anything additional that you are using?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Database Error after update during upgrade database stage’ is closed to new replies.