Before Step 5, Lots of fopen fclose errors

Layne Smith · April 22nd, 2005, 11:56 PM

I'm getting a whole lotta "Warning" errors, like so (Please note the last one is a different mysql_fetch_row(): error):

Warning: fopen(/home/layne/public_html/forums/photopost/data/500/thumbs/index.htm): failed to open stream: Permission denied in /home/layne/public_html/forums/photopost/install.php on line 978

Warning: fclose(): supplied argument is not a valid stream resource in /home/layne/public_html/forums/photopost/install.php on line 979

Warning: fopen(/home/layne/public_html/forums/photopost/data/500/medium/index.htm): failed to open stream: Permission denied in /home/layne/public_html/forums/photopost/install.php on line 984

Warning: fclose(): supplied argument is not a valid stream resource in /home/layne/public_html/forums/photopost/install.php on line 985

Warning: fopen(/home/layne/public_html/forums/photopost/data/500/mini/index.htm): failed to open stream: Permission denied in /home/layne/public_html/forums/photopost/install.php on line 990

Warning: fclose(): supplied argument is not a valid stream resource in /home/layne/public_html/forums/photopost/install.php on line 991

Warning: fopen(/home/layne/public_html/forums/photopost/data/1/thumbs/index.htm): failed to open stream: Permission denied in /home/layne/public_html/forums/photopost/install.php on line 978

Warning: fclose(): supplied argument is not a valid stream resource in /home/layne/public_html/forums/photopost/install.php on line 979

Warning: fopen(/home/layne/public_html/forums/photopost/data/1/medium/index.htm): failed to open stream: Permission denied in /home/layne/public_html/forums/photopost/install.php on line 984

Warning: fclose(): supplied argument is not a valid stream resource in /home/layne/public_html/forums/photopost/install.php on line 985

Warning: fopen(/home/layne/public_html/forums/photopost/data/1/mini/index.htm): failed to open stream: Permission denied in /home/layne/public_html/forums/photopost/install.php on line 990

Warning: fclose(): supplied argument is not a valid stream resource in /home/layne/public_html/forums/photopost/install.php on line 991

Warning: fopen(/home/layne/public_html/forums/photopost/data/2/thumbs/index.htm): failed to open stream: Permission denied in /home/layne/public_html/forums/photopost/install.php on line 978

Warning: fclose(): supplied argument is not a valid stream resource in /home/layne/public_html/forums/photopost/install.php on line 979

Warning: fopen(/home/layne/public_html/forums/photopost/data/2/medium/index.htm): failed to open stream: Permission denied in /home/layne/public_html/forums/photopost/install.php on line 984

Warning: fclose(): supplied argument is not a valid stream resource in /home/layne/public_html/forums/photopost/install.php on line 985

Warning: fopen(/home/layne/public_html/forums/photopost/data/2/mini/index.htm): failed to open stream: Permission denied in /home/layne/public_html/forums/photopost/install.php on line 990

Warning: fclose(): supplied argument is not a valid stream resource in /home/layne/public_html/forums/photopost/install.php on line 991

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/layne/public_html/forums/photopost/forums/vb3.php on line 456

I've double checked the permissions and they all appear as 777. The recurring theme to these problems seems to be check the path, check the permissions. Is that the case here as well?

I'll keep looking for a solution while I wait ...

Thanks in advance,
Layne

Layne Smith · April 23rd, 2005, 12:09 AM

Well crap!

Guess who didn't set the permissions on the data sub-directories!?

Yup me!

Now, if I could track down this mysql_fetch_row error ...

Still looking.

Layne Smith · April 23rd, 2005, 12:12 AM

The fetch row error refers to this line:

