Upgraded 1.5.1 to 1.5.4. Store seems fine, admin directs to "Thank you for.." page

I upgraded 1.5.1 to 1.5.4... went through all of the changed and new files, uploaded them over the 1.5.1 site, ran the DB upgrade from zc_install with no errors. If I try to connect to the admin page, however, it displays the "Hello! Thank you for installing Zen Cart" default page.

I've confirmed permissions on the configure.php files in store and admin, admin folder was moved, I'm using the new dist-configure.php files as my template and use the original data from the old configure.php files in case I missed a change...

I'm at a loss. Everything else seems to be running fine, but without access to the admin pages the store isn't much use :)

Running on CentOS 7, PHP 5.5.33

Please post both your configure.php files here and use the # code tag to enclose
XX out sensitive data about your admin folder and DB details

Admin:

Code:

---


<?php
/**
 * WE RECOMMEND THAT YOU USE SSL PROTECTION FOR YOUR ENTIRE ADMIN:
 * To do that, make sure you use a "https:" URL for BOTH the HTTP_SERVER and HTTPS_SERVER entries:
 */
  define('HTTP_SERVER', 'https://XXXXXXXX.com');
  define('HTTPS_SERVER', 'https://XXXXXXXX.com');
  define('HTTP_CATALOG_SERVER', 'http://XXXXXXXX.com');
  define('HTTPS_CATALOG_SERVER', 'https://XXXXXXXX.com');

  // secure webserver for admin?  Valid choices are 'true' or 'false' (including quotes).
  define('ENABLE_SSL_ADMIN', 'false');

  // secure webserver for storefront?  Valid choices are 'true' or 'false' (including quotes).
  define('ENABLE_SSL_CATALOG', 'true');


  define('DIR_WS_ADMIN', preg_replace('#^' . str_replace('-', '\-', zen_parse_url(HTTP_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');
  define('DIR_WS_CATALOG', '/');
  define('DIR_WS_HTTPS_ADMIN', preg_replace('#^' . str_replace('-', '\-', zen_parse_url(HTTPS_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');
  define('DIR_WS_HTTPS_CATALOG', '/');

//  define('DIR_WS_ADMIN', '/XXXXXXXX/');
//  define('DIR_WS_CATALOG', '/');
//  define('DIR_WS_HTTPS_ADMIN', '/XXXXXXXX/');
//  define('DIR_WS_HTTPS_CATALOG', '/');


// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
  // these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
  define('DIR_WS_IMAGES', 'images/');
  define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
  define('DIR_WS_CATALOG_IMAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'images/');
  define('DIR_WS_CATALOG_TEMPLATE', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/templates/');
  define('DIR_WS_INCLUDES', 'includes/');
  //  define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
  define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
  define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
  define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
  define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
  define('DIR_WS_CATALOG_LANGUAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/languages/');

// * DIR_FS_* = Filesystem directories (local/physical)
  define('DIR_FS_ADMIN', preg_replace('#.includes$#', '', realpath(dirname(__FILE__) . '/../') . '/'));

  define('DIR_FS_CATALOG', '/');

  //the following path is a COMPLETE path to the /logs/ folder  eg: /var/www/vhost/accountname/public_html/store/logs ... and no trailing slash
  define('DIR_FS_LOGS', DIR_FS_CATALOG . '/logs');

  define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
  define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
  define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
  define('DIR_FS_CATALOG_TEMPLATES', DIR_FS_CATALOG . 'includes/templates/');
  define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
  define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');
  define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', 'zen_');
  define('DB_CHARSET', 'utf8');
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'XXXXXXXX_zc1');
  define('DB_SERVER_PASSWORD', 'XXXXXXXX');
  define('DB_DATABASE', 'XXXXXXXX_zc1');

  //define('DB_SERVER_USERNAME', '');
  //define('DB_SERVER_PASSWORD', '');
  //define('DB_DATABASE', '');

  // The next 2 "defines" are for SQL cache support.
  // For SQL_CACHE_METHOD, you can select from:  none, database, or file
  // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
  // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
  // ie: /path/to/your/webspace/public_html/zen/cache  -- leave no trailing slash
  define('SQL_CACHE_METHOD', 'none');
  define('DIR_FS_SQL_CACHE', '/home/XXXXXXX/public_html/cache');

---

Store:

Code:

---

<?php

/*************** NOTE: This file is similar, but DIFFERENT from the "admin" version of configure.php. ***********/
/***************      The 2 files should be kept separate and not used to overwrite each other.      ***********/
// Define the webserver and path parameters
  // HTTP_SERVER is your Main webserver: eg-http://www.your_domain.com
  // HTTPS_SERVER is your Secure webserver: eg-https://www.your_domain.com
  define('HTTP_SERVER', 'http://XXXXXXXX.com');
  define('HTTPS_SERVER', 'https://XXXXXXXX.com');

  // Use secure webserver for checkout procedure?
  define('ENABLE_SSL', 'true');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
  // these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
  define('DIR_WS_CATALOG', '/');
  define('DIR_WS_HTTPS_CATALOG', '/');

  define('DIR_WS_IMAGES', 'images/');
  define('DIR_WS_INCLUDES', 'includes/');
  define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
  define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
  define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
  define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
  define('DIR_WS_DOWNLOAD_PUBLIC', DIR_WS_CATALOG . 'pub/');
  define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');

// * DIR_FS_* = Filesystem directories (local/physical)
//the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
//define('DIR_FS_CATALOG', '/path/to/store/');
  define('DIR_FS_CATALOG', '/home/XXXXXXXX/public_html/');

//the following path is a COMPLETE path to the /logs/ folder  eg: /var/www/vhost/accountname/public_html/store/logs ... and no trailing slash
define('DIR_FS_LOGS', DIR_FS_CATALOG . '/logs');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/');
define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS);
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_'); // prefix for database table names -- preferred to be left empty
define('DB_CHARSET', 'utf8');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'XXXXXXXX_zc1');
define('DB_SERVER_PASSWORD', 'XXXXXXXX');
define('DB_DATABASE', 'XXXXXXXX_zc1');

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from:  none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache  -- leave no trailing slash
define('SQL_CACHE_METHOD', 'none');
define('DIR_FS_SQL_CACHE', '/home/XXXXXXXX/public_html/cache');

//EOF

---

I did try SSL admin true and false with the same result.

DIR_FS_CATALOG is wrong in the admin version. That's a starter, might see something else...

Corrected the DIR_FS_CATALOG and at least I'm not getting the welcome page :)
Now it's "WARNING: An Error occurred, please refresh the page and try again"

Progress at least.

The error in the error log is:
PHP Fatal error: 1101:BLOB/TEXT column 'logmessage' can't have a default value ::
ALTER TABLE zen_admin_activity_log ADD COLUMN logmessage mediumtext NOT NULL default ''

So then should have an additional myDebug log in your logs folder. If it's still banner related curious about what you have installed/turned on that logs queries to your backups folder... Seems somewhat odd...

The other thing of importance is to identify how you did this upgrade as requested in the posting tips...

Could also be that you have content in your banner(s) that is no longer acceptable in more recent versions (without customization). Might have to dig into phpmyadmin at some point to turn off some thiings/make modifications.

Quote:

---

Originally Posted by asudol

The error in the error log is:
PHP Fatal error: 1101:BLOB/TEXT column 'logmessage' can't have a default value ::
ALTER TABLE zen_admin_activity_log ADD COLUMN logmessage mediumtext NOT NULL default ''

---

Was that just now created? That would have more than likely been related to the upgrade process or there is an auto-installer that is doing something... Normally there are no table alterations performed in the process of accessing the store/admin unless such a plugin condition is occurring.... Unfortunately the information above doesn't identify in what file(s) this is occurring.

FYI, this is what shows that was called... it logged it every time I tried to access the admin page.

(as called by) /home/XX/public_html/XX/includes/classes/class.admin.zcObserverLogWriterDatabase.php on line 90 <== in /home/XX/public_html/includes/classes/db/mysql/query_factory.php on line 155

I appear to have corrected it by running the ALTER as shown, but removing the default:
ALTER TABLE zen_admin_activity_log ADD COLUMN logmessage mediumtext NOT NULL

I'm in and everything is working.. but definitely it's interesting that it was even trying to alter a table just by accessing the admin page...

Okay, maybe I remember that one, but if nothing else at least the file looks more trustworthy. :)