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

[Chuck S]

Its not a problem with the script its your server there look at the error.

Result: MySQL server has gone away

Your host probally limits your mysql to a SPECIFIC amount of queries then shuts down.

Nothing I can do about that script wise. You need to do each category one at a time if your host is shutting mysql down when you try and do all.

[charm]

Such situation has appeared 3rd time during this year at my database.

Problem description

1. User Doctor Mu (id = 488) has posted photo.
2. Image was uploaded with mistakes, so user charm (id = 2, admin rights) has decided to move it to the closed area (closed from public access).
3. User charm has opened posted photo for edit, choosed a different sub-category for photo, and also replaced user Doctor Mu on user charm (this is my rule at this website, when the image is wrong, to move it to the closed area and replace user on admin's username).
4. After that user Doctor Mu can not login. I am checking his registration (http://www.zeno.ru/adm-users.php?ppa...ituser&uid=488) and see, that the username is not Doctor Mu but charm. But if we go to the user's gallery (http://www.zeno.ru/showgallery.php?cat=all&ppuser=488), we see all photos are still under his name.
5. I have edited the registration of this user, and replaced username charm for Doctor Mu.
6. His registration and login are ok now, however, if we go to the gallery of user charm http://www.zeno.ru/showgallery.php?cat=all&ppuser=2, we will see, that all pages are ascribed to Doctor Mu (currently some pages were fixed, but you can see the problem here - http://www.zeno.ru/showphoto.php?photo=55506 ). Link to User points to the correct user id = 2, while the username is written as Doctor Mu, which is wrong (should be charm).

Looks as by unknown reason sometime during the editing of the page, posted by some user, his username is replaced in the registry by admin's usename.
I have no any integration at this website, only one registration system for PhotoPost.

Hence is the first request - what can be done to escape such problem in a future?

For fixing of user ID / usernames there is a tool in the Admin's interface - Scan database, "Check here to resync photo/comments usernames/update comments counts."

It really works and restores correct usernames. However, there is a next problem.
At my website this tool applied to all categories, checks pages one by one, with speed about 100 pages per minute. For the large database (more than 60,000 pages) it will took 10 hours to finish the process. This is a problem, because during such long period some probability exists, that connection will be lost, and process of recovering will be canceled.
More ever, after few hours of checking I have got next message (already reported about such messages above):

-------------------------------
....
Checking photo #25072: done.
Checking photo #25073:

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=1353

Result: MySQL server has gone away

Database handle: Resource id #7
-------------------------------

So, my second question is - what does it mean, such report about mistake? How to resolve this problem?

Well, I have restarted process, this time not in all categories, but only in the category of the photo #25073. All was done successfully.

I have restarted process again for 'all categories', and received the same mistake at the same point after few hours of checking.

The advice to check the whole database step-by-step by separate subcategories doesn't work, because I have more than 6,500 subcategories.

So, my third request - is it possible to add to the database scanning tool two fields, where I can enter range of photos, which should be checked in this session? It will possible, having such feature, to finish scaning of the database during few sessions.

[charm]

Originally Posted by charm

[b]So, my third request - is it possible to add to the database scanning tool two fields, where I can enter range of photos, which should be checked in this session? It will possible, having such feature, to finish scaning of the database during few sessions.

or another way to resolve this problem - to scan not only the selected category, but all subcategories below it.

[Chuck S]

Your messaging is confusing but I will say this. If you choose to replace a users name when editing a photo with yours then the photo owner is indeed you not his because you have changed it.

Changing photo ownership is not going to cause some other owner to not login as all it does is change the owner.

Content visible to verified customers only.

As far as break down the admin scripts we have already done that it is all or you can go category by category. You can place suggestions for new features in the suggestions forum.

[charm]

Originally Posted by Chuck S

Your messaging is confusing but I will say this. If you choose to replace a users name when editing a photo with yours then the photo owner is indeed you not his because you have changed it.

Changing photo ownership is not going to cause some other owner to not login as all it does is change the owner.

However, it causes changes in user's registration. It is an intermittent fault and I understand that it is hard to repeat it at your test servers for understanding of reasons.
However, I noticed that in all 3 cases during this year, shortly before the case I have edited photos of users, whose login names were changed after that.

Originally Posted by Chuck S

As far as break down the admin scripts we have already done that it is all or you can go category by category. You can place suggestions for new features in the suggestions forum.

ok, will repeat it there. But currently I need some workaround which will help me to resolve current problem. The advice to check category by category is not very useful by reasons mentioned above.

[Chuck S]

1. What I am saying is the action you describe would never change a users account. If there is some other action here your not describing which could cause someone not to be able to login then we can look at that but its not tied to what your describing.

2. You need to do it cat by cat if your server can not handle doing everything at one time. We have no control over your server settings restrictions and this is the very reason michael added the cat by cat thing.

[charm]

Originally Posted by Chuck S

1. What I am saying is the action you describe would never change a users account. If there is some other action here your not describing which could cause someone not to be able to login then we can look at that but its not tied to what your describing.

What I am saying that there were no any other actions at my side, only editing of some fields at photo page, including user name.

Originally Posted by Chuck S

2. You need to do it cat by cat if your server can not handle doing everything at one time. We have no control over your server settings restrictions and this is the very reason michael added the cat by cat thing.

As I said, it doesn't works for database with many (thousands) categories.
Do you have any advices concerning the server settings?

[Chuck S]

1. Then there is something else your other user did to make him not login is what I am saying. There are very very few actions in the program to update users. One would be the users profile area where they can update email password etc. The password forgot link when logging in and of course the admin user script that you use. Otherwise user accounts can not be changed so what your posting is not the full issue only the issue you have with scanning to update names.

In fact if I read back on this thread I made several comments asking why things as far as photo ownership etc was so whacked out on your site and now we find out you have been doing it all along purposely.

MYSQL HAS GONE AWAY is a server error meaning your server's mysql has shut down. Have you ever asked your host about your mysql server going down what have they said?

[charm]

Originally Posted by Chuck S

1. Then there is something else your other user did to make him not login is what I am saying. There are very very few actions in the program to update users. One would be the users profile area where they can update email password etc. The password forgot link when logging in and of course the admin user script that you use. Otherwise user accounts can not be changed so what your posting is not the full issue only the issue you have with scanning to update names.

Only one user (me) has admin rights, so there were no any actions in with users in the same time.

Originally Posted by Chuck S

In fact if I read back on this thread I made several comments asking why things as far as photo ownership etc was so whacked out on your site and now we find out you have been doing it all along.

Sorry, Chuck, my English is not very good, so can't understand your idea in this comment.

Originally Posted by Chuck S

MYSQL HAS GONE AWAY is a server error meaning your server's mysql has shut down. Have you ever asked your host about your mysql server going down what have they said?

I will ask them but it is strange, that server gone away (if gone) at the same photo number during the repeated procedure of scanning.

[Chuck S]

Content visible to verified customers only.

What I was saying is this thread is like over 8 months old and as I stated back then I told you that you where the one messing or changing with Photo ownerships and now 8 months later it is exactly what you have been doing.

MYSQL HAS GONE AWAY is a server message telling you mysql has shut down. It is not s script error.

[charm]

Originally Posted by Chuck S

What I was saying is this thread is like over 8 months old and as I stated back then I told you that you where the one messing or changing with Photo ownerships and now 8 months later it is exactly what you have been doing.

Yes, the problem was frozen by me and I have not returned to it discussion, trying by hands to edit usernames in all thousands of wrong photos.

Now it occurs again with new user, so I raised this question again, trying to understand the reasons and resolving methods.

Originally Posted by Chuck S

MYSQL HAS GONE AWAY is a server message telling you mysql has shut down. It is not s script error.

But it is strange that server message appeared at the same photo numbers. It was seen during few experiments. It can not be coincidence. How to explaine it? If server shut down at the same point during the script proceeding, it deals with the same problem in the photo record - but what are possible reasons? How to find and explaine them?
Interesting, that checking of the subcategory with 'wrong' photo doesn't call such mistake.

[Chuck S]

I am not sure what your saying you have an issue with. All I know is someone registers uploads photos and you set them to yourself. I dont know why you do this but you really have not discussed any issues with the program.

There is not much I can tell you about mysql setup since I am not a server tech

MySQL :: MySQL 5.0 Reference Manual :: B.1.2.9 MySQL server has gone away

[charm]

Originally Posted by Chuck S

I am not sure what your saying you have an issue with. All I know is someone registers uploads photos and you set them to yourself. I dont know why you do this but you really have not discussed any issues with the program.

I think no matter, why I desided to assign photos to my (admin) login name. But I have used standard edit features of the program and this caused the described issue.

[Chuck S]

The standard edit photo feature of the program is not going to change a users entry in the users table. Here is the section of code in editphoto that updates a users name it does it only in the photos table for that photo nowhere else.

Content visible to verified customers only.

As one can see nowhere in this code do we alter anything about a user. I have tested the assign to a different user without fail and that user can still login fine. As I have stated before there is more to this that you have stated. I have posted the only actions in the program capable of changing user info.