Comment #28 on issue 14734 by [email protected]: Cookies never deleted
due to Win/POSIX epoch difference
http://code.google.com/p/chromium/issues/detail?id=14734
Dean is correct, you don't need the multiplication in the SQL I gave above.
So it
should be:
UPDATE mytable SET mytime = mytime + 11644473600000000 WHERE id IN (SELECT
id FROM mytable WHERE mytime > 0);
I think we must update the following information, and I don't think a patch
should
be accepted that does not update:
segment_usage.time_slot
urls.last_visit_tile
visits.visit_time
Not not updating will break the autocomplete suggestions and most visited
page for
all Mac & Linux users, and this data will have to be re-learned. I think
this is
unacceptable.
Migration code should also call TextDatabaseManager.DeleteAll and set all
visits.is_indexed to 0, since the date change will make the indexer
confused. This
isn't really worth migrating, but we should avoid the bad data by deleting
it (the
function is already there to do so so it should be trivial). To update the
is_indexed just execute:
UPDATE visits SET is_indexed = 0;
--
You received this message because you are listed in the owner
or CC fields of this issue, or because you starred this issue.
You may adjust your issue notification preferences at:
http://code.google.com/hosting/settings
--~--~---------~--~----~------------~-------~--~----~
Automated mail from issue updates at http://crbug.com/
Subscription options: http://groups.google.com/group/chromium-bugs
-~----------~----~----~----~------~----~------~--~---
