Error: There was a problem upgrading users.

freshweb

Joined: 2004-06-29
Posts: 10
Posted: Tue, 2004-06-29 18:35

After installing gallery I get this message.

The user database in your gallery was created with an older version of the software and is out of date. This is not a problem! We will upgrade it. This may take some time. Your data will not be harmed in any way by this process. Rest assured, that if this process takes a long time now, it's going to make your gallery run more efficiently in the future.
If you get an error, and only some users are upgraded, try refreshing the page to upgrade remaining users.

Please Wait...

Checking user 1 of 3 . . . . skipped
Checking user 2 of 3 . . . . skipped
Checking user 3 of 3 . . . . skippedError: Could not acquire lock (/home/virtual/freshwebdesign.ca/webroot/htdocs/xessive/gallery/albums/.users/userdb.dat.lock)!Error: Could not acquire lock (/home/virtual/freshwebdesign.ca/webroot/htdocs/xessive/gallery/albums/.users/userdb.dat.lock)!

Error: There was a problem upgrading users. Please check messages above, and try again

Here are my vital stats:
Give us your Gallery/webserver information to get a faster answer.
Get this information from the PHP diagnostic (in the configuration wizard).
Gallery URL http://www.freshwebdesign.ca/xessive/gallery/albums.php
Gallery version: 1.4.3-pl2
Apache version: 1.3.29
PHP version (don't just say PHP 4, please): PHP 4.3.6
Graphics Toolkit:
Operating system: winxp
Web browser/version (if applicable):

I have also changed the permissons of albums and .user directory to 777 chmod

Would greatly appreciate your help. [/b]

 
signe
signe's picture

Joined: 2003-07-27
Posts: 2322
Posted: Wed, 2004-06-30 20:42

You need to change all of the files in those directories.. not just the directories themselves.

"chmod -R 777 albums" should do it.

 
Dralt

Joined: 2004-07-03
Posts: 7
Posted: Sat, 2004-07-03 02:44

I have the same problem.

Currently, users do not get upgraded correctly. Even if you chmod -R 777 your albums directory.

In my case, I get:

Quote:
Upgrading Users

The user database in your gallery was created with an older version of the software and is out of date. This is not a problem! We will upgrade it. This may take some time. Your data will not be harmed in any way by this process. Rest assured, that if this process takes a long time now, it's going to make your gallery run more efficiently in the future.
If you get an error, and only some users are upgraded, try refreshing the page to upgrade remaining users.

Please Wait...

Checking user 1 of 3 . . . . skipped
Checking user 2 of 3 . . . . skipped
Checking user 3 of 3 . . . . skipped

Users upgraded successfully.

After that, all my users are cleared and only "admin" shows up in the Manage Users window.

I made backups of my albums (including .users) directories, so I can reproduce this as many times as I want.

 
signe
signe's picture

Joined: 2003-07-27
Posts: 2322
Posted: Sat, 2004-07-03 03:39

What version did you upgrade from? This is not the same problem as the previous user at all... his was simply a permissions error.

 
Dralt

Joined: 2004-07-03
Posts: 7
Posted: Sat, 2004-07-03 17:28

Gallery v1.3.2 -> Gallery v1.4.3-pl2

I used to run v1.3.2 under PostNuke.
However, I am going to run v1.4.3-pl2 standalone.

Would you like to get userdb.dat before the upgrade and after the upgrade?
Is there any password I should remove before I post them here?

I checked again this morning...
With Gallery v1.3.2, I get my full list of users when I access the "manage users" window.
With Gallery v1.4.3-pl2, after users have been upgraded/skipped, "admin" is the only user that shows up in the same "manage users" window.

I found an insignificant bug in classes/gallery/User.php, where on line 86, you have $this->version == "0"; instead of $this->version = "0";, but beyond that, I don't know enough about the format of userdb.dat to figure out what the problem may be.
If I have time, I will look into it.

 
signe
signe's picture

Joined: 2003-07-27
Posts: 2322
Posted: Sat, 2004-07-03 19:53

That's a nice catch. Try changing that before you upgrade and see if it changes anything. I believe that 1.3.2 is before we started versioning the user file, so that could be the issue.

 
Dralt

Joined: 2004-07-03
Posts: 7
Posted: Sat, 2004-07-03 22:35

userdb.dat before:

O:14:"gallery_userdb":4:{s:7:"userMap";a:20:{s:9:"EVERYBODY";s:9:"everybody";s:9:"everybody";s:9:"EVERYBODY";s:6:"NOBODY";s:6:"nobod
y";s:6:"nobody";s:6:"NOBODY";s:5:"admin";s:20:"1007011545:132889095";s:20:"1007011545:132889095";s:5:"admin";s:7:"Laurent";s:20:"100
7012110:704246895";s:20:"1007012110:704246895";s:7:"Laurent";s:3:"Ivy";s:21:"1007050745:1131117534";s:21:"1007050745:1131117534";s:3
:"Ivy";s:5:"Roxie";s:18:"1007050819:6944369";s:18:"1007050819:6944369";s:5:"Roxie";s:6:"Debbie";s:21:"1007050855:1083309071";s:21:"1
007050855:1083309071";s:6:"Debbie";s:5:"Naomi";s:20:"1007050943:535059315";s:20:"1007050943:535059315";s:5:"Naomi";s:7:"Parents";s:2
0:"1007955063:134415180";s:20:"1007955063:134415180";s:7:"Parents";s:8:"LOGGEDIN";s:8:"loggedin";s:8:"loggedin";s:8:"LOGGEDIN";}s:6:
"nobody";O:10:"nobodyuser":7:{s:8:"username";s:6:"NOBODY";s:8:"fullname";s:6:"Nobody";s:8:"password";N;s:5:"email";N;s:7:"isAdmin";b
:0;s:15:"canCreateAlbums";b:0;s:3:"uid";s:6:"nobody";}s:9:"everybody";O:13:"everybodyuser":7:{s:8:"username";s:9:"EVERYBODY";s:8:"fu
llname";s:14:"Anonymous User";s:8:"password";N;s:5:"email";N;s:7:"isAdmin";b:0;s:15:"canCreateAlbums";b:0;s:3:"uid";s:9:"everybody";
}s:8:"loggedIn";O:12:"loggedinuser":7:{s:8:"username";s:8:"LOGGEDIN";s:8:"fullname";s:14:"Anonymous User";s:8:"password";N;s:5:"emai
l";N;s:7:"isAdmin";b:0;s:15:"canCreateAlbums";b:0;s:3:"uid";s:8:"loggedin";}}

userdb.dat after:

O:14:"gallery_userdb":5:{s:7:"userMap";a:6:{s:9:"EVERYBODY";s:9:"everybody";s:9:"everybody";s:9:"EVERYBODY";s:8:"LOGGEDIN";s:8:"logg
edin";s:8:"loggedin";s:8:"LOGGEDIN";s:6:"NOBODY";s:6:"nobody";s:6:"nobody";s:6:"NOBODY";}s:6:"nobody";O:10:"nobodyuser":7:{s:8:"user
name";s:6:"NOBODY";s:8:"fullname";s:6:"Nobody";s:8:"password";N;s:5:"email";N;s:7:"isAdmin";b:0;s:15:"canCreateAlbums";b:0;s:3:"uid"
;s:6:"nobody";}s:9:"everybody";O:13:"everybodyuser":7:{s:8:"username";s:9:"EVERYBODY";s:8:"fullname";s:14:"Anonymous User";s:8:"pass
word";N;s:5:"email";N;s:7:"isAdmin";b:0;s:15:"canCreateAlbums";b:0;s:3:"uid";s:9:"everybody";}s:8:"loggedIn";O:12:"loggedinuser":7:{
s:8:"username";s:8:"LOGGEDIN";s:8:"fullname";s:14:"Anonymous User";s:8:"password";N;s:5:"email";N;s:7:"isAdmin";b:0;s:15:"canCreateA
lbums";b:0;s:3:"uid";s:8:"loggedin";}s:7:"version";i:5;}

Is it fixable?

 
Dralt

Joined: 2004-07-03
Posts: 7
Posted: Sat, 2004-07-03 22:36

I fixed the $this->version == "0"; thing, but it does not help.

 
signe
signe's picture

Joined: 2003-07-27
Posts: 2322
Posted: Sun, 2004-07-04 00:09

Did you ever switch your webhost, or did your webhost move you between a UNIX and Windows server?

You say you've got the directory backed up... can I get a copy of the .users directory? (The entire directory, not just userdb.dat)

If you can, zip/tar.gz the file and put it on your host, then PM me with the location so that others don't get ahold of it. I'll examine it ASAP and see if I can figure out the issue.

 
freshweb

Joined: 2004-06-29
Posts: 10
Posted: Sun, 2004-07-04 20:05

I tried to chmod the files in the album directory. I kept getting a error message that permission was denied. I have now deleted the gallery from my website except for the album directory that will not allow me to delete it???????

 
signe
signe's picture

Joined: 2003-07-27
Posts: 2322
Posted: Sun, 2004-07-04 20:58

You can use Bharat's Cleanup Script in the downloads section of the site. You can't delete the albums because they're owned by the webserver, not your user.

 
freshweb

Joined: 2004-06-29
Posts: 10
Posted: Sun, 2004-07-04 21:31

I reinstalled gallery and followed all the steps. Once again I get the same problem upgrading users error message.

The user database in your gallery was created with an older version of the software and is out of date. This is not a problem! We will upgrade it. This may take some time. Your data will not be harmed in any way by this process. Rest assured, that if this process takes a long time now, it's going to make your gallery run more efficiently in the future.
If you get an error, and only some users are upgraded, try refreshing the page to upgrade remaining users.

Please Wait...

Checking user 1 of 3 . . . . skipped
Checking user 2 of 3 . . . . skipped
Checking user 3 of 3 . . . . skippedError: Could not acquire lock (/home/virtual/freshwebdesign.ca/webroot/htdocs/xessive/gallery/albums/.users/userdb.dat.lock)!Error: Could not acquire lock (/home/virtual/freshwebdesign.ca/webroot/htdocs/xessive/gallery/albums/.users/userdb.dat.lock)!

Error: There was a problem upgrading users. Please check messages above, and try again

when I attempt to chmod the user dir and any files below I get "Operation not permitted" from Smart ftp?

 
signe
signe's picture

Joined: 2003-07-27
Posts: 2322
Posted: Sun, 2004-07-04 21:41

You will have to contact your webhost to have them chmod the files.

 
Dralt

Joined: 2004-07-03
Posts: 7
Posted: Mon, 2004-07-05 15:39

signe,

Any luck with these files I sent you?
Did you get a chance to run them through the 1.3.2 code?

 
freshweb

Joined: 2004-06-29
Posts: 10
Posted: Mon, 2004-07-05 17:03

I have had my webhost chmod the user dir to 777? I am still getting this message??????

The user database in your gallery was created with an older version of the software and is out of date. This is not a problem! We will upgrade it. This may take some time. Your data will not be harmed in any way by this process. Rest assured, that if this process takes a long time now, it's going to make your gallery run more efficiently in the future.
If you get an error, and only some users are upgraded, try refreshing the page to upgrade remaining users.

Please Wait...

Checking user 1 of 3 . . . . skipped
Checking user 2 of 3 . . . . skipped
Checking user 3 of 3 . . . . skippedError: Could not acquire lock (/home/virtual/freshwebdesign.ca/webroot/htdocs/xessive/gallery/albums/.users/userdb.dat.lock)!Error: Could not acquire lock (/home/virtual/freshwebdesign.ca/webroot/htdocs/xessive/gallery/albums/.users/userdb.dat.lock)!

Error: There was a problem upgrading users. Please check messages above, and try again

 
signe
signe's picture

Joined: 2003-07-27
Posts: 2322
Posted: Mon, 2004-07-05 19:01

freshweb, the permissions are still wrong. It's not just the directory that needs to change.. it's all the files in the directory as well. FAQ Gallery:c.15

 
signe
signe's picture

Joined: 2003-07-27
Posts: 2322
Posted: Mon, 2004-07-05 19:06

Dralt, your files are missing the necessary information. In fact, your files aren't even named correctly. They should be named in a format like this: "09812314523:098239847232". You files are missing the second part of the name. They only have "0987345098342", and they're also completely empty.

You should make sure that those users are even usable in 1.3.2, because all of their information is gone. Passwords, names.. everything.

 
freshweb

Joined: 2004-06-29
Posts: 10
Posted: Mon, 2004-07-05 20:54

All files in the albums folder have been changed to 777 including .user dir and
albums/.users/.htaccess
albums/.users/1088994367_1283248519.lock
albums/.users/userdb.dat.lock

Am I missing something. I still get the same error message?

Thanks for all your help.

 
h0bbel
h0bbel's picture

Joined: 2002-07-28
Posts: 13451
Posted: Tue, 2004-07-06 07:11

freshweb, all files and directories in the albums/ dir need to be chmod 777 ( FAQ Gallery:c.15 )

 
freshweb

Joined: 2004-06-29
Posts: 10
Posted: Tue, 2004-07-06 15:31

I get that all the files in the albums need to be chmod to 777. All three of the files in that directory have been changed?????

 
signe
signe's picture

Joined: 2003-07-27
Posts: 2322
Posted: Tue, 2004-07-06 15:37

If you're still getting the same error message, it means that the permissions are not correct, somewhere. Paste the error here again.. note that you need to do the permission change for all of the files in /albums, not just .users

 
freshweb

Joined: 2004-06-29
Posts: 10
Posted: Tue, 2004-07-06 16:13

The user database in your gallery was created with an older version of the software and is out of date. This is not a problem! We will upgrade it. This may take some time. Your data will not be harmed in any way by this process. Rest assured, that if this process takes a long time now, it's going to make your gallery run more efficiently in the future.
If you get an error, and only some users are upgraded, try refreshing the page to upgrade remaining users.

Please Wait...

Checking user 1 of 3 . . . . skipped
Checking user 2 of 3 . . . . skipped
Checking user 3 of 3 . . . . skippedError: Could not acquire lock (/home/virtual/freshwebdesign.ca/webroot/htdocs/xessive/gallery/albums/.users/userdb.dat.lock)!Error: Could not acquire lock (/home/virtual/freshwebdesign.ca/webroot/htdocs/xessive/gallery/albums/.users/userdb.dat.lock)!

Error: There was a problem upgrading users. Please check messages above, and try again

The following files are in the .users dir and they were all changed to 777

[Edit by Signe - Removed ftp links due to password inclusion]

 
signe
signe's picture

Joined: 2003-07-27
Posts: 2322
Posted: Tue, 2004-07-06 17:32

Please do not include password information - this is a public forum. I suggest you change your password immediately.

I looked at what you posted, and the issue is right here:

Quote:
drwxrwxrwx 3 freshwebdesi0005 freshwebdesi0005 512 Jul 6 15:58 ./
drwxrwxr-x 23 freshwebdesi0005 freshwebdesi0005 2560 Jul 6 15:56 ../
drwxr-xr-x 2 www freshwebdesi0005 512 Jul 6 15:58 .users/

The .users directory is *not* 777, and neither are the files inside it:

Quote:
drwxr-xr-x 2 www freshwebdesi0005 512 Jul 6 15:58 .
drwxrwxrwx 3 freshwebdesi0005 freshwebdesi0005 512 Jul 6 15:58 ..
-rw-r--r-- 1 www freshwebdesi0005 31 Jul 6 15:58 .htaccess
-rw-r--r-- 1 www freshwebdesi0005 0 Jul 6 15:58 1089129496_737010381.lock
-rw-r--r-- 1 www freshwebdesi0005 0 Jul 6 15:58 userdb.dat.lock

 
Dralt

Joined: 2004-07-03
Posts: 7
Posted: Wed, 2004-07-07 15:59

OK.

Since I do not wack those files myself. I suppose a previous upgrade did.

I am no longer interested in making sure the upgrade procedure work.

I just want to start with a clean sheet from a users standpoint.

If I delete the contents of .users, will Gallery recreate all the necessary files in this directory?

If not, which files can I delete in this directory?

Also, why is the serialized user map so complex for 1 single user?

 
signe
signe's picture

Joined: 2003-07-27
Posts: 2322
Posted: Wed, 2004-07-07 16:05

Dralt, if you delete the .users directory and re-run the configuration wizard, a new directory will be created.

The user map is "complex" because it's not one single user. It's several. "Nobody", "LoggedIn", "Everyone", and "Admin".

 
Dralt

Joined: 2004-07-03
Posts: 7
Posted: Wed, 2004-07-07 16:36

I did just that.

I assume it worked, but it's still fishy.

The configuration wizard did recreate the .users directory and its content.

However, when I accessed the gallery for the first time, I still got:

The user database in your gallery was created with an older version of the software and is out of date. This is not a problem! We will upgrade it. This may take some time. Your data will not be harmed in any way by this process. Rest assured, that if this process takes a long time now, it's going to make your gallery run more efficiently in the future. 
If you get an error, and only some users are upgraded, try refreshing the page to upgrade remaining users. 

Please Wait...

1 user was upgraded and 3 users were skipped.

I guess that was admin + "Nobody" + "LoggedIn" + "Everyone".

What I found weird is the need to upgrade something that was created by the config wizard of the very latest version.

Does the wizard create those users according to the old format?

 
freshweb

Joined: 2004-06-29
Posts: 10
Posted: Wed, 2004-07-07 18:32

I have reinstalled the program had my webhost company change the permissions again and I still get the same error message?

The user database in your gallery was created with an older version of the software and is out of date. This is not a problem! We will upgrade it. This may take some time. Your data will not be harmed in any way by this process. Rest assured, that if this process takes a long time now, it's going to make your gallery run more efficiently in the future.
If you get an error, and only some users are upgraded, try refreshing the page to upgrade remaining users.

Please Wait...

Checking user 1 of 3 . . . . skipped
Checking user 2 of 3 . . . . skipped
Checking user 3 of 3 . . . . skippedError: Could not acquire lock (/home/virtual/freshwebdesign.ca/webroot/htdocs/xessive/gallery/albums/.users/userdb.dat.lock)!Error: Could not acquire lock (/home/virtual/freshwebdesign.ca/webroot/htdocs/xessive/gallery/albums/.users/userdb.dat.lock)!

Error: There was a problem upgrading users. Please check messages above, and try again

Why? Why? Why?

Thanks

 
signe
signe's picture

Joined: 2003-07-27
Posts: 2322
Posted: Wed, 2004-07-07 20:28

freshweb, I don't know what your host is doing, but they are NOT setting the permissions correctly.

 
freshweb

Joined: 2004-06-29
Posts: 10
Posted: Wed, 2004-07-07 22:23

.users dir and the three files that are in the directory are all chmoded to 777. I checked on Smart ftp? Is there another file that I am missing???

 
signe
signe's picture

Joined: 2003-07-27
Posts: 2322
Posted: Wed, 2004-07-07 23:05

freshweb, that's what you thought last time, but given what I saw when I logged in last time, it wasn't true.

You're still getting the error.. that means it's not right. I don't know what to tell you.

 
freshweb

Joined: 2004-06-29
Posts: 10
Posted: Thu, 2004-07-08 01:11

Actually the last time I had deleted the program and reinstalled it. When you checked it I suspect it was the time lapse before the hosting co changed it. I guarantee that at this moment all the permissions in the files under the albums are 777!

I am still getting the error message and to echo Dalte "What I found weird is the need to upgrade something that was created by the config wizard of the very latest version."

seems to me there is a something wrong with the program.

 
h0bbel
h0bbel's picture

Joined: 2002-07-28
Posts: 13451
Posted: Thu, 2004-07-08 06:48

freshweb, pm me some logon details and I can have a look at it for you. It's not normal by any means that this should be so har to accomplish.

As for upgrading during an initial install, thats because we need to force the upgrade routine to execute after an upgrade. There has been a lot of changes to the userdatabase, and if we don't force the upgrading, people upgrading for 1.3.x to 1.4.3pl2 would get big problems.