line 2786 error

pfdwebgal · May 16th, 2005, 02:35 PM

After upgrading to 5.03, I get this message:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/shelley/domains/picketfencedesignsforums.net/public_html/gallery/pp-inc.php on line 2786

what is this wanting to know?

b6gm6n · May 16th, 2005, 07:57 PM

Hi..

Was this an upgrade from an older version of photopost? - i mean a really old version of photopost?, looks like theres some table entries missing for the new query... i'll look into this and report back.

-T

pfdwebgal · May 16th, 2005, 08:24 PM

it was an upgrade from 4.86

Chuck S · May 16th, 2005, 10:05 PM

Looking at the line in 5.03 which has nothing to do with a query the only guess to venture is you did not update all the files. Try uploading from 5.03 a new pp-inc.php file.

pfdwebgal · May 17th, 2005, 10:47 AM

I did try that. I went ahead and re-uploaded all of the files again this morning and I am still having the same issues.

Chuck S · May 17th, 2005, 10:55 AM

Might I suggest you try deleting pp-inc.php on the webserver and then reupload it.

Line 2786 is not a mysql query line and in Photopost 5.03 is within the login function that only gets called when a user is on the login screen so your file has to not be getting updated when you try and upload it.

pfdwebgal · May 17th, 2005, 11:13 AM

ok...did that...still getting that error; still can't get to the admin panel

Chuck S · May 17th, 2005, 11:39 AM

Okay what is line 2786 for you in pp-inc.php?

Have you ran all the upgrades from upload.php?

That will tell me alot here. The error on your site if the file is correct should not be there. I just did a phpbb install about 15 mins ago.

pfdwebgal · May 17th, 2005, 11:56 AM

what if I just delete the whole dang thing and start over? Will I lose my data tables if I do that?

Chuck S · May 17th, 2005, 12:25 PM

Yes you will.

The point I am trying to make is with the error your getting the line number does not match any mysql queries so your file would appear at least to me to be old.

If you tell me what line 2786 is in your file we can move forward from there.

pfdwebgal · May 17th, 2005, 12:51 PM

i am trying to figure out how to find that line. i don't have anything that has numbers on it....

Chuck S · May 17th, 2005, 01:07 PM

A good tool to use would be beyond compare from scootersoftware.com

pfdwebgal · May 17th, 2005, 05:01 PM

this is what I got from my server guy...

Here is that line and several around it for context:

2780 if ( $xloop == 0 ) {
2781 $Globals['cats'] = array();
2782 $query = "SELECT
id,ugnoupload,ugnoanno,ugnoview,ugnopost,ugnovote,password,watermark,cat
type,catname,parent,childre
n,thumbs,canzip,moderators,header,footer,headtags FROM {$Globals['pp_db_prefix']}categories";
2783 $resultb = ppmysql_query($query,$link);
2784
2785 // need to do this loop for each group user is a member
of
2786 while ( $row = mysql_fetch_row($resultb) ) {
2787 $arraykey = $row[0];
2788 $Globals['cats'][$arraykey] = $row;
2789 }
2790 }
2791
2792 foreach( $Globals['cats'] as $key => $value ) {
2793 list( $catugid, $ugnoup, $ugnoanno, $ugnoview,
$ugnopost, $ugnovote, $cpass, $cwatermark, $cattype, $catname, $catpa
rent, $children, $catthumb, $catzip, $mods, $header, $footer, $headtags ) = $value;
2794 $noupload=0; $noann=0; $noview=0; $nopost=0; $novote=0;

Chuck S · May 17th, 2005, 05:34 PM

Okay you did not run your upgrades.

I did not want to run all way through them not knowing what you ran. Open up your board so I can see what it looks like and then we can run the other upgrades. your error should be gone.

pfdwebgal · May 17th, 2005, 07:45 PM

open up the board? the url is www.picketfencedesignsforums.net/gallery . LMK what else you need if you need anything else...

Chuck S · May 17th, 2005, 08:06 PM

The boards are temporarily down for maintainence. PM me the admin login

pfdwebgal · May 18th, 2005, 12:37 AM

you are awesome....

when I tried to rebuild the thumbnails I get this now:

Warning: getimagesize(/home/shelley/domains/picketfencedesignsforums.net/public_html/gallery/data/500/always_dance.jpg): failed to open stream: No such file or directory in /home/shelley/domains/picketfencedesignsforums.net/public_html/gallery/image-inc.php on line 215

Warning: copy(/home/shelley/domains/picketfencedesignsforums.net/public_html/gallery/data/500/always_dance.jpg): failed to open stream: No such file or directory in /home/shelley/domains/picketfencedesignsforums.net/public_html/gallery/image-inc.php on line 261

Warning: Division by zero in /home/shelley/domains/picketfencedesignsforums.net/public_html/gallery/image-inc.php on line 288

and this error message:

Error creating thumbnail! Error code: 1

Command:

"/usr/bin/mogrify" +profile "*" -size 0x100 -quality 70 -geometry 0x100 '/home/shelley/domains/picketfencedesignsforums.net/public_html/gallery/data/500/thumbs/always_dance.jpg'

Chuck S · May 18th, 2005, 07:51 AM

You tried rebuilding thumbs without finishing the upgrade per the upgrade instructions.

You need to restore the photos table and run through the upgrade script again. Only run step3 of upgrade 486 ONCE.

pfdwebgal · May 18th, 2005, 08:58 AM

i tried to upload some of the photos again and get this error:

Warning: copy(/home/shelley/domains/picketfencedesignsforums.net/public_html/gallery/data/500/thumbs/BLbazziladdict.gif): failed to open stream: Permission denied in /home/shelley/domains/picketfencedesignsforums.net/public_html/gallery/image-inc.php on line 261

and this:

Error creating thumbnail! Error code: 1

Command:

"/usr/bin/mogrify" +profile "*" -size 100x33 -quality 70 -geometry 100x33 '/home/shelley/domains/picketfencedesignsforums.net/public_html/gallery/data/500/thumbs/BLbazziladdict.gif'

Chuck S · May 18th, 2005, 09:33 AM

Are you restoring your old table to get the photos back?

Looks to me as if your data subdirectories are not set to 777