Updating order status failed: Order with ID "XY" not found
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Updating order status failed: Order with ID "XY" not found
Hello, yesterday i got a order, payed with mpay, but the payment was not completed.
typo 11.5.18 aimeos 22.4.4
This is the aimeos log:
> Processing Order "XY" with MPay24
> Updating order status failed: Bestellung mit ID "xy" nicht gefunden
Array( => mpay24 [OPERATION] => CONFIRMATION ... )
> Lost session at confirmation page
Array
(
[MAGICK_TEMPORARY_PATH] => /usr/home/xy/.tmp
[TMPDIR] => /usr/home/xy/.tmp
[PHP_FCGI_MAX_REQUESTS] => 100000
[PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
[PHPRC] => /home/httpd/php74-ini/webh
[PWD] => /home/httpd/cgi-bin
[MAGICK_TMPDIR] => /usr/home/webh/.tmp
[CONTENT_LENGTH] => 0
[HTTP_CONNECTION] => close
[SCRIPT_NAME] => /index.php
[REQUEST_URI] => /produkte/shop/confirm?action=confirm&code=mpay24&controller=Checkout&TID=xy&LANGUAGE=DE&USER_FIELD=&BRAND=VISA
[QUERY_STRING] => action=confirm&code=mpay24&controller=Checkout&TID=xy&LANGUAGE=DE&USER_FIELD=&BRAND=VISA
[REQUEST_METHOD] => GET
[SERVER_PROTOCOL] => HTTP/2.0
[GATEWAY_INTERFACE] => CGI/1.1
[REDIRECT_QUERY_STRING] => action=confirm&code=mpay24&controller=Checkout&TID=xy&LANGUAGE=DE&USER_FIELD=&BRAND=VISA
[REDIRECT_URL] => /produkte/shop/confirm
[REMOTE_PORT] => xy
[SCRIPT_FILENAME] => /usr/www/users/webh/webling-holz.at/index.php
[SERVER_ADMIN] => webmaster@xy-xy.at
[CONTEXT_DOCUMENT_ROOT] => /usr/www/users/xy/xy-xy.at
[CONTEXT_PREFIX] =>
[REQUEST_SCHEME] => https
[DOCUMENT_ROOT] => /usr/www/users/xy/xy-xy.at
[REMOTE_ADDR] => xyxy
[SERVER_PORT] => xyxyx
[SERVER_ADDR] => xyxyx
[SERVER_NAME] => xyxyxy
[SERVER_SOFTWARE] => Apache
[SERVER_SIGNATURE] => <address>Apache Server at xyxyxy Port xy</address>
[HTTP_HOST] => xyxyxy
[HTTP_REFERER] => https://www.mpay24.com/
[HTTP_ACCEPT_LANGUAGE] => de-DE,de;q=0.9
[HTTP_USER_AGENT] => Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15
[HTTP_ACCEPT_ENCODING] => gzip, deflate, br
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
[HTTP_COOKIE] => _ga_S3WKEDWFSN=GS1.1.1685543226.4.1.1685543272.0.0.0; _ga=GA1.1.1546269835.1685525222; _gac_UA-155151041-1=1.1685525222.EAIaIQobChMI34ef3Z6f_wIVDy0GAB2PggSREAAYASAAEgLHJvD_BwE; _gid=GA1.2.85703736.1685525222
[SSL_TLS_SNI] => xyxyxyxy
[HTTPS] => on
[H2_STREAM_TAG] => 74310-4313-1
[H2_STREAM_ID] => 1
[H2_PUSHED_ON] =>
[H2_PUSHED] =>
[H2_PUSH] => on
[H2PUSH] => on
[HTTP2] => on
[CWD] => /
[REDIRECT_STATUS] => 200
[REDIRECT_SSL_TLS_SNI] =>xyxyxyxy
[REDIRECT_HTTPS] => on
[REDIRECT_H2_STREAM_TAG] => 74310-4313-1
[REDIRECT_H2_STREAM_ID] => 1
[REDIRECT_H2_PUSHED_ON] =>
[REDIRECT_H2_PUSHED] =>
[REDIRECT_H2_PUSH] => on
[REDIRECT_H2PUSH] => on
[REDIRECT_HTTP2] => on
[REDIRECT_CWD] => /
[FCGI_ROLE] => RESPONDER
[PHP_SELF] => /index.php
[REQUEST_TIME_FLOAT] => 1685543464.9076
[REQUEST_TIME] => 1685543464
[argv] => Array
(
[0] => action=confirm&code=mpay24&controller=Checkout&TID=xy&LANGUAGE=DE&USER_FIELD=&BRAND=VISA
)
[argc] => 1
)
> The session does not contain an ordernumber
#0 /usr/www/users/website/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-client-html/src/Client/Html/Common/Decorator/Base.php(67): Aimeos\Client\Html\Checkout\Confirm\Standard->data(Object(Aimeos\Base\View\Standard), Array, NULL)
#1 /usr/www/users/website/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-client-html/src/Client/Html/Common/Decorator/Context.php(48): Aimeos\Client\Html\Common\Decorator\Base->data(Object(Aimeos\Base\View\Standard), Array, NULL)
#2 /usr/www/users/website/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-client-html/src/Client/Html/Base.php(110): Aimeos\Client\Html\Common\Decorator\Context->data(Object(Aimeos\Base\View\Standard))
#3 /usr/www/users/website/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-client-html/src/Client/Html/Common/Decorator/Exceptions.php(73): Aimeos\Client\Html\Base->header('')
#4 /usr/www/users/website/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-client-html/src/Client/Html/Common/Decorator/Base.php(92): Aimeos\Client\Html\Common\Decorator\Exceptions->header('')
#5 /usr/www/users/website/typo3conf/ext/aimeos/Classes/Controller/CheckoutController.php(50): Aimeos\Client\Html\Common\Decorator\Base->header()
#6 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/extbase/Classes/Mvc/Controller/ActionController.php(575): Aimeos\Aimeos\Controller\CheckoutController->confirmAction()
#7 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/extbase/Classes/Mvc/Controller/ActionController.php(492): TYPO3\CMS\Extbase\Mvc\Controller\ActionController->callActionMethod(Object(TYPO3\CMS\Extbase\Mvc\Request))
#8 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/extbase/Classes/Mvc/Dispatcher.php(96): TYPO3\CMS\Extbase\Mvc\Controller\ActionController->processRequest(Object(TYPO3\CMS\Extbase\Mvc\Request))
#9 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/extbase/Classes/Mvc/Web/FrontendRequestHandler.php(46): TYPO3\CMS\Extbase\Mvc\Dispatcher->dispatch(Object(TYPO3\CMS\Extbase\Mvc\Request))
#10 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/extbase/Classes/Core/Bootstrap.php(165): TYPO3\CMS\Extbase\Mvc\Web\FrontendRequestHandler->handleRequest(Object(TYPO3\CMS\Extbase\Mvc\Request))
#11 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/extbase/Classes/Core/Bootstrap.php(148): TYPO3\CMS\Extbase\Core\Bootstrap->handleFrontendRequest(Object(TYPO3\CMS\Core\Http\ServerRequest))
#12 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(5397): TYPO3\CMS\Extbase\Core\Bootstrap->run('', Array, Object(TYPO3\CMS\Core\Http\ServerRequest))
#13 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/ContentObject/UserContentObject.php(44): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction('TYPO3\\CMS\\Extba...', Array, '')
#14 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(801): TYPO3\CMS\Frontend\ContentObject\UserContentObject->render(Array)
#15 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(737): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->render(Object(TYPO3\CMS\Frontend\ContentObject\UserContentObject), Array)
#16 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Controller/TypoScriptFrontendController.php(2834): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle('USER', Array)
#17 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Controller/TypoScriptFrontendController.php(2792): TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->processNonCacheableContentPartsAndSubstituteContentMarkers(Array, Object(TYPO3\CMS\Core\Http\ServerRequest))
#18 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Controller/TypoScriptFrontendController.php(2761): TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->recursivelyReplaceIntPlaceholdersInContent(Object(TYPO3\CMS\Core\Http\ServerRequest))
#19 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Http/RequestHandler.php(165): TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->INTincScript(Object(TYPO3\CMS\Core\Http\ServerRequest))
#20 /usr/www/users/website/typo3conf/ext/pdfviewhelpers/Classes/Middleware/Frontend/StopOutputMiddleware.php(19): TYPO3\CMS\Frontend\Http\RequestHandler->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#21 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): Bithost\Pdfviewhelpers\Middleware\Frontend\StopOutputMiddleware->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(TYPO3\CMS\Frontend\Http\RequestHandler))
#22 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Middleware/ResponsePropagation.php(34): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#23 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Core\Middleware\ResponsePropagation->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#24 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/OutputCompression.php(48): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#25 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\OutputCompression->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#26 /usr/www/users/website/typo3conf/ext/replacer/Classes/Middleware/ReplaceContent.php(32): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#27 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): JWeiland\Replacer\Middleware\ReplaceContent->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#28 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/ContentLengthResponseHeader.php(45): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#29 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\ContentLengthResponseHeader->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#30 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/ShortcutAndMountPointRedirect.php(79): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#31 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\ShortcutAndMountPointRedirect->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#32 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/PrepareTypoScriptFrontendRendering.php(78): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#33 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\PrepareTypoScriptFrontendRendering->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#34 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/TypoScriptFrontendInitialization.php(104): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#35 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\TypoScriptFrontendInitialization->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#36 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/PageArgumentValidator.php(132): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#37 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\PageArgumentValidator->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#38 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/PreviewSimulator.php(66): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#39 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\PreviewSimulator->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#40 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/PageResolver.php(106): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#41 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\PageResolver->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#42 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/StaticRouteResolver.php(80): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#43 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\StaticRouteResolver->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#44 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/SiteBaseRedirectResolver.php(94): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#45 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\SiteBaseRedirectResolver->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#46 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/FrontendUserAuthenticator.php(91): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#47 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\FrontendUserAuthenticator->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#48 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/BackendUserAuthenticator.php(78): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#49 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\BackendUserAuthenticator->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#50 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/MaintenanceMode.php(55): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#51 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\MaintenanceMode->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#52 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/SiteResolver.php(65): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#53 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\SiteResolver->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#54 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/EidHandler.php(64): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#55 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\EidHandler->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#56 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Middleware/NormalizedParamsAttribute.php(45): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#57 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Core\Middleware\NormalizedParamsAttribute->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#58 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Middleware/VerifyHostHeader.php(55): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#59 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Core\Middleware\VerifyHostHeader->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#60 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/TimeTrackerInitialization.php(58): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#61 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\TimeTrackerInitialization->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#62 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(78): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#63 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/AbstractApplication.php(86): TYPO3\CMS\Core\Http\MiddlewareDispatcher->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#64 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Http/Application.php(69): TYPO3\CMS\Core\Http\AbstractApplication->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#65 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/AbstractApplication.php(100): TYPO3\CMS\Frontend\Http\Application->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#66 /usr/www/users/website/typo3_src-11.5.18/index.php(21): TYPO3\CMS\Core\Http\AbstractApplication->run()
#67 /usr/www/users/website/typo3_src-11.5.18/index.php(22): closure()
#68 main
typo 11.5.18 aimeos 22.4.4
This is the aimeos log:
> Processing Order "XY" with MPay24
> Updating order status failed: Bestellung mit ID "xy" nicht gefunden
Array( => mpay24 [OPERATION] => CONFIRMATION ... )
> Lost session at confirmation page
Array
(
[MAGICK_TEMPORARY_PATH] => /usr/home/xy/.tmp
[TMPDIR] => /usr/home/xy/.tmp
[PHP_FCGI_MAX_REQUESTS] => 100000
[PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
[PHPRC] => /home/httpd/php74-ini/webh
[PWD] => /home/httpd/cgi-bin
[MAGICK_TMPDIR] => /usr/home/webh/.tmp
[CONTENT_LENGTH] => 0
[HTTP_CONNECTION] => close
[SCRIPT_NAME] => /index.php
[REQUEST_URI] => /produkte/shop/confirm?action=confirm&code=mpay24&controller=Checkout&TID=xy&LANGUAGE=DE&USER_FIELD=&BRAND=VISA
[QUERY_STRING] => action=confirm&code=mpay24&controller=Checkout&TID=xy&LANGUAGE=DE&USER_FIELD=&BRAND=VISA
[REQUEST_METHOD] => GET
[SERVER_PROTOCOL] => HTTP/2.0
[GATEWAY_INTERFACE] => CGI/1.1
[REDIRECT_QUERY_STRING] => action=confirm&code=mpay24&controller=Checkout&TID=xy&LANGUAGE=DE&USER_FIELD=&BRAND=VISA
[REDIRECT_URL] => /produkte/shop/confirm
[REMOTE_PORT] => xy
[SCRIPT_FILENAME] => /usr/www/users/webh/webling-holz.at/index.php
[SERVER_ADMIN] => webmaster@xy-xy.at
[CONTEXT_DOCUMENT_ROOT] => /usr/www/users/xy/xy-xy.at
[CONTEXT_PREFIX] =>
[REQUEST_SCHEME] => https
[DOCUMENT_ROOT] => /usr/www/users/xy/xy-xy.at
[REMOTE_ADDR] => xyxy
[SERVER_PORT] => xyxyx
[SERVER_ADDR] => xyxyx
[SERVER_NAME] => xyxyxy
[SERVER_SOFTWARE] => Apache
[SERVER_SIGNATURE] => <address>Apache Server at xyxyxy Port xy</address>
[HTTP_HOST] => xyxyxy
[HTTP_REFERER] => https://www.mpay24.com/
[HTTP_ACCEPT_LANGUAGE] => de-DE,de;q=0.9
[HTTP_USER_AGENT] => Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15
[HTTP_ACCEPT_ENCODING] => gzip, deflate, br
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
[HTTP_COOKIE] => _ga_S3WKEDWFSN=GS1.1.1685543226.4.1.1685543272.0.0.0; _ga=GA1.1.1546269835.1685525222; _gac_UA-155151041-1=1.1685525222.EAIaIQobChMI34ef3Z6f_wIVDy0GAB2PggSREAAYASAAEgLHJvD_BwE; _gid=GA1.2.85703736.1685525222
[SSL_TLS_SNI] => xyxyxyxy
[HTTPS] => on
[H2_STREAM_TAG] => 74310-4313-1
[H2_STREAM_ID] => 1
[H2_PUSHED_ON] =>
[H2_PUSHED] =>
[H2_PUSH] => on
[H2PUSH] => on
[HTTP2] => on
[CWD] => /
[REDIRECT_STATUS] => 200
[REDIRECT_SSL_TLS_SNI] =>xyxyxyxy
[REDIRECT_HTTPS] => on
[REDIRECT_H2_STREAM_TAG] => 74310-4313-1
[REDIRECT_H2_STREAM_ID] => 1
[REDIRECT_H2_PUSHED_ON] =>
[REDIRECT_H2_PUSHED] =>
[REDIRECT_H2_PUSH] => on
[REDIRECT_H2PUSH] => on
[REDIRECT_HTTP2] => on
[REDIRECT_CWD] => /
[FCGI_ROLE] => RESPONDER
[PHP_SELF] => /index.php
[REQUEST_TIME_FLOAT] => 1685543464.9076
[REQUEST_TIME] => 1685543464
[argv] => Array
(
[0] => action=confirm&code=mpay24&controller=Checkout&TID=xy&LANGUAGE=DE&USER_FIELD=&BRAND=VISA
)
[argc] => 1
)
> The session does not contain an ordernumber
#0 /usr/www/users/website/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-client-html/src/Client/Html/Common/Decorator/Base.php(67): Aimeos\Client\Html\Checkout\Confirm\Standard->data(Object(Aimeos\Base\View\Standard), Array, NULL)
#1 /usr/www/users/website/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-client-html/src/Client/Html/Common/Decorator/Context.php(48): Aimeos\Client\Html\Common\Decorator\Base->data(Object(Aimeos\Base\View\Standard), Array, NULL)
#2 /usr/www/users/website/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-client-html/src/Client/Html/Base.php(110): Aimeos\Client\Html\Common\Decorator\Context->data(Object(Aimeos\Base\View\Standard))
#3 /usr/www/users/website/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-client-html/src/Client/Html/Common/Decorator/Exceptions.php(73): Aimeos\Client\Html\Base->header('')
#4 /usr/www/users/website/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-client-html/src/Client/Html/Common/Decorator/Base.php(92): Aimeos\Client\Html\Common\Decorator\Exceptions->header('')
#5 /usr/www/users/website/typo3conf/ext/aimeos/Classes/Controller/CheckoutController.php(50): Aimeos\Client\Html\Common\Decorator\Base->header()
#6 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/extbase/Classes/Mvc/Controller/ActionController.php(575): Aimeos\Aimeos\Controller\CheckoutController->confirmAction()
#7 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/extbase/Classes/Mvc/Controller/ActionController.php(492): TYPO3\CMS\Extbase\Mvc\Controller\ActionController->callActionMethod(Object(TYPO3\CMS\Extbase\Mvc\Request))
#8 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/extbase/Classes/Mvc/Dispatcher.php(96): TYPO3\CMS\Extbase\Mvc\Controller\ActionController->processRequest(Object(TYPO3\CMS\Extbase\Mvc\Request))
#9 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/extbase/Classes/Mvc/Web/FrontendRequestHandler.php(46): TYPO3\CMS\Extbase\Mvc\Dispatcher->dispatch(Object(TYPO3\CMS\Extbase\Mvc\Request))
#10 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/extbase/Classes/Core/Bootstrap.php(165): TYPO3\CMS\Extbase\Mvc\Web\FrontendRequestHandler->handleRequest(Object(TYPO3\CMS\Extbase\Mvc\Request))
#11 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/extbase/Classes/Core/Bootstrap.php(148): TYPO3\CMS\Extbase\Core\Bootstrap->handleFrontendRequest(Object(TYPO3\CMS\Core\Http\ServerRequest))
#12 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(5397): TYPO3\CMS\Extbase\Core\Bootstrap->run('', Array, Object(TYPO3\CMS\Core\Http\ServerRequest))
#13 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/ContentObject/UserContentObject.php(44): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction('TYPO3\\CMS\\Extba...', Array, '')
#14 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(801): TYPO3\CMS\Frontend\ContentObject\UserContentObject->render(Array)
#15 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/ContentObject/ContentObjectRenderer.php(737): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->render(Object(TYPO3\CMS\Frontend\ContentObject\UserContentObject), Array)
#16 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Controller/TypoScriptFrontendController.php(2834): TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle('USER', Array)
#17 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Controller/TypoScriptFrontendController.php(2792): TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->processNonCacheableContentPartsAndSubstituteContentMarkers(Array, Object(TYPO3\CMS\Core\Http\ServerRequest))
#18 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Controller/TypoScriptFrontendController.php(2761): TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->recursivelyReplaceIntPlaceholdersInContent(Object(TYPO3\CMS\Core\Http\ServerRequest))
#19 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Http/RequestHandler.php(165): TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->INTincScript(Object(TYPO3\CMS\Core\Http\ServerRequest))
#20 /usr/www/users/website/typo3conf/ext/pdfviewhelpers/Classes/Middleware/Frontend/StopOutputMiddleware.php(19): TYPO3\CMS\Frontend\Http\RequestHandler->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#21 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): Bithost\Pdfviewhelpers\Middleware\Frontend\StopOutputMiddleware->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(TYPO3\CMS\Frontend\Http\RequestHandler))
#22 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Middleware/ResponsePropagation.php(34): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#23 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Core\Middleware\ResponsePropagation->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#24 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/OutputCompression.php(48): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#25 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\OutputCompression->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#26 /usr/www/users/website/typo3conf/ext/replacer/Classes/Middleware/ReplaceContent.php(32): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#27 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): JWeiland\Replacer\Middleware\ReplaceContent->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#28 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/ContentLengthResponseHeader.php(45): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#29 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\ContentLengthResponseHeader->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#30 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/ShortcutAndMountPointRedirect.php(79): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#31 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\ShortcutAndMountPointRedirect->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#32 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/PrepareTypoScriptFrontendRendering.php(78): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#33 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\PrepareTypoScriptFrontendRendering->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#34 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/TypoScriptFrontendInitialization.php(104): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#35 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\TypoScriptFrontendInitialization->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#36 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/PageArgumentValidator.php(132): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#37 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\PageArgumentValidator->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#38 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/PreviewSimulator.php(66): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#39 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\PreviewSimulator->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#40 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/PageResolver.php(106): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#41 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\PageResolver->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#42 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/StaticRouteResolver.php(80): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#43 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\StaticRouteResolver->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#44 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/SiteBaseRedirectResolver.php(94): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#45 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\SiteBaseRedirectResolver->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#46 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/FrontendUserAuthenticator.php(91): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#47 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\FrontendUserAuthenticator->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#48 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/BackendUserAuthenticator.php(78): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#49 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\BackendUserAuthenticator->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#50 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/MaintenanceMode.php(55): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#51 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\MaintenanceMode->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#52 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/SiteResolver.php(65): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#53 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\SiteResolver->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#54 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/EidHandler.php(64): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#55 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\EidHandler->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#56 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Middleware/NormalizedParamsAttribute.php(45): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#57 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Core\Middleware\NormalizedParamsAttribute->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#58 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Middleware/VerifyHostHeader.php(55): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#59 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Core\Middleware\VerifyHostHeader->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#60 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Middleware/TimeTrackerInitialization.php(58): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#61 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(172): TYPO3\CMS\Frontend\Middleware\TimeTrackerInitialization->process(Object(TYPO3\CMS\Core\Http\ServerRequest), Object(class@anonymous))
#62 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php(78): class@anonymous->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#63 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/AbstractApplication.php(86): TYPO3\CMS\Core\Http\MiddlewareDispatcher->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#64 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/frontend/Classes/Http/Application.php(69): TYPO3\CMS\Core\Http\AbstractApplication->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#65 /usr/www/users/website/typo3_src-11.5.18/typo3/sysext/core/Classes/Http/AbstractApplication.php(100): TYPO3\CMS\Frontend\Http\Application->handle(Object(TYPO3\CMS\Core\Http\ServerRequest))
#66 /usr/www/users/website/typo3_src-11.5.18/index.php(21): TYPO3\CMS\Core\Http\AbstractApplication->run()
#67 /usr/www/users/website/typo3_src-11.5.18/index.php(22): closure()
#68 main
Re: Updating order status failed: Order with ID "XY" not found
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?
-> 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);
}
Re: Updating order status failed: Order with ID "XY" not found
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.
Please note, that Aimeos 22.4.x versions are not supported any more and you must update to 22.10 LTS.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Updating order status failed: Order with ID "XY" not found
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
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
Re: Updating order status failed: Order with ID "XY" not found
The Error happens in the updatePush() of my Provider:
$this->getOrder($_GET['TID']);
Tried it with intval and strval.
$this->getOrder($_GET['TID']);
Tried it with intval and strval.
Re: Updating order status failed: Order with ID "XY" not found
Enable debug logging so the SQL statement for fetching the order is written to the madmin_log table:
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.
Code: Select all
madmin/log/manager/loglevel = 7
- 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.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Updating order status failed: Order with ID "XY" not found
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:See:Code: Select all
madmin/log/manager/loglevel = 7
- 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
)
Re: Updating order status failed: Order with ID "XY" not found
Does the SQL statement return the row from the mshop_order table if you execute it at the MySQL CLI or in phpMyAdmin?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Updating order status failed: Order with ID "XY" not found
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
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
Re: Updating order status failed: Order with ID "XY" not found
What code does the order service item for the payment use instead?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star