• 1
  • 18
  • 19
  • 20(current)
  • 21
  • 22
  • 45
MovieLib - Your movie database on web
Hi,

I installed MovieLib on my server and everything was working fine until i added all of my movies,
I added 1009 movies and now I can't open MovieLib. It loads and loads and loads and loads and then it says ''Server timeout'' or i get a blank page.

Administration is working fine, it shows 1008 movies in overall and in movie list i see all of my movies, but index.php won't open.

I deleted all, and installed again on fresh database, and as soon as i add more than 500 movies, same thing happens.

Please help Sad
Reply
hey Regss, first thanks for all your efforts! Glad your still constantly try to improve your great addon Smile I noticed that suddenly I often get status message on top of my XBMC skin,reporting "Movie added" and such - is it possible to disable those messages in configuration? Its a little spam for me Wink In previous version I only got errors reported.
Reply
All notification and progress bar can be disabled in addeon settings.
Reply
(2014-10-02, 19:24)Regss Wrote: All notification and progress bar can be disabled in addeon settings.

Ah ok thanks for quick reply, going to check later!
Reply
(2014-10-02, 16:58)azsenca Wrote: Hi,

I installed MovieLib on my server and everything was working fine until i added all of my movies,
I added 1009 movies and now I can't open MovieLib. It loads and loads and loads and loads and then it says ''Server timeout'' or i get a blank page.

Administration is working fine, it shows 1009 movies in overall and in movie list i see all of my movies, but index.php won't open.

I deleted all, and installed again on fresh database, and as soon as i add more than 500 movies, same thing happens.

Please help Sad

Ok, i ran benchmark on my server, and on index.php Time to First Byte is 59 secconds!

here is the output:
Quote:IP: 46.30.212.64
Location: Denmark
Error/Status Code: 200
Client Port: 64870
Start Offset: 0.318 s
DNS Lookup: 178 ms
Initial Connection: 140 ms
SSL Negotiation: ms
Time to First Byte: 58825 ms
Content Download: 167 ms
Bytes In (downloaded): 35.6 KB
Bytes Out (uploaded): 0.3 KB

Can you please help, or point me where the problem might be? I really like your script and i really need it.
Reply
Check a server access.log and error.log if you can.
Reply
error.log is clean, no errors, and here is access.log:

Quote:127.0.0.1 - - [03/Oct/2014:21:16:44 +0200] "GET /movielib/ HTTP/1.1" 200 163393
127.0.0.1 - - [03/Oct/2014:21:17:58 +0200] "GET /movielib/js/jquery.script.js HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:58 +0200] "GET /movielib/js/video.js HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:58 +0200] "GET /movielib/js/jquery-1.9.1.js HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:58 +0200] "GET /movielib/templates/default/css/style.css HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:58 +0200] "GET /movielib/templates/default/css/video.css HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:58 +0200] "GET /movielib/js/jquery.cycle.lite.js HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:58 +0200] "GET /movielib/templates/default/css/view_list.css HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:58 +0200] "GET /movielib/function.js.php?option=settings HTTP/1.1" 200 79
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/templates/default/img/bg.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_21.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_17.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_274.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_580.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_514.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_615.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_635.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_23.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_29.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_42.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_19.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_585.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_270.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_294.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_300.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_301.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_573.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_299.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_465.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_583.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_103.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_102.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_471.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_404.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_456.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_454.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_51.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_234.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_687.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_304.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_644.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_52.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_153.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/function.js.php?option=remote&f=check HTTP/1.1" 200 13
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_685.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_138.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_467.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/cache/movies_135.jpg HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/templates/default/img/flags/ac_ac3.png HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/templates/default/img/flags/vres_1080.png HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/templates/default/img/watched.png HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/templates/default/img/flags/ac_dts.png HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/templates/default/img/flags/ach_6.png HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/templates/default/img/flags/ac_aac.png HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/templates/default/img/flags/vres_720.png HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/templates/default/img/flags/vc_h264.png HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/templates/default/img/trailer.png HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/templates/default/img/flags/ach_2.png HTTP/1.1" 304 -
127.0.0.1 - - [03/Oct/2014:21:17:59 +0200] "GET /movielib/templates/default/img/flags/vc_avc.png HTTP/1.1" 304 -

I think that omewhere in index.php is the problem, as i checked on multiple servers. When you have big library it takes forever to execute script. I don't know why, maybe you could think of something. You know how your script works, and what it loads, and what utilizes CPU in your script, becouse httpd.exe is at 80-90% for about a minute when page is loading.
Reply
I checked little more, and i have found the problem. i lowered execution time to 30s and i get this error:

Quote:Fatal error: Maximum execution time of 30 seconds exceeded in /home/u914824028/public_html/function.php on line 451

That is something with function panels_array($columns, $table).

I hope we will work this out. I'm here to help you test, as i have large database.

OK, i changed:

if (!in_array($val, $panels_array[$column]) && strlen($val) > 0)

to:

if (in_array($val, $panels_array[$column]) && strlen($val) > 0)

and now everything is working fine, fast loading but ''Genre'' panel on the left is all messed up Sad
I dont know what i did, Maybe you would figure it out. Hope i helped.
Reply
Sorry to spam this, but i really want to work this out. There is a problem with strlen() becouse it is very slow on large database.

i changed this:
Quote:if (!in_array($val, $panels_array[$column]) && strlen($val) > 0) {
$panels_array[$column][] = $val;

to this:
Quote:if (!in_array($val, $panels_array[$column]) && preg_match('/^[a-zA-Z]+$/i', $val)) {
$panels_array[$column][] = $val;

Now everything is working fine, except i don't get ID's on cast members, so i can't filter by actors. For me this is not so important, but would be nice if you could think of something more.

I hope i helped... Big Grin
Reply
How many records have your database? I test it only on 1000 records.

Thanks for help.

edit:
Your preg match pattern search include only a-Z characters without blank chars (space).
A better solution will be delete this condition. It only check entries in panels is not empty.
Code will be:
Code:
if (strpos($value, ' / ') !== false) {
    foreach (explode(' / ', $value) as $val) {
        if (!in_array($val, $panels_array[$column])) {
            $panels_array[$column][] = $val;
        }
    }
} else {
    if (!in_array($value, $panels_array[$column])) {
        $panels_array[$column][] = $value;
    }
}
Reply
I have 1014 movies in database, and 604 episodes. there are in total over 15.000 actors.

Tried code you provided, but same thing happens, it loads page over 30s until first byte.
Reply
I tried adding in preg_match white space search '\s' but same thing then, loads and loads and loads and loads. So the problem must be with cast string, it is big string to work with and on every movie/episode
Maybe the best way would be to reorganize SQL database? Make a new table named 'Actors' and on each actor put movie id where that actor is acting, so on loading movie list it checks on table actors on actors for ID of that movie and show actor that has that ID ? Something like that? So we don't have on each movie one big string of actors?
Reply
Obviously the problem is with actors. I thinking about reorganize database exactly as you described. Few days ago i started to make a lot of changes in the script and improvement DB will be the next thing.
Reply
Okay, hope it will work as a charm. I'm using this: preg_match('/^[\w]+$/i', $val) now and it is the fastest and everything is working except actors.

I'm glad i could help, and looking forward to test your changes Smile
Reply
Hey,
the script work for me at the moment very well. Nice Job!
But there is one little thing that bothers me.
Can Season 0 also get an orange table header? Like Season 1, 2 ....

Greetz
Reply
  • 1
  • 18
  • 19
  • 20(current)
  • 21
  • 22
  • 45

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