Hi I try your addon, really think is great but I can't get working, like other user I have a SYNC problem:
Code:
23:22:38 T:5480 NOTICE: >>>> Movielib <<<< [REQUEST DATA SIZE]: 710667 bytes
23:22:39 T:5480 NOTICE: >>>> Movielib <<<< [RESPONSE]: INSERT INTO `movies` (`id`, `title`, `plot`, `rating`, `trailer`, `runtime`, `originaltitle`, `year`, `set`, `file`, `play_count`, `last_played`, `date_added`, `hide`, `hash`) VALUES ("216", "MOVIE_DESCRIPTION", "6.0", "http://www.youtube.com/embed/T0qlJ17IdwY", "149", "The Lone Ranger", "2013", "", "smb://MYIP/FOLDER/MOVIE.mkv", "0", "", "2013-10-14 19:14:01", "", "330e04a69a85b53993cb3b3bf324b983")
<br>ERROR: MySQL - Incorrect integer value: '' for column 'hide' at row 1
I check page 17 for similar issue but don't know where I have to change the data type of 'hide'.
EDIT 1: Fool of me, I have to changing this in my movielib MYSQL DB.
Now have another bug:
Code:
00:12:48 T:5212 NOTICE: >>>> Movielib <<<< [REQUEST DATA SIZE]: 238221 bytes
00:12:49 T:5212 NOTICE: >>>> Movielib <<<< [RESPONSE]: INSERT INTO `movies_stream` (`id`, `type`, `v_codec`, `v_aspect`, `v_width`, `v_height`, `v_duration`, `a_codec`, `a_chan`, `a_lang`, `s_lang`) VALUES ("124", "v", "h264", "2.40000009537", "1920", "800", "127", "", "", "", ""), ("124", "a", "", "", "", "", "", "aac", "2", "eng", ""), ("124", "a", "", "", "", "", "", "ac3", "6", "spa", ""), ("124", "s", "", "", "", "", "", "", "", "", "spa"), ("124", "s", "", "", "", "", "", "", "", "", "spa")
<br>ERROR: MySQL - Data too long for column 'v_aspect' at row 1
EDIT 2: Now got it, in `movies_stream` change the 'v_aspect' to varchar(15)
Also with my little collection, I found this bugs for movies with SUBTITLES (MKV and SRT subtitles)
For `movies_stream`:
`a_chan` column I have NULL (empty values, it is a subtittle), Change type `a_chan` to varchar(11)
'v_width' column I have NULL (empty values, it is a subtittle), Change type 'v_width' to varchar(11)
'v_duration' column I have NULL (empty values, it is a subtittle), Change type 'v_duration' to varchar(11)
I runing in a Jail MYSQL, PHP5, APACHE server for movielib script.
Runing MySQL, PHP5, APACHE for KODI/SBMC DB in another jail.
XBMC to 14.2 Git:20150326-7cc53a9
How can I fix this bug ?
Thank you.