TVE3 Web User Interface

[rekenaar]

I would like to try out this webinterface, but I am receiving the errors below:

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Channel'., SQL state S0002 in SQLExecDirect in C:\xampp\htdocs\htpc\index.php on line 145

Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in C:\xampp\htdocs\htpc\index.php on line 146
 

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Channel'., SQL state S0002 in SQLExecDirect in C:\xampp\htdocs\htpc\index.php on line 159

Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in C:\xampp\htdocs\htpc\index.php on line 162

Anyone able to give some advice?

I am using Friday's version of TV3 and MP.
Vista.
MS SQL Server 2005
XAMPP
ODBC connection test successfull.

Thank you

[level20peon]

You don't need the ODBC driver when you use MS SQL Server 2005, uninstall it. Also use Goatse's version of the Webinterface when using MS SQL Server 2005 not mine.


-level20peon

[rekenaar]

I am using goatse's version (1st post).

What did he mean in his post at point number 3 - Configure ODBC Connection? I did the following: Administrative Tools - Data Sources - Add.

If I remove it, I am receiveing the following error in addition to the errors previously opsted:

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\xampp\htdocs\htpc\index.php on line 6

[level20peon]

You might have misunderstood me, sorry. I said you don't need the "ODBC driver" not the "ODBC connection" at all. If you haven't installed the driver everything is fine. So configure your ODBC connection like you did and make sure you change the index.php like this:

< ?PHP
// DB SETTINGS
$ server="ENTERSERVER_NAME/IP_HERE";
$ username="YOUR_SERVER'S_USERNAME";
$ password="YOUR_SERVER'S_PASSWORD";
$ sqlconnect =  odbc_connect($server, $username, $password);

Don't modify line 6


-level20peon

[rekenaar]

UBF = User Brain Failure
There is a setting for default database in the data source connection setup. Changed that to TvLibrary and now it is working.

Thanks for trying to help.

[rekenaar]

When I try to increase the number of visible channels, something does not work. I am using the version in the 1st post. It seems that there are 2 place that I need to change from 6 to lets say 30.

The 1ste few channels show fine, but then the heading and the detail get out of sinc resulting in major confusion. My last 4 column headings then have no program data underneath.

Any ideas to resolve another possible UBF from my side?

[level20peon]

You need to change the following lines, since the line-numbers may differ from your version you have to look for them manually


around line 100

AND Cha.SortOrder BETWEEN 1 AND 30

around line 105

$sqlquerychannels="SELECT idChannel, name from Channel WHERE isRadio!=1 ORDER BY sortOrder limit 30";

-level20peon

[rekenaar]

That's exactly what I did.

AND Cha.SortOrder BETWEEN 1 AND 30

the second place looks slightly different but I guess its because it connects to different database (??):

$sqlquerychannels="SELECT TOP 30 idChannel, [name] from dbo.Channel WHERE  isRadio=0 ORDER BY SortOrder";

I am not at home now, but maybe I should try and change the second line to what you have.

[level20peon]

The second line is OK when you use MS SQL 2005, I use MySQL so I had to alter the code.


-level20peon


EDIT: Please post a screenshot of your error. Is the EPG shown correctly inside MediaPortal ?

[ZeroX]

is there any screenshots of Team MP webinterface or is that project scrapt ?
how's the development going goatse ??