Saving information in admin panel...

[kakarotto]

I was changing the configuration of my gallery in the admin panel.. ( the admin.php page) and I was trying to have guests be able to view my gallery....
but when I change the option to YES i click save settings and go back and the setting wasnt saved. I tried going into the sql and changing the setting but I can't find it.

" Allow unlogged users (guest or anonymous) access"  <--- won't update. Can anyone give me the SQL query for this setting? I think I might be missing it.

Thanks!!
ps:other options are updating.

[LeeWHill]

I had this problem, and it appeared to be because the cpg_config table in the MySQL database was incomplete. I had a look at the table in phpmyadmin and couldn't find a record for allow_unlogged_access. There were only 89 records in this table. I then created a new instance of Coppermine, and had a look at the config table there, to find 130 records, including an allow_unlogged_access. I think that this must have occurred while I was upgrading to the latest version, because the upgrade didn't seem to complete correctly.

To fix the problem I exported the table from the second installation (in SQL format) and imported it into the first installation's database (after dropping the config table that was already there). This meant that I had to reconfigure the whole gallery from scratch, but at least it let me allow unlogged access again.

The other thing to be aware of is that the enable_encrypted_passwords setting will be set back to 'on' when you do this. If you had it off beforehand (as I did) all your passwords will suddenly become invalid and you won't be able to log in, so you'll need to use phpmyadmin to turn this setting off again.

[Joachim Müller]

Thanks for your explanation. However, doing as you explained should not be the regular method. The update.php script should take care of the missing database entries being created when performing an upgrade. If it doesn't, there's something fishy with the permissions of your mysql user.