Problems after reseting configuration to standard values

[captain-lars]

Hi,

i  used coppermine 1.4.2 and i have pressed "reset to factory setting" by mistake and now i can't even login again. I can see that the user still exists in the database, but erverytime the error "could not login" occurs.

Can i undo the reset to factory setting? In which file the settings are stored? Is it include\config.php (this file contains only the right database settings in my installtion)? What is going wrong with the login?

Thanks in advance,

Lars.

[captain-lars]

I have some additonal infos.

The user entry in the database has an empty 'user_group_list' field. I tried to set it to "1" or "Adminstrators", but both doesn't help. I can't login. What is the correct syntax of this field?

[Joachim Müller]

"1" stands for "admin group", so this should be working.

[captain-lars]

I have found the problem. The password in the database was not encrypted! Now it works!

[Tranz]

Did you have a fresh 1.4 install or did you upgrade from 1.3? Maybe this reset issue has to do with the password encryption when the config gets reset?

[Nibbler]

Filed bug

http://forum.coppermine-gallery.net/index.php?topic=24548.0

[Audioslave]

Hi!

I just did the same mistake, and dont know what to do. Can anyone please explain what I have to do to be able to login again? Thanks!

[captain-lars]

Go to your cpg-database and update your admin password with the mysql function password().

[Nibbler]

No, don't do that. Set encrypted passwords to 0 in the config table.

[mizma]

Okay - where's the config table?
in the files...ah ah ah - so I found the coppermine files, I fopund something called config.php and in there I found a reference to configtable, but I'll be darned if I can figure out to set it to zero.  Is it possible to give us step by step instructions? 

[Joachim Müller]

not in a file, but the database. Use phpMyAdmin or similar, browse coppermine's config table.