Dear all,

I’ve migrated CA providence from 1.7.5 (on Windows server 2012, MySQL5.7, PHP7.0.17, Apache 2.4.52) to 1.7.17 (on Windows server 2019, MySQL8.0.35, PHP7.4.8, Apache 2.4.52) yesterday.
After I completed my installation and loaded my database backup to the new providence, I found that the data for relationships is missing. Such as object records, I have added related objects, related entities, related objects and related events in my old providence but could not find them in the relationship page of object records in new providence.
Also, I’ve tried to rebuild index by running rebuild index command but I’ve got an error:
Could not find your CollectiveAccess setup.php file! Please set the COLLECTIVEACCESS_HOME environment variable to the location of your CollectiveAccess installation, or run this command from a sub-directory of your CollectiveAccess installation.

I’ve already set COLLECTIVEACCESS_HOME environment variable.
In my old set file 1.7.5, there is a part (see below) could not be found in 1.7.17, should I add this part to the setup file of 1.7.17?

CA_BASE_DIR = the absolute server path to the directory containing your CollectiveAccess installation

The default value attempts to determine the path automatically. You should only change this if it's

failing to derive the correct value.

If you must to set this manually, enter the correct directory but omit trailing slashes!

For Windows hosts, use a notation similar to "C:/PATH/TO/COLLECTIVEACCESS"; do NOT use backslashes

#
#if (!defined("CA_BASE_DIR")) {

define("CA_BASE_DIR", pathinfo(preg_replace("!/install|/viewers/apps|/tests|support/bin/!", "", isset($SERVER['SCRIPT_FILENAME']) ? $SERVER['SCRIPT_FILENAME'] : FILE), PATHINFO_DIRNAME));

##}
if (!defined("CA_BASE_DIR")) {
define("CA_BASE_DIR", "C:/Apache24/htdocs/providence");
}
#

CA_URL_ROOT = the root-relative URL path to your CollectiveAccess installation

The default value attempts to determine the relative URL path automatically. You should only change

this if it's failing to derive the correct value.

If you must to set this manually leave the __CA_URL_ROOT_ BLANK if the CollectiveAccess directory is the

web server root or in the root directory of a virtual host. If CollectiveAccess is in a subdirectory or

an alias is used to point the web server to the correct path, set 'CA_URL_ROOT' to

the relative url path to the subdirectory; start the path with a slash ('/') but omit trailing slashes.

Example: If CollectiveAccess will be accessed via http://www.mysite.org/apps/ca then CA_URL_ROOT would be set to /apps/ca

#
#if (!defined("CA_URL_ROOT")) {

define("CA_URL_ROOT", str_replace(isset($SERVER['DOCUMENT_ROOT']) ? $SERVER['DOCUMENT_ROOT'] : '', '', CA_BASE_DIR));

#}
if (!defined("CA_URL_ROOT")) {
define("CA_URL_ROOT", "/providence");
}

CA_SITE_HOSTNAME = the hostname for your system

The default value attempts to determine the relative URL path automatically. You should only change

this if it's failing to derive the correct value.

If you must set this manually, it must be the full host name. Do not include http:// or any other prefixes.

#
if (!defined("CA_SITE_HOSTNAME")) {
define("CA_SITE_HOSTNAME", isset($SERVER['HTTP_HOST']) ? $SERVER['HTTP_HOST'] : '');
}

How can I fix the issues? Many thanks.