MediaPortal Forum - View Single Post

gunck4 · 2008-04-13, 19:54

Hi Big_Kev,

I'm running my TvLibrary database on a linux machine and as you probably know table names are case sensitive there. That causes troubles for the WebInterface that queries the database using only lower case characters in the table names.

"MP Web Server Error 500
The Web Server has encountered the following error:

[AnyDAC][Phys][MySQL][LIBMYSQL] Table 'TvLibrary.channelgroup' doesn't exist"

The table should for example be queried with 'TvLibrary.ChannelGroup' instead of 'TvLibrary.channelgroup'.

Is it possible to change the database operations so they also would work in linux users environments?

EDIT: By setting lower_case_table_names=1 in my.cnf it is possible to make MySQL on linux case insesitive to, so I think I can live with that.

Thank you anyway!

-gunck4

2008-04-13, 19:54	#392 (permalink)
gunck4 Portal Member Join Date: Dec 2007 Posts: 12 Thanks: 0 Thanked 0 Times in 0 Posts Country:	Problem with database on linux Hi Big_Kev, I'm running my TvLibrary database on a linux machine and as you probably know table names are case sensitive there. That causes troubles for the WebInterface that queries the database using only lower case characters in the table names. "MP Web Server Error 500 The Web Server has encountered the following error: [AnyDAC][Phys][MySQL][LIBMYSQL] Table 'TvLibrary.channelgroup' doesn't exist" The table should for example be queried with 'TvLibrary.ChannelGroup' instead of 'TvLibrary.channelgroup'. Is it possible to change the database operations so they also would work in linux users environments? EDIT: By setting lower_case_table_names=1 in my.cnf it is possible to make MySQL on linux case insesitive to, so I think I can live with that. Thank you anyway! -gunck4 Last edited by gunck4; 2008-04-13 at 20:30. Reason: Found a solution myself.