[bug] creates 'program' uses 'Program' on mysql (1 Viewer)

[deebo]

TV-Server Version: fresh svn on 25.4.

title says it all

the setup program creates a table called tvlibrary.program

then tries to create an index for tvlibrary.Program

which, using linux mysql is plain wrong:

mysql> select * from program;
Empty set (0.00 sec)

mysql> select * from Program;
ERROR 1146 (42S02): Table 'tvlibrary.Program' doesn't exist

please turn all references to take into account case

 

[deebo]

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

by default the windows client is case insensitive and linux is sensitive

can be changed, but still, there shouldnt be mixed tablenames

To avoid problems caused by such differences, it is best to adopt a consistent convention, such as always creating and referring to databases and tables using lowercase names. This convention is recommended for maximum portability and ease of use.

 

[Frodo]

should be fixed now