Database Upgrade Never Progresses

Hey @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.

Warmly,
Razvan

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

Hey @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 )

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

Hello Razvan,

Here’s the link to the lasted video 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

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 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

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 2 years, 1 month ago by GeraldRezes.
• This reply was modified 2 years, 1 month ago by GeraldRezes.

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

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.

Hey Gerald,

Do you have any caching system/plugin active?

Could you please install this plugin: https://www.ads-software.com/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

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.

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 2 years, 1 month ago by GeraldRezes.

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.

Warmly,
Razvan

I sent the request. TY

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 2 years ago by Razvan Aldea.

Verified it is working now. The database update worked, and I can see the new reporting page. Thank you.