difficulties with inc_features - please help
 

To my best knowledge, everything in inc_features at my site should be ok. Photopost itself is running perfectly, but I cant't get inc_features to display pictures on a custom page.

If I run inc_features.phpo, these are the errors I get:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtual/site4/fst/var/www/html/gallery/inc_features.php on line 49

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/virtual/site4/fst/var/www/html/gallery/inc_features.php on line 63

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtual/site4/fst/var/www/html/gallery/inc_features.php on line 115


If I call inc_features from another .php page like this:

<?
include "/home/virtual/site4/fst/var/www/html/gallery/inc_features.php";

echo "$photopostfeature" ;
?>

I get a display that says "Featured Photos", but doesn't show pictures at all.
So what am I doing wrong here?

If you have the forum and photopost in separate databases you need to uncomment the mysql_select_db lines as the instructions state and point to the proper database etc so everything can be found

I don't. They are in the same database.

Okay so you say they are in the same database forum and photopost

Okay in your integration settings make sure you have the proper table prefix entered for photopost

That shouldn't be the problem either.

Forum integration works flawless. It's skinned like vb3, cookies work, everything ok. I just can't get inc_features working.

Addendum:

When I include $pohotopostfeature in the template for forumhome, it displays links with the relative path to picture and the name of the one who posted it, but no picture (no thumbnail).

Well obviously you have changed something if your not getting mysql errors now. I need you to post a url so I can see what your doing more than likely in your config-int.php INTEGRATION OPTIONS you have the data url set incorrectly if it is not displaying pictures

Mailed you my config-int.php and the url. Thanks in advance.

Bernhard

OK, so the inc_features.php file is what folks are using to display a picture(s) on their home page, or any other page in their site - correct? looking at the code it appears that you have a choice between random, most_view, latest for what you want to show. is there a way to display the latest picture in a particular category? I have a category on my site/gallery called Cover Shot. I want to always display the latest shot from that category on my home page plus it's title and description. I'm sure I can write something to do this, it's hardly rocket science, but it would be nice if this were already done & I'm lazy.

thanks...

change this say

AND p.cat !=500

to say

AND p.cat=521

where 521 is the cat you want to pull from