Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Can't Login After Upgrade to v1.6  (Read 3383 times)

0 Members and 1 Guest are viewing this topic.

RoyReed

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Can't Login After Upgrade to v1.6
« on: January 31, 2019, 04:08:46 pm »

I've just upgraded my gallery to 1.6.05 and although everything in the gallery appears to be working, I can no longer login as Admin. I've enabled debug_mode via PHPAdmin and this is the error message I'm seeing:
__________

Critical error
There was an error while processing a database query.

While executing query 'SELECT user_password, user_password_salt, user_password_hash_algorithm, user_password_iterations FROM `rdesign_cpg572`.cpggj_users WHERE user_name = 'RoyReed' AND user_active = 'YES' LIMIT 1' in bridge/udb_base.inc.php on line 57

database error: 1054 : Unknown column 'user_password_salt' in 'field list'

File: /data04/rdesign/public_html/cpg/include/functions.inc.php - Line: 250
__________

I'm the only Admin/User for this site: https://reeddesign.co.uk/cpg/

Can anyone help please.
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Can't Login After Upgrade to v1.6
« Reply #1 on: January 31, 2019, 04:38:50 pm »

Did you remember to run update.pho ?
Logged
It is a mistake to think you can solve any major problems just with potatoes.

RoyReed

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Can't Login After Upgrade to v1.6
« Reply #2 on: January 31, 2019, 05:20:20 pm »

I upgraded via Scriptaculous, so not unless they include that as part of their update routine.
Logged

FansCityEu

  • Coppermine newbie
  • Country: 00
  • Offline Offline
  • Posts: 17
  • FC
Re: Can't Login After Upgrade to v1.6
« Reply #3 on: January 31, 2019, 06:31:06 pm »

Go to PHPMyAdmin to "users" table, copy your user, change name and password (MD5 type), login with that new admin account and change your other admin password from there, it happened to a few clients when they upgraded with upgrader.php a few months back
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Can't Login After Upgrade to v1.6
« Reply #4 on: January 31, 2019, 09:56:21 pm »

Try running update.php as per the docs. When the upgrade to the new version is done there are quite a few things to also change in the database. One of those things is salting the passwords, one of the security updates that have been added. Unless your run update.php you may find other problems occur.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

RoyReed

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Re: Can't Login After Upgrade to v1.6
« Reply #5 on: February 01, 2019, 10:43:51 am »

Try running update.php as per the docs. When the upgrade to the new version is done there are quite a few things to also change in the database. One of those things is salting the passwords, one of the security updates that have been added. Unless your run update.php you may find other problems occur.
Thank you - that worked!
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 19 queries.