After upgrade i can not login and other errors

[informatikboard]

Hello

I have now upgrade from 4.8 to 5.62.
Now i have folow Problems:

- i see now no more pictures
- i can not login with admin
- when i login with user, i see no profil for pictures upload

thanks for help

Link: http://www.informatikboard.ch/photos/

[Chuck S]

well your login you would need to post a test login here so lets deal with what I see right this second

http://www.informatikboard.ch/photos...noch_keins.JPG

You have repeatedly ran the upgrade for 485 a total of 6 times over and over and this is why your photos will not show. You need to restore a backup of the Photopost photos table and rerun the upgrade scripts ONCE and only once.

[informatikboard]

and why the login don't work ?
i can not login in admin or client profile

[informatikboard]

Originally Posted by Chuck S

well your login you would need to post a test login here so lets deal with what I see right this second

http://www.informatikboard.ch/photos...noch_keins.JPG

You have repeatedly ran the upgrade for 485 a total of 6 times over and over and this is why your photos will not show. You need to restore a backup of the Photopost photos table and rerun the upgrade scripts ONCE and only once.

You kno whiches photos table are important, because i have NO "pp_ ".

[Chuck S]

Your gallery is still the same here as you have done nothing of what I said. I can not assist you here unless you do as instructed.

You need to restore the photos table. Most commonly the one you want to restore is called pp_photos and then you rerun the upgrades ONCE.

As far as logins I had asked for you to post a login here but most likely if you upgraded from vb2 this would easily explain why you can not login

[informatikboard]

Now the pictures works, thanks.

But i have still folow problems:

"i can not login in admin or client profile"

Ps. I will send you login-details with pn

[informatikboard]

Login for try:

[Chuck S]

Login works but your not logged in probally because of cookies

First off what where you running before you upgraded vbulletin wise?

Your cookies in vb should be set like this and Photopost as well

cookie path /

cookie prefix bb

cookie domain .informatikboard.ch


You can issue these queries against the Photopost database to make sure they are right

UPDATE pp_settings SET setting='/' WHERE id=171
UPDATE pp_settings SET setting='bb' WHERE id=172
UPDATE pp_settings SET setting='.informatikboard.ch' WHERE id=173

[informatikboard]

Hello

Our table calles settings not pp_settings:

We have do this things:
UPDATE settings SET setting='/' WHERE id=171
UPDATE settings SET setting='bb' WHERE id=172
UPDATE settings SET setting='.informatikboard.ch' WHERE id=173

and i see folow failure:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE settings SET setting='bb' WHERE id=172
UPDATE settings SET setting='.inf' at line 2

[Chuck S]

If your trying to update queries all at once you need to use semicolons

UPDATE settings SET setting='/' WHERE id=171;
UPDATE settings SET setting='bb' WHERE id=172;
UPDATE settings SET setting='.informatikboard.ch' WHERE id=173;

[informatikboard]

Done.

The login's in photopost still not work

[Chuck S]

I login fine with that username and there is an upload link for me to upload a photo. Now if you set your processor to gd2 in admin global options so uploads work I will gladly show you this is a fact by uploading a photo

[informatikboard]

Now it works, i dont know why ;-)
But i still can not login in the admin with my supervisor login from vB

[Chuck S]

well what do you mean by not login what happens?

[informatikboard]

i can upload pictures, but i cannot access:
http://www.informatikboard.ch/photos/adm-index.php

[Chuck S]

Okay let me try to be even clearer so I can try and assist you.

What do you mean you can not access admin? Do you not see an admin link? What happens if you click it?

[informatikboard]

shure i can see the "Admin" - Link next to Home, but when i click on it, i see the login-site for login admin.

I put in the admin-login from vb (it is the same db) but i see a error:

"wrong username and passwort"

[Chuck S]

Well did you also upgrade your forum along with the gallery? I think I asked questions earlier on this that where never answered.

Does your config-inc.php file have a line in it with this

$vblicense="122345678";

with obviously the string in there being set to your correct vb3 license number which can be found at the top of your config file for vb3 in the includes directory of the forum?

[informatikboard]

it works know !!!!!

I must change in the DB: "settings"
41 User Registration System from vb2 in vb3

;-)

thanks for your help

[Chuck S]

Yep no problem