[lowfi]

Hi

I run an mysql db (5.1.41) op an ubuntu 10.04lts box. My xbmclive clients connect to this linux box using mysql DB. I use imdb scraper together with .NFO with imdb url inside.

typical movie folder contents:


mysql DB scrape result:


sqlite DB scrape result:


These are osx SS but results on xbmclive clients are the same...

As you can see some details are missing. This is just one example. About 30 from the 220 movies miss some kind of info. Mostly plot details.

mysql errorlog: http://pastebin.com/0gUxQdP4
mysql my.cnf: http://pastebin.com/KHeiG3ew

Any help is appreciated

[Tight_wad]

I don't use the MySql as of yet, but I will try to help.

Line 14

Code:

#
ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1

Does this mean that you did not set the character set to DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci ?

Not sure, if this helps or not.

[lowfi]

ah... well that seems to be it... Although i dont see how i can change this:

Code:

mysql> SHOW VARIABLES LIKE 'character\_set\_%';
+--------------------------+--------+
| Variable_name            | Value  |
+--------------------------+--------+
| character_set_client     | latin1 |
| character_set_connection | latin1 |
| character_set_database   | latin1 |
| character_set_filesystem | binary |
| character_set_results    | latin1 |
| character_set_server     | latin1 |
[b]| character_set_system     | utf8   |[/b]
+--------------------------+--------+
7 rows in set (0.00 sec)

It is read only when i try mysql cli:

Code:

mysql> SET character_set_system = latin1;
ERROR 1238 (HY000): Variable 'character_set_system' is a read only variable

Also tried messing about in the my.cnf:

Code:

[mysqld]
character-set-system = latin1

output is the same