[dutchbb]

Originally Posted by The M.I.P.

In inc_features.php, there's no DB resource identifier used when accessing the database. In this case, PHP uses the last DB link which normally is vBulletin's database, but when using phpAdsNew integration, this might be the phpAdsNew database.

Solutions (untested, as I don't have access to Photopost):
Use a separate DB connection for the Photopost stuff as mentioned in the comments in inc_features.php.
Or add vBulletin's DB resource identifier to the mysql queries:

--- inc_features.php.orig	Mon Nov 21 11:54:09 2005
+++ inc_features.php	Mon Nov 21 11:56:21 2005
@@ -49,7 +49,7 @@
     }     
     $grouparr = explode( ",", $mygroups );
     
-    $resultb = mysql_query("SELECT id,ugnoview FROM {$pp_db_prefix}categories");
+    $resultb = mysql_query("SELECT id,ugnoview FROM {$pp_db_prefix}categories", $db->link);
     $ViewPerm = array();
     while ( list( $catugid, $ugnoview ) = mysql_fetch_row($resultb) ) {
         $noview=0; $ViewPerm[$catugid] = 1;
@@ -112,7 +112,7 @@
                         WHERE c.cattype = 'c' AND p.cat != 500 AND p.storecat = 0
                         ORDER BY RAND()";
 }
-$result = mysql_query($query);
+$result = mysql_query($query, $db->link);
 
 $counted = 0; $countcol = 0; $featured = "";

Thank you

I get this when I replace/add that code:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/xch1295/domains/mydomain.com/public_html/gallery/inc_features.php on line 51

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/xch1295/domains/mydomain.com/public_html/gallery/inc_features.php on line 53

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/xch1295/domains/mydomain.com/public_html/gallery/inc_features.php on line 114

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/xch1295/domains/mydomain.com/public_html/gallery/inc_features.php on line 118