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

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

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

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

Hey Gerald,

Do you have any caching system/plugin active?

Could you please install this plugin: 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

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

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, 5 months ago by Razvan Aldea.