No ..

[m.Th.]

Yes, no .. We do NOT need them.

I see in my DB a bunch of entries with 0 bytes in size in the Images table which are, in fact the names of the folders.

Do a...

Code: Select all

Select * from Images where size = 0;

...to see them.

Perhaps this is because together with the other files you catalog the current directory (ie the .. file)?

So, take out the .. file from the catalog.

And what's worse is that when we move / delete the other files these .. files just remain in the DB.

Also, after fixing this, be sure in the next release in the upgrade DB process to have a

Code: Select all

delete from thumbs.datas where imageid in (select imageid from images where size=0);
delete from thumbs.datasExtra where imageid in (select imageid from images where size=0);
Delete from Images where size=0;