[Xycl]

Beta Testers needed

I changed a lot of legacy DB code due to several errors with null values and values containing an apostrophe (values := Directory or file names and tag values).

In particular:
1) SQLs are changed (but not all) to use bind variables instead of placeholders for string variables.

Code:

select * from files where filename = '%s'
doesn't work if the variable contains an apostrophe.

2) Null value handling in selects is changed.

Code:

select distinct date_column from files where date_column is not null
returned null values! Sqlite seems really to be lite.

Especially 1) caused aftereffects like unicode issues with non latin characters.

Due to the infinite possibilties with tag types/tag values or path/file name combinations I'm not able to test everything.

If you are willing to help testing then please install my repo Xycl abandoned Dharma Repository.
This will update MyPicsDB to the latest development version.

Error reports must contain the part of the XBMC log file with the error!
If there are problems with special pictures because they contain tags/tag values which cause the error then PM me the pictures.

Thanks
Xycl