Cannot add, see details, or change contacts since migration to 8.7

[svdkar]

Since the migration to 8.7 from 7.14.5, we cannot add any contacts. The Suitecrm log does not show anything special. We have verified the rights and they are fine. We deleted the cache as well.
The php log has the following errors:

[14-Oct-2024 16:12:54 UTC] PHP Deprecated: Return type of SuiteCRM\Search\SearchQuery::jsonSerialize() should either be compatible with JsonSerializable::jsonSerialize(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/kconsu5/public_html/SuiteCRM8/public/legacy/lib/Search/SearchQuery.php on line 371
[14-Oct-2024 16:12:54 UTC] PHP Deprecated: Constant FILTER_SANITIZE_STRING is deprecated in /home/kconsu5/public_html/SuiteCRM8/public/legacy/lib/Search/SearchQuery.php on line 141
[14-Oct-2024 16:12:54 UTC] PHP Deprecated: Constant FILTER_SANITIZE_STRING is deprecated in /home/kconsu5/public_html/SuiteCRM8/public/legacy/lib/Search/SearchQuery.php on line 142
[14-Oct-2024 16:12:54 UTC] PHP Deprecated: Constant FILTER_SANITIZE_STRING is deprecated in /home/kconsu5/public_html/SuiteCRM8/public/legacy/lib/Search/SearchQuery.php on line 145
[14-Oct-2024 16:12:54 UTC] PHP Deprecated: Using unregistered function “key” in a template is deprecated and will be removed in a future release. Use Smarty::registerPlugin to explicitly register a custom modifier. in /home/kconsu5/public_html/SuiteCRM8/vendor/smarty/smarty/libs/sysplugins/smarty_internal_compile_private_modifier.php on line 113
[14-Oct-2024 16:12:54 UTC] PHP Deprecated: Function strftime() is deprecated in /home/kconsu5/public_html/SuiteCRM8/public/legacy/include/SugarLogger/SugarLogger.php on line 239
[14-Oct-2024 16:12:54 UTC] PHP Deprecated: Function strftime() is deprecated in /home/kconsu5/public_html/SuiteCRM8/public/legacy/include/SugarLogger/SugarLogger.php on line 239
[14-Oct-2024 16:13:01 UTC] PHP Deprecated: usort(): Returning bool from comparison function is deprecated, return an integer less than, equal to, or greater than zero in /home/kconsu5/public_html/SuiteCRM8/public/legacy/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 423
[14-Oct-2024 16:13:17 UTC] PHP Deprecated: usort(): Returning bool from comparison function is deprecated, return an integer less than, equal to, or greater than zero in /home/kconsu5/public_html/SuiteCRM8/public/legacy/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 423
[14-Oct-2024 16:13:21 UTC] PHP Deprecated: usort(): Returning bool from comparison function is deprecated, return an integer less than, equal to, or greater than zero in /home/kconsu5/public_html/SuiteCRM8QA/public/legacy/modules/SugarFeed/Dashlets/SugarFeedDashlet/SugarFeedDashlet.php on line 423
What else could we verify? Has anybody else had this issue?

[rsp]

Is it similar to this issue?

SQL error when a contact detail view is opened

The issue is fixed by changing the indexes of $queries in ContactLastTouchPoint in 8.7 similar to 8.6.2. $parts = $queries[5]; ..... $parts = $queries[6]; There were indexes difference in this file in 8.6.2 and 8.7 . The $queries list has different indexes 8.7 and 8.6.2 in ContactLastTouchPoint.php but the order of subpanels in subpaneldefs.php in two versions is not different. 8.7 Core\core\modules\Contacts\Statistics\ContactLastTouchPoint.php $queries[4] & $queries[5] $parts = $q…

[rsp]

Compatibility Matrix

[svdkar]

PHP is 8.2
MariaDB is 10.6.19
Apache 2.4

[rsp]

Anyways these errors look deprecated. Maybe you need to update your php.ini file

error_reporting=E_ALL & ~E_DEPRECATED & ~E_STRICT

Then restart PHP.

[svdkar]

Setting the log does not solve the issue

[svdkar]

I just found this error in the other suitecrm log at the root of SuiteCRM8 (not in the legacy folder)
Bean file does not exist in path: modules/Users/User.php
any clue would be welcome

[pgr]

There should be no log called suitecrm.log at the root level, it should be in public/legacy only.

If your web server is still confused about the web_root and perhaps it needs the mod_rewrite configuration to be checked.

I know you’re doing an upgrade/migration, but still, check the Documentation on the new installations page, it has some detail about the issues I mentioned above.

[rsp]

Checkout this page:

Migration - 7.14.x to 8.7.0+

[svdkar]

Yes I followed all the instruction there when doing the migration

[rsp]

Okay! Do you have problem in the contacts module only or in all modules?

[svdkar]

Only that one No other module is affected

[rsp]

If you have custom code for contacts, please check that.

[svdkar]

No there is no custom code for that module

[rsp]

That’s weird! Set time zone in php.ini.

---

You need something like this: (Replace Europe/London with your location)

date.timezone = "Europe/London"

# List of Supported Timezones

---

Go to profile settings and reset preferences

---

Try on different browser

---

Is it admin profile. Try with another user profile.

[svdkar]

I have this date.timezone = “UTC”
Why should this be relevant?

[svdkar]

I checked that and it seems fine. in the document root I have an htaccess that has a RewriteRule pointing to the public directory. Then in the legacy the htacces has the set like “RewriteBase /legacy”. Finally the url configured in the conf has the URL without public and legacy.

[svdkar]

[rsp]

So, is it working now?

[svdkar]

No it is not working I am running out of ideas where to check