PhotoPost 4.86 & VB 3.0.5 Integration with some errors.

Pinpoint · January 8th, 2005, 04:39 PM

Greetings all,

I am trying to do a fresh install with VB 3.0.5 that was just released. And I wanted to get Photopost 4.86 running as well the install seems to go well, untill I finnish the install script and attempt to log in.

When i click on the link to goto the Admin login area, I am confronted with this error.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/skywarriors.net/httpdocs/photopost/forums/vb3.php on line 25

looking at the script on line 25 of the vb3.php it states the following code.

Code:

Content visible to verified customers only.

I still have access to the login blocks below this error to try to log in, when I attempt to do so, I get this error.

Warning: chdir(): SAFE MODE Restriction in effect. The script whose uid is 10167 is not allowed to access /usr/local/psa/home/vhosts/skywarriors.net owned by uid 0 in /usr/local/psa/home/vhosts/skywarriors.net/httpdocs/photopost/header-inc.php on line 110

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/skywarriors.net/httpdocs/photopost/forums/vb3.php on line 25

The script appears to be working and I get this message in "My Photo Gallery Message" box:

Invalid login. Please check your username and password, or register.

The code for the header-inc.php on line 110 reads (on my script, mind you I have not made any edits on this)

Code:

Content visible to verified customers only.

Whats going on with this? Is this some sort of problem thats cropped up with the latest release of vb 3.0.5?

Any help would be really appreciated here

my website is http://www.skywarriors.net/forums/index.php
and my error is showing up at this link: http://www.skywarriors.net/photopost/login.php

Many thanks in advance
Pinpoint

MojoNixon · January 8th, 2005, 04:56 PM

Hi,

turn the safe mode off... or change the rights to the executing user...i guess you installed it with root acess.

What about the "." in your url ..maybe it makes some trouble.

i have 3.0.5 too and installed the Photopost today to it... it just works ..but with some problems. ;-)

Pinpoint · January 8th, 2005, 05:21 PM

Many thanks Nixon to your quick reply, do you mean the Skywarriors.net in the full paths? Is that what you mean by the "."?

MojoNixon · January 9th, 2005, 02:11 AM

yes..maybe its the cause for your problem.

Interdit · January 9th, 2005, 04:39 AM

Hello,

The dot should be ok, try safe mode off first

In php.ini if it's your server, or ask your host.

Interdit

Chuck S · January 9th, 2005, 09:21 AM

Yep as Interdit states turn off safe mode as one of our program requirements is safe mode off. You will never be able to have users upload with safe mode on.

As far as mysql errors have you ran the upgrades? Do you get that error if the VB integration is off and your just authenticating against the user database?

Michael P · January 9th, 2005, 09:23 AM

> You will never be able to have users upload with safe mode on.

I believe that you can make PhotoPost work with safe mode enabled, it just requires some specific configuration of your server to make sure that the program can accept the files and has the permissions it needs to move them around.

Chuck S · January 9th, 2005, 10:02 AM

Well from my knowledge with safe mode a couple things needs to happen

1. You must use GD

2. Forget about header includes and such is not going to happen with safe mode on.

3. Everytime a new user registers you must create there upload directory. This way they can upload.

It gets more complicated than this obviously but those are the basic things.

Pinpoint · January 11th, 2005, 11:58 PM

Many thanks folks,

I have had my Domain host change the permission settings, and things seem to be working ok. The Photopost is actualy working, however I can't log into my admin area, at least it does not appear to me. I am speaking about the adm-index.php this brings up the login box once more, but there is no page to change anything it sort of cycles me back as a standard user would see things.

Any ideas why its doing this?
http://www.skywarriors.net/photopost/adm-index.php

I log in, it states that I am successfull then it brings me back to the standard index page not the admin page.. Or am I missing somthing here?

http://www.skywarriors.net/photopost/index.php

