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');

[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/?

[mc12345678]

And the screen says...

As you probably know, this is expected based on the debug log identifying an error. What lat9 identified seems to be a possibility though even with starting with a 1.5.1 database, that field already existed. Only thing that really makes sense is that the database referenced doesn't have a the admin that is even that recent.

Provided data about the current system configure files, what about the original store? What db_prefix did it have?

[swguy]

Go to phpmyadmin, select database soycnanc_151, go to table admin and click structure to view the schema. Post a screenshot of the schema.

[dbltoe]

Covid twice was way easier than this!
The original structure had admin_level as you can see in the image.
After bringing it over and getting all the files up to really 1.5.1, the DB upgrade added fields to the admin table but left the admin_level field.

[dbltoe]

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

Nothing in any of my tries but skip_version_check.inoi

[dbltoe]

To add further info,
brought over the files

files had four sub or sub-sub folders named public_html

finally found correct root/admin and added them to the new site

brought over DB dump from old site.

had to load 5.3 to get anything to work. 5.3 gave timezone error and that was set

loaded files and database from old site and tried to run on our server. Admin would not let us in even after sending new password. Kept getting the "incorrect password" notice.

pulled down fresh 1.5.1 and went file by file to ensure the site was all 1.5.1 (found many 1.3.9 and 1.5.0 files in existance)

after that, we could get the storefront with products and images but still no joy on the admin.

used zc_install and it did have the DB upgrade option. Ran that, got success notice, still couldn't get into admin (all times/tries showed that version's admin login screen

All zc_install operations at 1.5.1 reported a curl error if that makes any difference

created a 1.5.5 test site and imported the DB. Upgrade reported succes but still no access to the admin although passwords created did not report "incocrrect password" We got a 500 and a PHP parse error unexpected 'if' (T_IF) in /home/USER/public_html/ADMIN/login.php on line 22

19.5 years at this. You'd think I could at least stumble on a fix