MovieLib - Your movie database on web
#20
(2013-07-05, 23:46)_Andy_ Wrote: I reinstalled your package with the latest function.php. I did the installation again but the table 'user' is empty and the table 'config' is filled. So i assume no access issue.

Before reinstall You must manually delete table in movielib database.

(2013-07-05, 23:46)_Andy_ Wrote: After adding the user with MySQL Workbench i entered the admin panel and checked sync with xbmc database and entered my access data to the xbmc database i noticed after pressing 'save'
the database name for xbmc is still 'xbmc_video75' but in the 'config' table the name is correct. Maybe an display issue?

Yes, it is display issue. Thanks, I fix it.

(2013-07-05, 23:46)_Andy_ Wrote: I clicked on 'check connection' and i get Connected. Found movies: 840

After that i clicked on 'sync now' and went to index.php. I get an error 'Notice: Undefined variable: conn_ml in C:\xampp\htdocs\movielib\function.php on line 399'

To debug i insert the line 'echo $insert_sql;' and i can see all insert statements. They are filled with my XBMC movies. So i assume the XBMC database is readable.
But the var conn_ml is void so no insert into the movielib database. But why?

Hmm... Try copy one or all this insert query to phpmyadmin and run it. Example:

Code:
INSERT INTO `movies` ( `title`, `plot`, `rating`, `year`, `poster`, `fanart`, `runtime`, `genre`, `director`, `originaltitle`, `country`, `v_codec`, `v_aspect`, `v_width`, `v_height`, `v_duration`, `a_codec`, `a_channels`, `play_count`, `last_played`, `date_added` ) VALUES ( "Skyfall", "When Bond\'s latest assignment goes gravely wrong and agents around the world are exposed, MI6 is attacked forcing M to relocate the agency. These events cause her authority and position to be challenged by Gareth Mallory (Ralph Fiennes), the new Chairman of the Intelligence and Security Committee. With MI6 now compromised from both inside and out, M is left with one ally she can trust: Bond. 007 takes to the shadows - aided only by field agent, Eve (Naomie Harris) - following a trail to the mysterious Silva (Javier Bardem), whose lethal and hidden motives have yet to reveal themselves.", "6.400000", "2012", "http://cf2.imgobject.com/t/p/original/hunPAt4uxeFXhoNtEVe9xxhRozS.jpg", "http://cf2.imgobject.com/t/p/original/AunH2MIKIbnU9khgFp45eJlydPu.jpg", 143, "Action / Adventure / Thriller", "Sam Mendes", "Skyfall", "United Kingdom", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, "2013-06-27 21:31:22" )

Download package again I fix some bugs.

(2013-07-05, 16:10)Aenima99x Wrote:
(2013-07-05, 12:28)Regss Wrote: I forgot about the local files. I'll try to add support for it as soon as I get back from vacation.

Great thanks!

I added support for local files, can You see if it works?
Reply
 
Thread Rating:
  • 8 Vote(s) - 4.63 Average


Messages In This Thread
RE: MovieLib - Your movie database on web - by Regss - 2013-07-06, 08:54
Last Post - by Jeffreywat - 2017-09-03, 14:02


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