Title: Database Upgrade Never Progresses Last modified: October 14, 2022 --- # Database Upgrade Never Progresses * Resolved [GeraldRezes](https://wordpress.org/support/users/geraldrezes/) * (@geraldrezes) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-upgrade-never-progresses/) * I am re-reporting this problem that was “fixed” in a 4.6.4 because it was not fixed for me ([https://wordpress.org/support/topic/upgrading-the-database-doesnt-work-v4-6-1/](https://wordpress.org/support/topic/upgrading-the-database-doesnt-work-v4-6-1/)). I have now installed version 4.7.0 and still I cannot update the database. The outward sign is that the progress bar never progresses from 0%. The WordPress debug log continues to report, “PHP Notice: Function wpdb::prepare was called** incorrectly**. The query argument of wpdb::prepare() must have a placeholder.” I try upgrading the database with every version update, I follow the procedure to recreate the upgrade environment. * Is anyone else having this issue? Maybe it is just me. I do not need the reporting feature as long as the Downloads app continues to work as expected. * My host is iPage.com running PHP Version 7.4.10, Percona MySQL 5.6.32, WordPress 6.0.2. - This topic was modified 3 years, 7 months ago by [GeraldRezes](https://wordpress.org/support/users/geraldrezes/). Viewing 14 replies - 1 through 14 (of 14 total) * [Razvan Aldea](https://wordpress.org/support/users/raldea89/) * (@raldea89) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-upgrade-never-progresses/#post-16109613) * Hey [@geraldrezes](https://wordpress.org/support/users/geraldrezes/) , * Sorry for the late reply. Is it possible to send us a video with how you are recreating and doing the upgrade? Can’t tell for sure what is going on there. Also, it would be great if you could include the console from the developer tools( hitting the F12 key on your keyboard and going to Console ) in the video so we can have a look? * If you are not comfortable with showing the video here you can use our contact form [here](https://www.download-monitor.com/contact/). * Warmly, Razvan * Thread Starter [GeraldRezes](https://wordpress.org/support/users/geraldrezes/) * (@geraldrezes) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-upgrade-never-progresses/#post-16116107) * In the video, I walk you through my typical steps. 1) enable logging, 2) reset the upgrade environment, 3) upgrade, and 4) display the debug.log file. * [https://drive.google.com/file/d/1-1qlzmSeDjetUsHdUfe9grHrGmglYYOo/view?usp=sharing](https://drive.google.com/file/d/1-1qlzmSeDjetUsHdUfe9grHrGmglYYOo/view?usp=sharing) * [Razvan Aldea](https://wordpress.org/support/users/raldea89/) * (@raldea89) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-upgrade-never-progresses/#post-16116972) * Hey [@geraldrezes](https://wordpress.org/support/users/geraldrezes/) , * Thanks for the video, it’s really helpful. Seems like the first AJAX request doesn’t finish, the counter goes on and on and on. Could you do another video, this time with the Network tab of the Browser’s developer tools? The steps are as follows: 1. Recreate again the upgrade environment 2. In the Network tab clear all shown data ( the void icon ) 3. Click Upgrade database button 4. Click on the first entry that now appears in the Network tab and go to Response ( example here : [https://imgur.com/a/nUp2edp](https://imgur.com/a/nUp2edp) ) * This will show us if there is any error in the first request. The notice from the debug log doesn’t affect the upgrade. * Warmly, Razvan * Thread Starter [GeraldRezes](https://wordpress.org/support/users/geraldrezes/) * (@geraldrezes) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-upgrade-never-progresses/#post-16119461) * Hello Razvan, * Here’s the link to the lasted video [https://drive.google.com/file/d/1-3u9BQJIWrmAOcQNtFk4WxUBF9v-YAAW/view?usp=sharing](https://drive.google.com/file/d/1-3u9BQJIWrmAOcQNtFk4WxUBF9v-YAAW/view?usp=sharing). It doesn’t seem to show me much. The response is the number of entries and an offset. * TY * [Razvan Aldea](https://wordpress.org/support/users/raldea89/) * (@raldea89) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-upgrade-never-progresses/#post-16127416) * Hey Gerald, * If you are comfortable, could you please modify this line [https://github.com/WPChill/download-monitor/blob/4.7.1/src/Admin/class-dlm-db-upgrader.php#L313](https://github.com/WPChill/download-monitor/blob/4.7.1/src/Admin/class-dlm-db-upgrader.php#L313) from `$add_index = "ALTER TABLE {$wpdb->download_log} ADD INDEX download_count( version_id);";` to `$add_index = "ALTER TABLE {$wpdb->download_log} ADD INDEX download_counts (version_id);";` ? There is an extra `s` added to the INDEX ` download_count`. After you modify it please recreate the upgrade environment and try the upgrade again and let us know the outcome of this. * Warmly, Razvan * Thread Starter [GeraldRezes](https://wordpress.org/support/users/geraldrezes/) * (@geraldrezes) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-upgrade-never-progresses/#post-16129426) * Hello Razvan, * I made the change and it is still not updating. It seems to be having the same issue. The retries on database-upgrader.min.js?ver=4.4.7:1 and the admin-ajax. php still has {“entries”:”34″,”offset”:0}. Just tried it on Version 4.7.2 too. - This reply was modified 3 years, 7 months ago by [GeraldRezes](https://wordpress.org/support/users/geraldrezes/). - This reply was modified 3 years, 7 months ago by [GeraldRezes](https://wordpress.org/support/users/geraldrezes/). * [Razvan Aldea](https://wordpress.org/support/users/raldea89/) * (@raldea89) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-upgrade-never-progresses/#post-16135748) * Could you tell me what is the response of the next AJAX request, so the second request. The first one responds OK, the second one from what I’ve seen in the video did not return anything in the time you filmed, although it should have. Could you please go to your database and tell me if the following tables exists: – dlm_downloads – dlm_reports_log – download_log * Warmly, Razvan * Thread Starter [GeraldRezes](https://wordpress.org/support/users/geraldrezes/) * (@geraldrezes) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-upgrade-never-progresses/#post-16137207) * The response to the second admin-ajax.php request is “This request has no response data available.” Seems as though it never responses. All three tables exist and have data. * [Razvan Aldea](https://wordpress.org/support/users/raldea89/) * (@raldea89) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-upgrade-never-progresses/#post-16138227) * Hey Gerald, * Do you have any caching system/plugin active? * Could you please install this plugin: [https://wordpress.org/plugins/health-check/](https://wordpress.org/plugins/health-check/) * After you install and activate the above plugin it has a Troubleshooting mode which allows you to have a vanilla WordPress session, where all plugins are disabled, and a default theme is used, but only for your user – your visitors will still see the normal website. * Go to its troubleshoot mode and only activate Download Monitor and see if it works correctly with a default WordPress theme (Twenty Twenty-One for example) and no other plugins. * Please let me know how it goes and what you find! * Warmly, Razvan * Thread Starter [GeraldRezes](https://wordpress.org/support/users/geraldrezes/) * (@geraldrezes) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-upgrade-never-progresses/#post-16140496) * Unfortunately, that didn’t work, and I had high hopes. Here’s a screenshot of the Troubleshooter and the non-response [https://drive.google.com/file/d/1-7s50qBXCZ5sdBiupgWKJZe6WQ-vEFgB/view?usp=sharing](https://drive.google.com/file/d/1-7s50qBXCZ5sdBiupgWKJZe6WQ-vEFgB/view?usp=sharing). * I have WP Fastest Cache installed but I disable most of the caching. I tried disabling WP Fastest Cache, that didn’t work. I tried enabling WP Fastest Cache, clearing all cache then disabling it again; that didn’t change the outcome. * Thanks, Gerald - This reply was modified 3 years, 7 months ago by [GeraldRezes](https://wordpress.org/support/users/geraldrezes/). * [Razvan Aldea](https://wordpress.org/support/users/raldea89/) * (@raldea89) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-upgrade-never-progresses/#post-16142010) * Hello Gerald, * Thank you for the info. * I’ll need to ask you some questions about the database and need to give you some queries to run on the database to see if there are any problems retrieving the data. If you’re comfortable discussing it here ( they are kinda sensitive ) please let me know, else please use our contact form [here](https://www.download-monitor.com/contact/). * Warmly, Razvan * Thread Starter [GeraldRezes](https://wordpress.org/support/users/geraldrezes/) * (@geraldrezes) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-upgrade-never-progresses/#post-16143575) * I sent the request. TY * [Razvan Aldea](https://wordpress.org/support/users/raldea89/) * (@raldea89) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-upgrade-never-progresses/#post-16173494) * Going to mark this as resolved. The problem was a JSON response that apparently was not sent OK. The fix will also be present in version 4.7.4 in case someone else has this issue. * Warmly, Razvan - This reply was modified 3 years, 7 months ago by [Razvan Aldea](https://wordpress.org/support/users/raldea89/). * [grezes](https://wordpress.org/support/users/grezes/) * (@grezes) * [3 years, 7 months ago](https://wordpress.org/support/topic/database-upgrade-never-progresses/#post-16174134) * Verified it is working now. The database update worked, and I can see the new reporting page. Thank you. Viewing 14 replies - 1 through 14 (of 14 total) The topic ‘Database Upgrade Never Progresses’ is closed to new replies. * ![](https://ps.w.org/download-monitor/assets/icon-256x256.png?rev=3198936) * [Download Monitor](https://wordpress.org/plugins/download-monitor/) * [Frequently Asked Questions](https://wordpress.org/plugins/download-monitor/#faq) * [Support Threads](https://wordpress.org/support/plugin/download-monitor/) * [Active Topics](https://wordpress.org/support/plugin/download-monitor/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/download-monitor/unresolved/) * [Reviews](https://wordpress.org/support/plugin/download-monitor/reviews/) ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [upgrade](https://wordpress.org/support/topic-tag/upgrade/) * 14 replies * 3 participants * Last reply from: [grezes](https://wordpress.org/support/users/grezes/) * Last activity: [3 years, 7 months ago](https://wordpress.org/support/topic/database-upgrade-never-progresses/#post-16174134) * Status: resolved