Support » Plugin: WP Statistics » Database Update – Error occurred during operation. Please refresh the page.

  • Hello, I recently updated WP and the WP Statistics and now I see a message “WP-Statistics database requires upgrade.”

    When I try to update it stops at around 3-5% on multiple occasions and I get the error “Error occurred during operation. Please refresh the page.”

    I am using PHP v. 7.3.3. and MySQL 5.1.73

    Can you please offer any advice?

    Thank you!

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Contributor Mehrshad Darzi

    (@mehrshaddarzi)

    @rimbaudhotel

    Hi,
    How long have you installed the WP-Statistics plugin?

    I installed the plugin about 3 years ago. Another thing to note is that the plugin is also severely slowing down my WP Admin as of late.

    Plugin Contributor Mehrshad Darzi

    (@mehrshaddarzi)

    @rimbaudhotel

    it seems your WP-Statistics is very large.
    If you have an error, continue the update process until it finishes. Also, ignore the error and refresh the browser page.

    about Slowing WP Admin : We are Optimizing Wp-statistics Overview Page in new version that release soon.

    Thanks, but if I get the error and then refresh the page and try again, it just restarts and the same issue happens.

    Also the plugin in slowing down the site so much sometimes I cannot even log into the WP Admin unless I rename the plugin folder in the File Manager to disable the plugin.

    Is there anyone who would be able to take a look?

    • This reply was modified 1 year, 6 months ago by rimbaudhotel.
    Plugin Author Mostafa Soufi

    (@mostafas1990)

    I’ve increased the maximum execution time and the memory limit. Our database is large. I understand that. I tried to figure out the update query for the DB, but it was a little complicated to derive from what is generated by the page.

    Would you share the query so that it can be manually run? If needed, I could even pull the DB to a powerful machine, locally, to run the query, then push the data (and tables) back the WP server.

    I can’t dump the data. It is used for longitudinal comparison.

    Really, I just need a manual update query or script.

    Thank you.

    Plugin Author Mostafa Soufi

    (@mostafas1990)

    Thank you. I pulled the queries, which show the necessity for a script since there are conditions for modifications of tables and entries (see example below).

    Oddly, the end of the log file for the queries showed “Quit”, even though the update operation hadn’t completed. Why might this happen? There is nothing in the error.log.
    2019-09-23T11:58:54.009016Z 24 Quit
    2019-09-23T11:58:54.009391Z 23 Quit

    The updates are quite involved; e.g.
    UPDATE wp_options SET option_value = ‘1569225508’ WHERE option_name = ‘wp_statistics_check_useronline’
    UPDATE wp_options SET option_value = ‘a:31:{i:1569239857;a:1:{s:54:\”cs_exchange_rate_wp_give_db_updater_cron_interval_task\”;a:1:{s:32:\”583138a015e9e66eba5d541d392b69a0\”;a:3:{s:8:\”schedule\”;s:32:\”wp_give_db_updater_cron_interval\”;s:4:\”args\”;a:1:{i:0;s:32:\”wp_give_db_updater_cron_interval\”;}s:8:\”interval\”;i:300;}}}i:1569239868;a:1:{s:11:\”wp_cache_gc\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:2:{s:8:\”schedule\”;b:0;s:4:\”args\”;a:0:{}}}}i:1569239986;a:1:{s:20:\”jetpack_clean_nonces\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:6:\”hourly\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:3600;}}}i:1569240145;a:1:{s:19:\”wp_cache_gc_watcher\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:6:\”hourly\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:3600;}}}i:1569240157;a:1:{s:54:\”cs_exchange_rate_wp_give_db_updater_cron_interval_task\”;a:1:{s:32:\”583138a015e9e66eba5d541d392b69a0\”;a:3:{s:8:\”schedule\”;s:32:\”wp_give_db_updater_cron_interval\”;s:4:\”args\”;a:1:{i:0;s:32:\”wp_give_db_updater_cron_interval\”;}s:8:\”interval\”;i:300;}}}i:1569241861;a:1:{s:34:\”wp_privacy_delete_old_export_files\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:6:\”hourly\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:3600;}}}i:1569242589;a:1:{s:28:\”wp_statistics_add_visit_hook\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:5:\”daily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:86400;}}}i:1569248463;a:1:{s:21:\”wpo_plugin_cron_tasks\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:10:\”twicedaily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:43200;}}}i:1569251308;a:1:{s:20:\”jetpack_v2_heartbeat\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:5:\”daily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:86400;}}}i:1569260543;a:1:{s:25:\”delete_expired_transients\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:5:\”daily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:86400;}}}i:1569265339;a:1:{s:34:\”puc_cron_check_updates-updraftplus\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:5:\”daily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:86400;}}}i:1569272060;a:1:{s:24:\”wp_statistics_geoip_hook\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:5:\”daily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:86400;}}}i:1569275366;a:3:{s:16:\”wp_version_check\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:10:\”twicedaily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:43200;}}s:17:\”wp_update_plugins\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:10:\”twicedaily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:43200;}}s:16:\”wp_update_themes\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:10:\”twicedaily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:43200;}}}i:1569275373;a:1:{s:19:\”wp_scheduled_delete\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:5:\”daily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:86400;}}}i:1569278443;a:1:{s:32:\”recovery_mode_clean_expired_keys\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:5:\”daily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:86400;}}}i:1569278900;a:1:{s:22:\”mwp_update_public_keys\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:5:\”daily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:86400;}}}i:1569283830;a:1:{s:26:\”wp_cache_full_preload_hook\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:2:{s:8:\”schedule\”;b:0;s:4:\”args\”;a:0:{}}}}i:1569286206;a:1:{s:30:\”wp_scheduled_auto_draft_delete\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:5:\”daily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:86400;}}}i:1569315961;a:1:{s:27:\”give_daily_scheduled_events\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:5:\”daily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:86400;}}}i:1569318457;a:1:{s:31:\”cs_exchange_rate_wpo_daily_task\”;a:1:{s:32:\”70da31e343f6f76fda988df88f3d24c4\”;a:3:{s:8:\”schedule\”;s:9:\”wpo_daily\”;s:4:\”args\”;a:1:{i:0;s:9:\”wpo_daily\”;}s:8:\”interval\”;i:86400;}}}i:1569323200;a:1:{s:19:\”wpseo-reindex-links\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:5:\”daily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:86400;}}}i:1569351750;a:1:{s:27:\”wp_statistics_browscap_hook\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:6:\”weekly\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:604800;}}}i:1569448629;a:1:{s:18:\”wpseo_onpage_fetch\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:6:\”weekly\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:604800;}}}i:1569575161;a:1:{s:28:\”give_weekly_scheduled_events\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:6:\”weekly\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:604800;}}}i:1569577657;a:1:{s:32:\”cs_exchange_rate_wpo_weekly_task\”;a:1:{s:32:\”e24703affc92461641c643d7a274b78d\”;a:3:{s:8:\”schedule\”;s:10:\”wpo_weekly\”;s:4:\”args\”;a:1:{i:0;s:10:\”wpo_weekly\”;}s:8:\”interval\”;i:604800;}}}i:1569736800;a:1:{s:23:\”updraft_backup_database\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:6:\”weekly\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:604800;}}}i:1569823200;a:1:{s:14:\”updraft_backup\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:7:\”monthly\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:2592000;}}}i:1570182457;a:2:{s:37:\”cs_exchange_rate_wpo_fortnightly_task\”;a:1:{s:32:\”c8099c370b3cf2339040b331551999d2\”;a:3:{s:8:\”schedule\”;s:15:\”wpo_fortnightly\”;s:4:\”args\”;a:1:{i:0;s:15:\”wpo_fortnightly\”;}s:8:\”interval\”;i:1209600;}}s:33:\”cs_exchange_rate_fortnightly_task\”;a:1:{s:32:\”f99efef762402c63e2b9383d505fb262\”;a:3:{s:8:\”schedule\”;s:11:\”fortnightly\”;s:4:\”args\”;a:1:{i:0;s:11:\”fortnightly\”;}s:8:\”interval\”;i:1209600;}}}i:1571219257;a:2:{s:33:\”cs_exchange_rate_wpo_monthly_task\”;a:1:{s:32:\”54ae9fe17daca8271ea390477a1549fa\”;a:3:{s:8:\”schedule\”;s:11:\”wpo_monthly\”;s:4:\”args\”;a:1:{i:0;s:11:\”wpo_monthly\”;}s:8:\”interval\”;i:2592000;}}s:29:\”cs_exchange_rate_monthly_task\”;a:1:{s:32:\”21daff591fc782d9882e919049132e18\”;a:3:{s:8:\”schedule\”;s:7:\”monthly\”;s:4:\”args\”;a:1:{i:0;s:7:\”monthly\”;}s:8:\”interval\”;i:2592000;}}}i:1571684730;a:1:{s:29:\”give_monthly_scheduled_events\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:7:\”monthly\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:2592000;}}}s:7:\”version\”;i:2;}’ WHERE option_name = ‘cron’

    Was there any solution for this problem.
    I’m having exactly the same problems and the update process takes longer then a day and then it crashes and comes with the refresh page notification. Starting all over again keeps giving the same issue.

    Also the stats seemed to have droppen drastically since I started the update.

    The only solution I found was to keep re-running it after it crashed until all of the updates were finally done. It took almost 3 days total time running.

    *You don’t want to do this during peak hours on your site! It will negatively impact performance.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Database Update – Error occurred during operation. Please refresh the page.’ is closed to new replies.