mysql array and stripped slashes error

[MortysTW]

I've got the latest version of vB and photopost as of 3 days ago.

Installation appears to have gone fine on the photopost along with the integration except for this error.

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

I've read and read a bunch of posts on here and people seem to have similar errors but not exactly mine. Or at least the one's I have read.

1) What the heck is causing all my slashes to be removed from that error?
2) I'm guessing I need to do something in phpMyAdmin to edit some db table but can't sort out which table. I made sure config-itc and -int had the correct info, then I looked at the db for the pp_settings and made sure that had the right info. I'm still at a loss.

Mind you I'm not very good at php so maybe its right in front of me and I just don't see the error.

My gallery can be found at www.MortysTwistedWorld.com/gallery

Also, when I try to log into /gallery/adm-index.php I get redirected to the gallery/index.php page. I'm assuming that's an error correct? Or have all the editing permissions been integrated into my vB admin panel also now?

Thanks for any help.

[MortysTW]

Another thing, that homevirtualsite68fstvarwwwhtmlgalleryforumsvb3.php should actually not have the "site68" in it. Should read something more like /home/virtual/mortystwistedworld.com/var/www/html/gallery/forums/vb3.php

Not sure what file is telling it to use the site68 or what db table.

[b6gm6n]

Hi..

I would recheck your vbulletin path in config-int
also whats your vbulletin database table prefix? make sure this is set correctly in the setup/install of photopost

-T

[MortysTW]

As for the vb_ database prefix name, how do I edit it now that PhotoPost is already installed?

And here is my config-int

// We need to know the server paths to both your vB installation and your PhotoPost installation
$vbpath = "/home/virtual/mortystwistedworld.com/var/www/html/forums";
$pppath = "/home/virtual/mortystwistedworld.com/var/www/html/gallery";

// We need the URL path to your PhotoPost and vb installation
$url_path = "http://www.mortystwistedworld.com/gallery";
$vb_urlpath = "http://www.mortystwistedworld.com/forums";

// The URL of your photo dir where your images are stored (with / at end)
$data_dir = "http://www.mortystwistedworld.com/gallery/data/";

// If your PhotoPost tables have a prefix, put it here
// Example:
// pp_ = "pp_";
$pp_db_prefix = "pp_";

// If you use the mobile phone integration, set this variable to the CatID for the gallery
define( MOBILE_CAT, -1 );

Any other ideas?

[Michael P]

Well, the error is giving you the path to the file which it is executing, however the error it is showing is saying that it cannot query the vb3 user database. I would check your config-inc.php settings to be sure that you have the vB3 user database set properly for the variables:

$host_bb="localhost";
$database_bb="photopost";
$user_bb="root";
$password_bb="";

If you look at vb3.php at line 25, you'll see the simple SELECTs on the vb3 database are failing.

[MortysTW]

I deleted, reinstalled, deleted, reinstalled, and as far as I know, I never changed anything. But the installation finally went clean. So all is well now.

Thanks.