MovieLib - Your movie database on web
(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:
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.


You can disable strict mode in mysql config. That allow pass strings to integer fields.
Reply
 
Thread Rating:
  • 8 Vote(s) - 4.63 Average


Messages In This Thread
RE: MovieLib - Your movie database on web - by Regss - 2015-05-26, 08:26
Last Post - by Jeffreywat - 2017-09-03, 14:02


Logout Mark Read Team Forum Stats Members Help
MovieLib - Your movie database on web4.638