• 1
  • 8
  • 9
  • 10(current)
  • 11
  • 12
  • 45
MovieLib - Your movie database on web
Hi,

I'm trying to install this on my QNAP NAS which already has PHP, and MySQL installed. In fact my XBMC library is already in MySQL.

When going through the installation I'm getting the following error:

: config - 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 'panel_overall` int(1) DEFAULT 1, `panel_genre` int(1) DEFAULT 1,' at line 11

When attempting to create the movielib database.

It may be worth noting for security purposes I don't have MySQL running on the default port, but on a different port, which I have entered into the page. I dont know if this has anything to do with it?

Any ideas?
Image
Reply
Woops, small bug.
edit function.php
replace:
Code:
`live_search_max_res int(4) DEFAULT 10,
to
Code:
`live_search_max_res` int(4) DEFAULT 10,

I fix it in Github later.
Reply
EDIT: sorry it is now working, thanks for your help and the very quick reply.

(helps if I edit the version that's on the webserver and not the one on my hard drive. Having a moment there!!)
Image
Reply
I'm very pleased with this as it is 'almost' exactly what I wanted.

My only small issue now is that I pretty much have 2 identical MySQL databases on my NAS. The one created by XBMC and the one created by MovieLib.

Could I submit a feature request?

I don't know how easy this would be, but as an alternative to having the addon installed on the XBMC box, for those of us that have multiple XBMC clients that connect to a central DB on MySQL, could it be possible to have MovieLib read that database?

This would then eliminate the need to get the data from the XBMC client because everything would already be in the MySQL DB that XBMC has created.

The only issue could be thumbnails, for this I have a substitute path pointing to a share on my NAS so they are also unified across my XBMC installs without the need for each client to download poster art etc but appreciate in some instances this is frowned upon and people are advised to still have local thumbnails.

Also, no doubt mentioned, would be great to get TV Show data in here as well but it's not a show stopper!

Thanks for at least reading and this is a great little script/add on for allowing me to view my database without having to power on an XBMC client and also to be able to view over the www. Smile
Image
Reply
I've noticed one thing it is doing wrong. Again nothing major.

All of my 720P films are showing the 1080 graphic underneath them.

Not sure if your assuming all HD content to be 1080 or if this is a bug?

Thanks.
Image
Reply
Found a "bug": Whenever you click on any genre in genrelist, the listed movies will have ALL their actor images expanded! To "fix" this I have to move my mouse over an actor image and then wenn I move mouse out of image all the images gets minimized like expteced.
Reply
(2014-02-20, 19:48)Cocotus Wrote: Found a "bug": Whenever you click on any genre in genrelist, the listed movies will have ALL their actor images expanded! To "fix" this I have to move my mouse over an actor image and then wenn I move mouse out of image all the images gets minimized like expteced.

http://cocotus.bplaced.net/movielib/index.php - You have old jquery.script.js
Reply
(2014-02-20, 18:24)ensignvorik Wrote: I've noticed one thing it is doing wrong. Again nothing major.

All of my 720P films are showing the 1080 graphic underneath them.

Not sure if your assuming all HD content to be 1080 or if this is a bug?

Thanks.

v. 2.3.2
- fix graphics for HD movies
- fix create tables in install process
Reply
Thanks, the image for 720 and 1080 are now correct.

However, the script is now throwing a error when I start XBMC. I think there is possibly an entry in my library it doesn't like the format of.

Below is my log file. I can't seem to work it out for myself what I might be?

Code:
21:17:41 T:140625810810624  NOTICE: >>>> Movielib <<<< toAddID: ['2181', '2182', '2179', '2180', '2177', '2178', '2174', '2175', '2176', '2172', '2173', '2171', '2170', '2168', '2169', '2167', '2164', '2165', '2166', '2160', '2161', '2162', '2163', '2157', '2158', '2159', '2155', '2156', '2153', '2154', '2150', '2151', '2152', '2149', '2148', '2147', '2146', '2144', '2145', '2140', '2141', '2142', '2143', '2137', '2138', '2139', '2136', '2133', '2134', '2135', '2132', '2131', '2130', '2129', '2128', '2127', '2126', '2125', '2124', '2122', '2123', '2120', '2121', '2118', '2119', '2115', '2116', '2117', '2114', '2113', '2112', '2111', '2110', '2109', '2108', '2102', '2103', '2104', '2105', '2106', '2107', '2101', '2100', '2099', '2098', '2096', '2097', '2095', '2094', '2091', '2092', '2093', '2090', '2089', '2088', '2078', '2079', '2080', '2081', '2082', '2083', '2084', '2085', '2086', '2087', '2072', '2073', '2074', '2075', '2076', '2077', '2070', '2071', '2068', '2069', '2065', '2066', '2067', '2064', '2063', '2062', '2061', '2060', '2059', '2058', '2056', '2057', '2054', '2055', '2052', '2053', '2050', '2051', '2049', '2571', '2048', '2046', '2045', '2042', '2043', '2044', '2036', '2037', '2038', '2039', '2040', '2041', '2034', '2035', '2033', '2028', '2029', '2030', '2031', '2032', '2026', '2027', '2025', '2024', '2018', '2019', '2020', '2021', '2022', '2023', '2016', '2017', '2012', '2013', '2014', '2015', '2011', '2010', '2009', '2008', '2005', '2006', '2007', '1999', '2000', '2001', '2002', '2003', '2004', '1998', '1997', '1996', '1995', '1993', '1994', '1990', '1991', '1992', '1989', '1988', '1987', '2562', '1986', '1985', '1984', '1981', '1982', '1983', '1979', '1980', '1978', '1977', '1975', '1976', '1973', '1974', '1970', '1971', '1972', '1969', '1968', '1967', '1965', '1966', '1963', '1964', '1962', '1961', '1960', '1958', '1959', '1956', '1957', '1953', '1954', '1955', '1951', '1952', '1947', '1948', '1949', '1950', '1943', '1944', '1945', '1946', '1942', '1940', '1941', '1938', '1939', '1937', '1936', '1935', '1934', '1933', '1932', '1930', '1931', '1929', '1928', '1926', '1927', '1925', '1923', '1924', '1922', '1921', '1918', '1919', '1920', '1916', '1917', '1914', '1915', '1912', '1913', '1903', '1904', '1905', '1906', '1907', '1908', '1909', '1910', '1911', '1801', '1802', '1803', '1804', '1805', '1806', '1807', '1808', '1809', '1810', '1811', '1812', '1813', '1814', '1815', '1816', '1817', '1818', '1819', '1820', '1821', '1822', '1823', '1824', '1825', '1826', '1827', '1828', '1829', '1830', '1831', '1832', '1833', '1834', '1835', '1836', '1837', '1838', '1839', '1840', '1841', '1842', '1843', '1844', '1845', '1846', '1847', '1848', '1849', '1850', '1851', '1852', '1853', '1854', '1855', '1856', '1857', '1858', '1859', '1860', '1861', '1862', '1863', '1864', '1865', '1866', '1867', '1868', '1869', '1870', '1871', '1872', '1873', '1874', '1875', '1876', '1877', '1878', '1879', '1880', '1881', '1882', '1883', '1884', '1885', '1886', '1887', '1888', '1889', '1890', '1891', '1892', '1893', '1894', '1895', '1896', '1897', '1898', '1899', '1900', '1901', '1902', '1790', '1791', '1792', '1793', '1794', '1795', '1796', '1797', '1798', '1799', '1800', '1788', '1789', '1715', '1716', '1717', '1718', '1719', '1720', '1721', '1722', '1723', '1724', '1725', '1726', '1727', '1728', '1729', '1730', '1731', '1732', '1733', '1734', '1735', '1736', '1737', '1738', '1739', '1740', '1741', '1742', '1743', '1744', '1745', '1746', '1747', '1748', '1749', '1750', '1751', '1752', '1753', '1754', '1755', '1756', '1757', '1758', '1759', '1760', '1761', '1762', '1763', '1764', '1765', '1766', '1767', '1768', '1769', '1770', '1771', '1772', '1773', '1774', '1775', '1776', '1777', '1778', '1779', '1780', '1781', '1782', '1783', '1784', '1785', '1786', '1787', '2572']
21:17:41 T:140625810810624  NOTICE: >>>> Movielib <<<< toRemoveID: []
21:17:41 T:140625810810624  NOTICE: >>>> Movielib <<<< {u'jsonrpc': u'2.0', u'id': u'1', u'result': {u'moviedetails': {u'originaltitle': u'Open Grave', u'dateadded': u'2013-12-06 23:17:19', u'movieid': 2181, u'plot': u'Sharlto Copley will play a man who awakens in a large pit full of dead bodies and does not remember how he got there. He then hallucinates and believes that he is the killer, and must try to uncover the truth.', u'fanart': u'image://http%3a%2f%2fimage.tmdb.org%2ft%2fp%2foriginal%2f9aPAt8qyf3fMeQYRy743MarHrX4.jpg/', u'country': [u'United States of America'], u'lastplayed': u'', u'thumbnail': u'image://http%3a%2f%2fimage.tmdb.org%2ft%2fp%2foriginal%2f4yJfkoMzHcZVuZTgDH2t5guhPnI.jpg/', u'label': u'Open Grave', u'director': [u'Gonzalo L\xf3pez-Gallego'], u'cast': [{u'role': u'John', u'name': u'Sharlto Copley', u'thumbnail': u'image://http%3a%2f%2fimage.tmdb.org%2ft%2fp%2foriginal%2fhs2rmzwJM77S320gFQUuMDS6azk.jpg/'}, {u'role': u'Nathan', u'name': u'Joseph Morgan', u'thumbnail': u'image://http%3a%2f%2fimage.tmdb.org%2ft%2fp%2foriginal%2fkfYqG5r6ceZi3e7elGATDY5h1K7.jpg/'}, {u'role': u'Lukas', u'name': u'Thomas Kretschmann', u'thumbnail': u'image://http%3a%2f%2fimage.tmdb.org%2ft%2fp%2foriginal%2fallahLWNWLQpeY46nUg1d6zSO7T.jpg/'}, {u'role': u'Sharon', u'name': u'Erin Richards', u'thumbnail': u'image://http%3a%2f%2fimage.tmdb.org%2ft%2fp%2foriginal%2flIqwUIbOyS2GRTnB2ZcjFYWepgx.jpg/'}, {u'role': u'Brown Eyes', u'name': u'Josie Ho', u'thumbnail': u'image://http%3a%2f%2fimage.tmdb.org%2ft%2fp%2foriginal%2flbKcMciswqKaG6Sz6RylyoeGkoo.jpg/'}, {u'role': u'Michael', u'name': u'Max Wrottesley'}, {u'role': u'Moaner Woman', u'name': u'Kati Dombi'}, {u'role': u'Mother', u'name': u'Eva Botos'}, {u'role': u'Boy', u'name': u'Tofi Seffer'}], u'file': u'smb://192.168.0.3/Multimedia/movies/Open Grave (2013)/Open.Grave.2013.720p.BluRay.x264.YIFY.mp4', u'year': 2013, u'genre': [u'Horror', u'Mystery', u'Thriller'], u'title': u'Open Grave', u'playcount': 0, u'runtime': 6132, u'rating': 6.3000001907348633, u'trailer': u'plugin://plugin.video.youtube/?action=play_video&videoid=AkCNY131ceA\u200e', u'streamdetails': {u'video': [{u'duration': 6132, u'width': 1280, u'codec': u'avc1', u'aspect': 2.4242401123046875, u'height': 528}], u'audio': [{u'channels': 2, u'codec': u'aac', u'language': u'eng'}], u'subtitle': []}}}}
21:17:41 T:140625810810624  NOTICE: >>>> Movielib <<<< {'rating': 6.3000001907348633, 'v_width': 1280, 'year': 2013, 'a_chan': 2, 'v_duration': 102, 'id': '2181', 'plot': 'Sharlto Copley will play a man who awakens in a large pit full of dead bodies and does not remember how he got there. He then hallucinates and believes that he is the killer, and must try to uncover the truth.', 'a_codec': u'aac', 'title': 'Open Grave', 'fanart': 'http://image.tmdb.org/t/p/original/9aPAt8qyf3fMeQYRy743MarHrX4.jpg', 'v_aspect': 2.4242401123046875, 'poster': 'http://image.tmdb.org/t/p/original/4yJfkoMzHcZVuZTgDH2t5guhPnI.jpg', 'originaltitle': 'Open Grave', 'director': 'Gonzalo L\xc3\xb3pez-Gallego', 'genre': 'Horror / Mystery / Thriller', 'dateadded': u'2013-12-06 23:17:19', 'country': 'United States of America', 'lastplayed': u'', 'v_height': 528, 'cast': 'Sharlto Copley / Joseph Morgan / Thomas Kretschmann / Erin Richards / Josie Ho / Max Wrottesley / Kati Dombi / Eva Botos / Tofi Seffer', 'v_codec': u'avc1', 'playcount': 0, 'runtime': 102, 'trailer': u'http://www.youtube.com/embed/kCNY131ceA\u200e'}
21:17:41 T:140625810810624   ERROR: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<--
                                             - NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS!
                                            Error Type: <type 'exceptions.UnicodeEncodeError'>
                                            Error Contents: 'ascii' codec can't encode character u'\u200e' in position 39: ordinal not in range(128)
                                            Traceback (most recent call last):
                                              File "/storage/.xbmc/addons/script.movielib/default.py", line 91, in <module>
                                                Movielib()
                                              File "/storage/.xbmc/addons/script.movielib/default.py", line 45, in __init__
                                                self.checkToken()
                                              File "/storage/.xbmc/addons/script.movielib/default.py", line 75, in checkToken
                                                syncMovie.syncMovie()
                                              File "/storage/.xbmc/addons/script.movielib/lib/syncMovie.py", line 47, in __init__
                                                self.syncMovie()
                                              File "/storage/.xbmc/addons/script.movielib/lib/syncMovie.py", line 95, in syncMovie
                                                self.addMovie(toAddID)
                                              File "/storage/.xbmc/addons/script.movielib/lib/syncMovie.py", line 282, in addMovie
                                                data = urllib.urlencode(values)
                                              File "./Lib/urllib.py", line 1312, in urlencode
                                            UnicodeEncodeError: 'ascii' codec can't encode character u'\u200e' in position 39: ordinal not in range(128)
                                            -->End of Python script error report<--

UPDATE: It's clearly something to do with the film 'Open Grave'

I have removed it from my library and restarted XBMC and the Database now continues to populate without error.

So, I have no idea what it is about this film that it doesn't like.

Is it something to do with the formatting of the YouTube URL??

If it helps, here are it's IMDB and The Movie Database entries also.

http://www.imdb.com/title/tt2071550/?ref_=nv_sr_1
http://www.themoviedb.org/movie/215830-open-grave
Image
Reply
Yes, YouTube URL have unicode character. I fix this later.

edit:
Fixed in 1.1.8
Reply
Thanks again for the quick fix. Open Grave is now always skipped. Will this always be the case?

Also, as my QNAP seems slow at making the pages. I moved to some free webspace. Same as another user (Cocotus) in this thread.

Now I am unable to get images to go into cache folder? As you can see here: http://ensignvorik.bplaced.net/movielib-master/

I Messaged Cocotus and he said he did nothing special to get the fanart and posters to work.

I've chmod the cache folder to 777 but is still no go.

How do the images get posted to the cache folder? In case I need to create support ticket with bplaced.

I can see no errors in xbmc.log that would indicate the problem.

Sorry to give you more headache.
Image
Reply
Cocotus have image stored localy, you have stored only URL to image. Maybe bplaced blocking some function. I will try to sing up and test with movielib.

Put the new log after Open Grave will be skipped.
Reply
When script try to get image from URL get this waring:

Warning: imagecreatefromjpeg() [function.imagecreatefromjpeg]: Zugriff via http:// ist in Verbindung mit bplaced pro gegeben. Mehr Infos unter: http://www.bplaced.net/?handler=ext
Reply
(2014-02-23, 13:07)Regss Wrote: Put the new log after Open Grave will be skipped.

I've moved to a different host and it's now also uploaded open grave without an error.

(2014-02-23, 20:35)Regss Wrote: When script try to get image from URL get this waring:

Warning: imagecreatefromjpeg() [function.imagecreatefromjpeg]: Zugriff via http:// ist in Verbindung mit bplaced pro gegeben. Mehr Infos unter: http://www.bplaced.net/?handler=ext

Yes, looked like the problem was on bplaced side. Not sure if it is because I don't have the image files stored locally on the XBMC device, but on my NAS.

Either way, after trying a number of other free hosts just to allow speedier access to this I am able to use it fully featured with https://www.x10hosting.com/

For anyone else that wishes to follow suit, you may want to add your IP in their control panel settings to be allowed remote access to the MySQL db. Not sure if this made a difference or not, but I am now fully working how I want to be.

Thankyou for your support Regss and I look forward to seeing how this develops over time.
Image
Reply
Hi Regss,

Thank you for the fix for the ISO files! It works like a charm.
Do you think you could add a similar feature for VIDEO_TS directory files? They can be added at the same time when you enable the ISO option.
That would be awesome.

On another topic: we have parts of our movies protected with a password on the NFS share (i.e. master password lock turned on).
If I do not enter the password, the protected movies are removed from the database. I assume the script cannot access the movies and therefor removes them.
Do you think you could change or add a workaround to thisHuh

Thank you so much for this very helpful tool. Love it!
Reply
  • 1
  • 8
  • 9
  • 10(current)
  • 11
  • 12
  • 45

Logout Mark Read Team Forum Stats Members Help
MovieLib - Your movie database on web8