Upgrading the Database doesn’t work. v4.6.1

Hello @grezes ,

It doesn’t really matter the number of download items but the number of logs you have. But it shouldn’t take too long. Did you had any errors in the console of the developer tools? You can go to dashboard > Downloads > Settings > Advanced > Miscellaneous and hit the “Recreate update environment” button to redo the upgrade.

Warmly,
Razvan

Thanks for the suggestions. I tried Recreating the update environment and they didn’t help. We haven’t been using Downloads for long so the logs should be small. I am not sure how to look into any error messages. You mentioned the console of the developer tools. I do not know what that is if it is part of Downloads or another plugin. Thanks.

I captured this message from the WordPress debug log:
“[29-Sep-2022 16:55:57 UTC] PHP Notice: Function wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder. Please see Debugging in WordPress for more information. (This message was added in version 3.9.0.) in /[localpath]/wp-includes/functions.php on line 5831″

My host is running PHP Version 7.4.10, MySQL 5.6.32, WordPress 6.0.2.

Hello @grezes ,

Is that all that the log said? No indication on where the error appeared?

Warmly,
Razvan

That is all that the WordPress debug.log shows when I enable debugging. That error appears every time I attempt to upgrade the database using the Downloads Update button or link. I’ve tried running it from an incognito tab but I still receive the same result. Is there another log I should be looking at?

Hey @grezes ,

Could you look into the database and see if there is a table called reports_log? Also, could you please look into the database and see if the table download_log has columns UUID, download_location and download_category?

Also, could you please specify server type, mysql type and php version?

Warmly,
Razvan

I do not have a table named “reports_log”. The “download_log” table does not have the columns you mentioned. It has IS, user_id, user_ip, user_agent, download_id, version_id, version, download_date, download_status, download_status_message, and meta_data.

My host is running PHP Version 7.4.10, Percona MySQL 5.6.32, WordPress 6.0.2.

Thank you

• This reply was modified 2 years, 1 month ago by grezes.

Hey @grezes ,

We found the issue regarding the database upgrade fail. We’ll release version 4.6.4 in a day or two that will contain a fix for your problem. Real sorry for the problems you are experiencing.

Warmly,
Razvan

Thank you. I will look out for the release.

Hello. I updated the plugin to version 4.6.5 and I am still having the issue upgrading the database. The debug.log file still displays “PHP Notice: Function wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder.” I looked at the database and no additional fields have been added to the downloads_log table. I do not think it even started the update process to touch the downloads_log table.