while ( list($gid, $title, $cancontrol) = mysql_fetch_row( $readug ) ) {

Layne Smith · April 23rd, 2005, 01:25 AM

And now I'm getting a fetch array error like this at the very top of the page when I got to the photopost page ...

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in homelaynepublic_htmlforumsphotopostforumsvb3.php on line 25

And get one like this above the navbar, I htink it's called teh navbar ...

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in homelaynepublic_htmlforumsphotopostforumsvb3.php on line 54

I'm spent for this evening. Hopefully someone can help.

As always, thanks
-Layne

Chuck S · April 23rd, 2005, 08:19 AM

I would tend to think with that errror you did not input on install the correct table prefix for your vbulletin forum tables hense the error you have left.

Solution would be to run through install again and properly input the correct mysql table prefix since you already corrected directory permissions. I beleive the usual table prefix people use is either vb3_ or vb3

That can be found in your vb includes directory in the bottom of config.php

That should get ya set up.

Layne Smith · April 23rd, 2005, 11:16 AM

Thanks omegatron.

Is there a way to harcode that in somewhere?

When you say install again, does that mean I need to go back to step one and recreate my database and start over from scratch? Or can I just go back to that page where I enter that data?

Thanks,
Layne

Chuck S · April 23rd, 2005, 02:06 PM

Layne

If your familiar with phpmyadmin you can view your settings table and enter the proper forum table prefix in setting number 83 of the settings table of photopost

Otherwise you need to go through install again so you can input the proper info.

Layne Smith · April 23rd, 2005, 02:16 PM

Eeek!

Reinstall it is!

Thanks,
Layne

Layne Smith · April 23rd, 2005, 04:41 PM

Sorry, got weird line breaks on this post and half my question didn't show up so redid and posted below. Skip to next post.

Layne Smith · April 23rd, 2005, 04:43 PM

Quote:

Originally Posted by omegatron

I would tend to think with that errror you did not input on install the correct table prefix for your vbulletin forum tables hense the error you have left.

Solution would be to run through install again and properly input the correct mysql table prefix since you already corrected directory permissions. I beleive the usual table prefix people use is either vb3_ or vb3

Still getting the error. Let me see if I understand ...

1. I checked my vb includes directory and my table prefix reads ''. If it's blank in my config.php file, it should be blank in my photopost setup? Not sure if it's related, but I'm using a separate mysql database for photopost. Should I share the existing databse? I thought having a second would make it easier.

2. Noticed I didn't eneter my bb cookies table prefix after checking the config.php file. Entered that this time around, still got the original error, but I'm hoping to head off some future error.

So the error in question reads Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/layne/public_html/forums/photopost/forums/vb3.php on line 456 and is displayed at the top of Step 5.

Thanks for your assistance.

-Layne

Chuck S · April 23rd, 2005, 07:28 PM

If your table prefix is right then there can only be two other causes. You have vb2 not vb3 or in step 1 of the install you specified the wrong database info for the forum.

Layne Smith · April 23rd, 2005, 08:34 PM

Okay. As new as I am to all this I can assure you I'm definitely running vb3.

So then either ...

1. My table prefix is wrong. If the vb3 config.php file says my table prefix is blank, and by blank I mean just two '' with no space in between, what should the prefix be when configuring photopost? I assume it should be left blank.

2. I specified the wrong database info in step one of the set up. I have a hunch this the problem. In cPanel I created the database called "NAOgallery". For some reason I felt compelled to name the database "layne_NAOgallery" in step one because "layne" is my user account. I think this may be the problem. But it seems when I first tried to install photopost it wouldn't recognize only "NAOgallery" in the step 1 info entry.Is there some directory naming convention I need to be aware of?

Thanks,
Layne

Chuck S · April 23rd, 2005, 08:50 PM

In the first step of the install is the database info

In the first database settings you put the gallery database info

In the second database setting area you put the forum database info

Layne Smith · April 23rd, 2005, 09:19 PM

Ahh! So read behind me real quick

Step 1:
Path to installation:/home/layne/public_html/forums/photopost
PhotoPost Database Host: localhost
PhotoPost Database Name: layne_NAOgallery
etc...

Here' where I think I'm messing up since I am attempting to integrate. (Yeah, it says in real big letters not to do what I did!!!) But I'm still not sure what to put in these spaces
User Database Host: localhost
User Database Name: Is this the separate database that vb3 is using?
etc...

Thanks again!

Layne Smith · April 23rd, 2005, 09:34 PM

Holy crap! I fixed it!!!

For the next poor newb in my situation, that other databse WAS the separate databse vb# was using.

I'm now at Step 5 error free!!!

Onward and upward!

-Layne

Chuck S · April 23rd, 2005, 09:34 PM

Quote:

Originally Posted by Layne Smith

Ahh! So read behind me real quick

Here' where I think I'm messing up since I am attempting to integrate. (Yeah, it says in real big letters not to do what I did!!!) But I'm still not sure what to put in these spaces
User Database Host: localhost
User Database Name: Is this the separate database that vb3 is using?
etc...

YES VBULLETIN USER DATABASE GOES WHERE IT TELLS YA

Layne Smith · April 23rd, 2005, 10:28 PM

Quote:

Originally Posted by omegatron

YES VBULLETIN USER DATABASE GOES WHERE IT TELLS YA

Meow!

I've probably read a hundred of your responses. Don't recall ever seeing anyone get CAPPED!

A teary-eyed and special moment for me.

And technically, it only says "User Database Name" and not "Bulletin Board Database Name" pardon my confusion.

Seriously, thanks for you help!

-Layne

Chuck S · April 23rd, 2005, 10:42 PM

Whats Meow?

Don't tell me you think caps means I was mad.

CAPS mean BINGO you got it. Hense I quoted your reply where you answered your own problem.

Layne Smith · April 23rd, 2005, 10:50 PM

Gettin' catty!

Don't tell me all caps now means something potentially positive! I'm too old to have everyone up and changin' the rules on me like this. When I was a young 'un, all caps was a yellin'. Now it means Bingo!?

I'll never keep up.

And thanks for the BINGO then!

-Layne

Chuck S · April 23rd, 2005, 11:07 PM

LOL You think your old. I aint no spring chicken

Isnt it the kiddies who think caps mean a shout. I dont follow all that stupid jargon.