• Resolved karne99

    (@karne99)


    Hi,

    I just upgraded Give to the latest version and when I went to update the DB it seems to go into a loop:

    I stopped it at update 22 of 2.

    I am using a windows PC and Firefox as the browser.

    Any assistance would be much appreciated.

    System Info below
    WordPress Environment
    Home URL: http://www.macquarieadhd.org.au
    Site URL: http://www.macquarieadhd.org.au
    WP Version: 4.9.1
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron:
    Language: en_GB
    Permalink Structure: /%year%/%monthnum%/%day%/%postname%/
    Show on Front: page
    Page on Front: (#2)
    Page for Posts: Unset
    Table Prefix Length: 3
    Table Prefix Status: Acceptable
    Admin AJAX: Inaccessible
    Registered Post Statuses: publish, future, draft, pending, private, trash, auto-draft, inherit, refunded, failed, revoked, cancelled, abandoned, processing, preapproval, spam
    Server Environment
    Hosting Provider: DBH: localhost, SRV: http://www.macquarieadhd.org.au
    TLS Connection: Connection uses TLS 1.2
    TLS Rating: Bad
    Server Info: Apache/2.2.31 (Unix) mod_ssl/2.2.31 OpenSSL/1.0.1e-fips mod_bwlimited/1.4
    PHP Version: 7.0.26
    PHP Post Max Size: 8 MB
    PHP Time Limit: 600
    PHP Max Input Vars: 1000
    PHP Max Upload Size: 2 MB
    cURL Version: 7.54.0, OpenSSL/1.0.2k
    SUHOSIN Installed: –
    MySQL Version: 5.5.58 – We recommend a minimum MySQL version of 5.6. See: WordPress Requirements
    Default Timezone is UTC:
    fsockopen/cURL:
    SoapClient:
    DOMDocument:
    gzip:
    GD Graphics Library:
    Multibyte String: Your server does not support the mbstring functions – this is required for better character encoding. Some fallbacks will be used instead for it.
    Remote Post:
    Remote Get:
    Give Configuration
    Give Version: 1.8.19
    Database Updates: 2 of 11 updates still need to run.
    Upgraded From: –
    Test Mode: Disabled
    Currency Code: AUD
    Currency Position: Before
    Decimal Separator: .
    Thousands Separator: ,
    Success Page: http://www.macquarieadhd.org.au/donation-confirmation/
    Failure Page: http://www.macquarieadhd.org.au/donation-failed/
    Donation History Page: http://www.macquarieadhd.org.au/donation-history/
    Give Forms Slug: /donations/
    Enabled Payment Gateways: PayPal Standard
    Default Payment Gateway: PayPal Standard
    PayPal IPN Verification: Enabled
    PayPal IPN Notifications: N/A
    Admin Email Notifications: Enabled
    Donor Email Access: Disabled
    Session Configuration
    Give Use Sessions: Enabled
    Session: Disabled
    Active Give Add-ons
    Other Active Plugins
    Akismet Anti-Spam by Automattic – 4.0.2
    Easy Forms for MailChimp by YIKES, Inc. – 6.3.29
    Google XML Sitemaps by Arne Brachhold – 4.0.9
    Jetpack by WordPress.com by Automattic – 5.7
    Menu Icons by ThemeIsle – 0.11.0
    W3 Total Cache by Frederick Townes – 0.9.6
    Wordfence Security by Wordfence – 6.3.22
    WPForms Lite by WPForms – 1.4.3
    WP Smush by WPMU DEV – 2.7.6
    Inactive Plugins
    Theme
    Name: Graphy Child
    Version: 1.0.0
    Author URL: http://www.orangelimewebdesign.com.au
    Child Theme: Yes
    Parent Theme Name: Graphy
    Parent Theme Version: 2.1.2
    Parent Theme Author URL: http://themegraphy.com/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Matt Cromwell

    (@webdevmattcrom)

    Thanks for including your System Info. Based on that, it indicates that admin-ajax.php is not accessible. Our upgrade routine depends on that to update seamlessly without requiring a page refresh.

    Admin-ajax.php can be blocked for a lot of different reasons, but I would suggest it is most likely Wordfence causing the issue. Luckily they have a workaround built into their plugin. There’s a setting called “Learning Mode” in their Firewall settings. Enable that, then go to your Give Updates and run them again. Ideally they will run smoothly, then you can set your Firewall back to how it was before and you won’t have that issue again. If it still is problematic while in Learning Mode, then you’ll need to disable Wordfence completely to run the update.

    Here’s docs on Wordfence learning mode:
    https://docs.wordfence.com/en/Web_Application_Firewall_-_How_to_use_Learning_Mode

    Let me know how that goes.

    Thread Starter karne99

    (@karne99)

    Many thanks Matt, that worked like a charm!

    Plugin Contributor Matt Cromwell

    (@webdevmattcrom)

    Glad to hear it, happy to help.

    If you’re enjoying Give and appreciate our support, we’d love a kind review from you here:
    https://ww.wp.xz.cn/support/plugin/give/reviews/

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘DB Update looping’ is closed to new replies.