2015-05-26, 08:26
(2015-05-14, 17:50)Cocotus Wrote:(2015-03-13, 23:08)dotnotnet Wrote: ...
1. Option to set default "Watched Status"
...
You mean that you can set the default view with only watched or only unwatched?
(2015-05-21, 05:53)Lokotito Wrote: 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:
EDIT 2: Now got it, in `movies_stream` change the 'v_aspect' to varchar(15)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
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.
You can disable strict mode in mysql config. That allow pass strings to integer fields.