we have a large amount of archives with incorrect submission publication dates. The publication dates are either missing or showing the date of upload onto the web.
The archives were produced partly with XML import in OJS2 and partly with the QuickSubmit plugin in OJS2. Now we have a running OJS18.104.22.168 install.
What I wish is to populate and overwrite the publication dates of the submissions for all published articles with the issue publication dates (the latter are correct for the whole archives). I have access to the database via phpmyadmin but do not know SQL to write a script like that.
Thank you for any suggestions.