Critical Error at admin login

[BradInOKC]

When I try to login as admin, I get "Critical error
There was an error while processing a database query"

Any thoughts?  http://www.builderbobs.com/gallery/clearance is the url

Thanks for your help.

[BradInOKC]

Just another note...  I have three galleries on the same mysql server, and this is the only one of the three that is suddenly giving me problems...  I have not changed anything that I can think of, except relatively recently I edited my template's php file...but I have not had any problems with my other galleries and I changed those templates as well.  Thanks for any help you can think of.

[phill104]

First update your gallery as we are now on 1.5.6

Try and see if it works with another theme such as curve. If not enable debug and post the error.

[BradInOKC]

I'm in the process of updating now, didn't know about the new release.  How can I change the theme I use if I cannot login as admin?

[onthepike]

Use phpMyAdmin and select your CPG database. Then select the config table and scroll to theme (could be on any of multiple pages; all in alphabetical order). Change your theme manually, as you would any other configuration option using phpMyAdmin:

[phill104]

Or read the docs - http://documentation.coppermine-gallery.net/en/theme_create.htm#theme_create_tipps

This tells you that all you need to do is use the right link and your will see your site with your chosen theme. None of that silly messing around with the database needed.

In your case try this - http://www.builderbobs.com/gallery/clearance/index.php?theme=curve

Notice the ?theme=curve at the end?

[Αndré]

Using the url parameter is recommended, as we store the user's settings in the cookie. If you change the default theme in the database, it won't change your individual settings.

[BradInOKC]

Well, I upgraded my galleries w/no problems...thanks again for the heads up about the upgrade.  I think the problem I was having yesterday really had to do with this computer, because I was able to login as admin from other computers.  I deleted my temporary internet files, and it let me login again.  Your comment about the cookies made me think to try that.  Thanks for your help, hopefully the problem is fixed for good.  It would sometimes allow me to login as admin, but then say "Welcome Guest" and not show the admin controls.  I suspect the last time I admin'd the gallery from this computer I did a "Hide Admin Controls" and maybe that fouled things up from this computer?  Anyway, thanks again.

[Joachim Müller]

I suspect the last time I admin'd the gallery from this computer I did a "Hide Admin Controls" and maybe that fouled things up from this computer?

Never hide admin controls then...

[BradInOKC]

lol, probably a good plan...  now to fix this new problem uploading...very strange and sudden problems lately.

[Αndré]

It would sometimes allow me to login as admin, but then say "Welcome Guest" and not show the admin controls.

I recognized that on my testbed, too. If it happens, you aren't logged. I thought it depends on my testbed, as I haven't recognized that on my production gallery.

If it happens the next time to me, I'll have a closer look at the browser cookies and Coppermine's session table.