Reply to thread

Message

<blockquote data-quote="David F" data-source="post: 879437" data-attributes="member: 125510">Hi,&nbsp;Many thanks for this. After making my post above, I spent quite some time analysing and retesting the installation, including multiple uninstall and re-installs, and eventually found my problem and a solution. I didn't explain initially that instead of a standard SQLEXPRESS or MySQL database, my installation is using a pre-installed SQL Server 2008 R2 database server which I also use for some other database applications on the same machine. When SetupTv.exe runs for the first time and creates and upgrades the MpTvDb database, it was throwing an error which I was ignoring, which turns out to be crucial. The DoScan() thread was then failing to insert data into the Channel table because of a 'not null' column which should not have existed.&nbsp;The fix I made is in TvEngine3\TVLibrary\SetupTv\57_upgrade_sqlserver_database.sql; Lines 21 and 24 should refer to table 'Channel', not 'channel'. I suppose that if my server collation was case-insensitive this might not matter, but by changing this alone, my installation works fine with case-sensitive collation. &nbsp;I tested this by downloading, patching and rebuilding the Release 1.2.3 source code. I don't have GIT installed. I hope the above is sufficient for you to roll this fix into the code, but let me know if I should help with a bug report or similar.&nbsp;David</blockquote>

[QUOTE="David F, post: 879437, member: 125510"] Hi, Many thanks for this. After making my post above, I spent quite some time analysing and retesting the installation, including multiple uninstall and re-installs, and eventually found my problem and a solution. I didn't explain initially that instead of a standard SQLEXPRESS or MySQL database, my installation is using a pre-installed SQL Server 2008 R2 database server which I also use for some other database applications on the same machine. When SetupTv.exe runs for the first time and creates and upgrades the MpTvDb database, it was throwing an error which I was ignoring, which turns out to be crucial. The DoScan() thread was then failing to insert data into the Channel table because of a 'not null' column which should not have existed. The fix I made is in TvEngine3\TVLibrary\SetupTv\57_upgrade_sqlserver_database.sql; Lines 21 and 24 should refer to table 'Channel', not 'channel'. I suppose that if my server collation was case-insensitive this might not matter, but by changing this alone, my installation works fine with case-sensitive collation. I tested this by downloading, patching and rebuilding the Release 1.2.3 source code. I don't have GIT installed. I hope the above is sufficient for you to roll this fix into the code, but let me know if I should help with a bug report or similar. David [/QUOTE]

Verification