95% of library's Published date randomly changed

Thinkling · 02-06-2026, 09:00 PM

I am a stickler for saving the Published field date of my files in Calibre (MacOS 26).

Today I noticed something very alarming. About 95% of the files had this field changed to January 29, 2026. This make zero sense, as the vast majority of files predate that...often by years. I have upwards of 13000 files (mostly news/magazine articles).

Any advice as to what happened here, how it can be fixed, and how to avoid in the future. I am aware of the "Edit metadata in bulk" command and can assure you this was not carelessly used.

Thanks in advance.

BetterRed · 02-07-2026, 06:13 AM

Which version of calibre?
If version 9 when did you install it - date & time if possible?
What formats do you have for the 5% where pubdate did not change?

BR

theducks · 02-07-2026, 12:25 PM

FILES?
Published is a column in Calibre. The File (creation and modified) dates change with data updates.
Did you ADD/delete a custom column? That affect metadata.opf in all book folders (it updates in background) so you have a Library Recovery ability if the main db gets hosed.

Thinkling · 02-08-2026, 04:45 PM

Quote:

Originally Posted by BetterRed

Which version of calibre?
If version 9 when did you install it - date & time if possible?
What formats do you have for the 5% where pubdate did not change?

BR

Thanks for replying. I installed v9.2.1 earlier that day the 6th.

Vast majority that did not change were PDF and EPUB, small numbers of MOBI, AZW, AZW3, and DJVU. Although it seems to me roughly the distribution of the formats anyway.

Thinkling · 02-08-2026, 04:49 PM

Quote:

Originally Posted by theducks

FILES?
Published is a column in Calibre. The File (creation and modified) dates change with data updates.
Did you ADD/delete a custom column? That affect metadata.opf in all book folders (it updates in background) so you have a Library Recovery ability if the main db gets hosed.

The last custom column activity I performed was adding a column last ~May. This by itself suggests this is not pertinent, but I'm happy to re-entertain the possibility.

I will probably dig into the Library Recovery option. Thanks for replying.

theducks · 02-08-2026, 04:58 PM

Just to be clear:
We are talking about the {Published} date column/field?
The only thing I can think is you accidentally did a Bulk Mode metadata update that included more that you intended

. (Been there)

Always check the status lines # selected , before executing the bulk update.

BetterRed · 02-08-2026, 05:29 PM

Quote:

Originally Posted by Thinkling

Thanks for replying. I installed v9.2.1 earlier that day the 6th.

Vast majority that did not change were PDF and EPUB, small numbers of MOBI, AZW, AZW3, and DJVU. Although it seems to me roughly the distribution of the formats anyway.

Did you install 9.0.0, and when would you have installed it, it was released on "30 Jan, 2026". I think that may be Mumbai time, Pennsylvania lags Mumbai by 10½ hours, so if you were quick off the mark, maybe . . .

FTR - I value Publication Date for the same reason as you… it matters a lot for news/magazine/journal items. I have also installed version 9.x.x (beta and release) and my Publication Dates have not changed.

Which makes me wonder if an optional plugin or third party program is at play… something triggered by a database schema change… version 9.0.0 and subsequent releases do change the database schema for existing libraries.

BR

Comfy.n · 02-10-2026, 10:55 AM

Mine haven't changed either, but I noticed a time-related oddity about the .msi installer, beginning from 9.2 release. Didn't affect 8.99.12 nor 9.0 nor 9.1, in my perception.

I often get and install new versions very close to release time, but this time I noticed calibre creating files in its installation dir with timestamps that were ahead of the then-current local time.

Thinkling · 02-12-2026, 07:49 PM

Quote:

Originally Posted by BetterRed

Did you install 9.0.0, and when would you have installed it, it was released on "30 Jan, 2026". I think that may be Mumbai time, Pennsylvania lags Mumbai by 10½ hours, so if you were quick off the mark, maybe . . .

FTR - I value Publication Date for the same reason as you… it matters a lot for news/magazine/journal items. I have also installed version 9.x.x (beta and release) and my Publication Dates have not changed.

Which makes me wonder if an optional plugin or third party program is at play… something triggered by a database schema change… version 9.0.0 and subsequent releases do change the database schema for existing libraries.

BR

Hmm I don't think I can verify if/when I installed 9.0.0. I probably install about 2/3 of the new versions when I get the update notifications. To my knowledge I never install beta versions, unless (say) X.0.0 versions are betas.

