Splitting of galleries, uploaded by different users, into one gallery

[charm]

First of all - Happy New Year to all!

Problem description:
1. I have account with admin rights at my website, for example, YYYY. User ID is 2.
2. There is one more user, registered at my website, for example, ZZZZ. User ID is 214.
3. Today I tried to login with my login name YYYY and failed.
4. I've used 'Forgot password' feature, and unexpectedly received e-mail speaking next:
Your username is: ZZZZ
Your new password is: *****
Reset password was requested by me, user YYYY, ID=2, but e-mail speaks, that password was reset for user ZZZZ .
5. I've login under admin password into the database, and checked what is written under User ID=2. Surprise - there is a name of user ZZZZ (his actual ID=214).
6. I changed record under User ID=2 and wrote there that user name should be YYYY, as before.
7. After that I reset password for user YYYY and login successufully.
8. However, there is a new problem. All pages, uploaded by the user ZZZZ (id=214), shows that they were uploaded by the user YYYY (id=214). Comments, left by user ZZZZ, are still under his proper name.

So questions:
1. How to resolve this problem? It is impossible to open 3,000 pages one by one, actually belonged to user ZZZZ, and change page owner from YYYY to ZZZZ.
2. How to avoid such problem in a future?

Thank you in advance!

[Chuck S]

Hard thing to respond to here. Why do you have users that both have userid 214 but have different usernames?

Did you perhaps do something your not suppose to do like switch your integrations midstream so that all your userids and users and mismatched?

We definately need more info here.

You can update usernames on photos and comments by running the tool in admin but before doing that your answer to my question will determine to do that or to run some other special script in our import forum to reassign userid's based on username so photos are correctly owned especially if you switched forums or integrations.

[charm]

Originally Posted by Chuck S

Hard thing to respond to here. Why do you have users that both have userid 214 but have different usernames?

Did you perhaps do something your not suppose to do like switch your integrations midstream so that all your userids and users and mismatched?

I've not proceed any integrations.
Just usual work of the database, and today occasionally found this bug.

I have not different users under ID=214. User name under ID 214 is ZZZZ. When today I opened for edit user ID=2, I found that his name is not YYYY, but ZZZZ, as name of user ID=214.

[Chuck S]

You had to do something here userids do not change. The reason you get an email requesting a password reset is because your logged in as a user and this is what we say the userid is for that user. Do those users have the same email associated with them both? That can cause an issue with a password reset since we will grab the info from the first user found with the email.

at any rate you can place a link here to your site.

[charm]

No, users ID=2 and ID=214 are physically different persons with different e-mails.
My website is http://zeno.ru .

[charm]

BTW, seems that galleries of users are displayed not by USER ID but by user name. Hence the problem with correct ID but wrong user name, recorded at the image page, leads to the wrong displaying.

[Chuck S]

http://www.zeno.ru/showmembers.php

Thats not what I see. User 214 is user charm not ZZZZ or YYYY but if you go to the members profile the user is Vladimir Suchy not charm.

http://www.zeno.ru/member.php?uid=214

http://www.zeno.ru/member.php?ppaction=profile&uid=2

This can only transpire if you switch databases to some other user table or switch a forum etc. This cant happen unless you do something like that. You say splitting galleries so I would suspect somewhere in splitting things you caused this issue. You can try running this script we have in the import forum to update the userid's to the corresponding users. I assume this is the correct action because charm is user 2 correct. Vladmir is user 214 right then do run this from your photopost directory

Reassign userid's when switching integrations to VBulletin

[charm]

Too bad ... now, after the running of this script, all photos belongs to user id = 2 (before part of them belonged to user id = 2 and part to user id = 214).
What I can do now? Full restore from the back-up?

[Chuck S]

