Umm...I missed something when trying to integrate VB3 - inc.features.php error

ArchangelX · February 11th, 2006, 05:17 PM

I was trying to integrate Photopost into VB3...it worked fine after the installation...when separated...but after I made the changes to the inc.features.php, inc.photopost.php, and FORUM template files...I got this error:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /photopost/inc_features.php on line 54

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /photopost/inc_features.php on line 119

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /photopost/inc_photopost.php on line 107

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /photopost/inc_photopost.php on line 118

Did I do something wrong? How can I fix this...separately, the forum works fine, the photopost works fine, and I can long in and administrate...but I'm obviously doing something wrong? Any help would be appreciated...this is my first time to mess with anything close to this nature. See the attached image for what it really looks like.

Also...although I have photos installed, I'm getting nothing under the photo galleries headers at the top of the page. I'm assuming that the above problem has something to do with it.

Thanks.

ArchangelX · February 11th, 2006, 05:34 PM

EDIT: I had a problem with not being able to upload, but I fixed it. I didn't realize you had to set permissions for every single group...wow...lotsa control...neat. But I still have the problems up there...any ideas, thanks?

ArchangelX · February 11th, 2006, 06:14 PM

I took a look at the problem areas...the ones that were showing errors, and I honestly have no clue what's wrong...

For the first error...the line is:
while ( list( $catugid, $ugnoview ) = mysql_fetch_row($resultb) ) {

The second error line is:
while (list($pid,$puser,$puserid,$pcat,$photo,$height,$width,$catname,$cphotos,$cposts) = mysql_fetch_row($result)) {

The third error line is:
while ( $categories = mysql_fetch_row($boards) ) {

The fourth error line is:
mysql_free_result($boards);

So...do I have whatever the "$result" and "$boards" variable is...do I have it defined wrong or something? Thanks!

Chuck S · February 11th, 2006, 10:26 PM

Well if the file worked before you started changing it upload a clean one and in Admin => Edit Integration make sure your photopost table prefix is in there then if your photopost and forum databases are separate you need to follow the instructions here to edit the proper things in the file to connect.

PhotoPost Enhanced vB3 Index Integration

ArchangelX · February 11th, 2006, 10:51 PM

Thank you for your response Chuck, I appreciate a lot.

Well...what I mean is that the two programs worked separately...and they still do...only when I went to edit the files to integrate it with the main index (using the thread that you just linked me to), i end up with that mess at the top, and no visible photos on the main index forum page.

I went back in and rechecked everything about 20 times (give or take...I've been working on this specific problem all day), and it's all the way it was to be detailed in the instructions. Also, the pp_ prefix is listed in the database.

My databases aren't separate either, they're within the same database. I had no problems installing it...grrr.

*sigh* I'll recheck it again...

Chuck S · February 11th, 2006, 11:09 PM

If your databases are not separate then just upload a clean file. Make sure your proper prefix for photopost tables is in admin edit integration settings include the file via the instructions or if running vb 35 make a plugin and in the forumhome template include the $photopostfeature string thats it.

ArchangelX · February 11th, 2006, 11:12 PM

Okay...when you say upload a clean file...which file do you mean? I'm sorry...I'm really new to this...if this doesn't go right tonight, I'll probably just have Photopost do the install. But I hate not knowing how to do things...

I don't know how to make a plug-in...so I'm not going to touch that, probably, I don't mind editing it by hand.

Thanks.

Chuck S · February 11th, 2006, 11:29 PM

Upload a clean inc_features.php

Here is the plugin

http://www.photopost.com/forum/showthread.php?t=122207

ArchangelX · February 11th, 2006, 11:31 PM

Thank you very much for your help...it means alot. I'll try that now.

ArchangelX · February 12th, 2006, 12:22 AM

Alright...I tried it...but I'm still getting the same error.

Chuck S · February 12th, 2006, 05:24 AM

Then your not following one of the instructions clearly here. You tell me the applications are in the same database then follow this post.

Umm...I missed something when trying to integrate VB3 - inc.features.php error

ArchangelX · February 12th, 2006, 01:31 PM

It's okay Chuck...I don't really have much more time for this...I manage four other websites, along with producing videos, pictures & articles-content for them, so I think it's better if I just have someone else do it for me. Thanks and I appreciate the help.