Reply to thread

Message

<blockquote data-quote="gunck4" data-source="post: 254899" data-attributes="member: 61797">Problem with database on linuxHi 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.&quot;MP Web Server Error 500The Web Server has encountered the following error:[AnyDAC][Phys][MySQL][LIBMYSQL] Table 'TvLibrary.channelgroup' doesn't exist&quot;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? <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />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. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /> Thank you anyway!-gunck4</blockquote>

[QUOTE="gunck4, post: 254899, member: 61797"] [b]Problem with database on linux[/b] 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. "[COLOR="Blue"]MP Web Server Error 500 The Web Server has encountered the following error: [AnyDAC][Phys][MySQL][LIBMYSQL] Table 'TvLibrary.channelgroup' doesn't exist[/COLOR]" 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 [/QUOTE]

Verification