Fresh Install, no admin access

[shad0w]

First, preliminary data as requested in sticky:

Tell us what server operating system you are running. Windows? Flavor of Linux? What version is it? Service packs or other updates applied?
linux running Apache v1.3.29

Tell us what version of PHP and MySQL you are running.
PHP v4.3.5, MySQL v4.0.18-standard

Tell us whether the server in question is a dedicated host or if it is a shared host.
shared hosting

Tell us if the server is under your control or if you are leasing/renting/borrowing hosting space from someone else.
See above, using shared hosting

Give us a URL that links us straight to your PhotoPost installation. If it is a private installation that limits access to unregistered guests, give us a dummy account to use that actually has access to the photos.
http://www.ultimatesubaru.net/photos/

If I had admin access or could do *anything* with photopost, I might "give us a dummy account to use that actually has access to the photos"

Be nice and be patient!!! Not everyone who answers your question is a "Paid PhotoPost Employee" ... a lot of us are going to be fellow PhotoPost users who have been down that road before and have advice to share. If you're rude and piss us off, you're just going to cut your own throat.

Even the PhotoPost employees don't deserve to be treated badly just because something isn't working right for you and you're aggrivated by it. Chances are you're not the only problem ticket they are working on at any given moment. Realize that you sometimes have to just take your turn and wait in line.

Now additional information:

Just bought and downloaded PhotoPost version 4.8c this week. Following the direction here, installation went off without a hitch. Photopost is installed in the same database as vBulletin 3.0.1, using the vBulletin user database. The final step of the install process contains a link to adm-index.php, of which I have access to several links - Statistics, Approve/Bulk Actions, Moderate Comments, Back to User Index, and Logout. I do not have access to users/usergroup options, as the final step of the install process recommended I go ahead and change now.

Reading other posts on the subject, I see that something is wrong with the install process, which is not giving adminsitrators of vBulletin access by default. Taking that under advisement, I would have used phpmyadmin to correct this problem, if I had such a utility at my disposal. Recently, our lovely host, communehost, run by Jonathan Tittle, has been without so much as a semblance of support for almost 3 weeks. Recently, it appears that his license for cPanel has expired, leaving us in the dark as far as configuring our server goes. Given that situation, I would like a method by which to correct this installation problem without having access to third party utilities, provided with cPanel, to do so.

Without any specific knowledge of SQL, I have theorizied that I may be able to update the erroneous entry in the database using the SQL query feature in the vB admin control panel. All I need to know is what query that might be, to update what entry in what table with what value. If I knew SQL, I might have even put together this simple query myself! So, any help out there would be appreciated.

As far as database specifics go, both Photopost and vBulletin are installed with no prefixes, in the same database, as mentioned before. There are no other special instances regarding our installation that would make the supposed SQL query any different.

[Chuck S]

Well I show that you have cpanel installed

Looks like you have mod access not admin access

I would have to look at your usergroups table to see what is going on

The photopost usergroup import takes admin permissions right from your vb usegroup table.

You can PM me a link to your control panel and I will see what you have if any database viewer

Also PM me the admin login for photopost

[shad0w]

The problem is not having cpanel installed, it is the fact that when you log into it the only screen you get is a nice big Invalid License File printed across the screen.

I am installing phpmyadmin now on my own, if you have no idea what is causing this I will troubleshoot it on my own. I had made the assumption since this sort of thing has happened before you may have some tips or ideas as to what has happened.

Thanks,
shadow

[Chuck S]

Well as I stated looks like your usergroups import marked you as having mod access not admin access

As far as how to correct it thats why I said to give me a link to it since you said you had no idea how to do it anyway.

You need to go in and make sure in your photopost usergroups table under the Administrator entry which should have a groupid entry of 6 and cpaccess needs to be 1 that should get you the admin menu if your a true admin in vb3

[shad0w]

.....

[shad0w]

That last post was the structure of the table, I see that value cpaccess for Administrator is set to '3' rather than '1', as stated in other posts with people who have a similar problem.

I am sorry but I do not give cp, administrator, or any other access to anyone. Not that you guys here at photopost are not trustworthy, its just my policy I did not say I had no idea how to do it, I just was stating that I am not familiar with sturctured query language, at least not intimately enough to blindly attempt a query without some input. Understanding mySQL is another story, and with the use of phpMyAdmin any 2 year old could manipulate a database easily.

[shad0w]

Just for future reference for the developers of photopost:

The entry in vBulleting table 'usergroup' titled 'adminpermissions' is the sum of two separate admin permissions. One is titled "Is Super moderator?" in vB admincp, and the other titled "Is Admin?" in the vB admincp. Is super moderator evaluates to an integer value of 1 if TRUE, while is admin evaluates to an integer value of 2 if true. The contents of adminpermissions is the sum of both of these two values. Hence, the default value for groupid 6, Administrators, in vBulletin 3 is set as integer 3 in this field. Apparently the PhotoPost 'cpacess' value evaluates 1 as TRUE and all else as FALSE. A small change to the install script would be able to cope with this error, rather than having to have people manually edit the database via phpMyAdmin, and should be much easier on the general populace

By default, the groupid 5 "Super Moderators" in vBulletin is given admin cp access in photopost, while the "Administrators" groupid 6 is not. This is assuming default values for those two groups on the vBulletin side.

[SLix]

Yep I got the same problem with pp4.8d installed with vB3.0.1 user database. I am default admin in the vB forum, but am not recognised as admin by PP, although I can login as a standard user.

I think what may have happened, is that something has been changed in vB between version 3.0.0 and 3.0.1 even though they say it was just a few bug fixes. So I think the PP installer needs revising.

[A-handreas]

Originally Posted by SLix

Yep I got the same problem with pp4.8d installed with vB3.0.1 user database. I am default admin in the vB forum, but am not recognised as admin by PP, although I can login as a standard user.

I think what may have happened, is that something has been changed in vB between version 3.0.0 and 3.0.1 even though they say it was just a few bug fixes. So I think the PP installer needs revising.

I have the same problem. Everything went fine during the installation and importing from my vbulletin 3.0.2. But no Admin rights only a Standard User.
What should we do ?

regards
Andreas

[A-handreas]

I got it - it was an cookie problem - I lost the "bb"