MySQL - issue with database layout (case sensitive) (1 Viewer)

[Valk]

With the TV Server I find that if I create a database on my linux MySQL 5 server that it has a issue with the database it creates not been right due to case sensitivity, can someone go over the MySQL create script and ensure that all the fields are the right case to the calls by the TVServer.

I've started to manually re-create the database and fix all the errors but there is a few.

Also in the source code you probably change case also. Kind of a annoying bug but one i'd appreciate if it was looked into.

I got (10-3-2007) todays release:
tvengine3-03-09-2007--01-13h--Rev13308.zip
MediaPortal-svn--03-09-2007--01-02-Rev13308.exe

Wasn't there a tool to get the info below? (can't find it). That information doesn't matter in this case so i'm going to ignore the rest, though if you want more for whatever reason, just ask.

MediaPortal Version: REV 13308
MediaPortal Skin: BlueTwo
Windows Version: Windows XP 64-bit
CPU Type: Intel Core Duo 2 - 6400 ( 2.13GHz )
HDD: 250GB ( 159GB Free ), 465GB ( 3.17GB Free ), 467GB ( 8.92GB Free )
Memory: 4GB
Motherboard: Asus P5B Deluxe
Motherboard Chipset: Intel-BW
Motherboard Bios: 1004
Video Card: Nvidia 7900GT
Video Card Driver: 91.47
Sound Card: Creative Xi-Fi Fatal1ty
Sound Card AC3:
Sound Card Driver:
1. TV Card:
1. TV Card Type:
1. TV Card Driver:
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec:
MPEG2 Audio Codec:
Satelite/CableTV Provider:
HTPC Case:
Cooling:
Power Supply:
Remote:
TV:
TV - HTPC Connection:

 

[deeceefar2]

I added a section to the wiki with a little bit of info about this: config-MySql.
What I ended up doing was adding a line to my.cnf under the [mysqld] section:
[mysqld]
lower_case_table_names=1

I then reinstalled tv server and everything worked fine.

 

[Valk]

you shouldn't have to do that but I guess left with little choice since no one seems interested.

Thanks for the reply.

 

[egandt]

Assuming you are on Windows (as lower_case_table_names is set properly on UNIX):
run the following SQL commands:
SHOW GLOBAL VARIABLES where Variable_name="lower_case_table_names";
will show lower_case_table_names=1
Since we need it set too the number 2, we run
UPDATE VARIABLES set Value=2 where Variable_name=""lower_case_table_names";
Fails as no DB is selected.

Lets try something else:
SHOW VARIABLES LIKE 'lower_case_table_names';
will show lower_case_table_names=1
Now the MYSQL documentation says I can change this using
SET @@lower_case_table_names=2
Fails with an error "unknown system variable"

Result I'm screwed as I can not set the variable for "lower_case_table_names" to 2 in any way I can find, using SQL.

Ok so I should be able to set it in the my.cnf file that is read at startup, however on windows it is called my.ini:
1. stop the mysql server
2. Locate the file my.ini (usually wherever MYSQL is installed)
3. Locate the section [mysqld] in the file under this section add the line:
lower_case_table_names=2
4. Save the file restart mysql
5. run the sql: "SHOW VARIABLES LIKE 'lower_case_table_names';"
will show lower_case_table_names=1

Well that way also failed, so I'm still screwed using mysql as the database. Anyone have another suggestion as I've already wasted over 90 minutes on setting this damn option without success.

Thanks,
ERIC

 

[egandt]

Ok wrong place in the mysql.ini file should be [mysqld] not [mysql], I would edit the last post, but IE and Firefox, both wait when I press save and do nothing but the second set of steps above will work.


ERIC

 

[troky]

Hi,

I've submitted mysql patch HERE

It would be nice if someone can test it. It works for me with default lower_case_table_names=0 and all other databases.


Regards,
Troky