Upgrade from 6 to latest - problem with inc_features.php on home page

[cobradude]

After the upgrade, my homepage just displays this when I try to show the random pics as I always have:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in F:\Inetpub\wwwroot\clubcobra\photopost\inc_features.php on line 67
Table 'clubcobra.photos' doesn't exist

When I change to the old inc_features.php my page displays at least but where the random pics are I just get:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in F:\Inetpub\wwwroot\clubcobra\photopost\inc_features.php on line 67

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in F:\Inetpub\wwwroot\clubcobra\photopost\inc_features.php on line 143

Any help would be appreciated. Thanks.

[Chuck S]

If you overwrote your file have you reedited that file and uncommented the $link and mysql_select_db lines and filled them out with the proper info?

[cobradude]

I'm using the same db for both photopost and vb. I didn't have those lines uncommented before or on my other sites.

[Chuck S]

clubcobra.photos

Okay then so do you have a table prefix on your photopost tables and forgot to enter it in edit integration settings under admin?

[cobradude]

Just double checked. The pp_ is in there appropriately. The photopost site Main Index - Club Cobra Photo Gallery works fine...Just have the problem on my home page clubcobra.com where I had random pics showing. Right now I have the old inc_features.php in there so the page at least loads with a couple of errors. The new inc_features.php breaks the whole page with the error noted above.

Thanks for your help by the way.

[Chuck S]

The inc_features.php is an enclosed file so you need to set things correctly

1. In the edit integration settings in admin you must have properly entered the correct table prefix for your photopost tables.

Based on the error your posting that it is looking for the photos table not pp_photos table then your settings have to be off.

[cobradude]

When in the admin mode and looking at edit config, it shows: PhotoPost Database Prefix (cannot be changed once set) pp_

When I opened config-int.php I did miss $pp_db_prefix = "";

Thanks for the help it's working now.

[Chuck S]

You can edit config-int.php by Admin => Edit Integration which is what I was posting. It appeared you kept going to edit config

[ttnb]

I have the same problem. I can go to photopost main but when I go to my forum I have this problem on inc_features.php on line 67.

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/myaccountname/public_html/photo/inc_features.php on line 67
Table 'vb_databasename.pt_photos' doesn't exist

How can i fix?

Edit:
I fixed it!

[Chuck S]

http://www.photopost.com/forum/photo...3-5-3-8-a.html

This is the instructions for that little mod.