PhotoPost Community - mysql array and stripped slashes error

PhotoPost Community (http://www.photopost.com/forum/)

- Photopost Pro Installation & Upgrades (http://www.photopost.com/forum/photopost-pro-installation-upgrades/)

- - mysql array and stripped slashes error (http://www.photopost.com/forum/photopost-pro-installation-upgrades/113458-mysql-array-stripped-slashes-error.html)

mysql array and stripped slashes error

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.

Quote:

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. :confused:

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.

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

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

And here is my config-int

Quote:

// 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?

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.

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.