Unable to log in - CRITICAL ERROR

[flightless]

When I have typed in the user name and password and click on "LOGIN", I get the following error:

Critical error
There was an error while processing a database query


What do I need to do to fix this?

[Joachim Müller]

enable debug mode to get a better error message. Use a tool like phpMyAdmin, browse coppermine's config table, set debug_mode to "1". Post the error message (not the debug_ouput!). Post a link to your site as well.

[flightless]

I did as requested above.

This is the error message I am getting now:


While executing query "SELECT user_id, user_name, user_password_md5 FROM cpg133_users WHERE user_name = '********' AND BINARY user_password_md5 = md5('******') AND user_active = 'YES'" on 0

mySQL error: Unknown column 'user_password_md5' in 'field list'


My setup is at:

http://www.lvanduyn.com/coppermine/

[Stramm]

have you tried to update to 1.4 and stepped back

[flightless]

No I haven't. 

What do you mean by "stepped back"?

[Stramm]

that you downgraded back to 1.3... cause there was no user_password_md5 in 1.3 (as far as I remember)

[flightless]

I understand now.

No, I did not upgrade and then step back.

[Stramm]

please attach your login.php to your next post (rename to txt)

[flightless]

Here it is.

[Stramm]

this file has been crippled by msfedit. I hope that just happened when you opened it with a MS prog and save as txt. You musn't do that. It's OK if you just rename the file within Windows Explorer

Nevertheless that's not the original login.php that comes with CPG 1.3.3
Either reupload an unmodified version (I attach one) or even better upgrade to at least 1.3.5 (I recommend to upgrade to the latest stable 1.4.5)

Uploading the orig 1.3.3 upload.php may not fully work if you applied some mods (I guess so cause of your changed login file)

[flightless]

Thank you, Stramm, for your effort. I will respond once I have this working again.