Reply to thread

Message

<blockquote data-quote="Big_Kev" data-source="post: 295803" data-attributes="member: 52102">This issue is usually caused when there is no default recording folder associated with a tv card. Check in TV Server Configuration under Recording Settings -&gt; Recording Folders that there is a recording directory specified for each card.I am not sure about this one... basically, when the system searches for all suggested programs, it needs to access both the bkqueries database and the normal mediaportal database in the same query. This works fine in MySQL just by prefixing the table names with the database name - like bkqueries.programs - but in MSSQL, you need to specify the database owner as well, hence the &quot;.dbo&quot; added to the table name for MSSQL.I think there are 2 possibilities....1. You are using MySQL and the interface has not detected this correctly.2. The loggin you created for the web interface to your MSSQL database does not have sufficient privileges to both&nbsp; databases.As a start, which database are you using?If you are using MSSQL, check that the privileges on the user you created are sufficient. To do this you will need to have installed Microsoft SQL Server Management Express (there is a link in a previous post). From the main screen, open the &quot;Security&quot; folder, then &quot;logins&quot; then double click the user id that you are using for the web interface. This will open the &quot;Login Properties&quot; window. Select &quot;Server Roles&quot; - I am not sure which is the correct one, so tick them all! (someone out there probably knows!). I am not actually sure if this will work, but it is a good probability.Please keep me posted so we can get to the bottom of it.Kev</blockquote>

[QUOTE="Big_Kev, post: 295803, member: 52102"] This issue is usually caused when there is no default recording folder associated with a tv card. Check in TV Server Configuration under Recording Settings -> Recording Folders that there is a recording directory specified for each card. I am not sure about this one... basically, when the system searches for all suggested programs, it needs to access both the bkqueries database and the normal mediaportal database in the same query. This works fine in MySQL just by prefixing the table names with the database name - like bkqueries.programs - but in MSSQL, you need to specify the database owner as well, hence the ".dbo" added to the table name for MSSQL. I think there are 2 possibilities.... 1. You are using MySQL and the interface has not detected this correctly. 2. The loggin you created for the web interface to your MSSQL database does not have sufficient privileges to both databases. As a start, which database are you using? If you are using MSSQL, check that the privileges on the user you created are sufficient. To do this you will need to have installed Microsoft SQL Server Management Express (there is a link in a previous post). From the main screen, open the "Security" folder, then "logins" then double click the user id that you are using for the web interface. This will open the "Login Properties" window. Select "Server Roles" - I am not sure which is the correct one, so tick them all! (someone out there probably knows!). I am not actually sure if this will work, but it is a good probability. Please keep me posted so we can get to the bottom of it. Kev [/QUOTE]

Verification