由于我的旧数据库中存在一些不一致,我遇到了同样的问题.修复后(主要是删除一些死引用)进行升级.我似乎还有另一个问题,但可能与db无关.

这将显示您的问题(除了根标签外都应为空)：

select * from Images where album not in (select Albums.id from Albums);

select id, icon from Albums where icon != 0 and icon not in (select id from Images);

select * from Albums where Albums.albumRoot not in (select AlbumRoots.id from AlbumRoots);

select * from ImageHaarMatrix where imageid not in (select id from Images);

select * from ImageInformation where imageid not in (select id from Images);

select * from ImageMetadata where imageid not in (select id from Images);

select * from VideoMetadata where imageid not in (select id from Images);

select * from ImagePositions where imageid not in (select id from Images);

select * from ImageComments where imageid not in (select id from Images);

select * from ImageCopyright where imageid not in (select id from Images);

select * from Tags where pid != 0 and pid not in (select id from Tags);

select id, icon from Tags where icon != 0 and icon not in (select id from Images);

select * from ImageTags where tagid not in (select id from Tags);

select * from ImageTags where imageid not in (select id from Images);

select * from ImageProperties where imageid not in (select id from Images);

select * from ImageHistory where imageid not in (select id from Images);

select * from ImageRelations where subject not in (select id from Images);

select * from ImageRelations where object not in (select id from Images);

select * from ImageTagProperties where imageid not in (select id from Images);

select * from TagProperties where tagid not in (select id from Tags);

select * from ImageTagProperties where tagid not in (select id from Tags);

还有一个修复脚本可以在源头找到.

而我刚才了解到,5.2.0已于两天前发布！