Fresh Install Problem - Assistance Required

[japhi]

Hi,

I am getting the following error during install of version 4.8.2 :

[Edit]

Okay, I now have the program installed but can't access the admin panel. I log in as the admin (from my forum) and get this page:

http://huntshoot.coastangler.com/mem...lery/index.php

It doesn't send me to the admin panel just to the main page. Looking at the main page is I can only assume something went wrong with the installation.

When I log in it says "thanks for logging in, hold on" as if it is connecting with my VB3 forum, but when I'm redirected to my gallery page it shows '1 unregistered user' browsing the page. So, my VB DB isn't talking to my Photopost DB.

Any ideas?

[Chuck S]

I would download 4.8.6 as 4.8.2 has not been available for awhile and do a reinstall and make sure you enter the correct database info

You also have not entered the correct server path to the Photopost files

In your config file you should have this

$PP_PATH="/home/coastang/public_html/huntshoot/membergallery";

[japhi]

Okay, so I reinstalled and once again it said the install was a success, but I still can't access my admin panel and I am getting MySQL errors at the top of the page:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/coastang/public_html/huntshoot/membergallery/forums/vb3.php on line 267

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/coastang/public_html/huntshoot/membergallery/forums/vb3.php on line 25

Line 25 in vb3.php is :

$results = mysql_fetch_array($queryv);

Not sure why this install is so difficult - vb3 is a breeze and so was Gallery. I've been screwing with this PhotoPost install for 6+ hours now!

Please advise how I can solve these errors?

[Chuck S]

Well I can tell you that if you install things correctly you have no errors.

From what your telling me your issues are I can tell you your errors are the following

1. You have incorrectly on setup specified your VB3 table prefix

2. You have not properly set your VB cookie settings upon install when Photopost asked you to enter your vb cookie path prefix domain and such

[japhi]

I have checked my cookies and they should be fine ( / , bb , .huntshoot.coastangler.com )

Also, the table prefexes are all set to PP. My ppusers and ppusergroups tables are empty though.

The error is related to these pieces of code:

list( $cookuser ) = mysql_fetch_row($results);

$results = mysql_fetch_array($queryv)

Not sure what do do, I've been pouring over old posts the past 2 hours.

[Chuck S]

I have already answered this but let me see if I can make this clearer

.huntshoot.coastangler.com??? WRONG

1. your cookie domain setting for Photopost should be blank just like your VB cookie domain is in their admin section

2. You did not enter the table prefix of VB3 correctly upon your install. Most likely you have a table prefix of vb3_ but you can open your Vb3 config.php file and check. You can alter this in your Photopost settings table line 83

Of course installing VB3 was a snap cause you did not have to think or answer any specific questions. Installing our program and integrating with another program requires the knowledge that you know specific things about how Vb was installed database settings cookie settings etc. If you answer any of these install settings incorrectly you will have issues.

[japhi]

Okay, so I found out that I didn't have any prefix in VB3 so I've made that change to my settings file. The error messages are gone and it is recoginizing my users. Yay, progress.

My last problem is I can't access the admin panel, I am not recognized as an Admin. From reading old posts I'm assuming it has to do with my usergroups? I deleted all the inserts in ppusergroups and copied the usergroups from VB to my ppusergroups table and voila, another error message. One step forward, two steps back.

http://huntshoot.coastangler.com/membergallery/

My question is this - how do I get my inserts in ppusergroups 'right'?

[Chuck S]

Just empty the usergroups table for Photopost and do this sql in phpmyadmin

INSERT INTO usergroups VALUES (6,'Administrator',1,1,1,1,'','','',1,1,1,0,0)

make sure to add any table prefix to photopost

[japhi]

Edit: Finally in!

[Chuck S]

LOL I was able to say if you added that insert and was logged in as an admin you should definately be in

glad your set

[japhi]

Yup, playing with it now (the forum that is).