Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Unable to log in - CRITICAL ERROR  (Read 13202 times)

0 Members and 1 Guest are viewing this topic.

flightless

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Unable to log in - CRITICAL ERROR
« on: April 18, 2006, 03:05:58 pm »

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?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Unable to log in - CRITICAL ERROR
« Reply #1 on: April 19, 2006, 09:57:37 am »

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.
Logged

flightless

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Unable to log in - CRITICAL ERROR
« Reply #2 on: April 25, 2006, 09:11:24 am »

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/
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Unable to log in - CRITICAL ERROR
« Reply #3 on: April 25, 2006, 10:01:25 am »

have you tried to update to 1.4 and stepped back

flightless

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Unable to log in - CRITICAL ERROR
« Reply #4 on: April 25, 2006, 10:15:48 am »

No I haven't. 

What do you mean by "stepped back"?
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Unable to log in - CRITICAL ERROR
« Reply #5 on: April 25, 2006, 10:17:42 am »

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

flightless

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Unable to log in - CRITICAL ERROR
« Reply #6 on: April 25, 2006, 10:30:23 am »

I understand now.

No, I did not upgrade and then step back.
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Unable to log in - CRITICAL ERROR
« Reply #7 on: April 25, 2006, 10:35:12 am »

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

flightless

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Unable to log in - CRITICAL ERROR
« Reply #8 on: April 25, 2006, 11:49:39 am »

Here it is.
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Unable to log in - CRITICAL ERROR
« Reply #9 on: April 25, 2006, 01:05:12 pm »

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

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Unable to log in - CRITICAL ERROR
« Reply #10 on: April 25, 2006, 02:31:53 pm »

Thank you, Stramm, for your effort. I will respond once I have this working again.
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 20 queries.