View Full Version : Warning: pp-inc.php on line 4611
October 29th, 2012, 02:01 PM
Just upgraded to 8.2 and this is at the top of all pages. Double checked the files. Cannot get into adm now.
Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in [path]/hdgallery/pp-inc.php on line 4611
October 29th, 2012, 02:33 PM
Have you ran all required upgrades?
Basically your error tells me you have not ran the upgrades. Most likely the upgrade 8.0 to 8.x upgrade
October 29th, 2012, 03:00 PM
Dang, I thought I was upgrading from 8.1 but it looks like it was 8.0.
That solved that error, now I just cant get into the admin site. I will pm you the logins.
on another note, is there a way to make the adm-index load without performing all of those statistics queries? At 800K pics it thrashes my server each time I, when I can, load the page.
Thanks again for the help,
October 29th, 2012, 03:03 PM
$datadirlen = dirsize($Globals['datafull']);
Comment out that line with // and then it will not stat the data directory and should load quick.
October 29th, 2012, 03:11 PM
I reached your admin without any problem so commenting out that line should make it load lots quicker your probally timing out trying to stat the directory.
Just an FYI also your forum login is extremely slow and at one time even timed out. This of course since I was logging in using your forum login prompting was not a galery issue so just thought I would bring that up since you seem to be having connection issues across the board.
Also make sure once you make things active you need to redo the plugins as well as that was also in the documentation and I figured you most likely overlooked that as well.
October 29th, 2012, 05:43 PM
That did it, thanks!!
Not sure what is up with the server, its dedicated. I have been optimizing it all day. I removed noatime and that was a huge boost earlier. They are bulking up the ram tonight, well see.
Thanks again for everything,
October 29th, 2012, 05:56 PM
Yeah the gallery loaded fine and was fast when I looked it was just the forum login which took forever. trying to stat a directory as huge of yours would take alot of time so that edit does indeed speed up admin.
You still do not have your plugins for vb4 redone or active or something so you have no menu system.
October 29th, 2012, 08:06 PM
You are gonna laugh but which file do I need to edit that line out?
I think my problem is io and ram. Both are not doing so well in the mysql dept. I have asked to upgrade the ram and and a second hd so I can move the mysql tables there.
October 29th, 2012, 08:11 PM
We where talking the adm-misc.php file so that is the line I am talking about.
Just make sure before you open things up to redo the xml plugins for vbulletin.
October 29th, 2012, 08:39 PM
Ah, ok, thats what I thought, still slow for some reason. Dont worry about it for now. Once I get the new drive in and tables moved I will look deeper. They are in Phillly so I may have to wait for Sandy :(
Check on the plugin and thanks!
October 29th, 2012, 08:55 PM
Yes I am about an hour and a half south of Philly just north of Baltimore so we are just sitting here relaxing waiting for the storm to pass.
October 30th, 2012, 01:47 PM
Made it through the hurricane here never lost power.
Let me know how things work out after your server changes. You do probally have the single biggest gallery I have ever seen. ;)
October 30th, 2012, 09:56 PM
Thank goodness man! I saw all of that. I am glad I am here in Texas. We don't have vegetation, water, many trees but at-least we don't have that! Of course if we did it would be bigger.....
On the subject. I did comment out (actually removed it too) but the page still causes the mice that run my server to have cheese embolyisms. Is there anything else I should remove? Or force that middle page to just be blank? I have never seen it so I dont think I am missing much lol
P.s. Upgraded the ram to 16gb and the server is much better. May need to go higher.
October 30th, 2012, 10:00 PM
I would need to know what your server is bulking down on to make a suggestion. No ideas here as aside from trying to stat that data directory I do not see anything that is of any huge load in the admin panel.
October 30th, 2012, 10:24 PM
Its no big deal really. Is there a way to just force a black page in the center frame instead of that one?
October 30th, 2012, 10:30 PM
Nevermind! I got it. Just made the center frame link blank and now all is well :) no more cheese embolyisms lol
October 30th, 2012, 10:36 PM
LOL well more of a lets see what the issue is and fix it type guy here.
October 30th, 2012, 10:45 PM
I understand, I ahve so many things to fix and so littl etime I take the victories when I can :) : ) :)
you are more than welcome to tear into the site and look. I am trying to post the few things I have found in different threads and then move on. Gaah. I am so out of practice.
October 30th, 2012, 10:54 PM
Yeah well I can not comment about your server issues without you investigating your server error logs and telling me what it is crapping out on. ;)
October 30th, 2012, 11:17 PM
Sorry, I am pretty dense :)
Nothing as far as the admin. These are the only pp related ones in the past few hours:
[Tue Oct 30 22:34:59 2012] [error] [client 220.127.116.11] File does not exist: /home/members/public_html/hdgallery/images/buttons, referer: Trackpads Military Photo Gallery - Trackpads Photo Gallery (http://members.trackpads.com/hdgallery/index.php)
[Tue Oct 30 22:24:24 2012] [error] [client 18.104.22.168] File does not exist: /home/members/public_html/hdgallery/images/buttons, referer: Trackpads Military Photo Gallery - Trackpads Photo Gallery (http://members.trackpads.com/hdgallery/)
[Tue Oct 30 22:24:22 2012] [error] [client 22.214.171.124] File does not exist: /home/members/public_html/hdgallery/css.php, referer: Trackpads Military Photo Gallery - Trackpads Photo Gallery (http://members.trackpads.com/hdgallery/)
[Tue Oct 30 22:00:39 2012] [error] [client 126.96.36.199] File does not exist: /home/members/public_html/hdgallery/stylesheets/images/blank.gif, referer: http://members.trackpads.com/hdgallery/stylesheets/lightbox.css
October 30th, 2012, 11:22 PM
Yeah nothing really that I can see there. That seems to be related to maybe some relative vbulletin image links.
November 2nd, 2012, 12:07 AM
Its ok, I am good now. I just need to beg enough money to up the ram to 32gb. I dont think 16 is going to be enough.... grr..
November 2nd, 2012, 11:24 AM
You do have a huge site so much more than any site I have ever seen forum or gallery.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.