FYI: Had the same problem. Solution for me was a new password that contained characters from the following groups: capital letter, small letter, number and special character.
To developer: If you set constraints to password, please validate new passwords to avoid lockouts. Also update information box on the password reset page as it suggests only two character groups ({A-Za-z0-9}, {~!@#$%&*_+`-(),.\^'"/[]{}=:;?|}).
The suggestion is just a suggestion within the field as you can edit it to include or exclude yourself. The information text does not suggest any group specifially, it refers to the values set:
Passwords must contain at least one of the characters from each of the groups. Groups are separated by "|". (Use "\|" to represent the "|" character in the groups.)
About maybe missing validation (not familar with the password stuff) please open a ticket. Otherwise this gets lost.
I already changed my password to meet those requirements and that is when the 404 error started happening. Now I can't login to my site nor can my clients whose photo albums I post there for previewing.
The password option applies only to creating new/changing old passwords. If you already have a password which does not meet the standards it will still work (but may not be so secure.) The box does exactly tell you what character groups are required, so I do not understand your comment. Besides which, you can set the criteria to whatever you choose.
Well, no one "forces" you to upgrade if the site works for you. "If it ain't broke, don't fix it". But due to lacking resource we are only able to support the current release.
You should look at the debug log files and report...
In our tests it works pretty well and we were able to login even after upgrade. The bug is serious and will cause everyone upgrading to be unable to login.
Yes, and it is a known issue that is fixed in the just released 1.4.1.1 version. (btw, the contact form was not working so we did not get a mail. Sorry about that).
Besides, the correct place to log problems is the Trac system as described in the "rules and usage" document. Anything else will probably not be acted upon and certainly cannot be tracked to be sure it was acted upon.
@acrylian the bug is there in the 1.4.1.1 as well. We had emailed your the FIX. Can we have some email address where its possible to email you ? Its rather better we first discuss it before you launch it.
Please use the contact form. As said it was broken for as short time when you tried to use it. We both will get the mail and one of us will get back to you.
Sorry, we did not encounter this issue ourselves. So you need to delete the administrators table in your database and re-run setup. Then set a new password.
Ok, thanks, got around that. But now all users have no group affiliation (all users was assigned to a group) and there's a new user '1' that wasn't there before.
If I try to assign a group to a user I get the following error message:
"Zenphoto encountered an error MySQL Query ( UPDATE `zp_administrators` SET `id`=NULL WHERE `id`='32' ) failed. MySQL returned the error Duplicate entry '0' for key 'PRIMARY' "
You did not say how you "got around" you previous problem, but somehow things in your database are messed up. The query you cite above does not seem proper, so I do not know how it would occur.
Please change the define `DEBUG_ERROR` to `true` in the global-definitions.php script and re-run. This will give a stack trace of where this error is being generated.
Got around by deleting the administrators table after upgrading to 1.4.1.1 and re-ran setup. Then I'm able to login but all users and groups are gone. No user could login after the first attempt of upgrading so I couldn't just delete the admin user as suggested by acrylian.
To prevent to have to add all users and groups I restored the database from before the upgrade. That was a backup of 1.4.0.4 restored to 1.4.1.1. Is that bad due to different versions? If not I redo again and change the DEBUG_ERROR define.
What about softaculous comments above that there's a issue with the upgrade process in 1.4.1.1, has that been looked into?
So what I'm looking for is a solution to upgrade from 1.4.0.4 to 1.4.1.1 and still be able to login and not having to add all users and groups.
Softaculous did not contact us so far. Regardless Softaculous to my knowledge is an install helper similar to Simple Scripts we don't really support (as we explained lots of times).
The only issue we have had was with a now disabled option to tie cookies to IP addresses. This would only be an issue if your browser IP address changes with each page refresh. Then you would indeed not be able to login ever.
I'm having the same log-in problem on 1.4.1 even though I did a clean install rather than an upgrade. The download from your site was done on 6/24/2011. I did the install a couple of weeks ago and everything worked fine. I set up users, logged in and out, all was well. Today, I can't log in at all with either of the two defined admin users. Nothing has changed other than a clearing of cached cookies, client re-boots, etc. I turned on the login debug option, and the debug file indicates everything worked fine - the user id/ password entry results in a match against a configured admin user. But all I see is a refresh of the login screen from admin.php - no error message, just a repaint of the login screen. I have tried it using both IE 8 and FireFox 5.x with the same results. I won't wave my arms about how bad this is, but I could sure use some help. By the way, it all works fine on my test Windows system - the problem is occurring on the public version which is running on a Yahoo Unix-based hosted service.
Again, we are sorry, but we did not encounter this issue ourselves. So the easiest fix is to delete the adminstrator table on the database, re-run setup and set a new admin account.
Ok, but wouldn't it make more sense to try to debug this thing and figure out what's wrong? Even if the drop-table technique works, I have no reason to think the problem won't occur again. And judging from the forum traffic, I'm not the only one having this problem. I'm in a position to do debugging work, but it would go a lot faster if someone familiar with the ZenPhoto code base could give me some help. Can that be done?
The download from your site was done on 6/24/2011.
Maybe a better approach would be for you to install a current update? Today is the 22 July, almost a month from when you did your download. Since then there even has been a 1.4.1.1 release. We do not usually debug except on current nightly builds. Waste of time if the problem has already been fixed.
You did notice that I posted that there have been fixes with regard to loggin in, didn't you? It is in this thread.
Comments
micheall
Best to e-mail me the log. Not sure what sensitive data is in it.
To developer: If you set constraints to password, please validate new passwords to avoid lockouts. Also update information box on the password reset page as it suggests only two character groups ({A-Za-z0-9}, {~!@#$%&*_+`-(),.\^'"/[]{}=:;?|}).
Best regards,
Kaarel
The password option applies only to creating new/changing old passwords. If you already have a password which does not meet the standards it will still work (but may not be so secure.) The box does exactly tell you what character groups are required, so I do not understand your comment. Besides which, you can set the criteria to whatever you choose.
still cant login after doing everything that was posted in this thread.
what do I do with the debug files?
You should look at the debug log files and report...
There is a BUG in the UPGRADE Utility file.
@sbillard and @zenphotodevelopers, I have emailed you the fix using this contact form :
http://www.zenphoto.org/pages/contact
In our tests it works pretty well and we were able to login even after upgrade. The bug is serious and will cause everyone upgrading to be unable to login.
Waiting for your reply.
Regards,
Softaculous Team
@acrylian the bug is there in the 1.4.1.1 as well.
We had emailed your the FIX.
Can we have some email address where its possible to email you ?
Its rather better we first discuss it before you launch it.
Is this issue resolved?
Tried to upgrade from 1.4.0.4 to 1.4.1.1 but couldn't login after the upgrade so went back to 1.4.0.4.
If I try to assign a group to a user I get the following error message:
"Zenphoto encountered an error
MySQL Query ( UPDATE `zp_administrators` SET `id`=NULL WHERE `id`='32' ) failed. MySQL returned the error Duplicate entry '0' for key 'PRIMARY' "
Any advise?
Please change the define `DEBUG_ERROR` to `true` in the global-definitions.php script and re-run. This will give a stack trace of where this error is being generated.
To prevent to have to add all users and groups I restored the database from before the upgrade. That was a backup of 1.4.0.4 restored to 1.4.1.1. Is that bad due to different versions? If not I redo again and change the DEBUG_ERROR define.
What about softaculous comments above that there's a issue with the upgrade process in 1.4.1.1, has that been looked into?
So what I'm looking for is a solution to upgrade from 1.4.0.4 to 1.4.1.1 and still be able to login and not having to add all users and groups.
But as said, that is disabled now.
You did notice that I posted that there have been fixes with regard to loggin in, didn't you? It is in this thread.