After upgrading from Chrome V84 to V91 in the afternoon, the above prompt pops up. Click OK to enter, and find that the history and download records are gone

Download records does not matter, the history is still very important, sometimes need to turn over the website opened before, and before with some custom domain name Settings fast search, if there is no history, but also to reset trouble.

Find the ~ / Library/Application Support/Google/Chrome/XXX under the project folder, also in the History file, and there are dozens of times, that data also in inside, tried the create a new project, copy these files directly in the past, there will be error, and only a historical record and download to fail, expand the bookmark these are normal Throughout the year. I wondered if Chrome could generate a new History and import data from the previous History.

I checked on the Internet and found that History is actually an SQLite3 database. I downloaded a SQLiteStudio and it was able to open it after trying it.

Begin to study how to import data into a new file. In the process of comparison test, it is found that the source of the problem is that there is a publicly_routable field in the visits table of the new version of Chrome. As long as you fill up this field history and download record, you can come back. You don’t have to mess around with import and export scripts.

Add a new field in the order shown below. I’m using SQLiteStudio, but the details may differ if you use other software

I’ve been searching the Chromium repository for information on publicly_routable, which first appeared in May last year, on v84 After the version of the added, did not look at the code, not sure whether Chrome has added a new column of code during the upgrade, or because I upgraded the version is too big, or I upgraded the way is wrong,Chrome’s own upgrade I gave off, directly go to the official website to download the latest version of the overlay. But since it has already been used, I am too lazy to reproduce the research.

Here to make a record, hope to help the friends who encountered the same problem.