""You are not a valid administrator or moderator!"

Andy R · December 7th, 2010, 10:12 AM

Upgraded 4.8 to the latest version. Turned on integration. It does seem to recognize me as a user, but not as an admin. When I try to go to the admin page, it gives me another login then when I do login it says:

"You are not a valid administrator or moderator!"

What do I do now.

Chuck S · December 7th, 2010, 11:14 AM

Some more information may help here. did you also upgrade your forum? what type of integration. Url and test user login?

Andy R · December 7th, 2010, 12:51 PM

No, we did not upgrade the forum. We only upgraded photpost. Unfortunately this is in my sandbox right now which is not online so I cannot give you a login because it is inaccessible. This is the test before we actually try this.. So far it is failing. It was never integrated with the forum before.

Chuck S · December 7th, 2010, 01:11 PM

If it was never integrated with the forum then your login from the forum would not work with photopost. To assign permissions correctly our product needs to be correctly installed with the product it is integrating with.

That would be the heart of your issue. There are several threads here on switching integration because there is alot to consider. What would happen with all your old photos and ownership because all the users would not exist on the forum. There are bound to be repercussions from switching sometimes minor to major.

http://www.photopost.com/forum/1236444-post4.html

That would help you with steps on how to switch integrations.

Andy R · December 7th, 2010, 02:19 PM

THe thread you posted is about converting phpbb to vbulletin? This is a stand alone photopost install going to vbulletin. Do you actually have a way to do that?

Chuck S · December 7th, 2010, 02:29 PM

The steps would be the same except you use the impex importer from vb and select photopost import

1. upgrade photopost if not using the latest

2. install vb

3. use vb impex system to import photopost

4. empty the pp_usergroups table in your photopost database so on next step your vb usergroups will get imported

5. rerun photopost install using same prefix and database to integrate with vb. this will not delete data

6. run the userfix script from our photopost import forum here to realign userid's when you switch integration

Andy R · December 7th, 2010, 04:54 PM

Quote:

Originally Posted by Chuck S

6. run the userfix script from our photopost import forum here to realign userid's when you switch integration

Thanks, do you have a link for this?

Chuck S · December 7th, 2010, 05:22 PM

Reassign userid's when switching integrations to VBulletin

Andy R · December 8th, 2010, 06:13 AM

OK, I did all those steps exactly as you laid it out and I still get this message:

"You are not a valid administrator or moderator!"

I deleted all cookies and still no avail.

By the way the pp_usergroups table is still empty, the vb groups did not import.

Chuck S · December 8th, 2010, 08:22 AM

Quote:

By the way the pp_usergroups table is still empty, the vb groups did not import.

then you did not install correctly it would appear. On the config in the user database portion you put the vb database. On step 4 we ask the integration type and forum mysql table prefix url etc etc. We then import the groups based on the info. If that information is correct your vb usergroups will be imported it not then they will not.

Andy R · December 8th, 2010, 09:53 AM

Perhaps not but I am following your directions to the letter. Here is a screen shot of the page you are referring to:

Code:

Content visible to verified customers only.

I am noticing that this script does NOT ask for the VBULLETIN database prefix. Are you sure this is not the root of the issue here?

I have done this twice now as per your instructions and it has failed.

Chuck S · December 8th, 2010, 12:55 PM

Yes we do ask for the vbulletin mysql table prefix as I noted in my about the issue above. On step 4 where you set your forum integration type we ask the forum mysql table prefix.

It is on this step you are not inputting the correct info.

Andy R · December 8th, 2010, 01:01 PM

Would you please look at this screenshot:

https://www.photopost.com/forum/atta...otocompost.jpg

And tell me where EXACTLY you put the database prefix for VBULLETIN (not photopost)? I do not see it.

Chuck S · December 8th, 2010, 01:04 PM

Andy as I have noted in my past replies it is on step 4 of the installation process not the initial config screen.

Andy R · December 8th, 2010, 01:17 PM

Excuse me, but where in here did you mention that?

Quote:

1. upgrade photopost if not using the latest

2. install vb

3. use vb impex system to import photopost

4. empty the pp_usergroups table in your photopost database so on next step your vb usergroups will get imported

5. rerun photopost install using same prefix and database to integrate with vb. this will not delete data

6. run the userfix script from our photopost import forum here to realign userid's when you switch integration

Anyway, step 4, I entered in the prefix, still not working. Still get the same error, still not moving over the usergroups.

Andy R · December 8th, 2010, 01:32 PM

I am looking at this install code and am seeing a couple issues here..

Code:

Content visible to verified customers only.

Our install of PP never had a prefix so you are assuming otherwise and inserting one here.

Second, I see no code in install.php that moves, creates, or otherwise inserts into a usergroup table.

Chuck S · December 8th, 2010, 02:08 PM

Andy if you select to integrate with vbulletin by selecting so on step 4 from the dropdown of all the integrations and enter the correct information asked it will install fine.

I meantioned step 4 of the install in posts 10,12 and 14 basically in every last reply I have made since you reported the issue in post 9.

Like I said if your usergroups are not being imported there can only be two possible issues which is what I laid out in post 10. You seem to have concentrated on the first half of my post where I talked about the config settings and missed the rest of that post.

If you are 100% sure your entering the correct information on the config section of install and the correct table prefix of step 4 where asked then the only issue this can be is you are selecting the wrong integration type in the dropdown on step 4. You should see a one line error telling you it can not insert results on step 5 if the wrong info is used.

Since we support 20 different integrations it is absolutely essential you select the correct information for all options asked. The way this works is each integration type has its own integration file which determines what functions ran in the program.

For vbulletin 3 or vbulletin 4 that file is vb3.php in the forums subdirectory of our code. If you select vb3 say from the dropdown on step 4 enter the correct table prefix and on the config have entered the correct database connection info then when you go to the last step of install step 5 we import the usergroups from the forum and make an entry in our usergroups table.

Andy R · December 9th, 2010, 07:00 AM

Step 4:

pp1.jpg

Step 5:

pp2.jpg

Result:

pp3.jpg

Database tables as shown in Navicat:

pp4.jpg

Usergroup table after import:

pp5.jpg

I have followed your directions exactly. The database for the forum is the same as the one for pp, same username, same login, etc..

Still empty usergroup table, still same error..

Chuck S · December 9th, 2010, 08:34 AM

Is MYSQL STRICT MODE ON? Turn that off and try.

Andy R · December 10th, 2010, 05:08 AM

Strict mode is not enabled.