You can sure but remember who do the photos belong to? Do you see what your telling us. You tell me the photos belong to charm not vladimir and now you say they dont. Photos are uploaded and a username and userid is recorded in the photos table. What have you changed in your system? I dont think I got a clear answer which way was the right way for you. Until we get a clear response from you there is not much I can comment on. I clearly explained if the username on the photo is correct you can use that script I linked. If the username is wrong and the userid on the photo is correct you can run the tool in admin scan database to update usernames on photos and comments in admin. You need to restore a backup then you can do that.

[charm]

Originally Posted by Chuck S

If the username is wrong and the userid on the photo is correct you can run the tool in admin scan database to update usernames on photos and comments in admin.

Dear Chuck, unfortunally, you've wrote this good advice too late...
Answering on your question - I didn't changed any settings, concerning the registration system and integration (I don't use it), at least, during last year.
There were more than 4300 pages (id=2), belonged to charm and more than 4000 pages, belonged to Vladimir Suchy (id=214). Now all are assigned to charm (id=2).

[Chuck S]

Okay well I cant tell you why things are like that unless you mixed databases or something. There is a big grey area here. I would suggest you restore a backup of the photos mysql table and then run the scan database tool in admin and see if that does what you want.

[charm]

yes, thank you for help, especially taking into account holidays!

[Chuck S]

Not a problem buddy enjoy the new year.

[charm]

Originally Posted by Chuck S

If the username is wrong and the userid on the photo is correct you can run the tool in admin scan database to update usernames on photos and comments in admin.

While running this admin tool, I have got the next message:
Checking photo #15146: done.
Checking photo #15147:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: adm-misc

Query: SELECT userid,username,email,password,usergroupid,offset,mature FROM users WHERE userid=588

Result: MySQL server has gone away

Database handle: Resource id #7


What is the reason? Too large number of pages (> 56 000)?
How can I scan the whole database?
Is it possible to continue to scan from the #15147?

[Chuck S]

Your error tells me mysql has shut down. Depends on your host really why is your mysql shutting down it should not unless your host limits your mysql queries and there is not much that can be done there except process things category by category.

[charm]

Originally Posted by Chuck S

If the username is wrong and the userid on the photo is correct you can run the tool in admin scan database to update usernames on photos and comments in admin. You need to restore a backup then you can do that.

Dear Chuck, please look here, for example:
http://www.zeno.ru/showphoto.php?photo=34922

The user ID = 2, and if you will click there, you will see user name charm, which is correct. However at the page you see user name Lingen, which is incorrect.

The scanning tool in the admin menu doesn't help.

[Chuck S]

actually i cant see things on your site but we have had this discussion before.

You tell me what I have provided you does not work. If thats the case then you use the scan database tool

see there are two scenerios here

If the userid is correct and name wrong then you can use the scan database tool to update names.

If the userid is wrong but the name is correct as the owner you use the tool I linked you to in this thread which updates userid to match names

it is all up to you here which way to go i can not tell you whats right. obviously you have switched databases combined things switched integrations something here.

[charm]

Yes, I understand.
We have the first scenario here.
I have tried to use scanning tool. It has checked 15146 pages and stopped.
Your recommendation to scan by subcategories doesn't works. This tool doesn't correct mistakes if I choose to do that in a separate subcategory.
The best way is to have option in the scanning tool - possibility to setup a range of page numbers for scanning.

[Chuck S]

subcategory or all categories is not going to affect the outcome so do not understand your issue. I suggest you should check as an example a certain photo in a certain category elect to do the scan database tool on that category of images and refresh your page when the admin tool is done and see if the info changes

[charm]

I have found, that scanning tool doesn't go in depth of the tree of subcategories. I.e., it checks only the selected subcategory.
Such algorithm is not useful if the subcategories tree is huge (I have about 6500 subcategories now).
Are there any othere ways to fix the problem?
BTW, I've tried to use the scanning tool again over the all categories. It was stopped at the same number:
Checking photo #15146: done.
Checking photo #15147:
MySQL server has not gone away, database worked properly without any problems.