[solved] Getting errors after migration

[iTroubl3]

Hello, getting some errors when trying go to orders. This is what I get:

 

PrestaShop\PrestaShop\Core\Domain\Order\QueryResult\OrderMessageForViewing::__construct(): Argument #2 ($message) must be of type string, null given, called in /home/u924237733/domains/hotpink-dogfish-447685.hostingersite.com/public_html/src/Adapter/Order/QueryHandler/GetOrderForViewingHandler.php on line 715

 

Any ideas how to fix that? All data was migrated from 8.1.0 to 8.1.7.

 

Edited August 9, 2024 by iTroubl3 (see edit history)

[Prestashop Addict]

Clear folders in /var/cache

[iTroubl3]

After that, problem the same. I thing something wrong with DB

[Prestashop Addict]

May be an override not compatible with this version.

[iTroubl3]

4 minutes ago, Prestashop Addict said:

May be an override not compatible with this version.

So, what I can do?

[iTroubl3]

Okay, I fixed it. Looks like ps_customer_message table was empty. I just import it manualy, now everything looking good

[pedepot]

I am glad that your issue was fixed. What went wrong during the migration leading the table ps_customer_message empty?

[iTroubl3]

I have no idea why that  hapend..

[RedeShop]

HTTP 500 error when opening some orders in Back Office (PrestaShop 8.2.x)

In some cases, this error can be resolved as follows.

The Back Office shows an HTTP 500 error with the message:

OrderMessageForViewing::__construct(): Argument #2 ($message) must be of type string, null given

Cause

There are orphan records in ps_customer_thread (customer message threads) without any related messages in ps_customer_message.

PrestaShop 8.2.x does not validate this situation and fails when trying to build the order view in the Back Office.

This usually happens after:

migrations from older versions

usage of some payment or integration modules

Correct solution

Remove the orphan customer threads via phpmyadmin:

DELETE ct FROM ps_customer_thread ct LEFT JOIN ps_customer_message cm ON cm.id_customer_thread = ct.id_customer_thread WHERE cm.id_customer_message IS NULL;

Then clear the cache (var/cache/*).