[mikebzh44]

@Xycl

I have downloaded the last ZIP from GITHUB and make some improvements as fresh install in Aeon Nox 4.0 rize ERROR in log (because categories tables does not exist or no picture in DB).

So edit default.py file, go to line 1027 and replaces those lines :

Code:

# Get general statistics and set properties
        Count = MPDB.Request( """SELECT COUNT(*) FROM files WHERE "EXIF DateTimeOriginal" NOT NULL AND UseIt=1""" )[0]
        Categories = MPDB.Request( """SELECT COUNT(*) FROM categories""" )[0]
        Collections = MPDB.Request( """SELECT COUNT(*) FROM collections""" )[0]
        Folders = MPDB.Request( """SELECT COUNT(*) FROM folders WHERE HasPics = 1""" )[0]

by

Code:

# Get general statistics and set properties
        # Check if FILES table exist
        _tableExist = MPDB.Request( """SELECT name FROM sqlite_master WHERE name='files'""" )
        if len(_tableExist) != 0:
            Count = MPDB.Request( """SELECT COUNT(*) FROM files WHERE "EXIF DateTimeOriginal" NOT NULL AND UseIt=1""" )[0]
        else:
            Count = [0]
        # Check if CATEGORIES table exist
        _tableExist = MPDB.Request( """SELECT name FROM sqlite_master WHERE name='categories'""" )
        if len(_tableExist) != 0:
            Categories = MPDB.Request( """SELECT COUNT(*) FROM categories""" )[0]
        else:
            Categories = [0]
        # Check if COLLECTIONS table exist
        _tableExist = MPDB.Request( """SELECT name FROM sqlite_master WHERE name='collections'""" )
        if len(_tableExist) != 0:
            Collections = MPDB.Request( """SELECT COUNT(*) FROM collections""" )[0]
        else:
            Collections = [0]
        # Check if FOLDERS table exist
        _tableExist = MPDB.Request( """SELECT name FROM sqlite_master WHERE name='folders'""" )
        if len(_tableExist) != 0:
            Folders = MPDB.Request( """SELECT COUNT(*) FROM folders WHERE HasPics = 1""" )[0]
        else:
            Folders = [0]

Thanks.