Upgrade Completes BUT

[dbltoe]

Upgraded 1.5.1 to 1.5.8 by installing a bare 1.5.8 and replacing the DB with that of the old 1.5.1. zc_install gave database upgrade option.

Using that reported thee upgrade as successful and completed to remove zc_install message.

I am able to see the storefront and all products are present. (imamges not copied over yet)

When I try to log in to the admin, I continually get:

[15-Jul-2023 17:39:05 UTC] Request URI: /ADMIN/index.php?cmd=login&camefrom=index.php, IP address: 123.345.567.789, Language id 1#1  trigger_error() called at [/home/*****/*****/includes/classes/db/mysql/query_factory.php:703]
#2  queryFactory->show_error() called at [/home/*****/*****/includes/classes/db/mysql/query_factory.php:648]
#3  queryFactory->set_error() called at [/home/*****/*****/includes/classes/db/mysql/query_factory.php:289]
#4  queryFactory->Execute() called at [/home/*****/*****/ADMIN/includes/functions/admin_access.php:272]
#5  zen_read_user() called at [/home/*****/*****/ADMIN/includes/functions/admin_access.php:290]
#6  zen_validate_user_login() called at [/home/*****/*****/ADMIN/login.php:34]
#7  require(/home/*****/*****/ADMIN/login.php) called at [/home/*****/*****/ADMIN/index.php:11]
--> PHP Fatal error: MySQL error 1054: Unknown column 'admin_profile' in 'field list' :: SELECT admin_id, admin_name, admin_email, admin_pass, pwd_last_change_date, reset_token, failed_logins, lockout_expires, admin_profile
            FROM admin WHERE admin_name = 'jeandert'  LIMIT 1 ==> (as called by) /home/*****/*****/ADMIN/includes/functions/admin_access.php on line 272 <== in /home/*****/*****/includes/classes/db/mysql/query_factory.php on line 703.

The admin_profile column DOES exist but nothing I do seems to make the system want to accept it.

Thoughts?

[DrByte]

First thing that comes to mind is whether it's pointed at the correct database, in the admin configure.php

[dbltoe]

Store

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', ''); // prefix for database table names -- preferred to be left empty
define('DB_CHARSET', 'utf8');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'soycnanc_marjac');
define('DB_SERVER_PASSWORD', 'Bm1e_}#R');
define('DB_DATABASE', 'soycnanc_151');

admin

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', '');
  define('DB_CHARSET', 'utf8');
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'soycnanc_marjac');
  define('DB_SERVER_PASSWORD', 'Bm1e_}#R');
  define('DB_DATABASE', 'soycnanc_151');

[lat9]

Store

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', ''); // prefix for database table names -- preferred to be left empty
define('DB_CHARSET', 'utf8');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'soycnanc_marjac');
define('DB_SERVER_PASSWORD', 'Bm1e_}#R');
define('DB_DATABASE', 'soycnanc_151');

admin

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', '');
  define('DB_CHARSET', 'utf8');
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'soycnanc_marjac');
  define('DB_SERVER_PASSWORD', 'Bm1e_}#R');
  define('DB_DATABASE', 'soycnanc_151');

Er, the database export that you provided via direct email uses a DB_PREFIX of zen_ ... that could easily be the underlying issue.

[dbltoe]

That's from a different try where I used phpmyadmin to remove the prefix

[lat9]

Using the as-sent database (with a zen_ DB_PREFIX), setting that constant to reflect that fact in both the admin and storefront configuration files yielded a successful upgrade from 1.3.9h to 1.5.8a and I was able to log into the admin after renaming zc_install.

[lat9]

What version of PHP is in use?

[dbltoe]

And the screen says...

WARNING: An Error occurred, please let us know! If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data.

[lat9]

Is there a configure.php file in admin/includes/local/?

[dbltoe]

Is there a configure.php file in admin/includes/local/?

Nothing in any of my tries but skip_version_check.inoi