Hi,
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
Hi,
@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.
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' "
Any advise?
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.
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.
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?