Kodi Community Forum
MovieLib - Your movie database on web - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Supplementary Tools for Kodi (https://forum.kodi.tv/forumdisplay.php?fid=116)
+--- Thread: MovieLib - Your movie database on web (/showthread.php?tid=167893)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45


RE: MovieLib - Your movie database on web - dotnotnet - 2015-03-12

(2015-03-12, 09:16)Regss Wrote: Check the /cache folder on server. Are there any files there? Maybe you must change CHMOD for cache folder, to script can save the files.
Thanks! That made it! (This should be mentioned during the installations steps or in the requirements list btw).
However I got nothing in the actors folder, what is it for?

One more thing! It seems that the Watched Status filtering dropdown button doesn't work on Chrome (Works on IE 11)

Update: The above problem seem to be a local issue on my Chrome - maybe some script get interupted as a result of blocking Facebook trackers.
Update2: Looks like it was a bug after all.Check my new post below.


RE: MovieLib - Your movie database on web - Regss - 2015-03-13

Actors folder is for actors thumbnails. It seems that not synced. If you want actors thumb you must delete movielib database and sync again with proper chmod for cache and cache/actors folders.


RE: MovieLib - Your movie database on web - dotnotnet - 2015-03-13

(2015-03-13, 12:39)Regss Wrote: Actors folder is for actors thumbnails. It seems that not synced. If you want actors thumb you must delete movielib database and sync again with proper chmod for cache and cache/actors folders.
Alright.. I think I found how to reproduce the "Watched status button" bug this time.

(Tested with Chrome)
1. Open movielib
2. Login to the admin panel in another tab.
3. Go back to movielib and refresh, now Watched status button doesn't work.
4. To enable it you must log out of the admin panel and refresh the movielib page.


RE: MovieLib - Your movie database on web - dotnotnet - 2015-03-13

Here is five feature requests:

1. Option to set default "Watched Status"
2. Option to set default sorting "Title,Year,Rating,Last Added etc"
3. IMDB link on the rating numbers
4. Don't show "Movie" and "TV-Shows" header if only one source is used.
5. URL-rewrite with htaccess / mod_rewrite

Smile


RE: MovieLib - Your movie database on web - noobiq - 2015-03-30

hello,

i wanted to try this so downloaded it. first surprise was time needed for loading each page of installation process. took like 5-8 sec., sometimes i had to refresh page becouse it did not load completly (white page, then missing accept button).i have my own server so it should load almost instantly (other pages do).
ok, so i created db manually, filled database info. DB created succesfully. but when i try to login to admin, it always says wrong password.

reinstalled several times, different locations, even tried chmod 666 for db.php (found this somewhere here). Dunno what to do.


RE: MovieLib - Your movie database on web - Regss - 2015-03-31

What server do you use?


RE: MovieLib - Your movie database on web - noobiq - 2015-03-31

debian latest stable v. , apache v2.22
also, im using webmin for mysql


RE: MovieLib - Your movie database on web - hallohome - 2015-04-03

Hi,

I have a problem, when i try to sort by "genre" I get an error

SELECT movies.date_added FROM movies, movies_genre ORDER BY movies.date_added DESC LIMIT 0, 1
ERROR: MySQL - Incorrect key file for table '/tmp/#sql_63e1_0.MYI'; try to repair it

I have space left for my mysql tmp folder. I tryed to repair the tables but that didnt help.
I use Version 2.7.2 and XBMC 13.2


RE: MovieLib - Your movie database on web - Cocotus - 2015-05-14

(2015-03-13, 23:08)dotnotnet Wrote: Here is five feature requests:

1. Option to set default "Watched Status"
2. Option to set default sorting "Title,Year,Rating,Last Added etc"
3. IMDB link on the rating numbers
4. Don't show "Movie" and "TV-Shows" header if only one source is used.
5. URL-rewrite with htaccess / mod_rewrite

Smile

1. I solved this by importing/syncing my watched states of my xbmc library using trakt.tv and then Movielib automatically updates the playcount on my site
2. +1
3. +1
4. +1

Cool

Great addon!!


RE: MovieLib - Your movie database on web - Lokotito - 2015-05-21

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.


RE: MovieLib - Your movie database on web - Regss - 2015-05-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:
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.


RE: MovieLib - Your movie database on web - dotnotnet - 2015-06-04

(2015-05-26, 08:26)Regss 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?
Yes.
I know that you can set it in the php file, but it would be nice if you could change it in admin settings.


RE: MovieLib - Your movie database on web - Regss - 2015-06-09

v. 2.7.3

- add uhd flag
- add htaccess and mod rewrite
- option to set default sorting
- option to set default watched status
- option to hide the select media header bar
- add imdb link

Download and replace all files without install.php. Go to admin panel to update database tables.


RE: MovieLib - Your movie database on web - Cocotus - 2015-07-06

Hey Regss,
I noticed my MovieLib Homepage is not up to date anymore, but I think I saw a notification in Kodi to update, so I'm going to install your latest update now. Thanks for all the work on this, it's my favorite Kodi Addon Smile


RE: MovieLib - Your movie database on web - Cocotus - 2015-07-12

For your notice: I updated to newest version and I had to delete htaccess file you provided in my movilib directory because otherwise my site wouldn't load at all. Is there any drawback by deleting that file? Everything seems to work so far Smile