That said, if you're right, that coincidence about the v9 date does seem intriguing. I have maybe half a dozen plugins installed, but IIRC I have never actually used any. Doesn't mean they can't do harm though, I guess.

I greatly appreciate yours and everyone's engagement with my issues on this thread.

Thinkling · 02-12-2026, 07:51 PM

Quote:

Originally Posted by theducks

Just to be clear:
We are talking about the {Published} date column/field?
The only thing I can think is you accidentally did a Bulk Mode metadata update that included more that you intended

. (Been there)

Always check the status lines # selected , before executing the bulk update.

That is a clear possibility, in the sense that I knew right away it could cause my problem. But to be honest, I am 99.999% sure that didn't happen. Your advice, however, will always be valuable going forward

.

BetterRed · 02-12-2026, 08:42 PM

Fairly easily done though, I just did it with 6 key 'strokes',

Ctrl+A — select all books
E — Edit Metadata in bulk
Alt+U, Alt+U — to get to Published
'=' — to set to Now
Enter — to Commit changes

Even easier if you use a mouse… click into Published when you were aiming for Date, press '=', click OK

There is no "Are you sure" popup.

BR

02-06-2026, 09:00 PM	#1
Thinkling Member Posts: 10 Karma: 10 Join Date: May 2025 Location: Pennsylvania, USA Device: Calibre	95% of library's Published date randomly changed I am a stickler for saving the Published field date of my files in Calibre (MacOS 26). Today I noticed something very alarming. About 95% of the files had this field changed to January 29, 2026. This make zero sense, as the vast majority of files predate that...often by years. I have upwards of 13000 files (mostly news/magazine articles). Any advice as to what happened here, how it can be fixed, and how to avoid in the future. I am aware of the "Edit metadata in bulk" command and can assure you this was not carelessly used. Thanks in advance.

02-10-2026, 10:55 AM	#8
Comfy.n want to learn what I want Posts: 1,908 Karma: 7955879 Join Date: Sep 2020 Device: none	Mine haven't changed either, but I noticed a time-related oddity about the .msi installer, beginning from 9.2 release. Didn't affect 8.99.12 nor 9.0 nor 9.1, in my perception. I often get and install new versions very close to release time, but this time I noticed calibre creating files in its installation dir with timestamps that were ahead of the then-current local time. Last edited by Comfy.n; 02-10-2026 at 02:41 PM.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calibre randomly changes date of metadata.opf files of books I haven't edited	nephtys59	Library Management	7	11-15-2021 07:18 AM
How to replace date with the published date	MegAnne	Calibre	6	02-25-2019 02:47 AM
Date first published	applesauce	General Discussions	19	07-16-2013 08:46 AM
'Published date' and 'originally published date'	Arrghus	Calibre	2	07-29-2011 01:43 AM
Bulk Changing Published Date To Date	hmf	Calibre	4	10-19-2010 11:19 PM

02-07-2026, 06:13 AM	#2
BetterRed null operator (he/him) Posts: 22,340 Karma: 30621608 Join Date: Mar 2012 Location: Sydney Australia Device: none	Which version of calibre? If version 9 when did you install it - date & time if possible? What formats do you have for the 5% where pubdate did not change? BR

02-07-2026, 12:25 PM	#3
theducks Well trained by Cats Posts: 31,509 Karma: 62503986 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	FILES? Published is a column in Calibre. The File (creation and modified) dates change with data updates. Did you ADD/delete a custom column? That affect metadata.opf in all book folders (it updates in background) so you have a Library Recovery ability if the main db gets hosed.

02-08-2026, 04:58 PM	#6
theducks Well trained by Cats Posts: 31,509 Karma: 62503986 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Just to be clear: We are talking about the {Published} date column/field? The only thing I can think is you accidentally did a Bulk Mode metadata update that included more that you intended . (Been there) Always check the status lines # selected , before executing the bulk update.

02-12-2026, 08:42 PM	#11
BetterRed null operator (he/him) Posts: 22,340 Karma: 30621608 Join Date: Mar 2012 Location: Sydney Australia Device: none	Fairly easily done though, I just did it with 6 key 'strokes', Ctrl+A — select all books E — Edit Metadata in bulk Alt+U, Alt+U — to get to Published '=' — to set to Now Enter — to Commit changes Even easier if you use a mouse… click into Published when you were aiming for Date, press '=', click OK There is no "Are you sure" popup. BR