(( Update: And apparently I am not able to upload as I don't have any permissions to do so, even though I am the admin?? )) Help

Many thanks for everyones help with this wonderfull program!
Pinpoint

Chuck S · January 12th, 2005, 08:48 AM

Okay we put in 4.8.6 a checkgaurd to ensure users can login with vb in this version to prevent the initial cookie mistakes admins make when installing things.

Basically if your using the vb integration we use the vb cookie settings. However when using the admin section this assumes you set the proper cookie settings to being with as we do not load the vb cookie settings for admin area since vb header does not load there.

You would need to edit your mysql settings table and check settings 171-173 to ensure they are the correct settings. Number one mistake is the cookie prefix is not set to bb

Pinpoint · January 12th, 2005, 10:55 AM

Many thanks omegatron,

I am a bit lost here, WHERE do I make this check for my settings at?

Am I wrong to use the default settings, as I never added a Cookie function durring my vbulletin install. I simply used the default settings which were the default "Blank" settings thus this is the bb your asking about?

Sorry, I am still a bit lost in mysql, and I am not quite sure what your telling me will resolve this. When I log into my Vbulletin, it knows I am the Admin, as well as when I log into the vbportal, it too knows I am the admin of the site. I am using the same DB for Photopost, as I am for Vbportal, and Vbulletin.

I am confused why photopost does not identify me, but it knows my user name, which is correct, it's just not thinking that I am an admin, with no permissions.

Many thanks for helping me!
Pinpoint

Interdit · January 12th, 2005, 12:54 PM

Hello,

If you an admin panel (such as cpanel) check in the mysql part and find the phpmyadmin tool.
Check in the settings table as Omegatron says id 171-to 173 to match the settings: cookie prefix forum: edit it and in the setting field put bb.

Later,
Interdit

Pinpoint · January 15th, 2005, 01:16 AM

Many thanks Interdit,

Mind you I have never used the phpMyAdmin tool before. I am looking at the setting for VBulletin, I don't see the varname for a Cookie prefix forum:

As well as I have no clue how to search an id of 171 - 173 with this tool. I am using phpMyAdmin 2.2.6 and my settings table shows the following:

# Table structure for table `setting`
#

CREATE TABLE setting (
varname varchar(100) NOT NULL default '',
grouptitle varchar(50) NOT NULL default '',
value mediumtext NOT NULL,
defaultvalue mediumtext NOT NULL,
optioncode mediumtext NOT NULL,
displayorder smallint(5) unsigned NOT NULL default '0',
advanced smallint(6) NOT NULL default '0',
volatile smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (varname),
FULLTEXT KEY varname (varname),
FULLTEXT KEY grouptitle (grouptitle)
) TYPE=MyISAM;

I have only Browsed around to look at files and not change anything. I can't see anything about a 'cookie prefix forum', in order to edit it to put the field setting to say bb.

Is there any other way to make this edit? Like I said, I have never used phpmyadmin tool, and as you can guess its real new to me, so I am clueless for this level of looking around.

There is a pp_settings table, which I assume looking at that will not help, but I simply don't see the cookie prefix forum in order to make any changes..

Or am I looking in the wrong spot?

Pinpoint

Quote:

If you an admin panel (such as cpanel) check in the mysql part and find the phpmyadmin tool.
Check in the settings table as Omegatron says id 171-to 173 to match the settings: cookie prefix forum: edit it and in the setting field put bb.

Interdit · January 15th, 2005, 03:38 AM

Hello,

First you need to look in the settings table of photopost not vbulletin.
Ok I made screenshots of the steps... tell me if you did follow me

http://valve.be/movies/pinpoint.swf

As you have 4.8.6, if you don't find id 172, that means that something wrong happened during the last upgrade.

I think i saw a thread of Omegatron or Michael telling that there will be a field for the cookie in the admin area settings, it will be for the next version.

If it's not possible to get it working, you can buy a installation script or upgrade package from photopost.

Later,
Interdit

Pinpoint · January 15th, 2005, 04:41 AM

Very impresive Flash Movie Interdit! (what program did you use to make that?)

Ok, back to photopost with some minor diffrences in the screenshots, I was able to do as you instructed (see the attached image of my settings). I saved and exited phpMyAdmin. I went back to my photopost site, and cleared out my cookies. I then re-logged in, as my user account.

I attempted to goto my Admin section of Pp. Logged in, Password, and then nada.. right back to my index.php.

So I am back to square 1. My VBulletin knows I am an admin, My VBPortal does too, Photopost does not..

Any other suggestions?? Reinstall the script?? Or perhaps somthing else that I missed?

Btw: thanks for that Flash movie, that was fantastic!

Pinpoint

Interdit · January 15th, 2005, 04:48 AM

Hello,

Yes it's a nice way to how explain how to

, it was done with build demo.
Maybe Photopost should do a serie for their soft... for V5.0 for example.

Anyway, so your problem, can you check as well in phpmyadmin if your usergroup table (photopost one) is empty or not ?

If it's empty, execute the mysql command:
INSERT INTO `pp_usergroups` VALUES (6, 'Administrators', 1, 1, 1, 0, 0, 1, 1, 0, 0, 0, 0);

Then try to log in again, if it's successful, go to your pp admin area and refresh the usergroups, then you are done.

Later,
Interdit

Pinpoint · January 15th, 2005, 05:02 AM

Interdit,

I have added those values [VALUES (6, 'Administrators', 1, 1, 1, 0, 0, 1, 1, 0, 0, 0, 0);] Manualy, saved and exited, returned to the photopost, cleared out my cookies, logged back in, and it still takes me back to the index.php.

I cant get into my admin area at all. I even tryed to see if it was accessing my login name, I logged with my user name but entered the wrong PW, it KNOWS that its wrong and would not allow me access. Since I am the only user at this time. I can't seem to get this to recognize me as an Admin (user group 6) for Photopost.

Any other thoughts?

Pinpoint

Interdit · January 15th, 2005, 05:04 AM

Hello,

Did you check your config-inc.php by putting the right vb license number, not your customer id (to login) ?

Francois

Pinpoint · January 15th, 2005, 05:16 AM

Yes it is correct. I just checked it.

Pinpoint

Interdit · January 15th, 2005, 05:29 AM

ok,

in your forums/includes/config.php you have:

// Prefix that all vBulletin cookies will have
// For example
$cookieprefix = '696th_skywarriors';

Replace it with:

// Prefix that all vBulletin cookies will have
// For example
$cookieprefix = 'bb';

Clear all cookies, then retry.

Or put in the pp setting 171 the same prefix, so 696th_skywarriors, the goal is to have the same one on both side.

Up to you

Later,

Francois