Updating order status failed: Order with ID "XY" not found

rvhelp2 · Post by **rvhelp2** » 01 Jun 2023, 09:29

rvhelp2 · Post by **rvhelp2** » 01 Jun 2023, 10:34

The Problem is:
-> Processing Order "100" with MPay24
-> 1min later -> Updating order status failed: Bestellung mit ID "100" nicht gefunden

How can this happen if the order is created first?

Code: Select all

  public function updatePush(ServerRequestInterface $request, ResponseInterface $response): ResponseInterface
    {
	//...
	
        if (in_array($ip, $allowedIps) && isset($_GET['STATUS']) && isset($_GET['TID'])) {
            $order = $this->getOrder($_GET['TID']); //ERROR
            $order->setStatusPayment($this->getStatusByMpayStatus($_GET['STATUS']));
            $this->saveOrder($order);
            return $response;
        }

        return $response->withStatus(500);
    }

Post by **aimeos** » 02 Jun 2023, 08:57

Guess, the order with ID "100" is still in the database, isn't it?

Please note, that Aimeos 22.4.x versions are not supported any more and you must update to 22.10 LTS.

rvhelp2 · Post by **rvhelp2** » 02 Jun 2023, 12:04

Yes, it is in the database
100
101
1.
NULL
NULL
6
2
2023-05-31
2023-05
2023-22
3
16
2023-05-31 16:27:52
2023-06-01 14:24:42
admin

rvhelp2 · Post by **rvhelp2** » 02 Jun 2023, 13:48

The Error happens in the updatePush() of my Provider:

$this->getOrder($_GET['TID']);

Tried it with intval and strval.

Post by **aimeos** » 03 Jun 2023, 11:32

Enable debug logging so the SQL statement for fetching the order is written to the madmin_log table:

Code: Select all

madmin/log/manager/loglevel = 7

See:
- https://aimeos.org/docs/2023.x/config/m ... /#loglevel
- https://aimeos.org/docs/2023.x/typo3/cu ... figuration

Then, check the SQL statement against your data so see why it returns no rows.

rvhelp2 · Post by **rvhelp2** » 15 Jun 2023, 12:10

aimeos wrote: ↑03 Jun 2023, 11:32 Enable debug logging so the SQL statement for fetching the order is written to the madmin_log table:
Code: Select all
madmin/log/manager/loglevel = 7
See:
- https://aimeos.org/docs/2023.x/config/m ... /#loglevel
- https://aimeos.org/docs/2023.x/typo3/cu ... figuration

Then, check the SQL statement against your data so see why it returns no rows.

We have a payment provider, Unzer. In Aimeos, our checkout lets you choose between credit card and instant bank transfer -> Both redirects to the same payment provider, where you can use instant bank transfe or credit card.

If you choose credit card payment and pay with credit card, the Mysql statement works and the order is found. If you use Instant bank transfer the order will not be found.

1. Processing Order "835" with MPay24
$this->context()->logger()->log('Processing Order "' . $order->getId() . '" with MPay24');

2. updatePush SearchTID "835"
-> sql statement seems fine
Time: 0.51593780517578ms
Class: Aimeos\MShop\Order\Manager\Standard
SELECT
mord."id" AS "order.id", mord."baseid" AS "order.baseid",
mord."siteid" AS "order.siteid", mord."channel" AS "order.channel",
mord."datepayment" AS "order.datepayment", mord."datedelivery" AS "order.datedelivery",
mord."statuspayment" AS "order.statuspayment", mord."statusdelivery" AS "order.statusdelivery",
mord."relatedid" AS "order.relatedid", mord."ctime" AS "order.ctime",
mord."mtime" AS "order.mtime", mord."editor" AS "order.editor"
FROM "mshop_order" mord
LEFT JOIN "mshop_order_base" AS mordba ON ( mord."baseid" = mordba."id" )
LEFT JOIN "mshop_order_base_service" AS mordbase ON ( mordba."id" = mordbase."baseid" )
WHERE ( ( mord."siteid" IN ('','1.') ) AND ( mordba."siteid" IN ('','1.') ) AND ( mordbase."siteid" IN ('','1.') ) AND ( mord."id" = 835 AND mordbase."code" = 'mpay24' ) )
GROUP BY mord."id", mord."id"
ORDER BY mord."id" ASC
LIMIT 100 OFFSET 0

->
Updating order status failed: Bestellung mit ID "835" nicht gefunden
Array
(

Code: Select all

 => mpay24
[OPERATION] => CONFIRMATION
[TID] => 835
[STATUS] => BILLED
[PRICE] => 12345
[CURRENCY] => EUR
[P_TYPE] => SOFORT
[BRAND] => SOFORT
[MPAYTID] => 12345678
[USER_FIELD] =>
[ORDERDESC] =>
[CUSTOMER] => 835
[CUSTOMER_EMAIL] =>
[LANGUAGE] => DE
[CUSTOMER_ID] =>
[PROFILE_ID] =>
[PROFILE_STATUS] => IGNORED
[FILTER_STATUS] =>
[APPR_CODE] => 1234-1234-1234-1234
)

Post by **aimeos** » 16 Jun 2023, 08:02

Does the SQL statement return the row from the mshop_order table if you execute it at the MySQL CLI or in phpMyAdmin?

rvhelp2 · Post by **rvhelp2** » 16 Jun 2023, 12:57

no entries:

SELECT
mord.`id` AS `order.id`,
mord.`baseid` AS `order.baseid`,
mord.`siteid` AS `order.siteid`,
mord.`channel` AS `order.channel`,
mord.`datepayment` AS `order.datepayment`,
mord.`datedelivery` AS `order.datedelivery`,
mord.`statuspayment` AS `order.statuspayment`,
mord.`statusdelivery` AS `order.statusdelivery`,
mord.`relatedid` AS `order.relatedid`,
mord.`ctime` AS `order.ctime`,
mord.`mtime` AS `order.mtime`,
mord.`editor` AS `order.editor`
FROM
`mshop_order` mord
LEFT JOIN
`mshop_order_base` AS mordba ON (mord.`baseid` = mordba.`id`)
LEFT JOIN
`mshop_order_base_service` AS mordbase ON (mordba.`id` = mordbase.`baseid`)
WHERE
(mord.`siteid` IN ('','1.')) AND
(mordba.`siteid` IN ('','1.')) AND
(mordbase.`siteid` IN ('','1.')) AND
(mord.`id` = 835 AND mordbase.`code` = 'mpay24')
GROUP BY
mord.`id`
ORDER BY
mord.`id` ASC
LIMIT 100 OFFSET 0;

without "AND mordbase.`code` = 'mpay24'" it finds one

Post by **aimeos** » 16 Jun 2023, 13:14

What code does the order service item for the payment use instead?

Help for Aimeos

Updating order status failed: Order with ID "XY" not found

Updating order status failed: Order with ID "XY" not found

Re: Updating order status failed: Order with ID "XY" not found

Re: Updating order status failed: Order with ID "XY" not found

Re: Updating order status failed: Order with ID "XY" not found

Re: Updating order status failed: Order with ID "XY" not found

Re: Updating order status failed: Order with ID "XY" not found

Re: Updating order status failed: Order with ID "XY" not found

Re: Updating order status failed: Order with ID "XY" not found

Re: Updating order status failed: Order with ID "XY" not found

Re: Updating order status failed: Order with ID "XY" not found

Connect with your social network account