No ..
Posted: Tue Jul 09, 2013 8:59 am
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...
...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
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;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;