Status: 500
Content-type: text/html
Interner Fehler
Leider ist ein interner Fehler in unserem System aufgetreten!
SQL-Fehler bei "SELECT SUM(posten_menge)
FROM shopauftraege_posten as p, shopauftraege as a, shopauftraege_stati as stat
WHERE p.posten_auftrag_id=a.id AND a.bearbeitung_status=stat.id
AND stat.abgeschlossen=0 AND a.auftragsnr > 0 AND a.abgesendet IS NOT NULL
AND p.posten_artid_ausf = ?
AND p.storage = ?
": Unknown column 'p.storage' in 'where clause' at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Object/Base.pm line 22.
CosmoShop::Object::Base::_die(plugins::bestands_handling::Plugin=HASH(0x565012c190d0), "SQL-Fehler bei \"SELECT SUM(posten_menge) \x{a} FROM shopau"...) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Object/Base.pm line 16
CosmoShop::Object::Base::_dbDie(plugins::bestands_handling::Plugin=HASH(0x565012c190d0), "SELECT SUM(posten_menge) \x{a} FROM shopauftraege_posten a"...) called at /home/w19596/web/staging/cgi-bin/plugins/bestands_handling/Plugin.pm line 287
plugins::bestands_handling::Plugin::getReservedStock(plugins::bestands_handling::Plugin=HASH(0x565012c190d0), 2720, "default") called at /home/w19596/web/staging/cgi-bin/plugins/bestands_handling/Hooks.pm line 113
plugins::bestands_handling::Hooks::getReservedStock(CosmoShop::Orders=HASH(0x56501248f490), HASH(0x565012bedc90), 2720, "default") called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm line 103
CosmoShop::Core::Object::HookBase::nextHook(CosmoShop::Orders=HASH(0x56501248f490), HASH(0x565012bedc90), 2720, "default") called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm line 47
CosmoShop::Core::Object::HookBase::parseHooks(CosmoShop::Orders=HASH(0x56501248f490), "CosmoShop::Orders", "getReservedStock", "object", 2720, "default") called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm line 17
CosmoShop::Core::Object::HookBase::AUTOLOAD(CosmoShop::Orders=HASH(0x56501248f490), 2720, "default") called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Articles/Article/Stock.pm line 77
CosmoShop::Core::Articles::Article::Stock::getReservedStock(CosmoShop::Core::Articles::Article::Stock=HASH(0x565012bdd800)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm line 113
CosmoShop::Core::Object::HookBase::nextHook(CosmoShop::Articles::Article::Stock=HASH(0x565012bd37e0), HASH(0x565012bedb88)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm line 47
CosmoShop::Core::Object::HookBase::parseHooks(CosmoShop::Articles::Article::Stock=HASH(0x565012bd37e0), "CosmoShop::Articles::Article::Stock", "getReservedStock", "object") called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm line 17
CosmoShop::Core::Object::HookBase::AUTOLOAD(CosmoShop::Articles::Article::Stock=HASH(0x565012bd37e0)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Articles/Article/Stock.pm line 84
CosmoShop::Core::Articles::Article::Stock::getAvailableStock(CosmoShop::Core::Articles::Article::Stock=HASH(0x565012bdd800)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm line 113
CosmoShop::Core::Object::HookBase::nextHook(CosmoShop::Articles::Article::Stock=HASH(0x565012bd37e0), HASH(0x565012b8d990)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm line 47
CosmoShop::Core::Object::HookBase::parseHooks(CosmoShop::Articles::Article::Stock=HASH(0x565012bd37e0), "CosmoShop::Articles::Article::Stock", "getAvailableStock", "object") called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm line 17
CosmoShop::Core::Object::HookBase::AUTOLOAD(CosmoShop::Articles::Article::Stock=HASH(0x565012bd37e0)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Articles/Article/Stock.pm line 92
CosmoShop::Core::Articles::Article::Stock::getOrderableStock(CosmoShop::Core::Articles::Article::Stock=HASH(0x565012bdd800)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm line 113
CosmoShop::Core::Object::HookBase::nextHook(CosmoShop::Articles::Article::Stock=HASH(0x565012bd37e0), HASH(0x565012bd3768)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm line 47
CosmoShop::Core::Object::HookBase::parseHooks(CosmoShop::Articles::Article::Stock=HASH(0x565012bd37e0), "CosmoShop::Articles::Article::Stock", "getOrderableStock", "object") called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm line 17
CosmoShop::Core::Object::HookBase::AUTOLOAD(CosmoShop::Articles::Article::Stock=HASH(0x565012bd37e0)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Articles/Article.pm line 237
CosmoShop::Core::Articles::Article::getAvailabilityInfo(CosmoShop::Core::Articles::Article=HASH(0x56501236cca0)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm line 113
CosmoShop::Core::Object::HookBase::nextHook(CosmoShop::Articles::Article=HASH(0x56501236cbb0), HASH(0x565012b8d918)) called at /home/w19596/web/staging/cgi-bin/plugins/timeplaner/Hooks.pm line 67
plugins::timeplaner::Hooks::getAvailabilityInfo_tp(CosmoShop::Articles::Article=HASH(0x56501236cbb0), HASH(0x565012b8d918)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm line 103
CosmoShop::Core::Object::HookBase::nextHook(CosmoShop::Articles::Article=HASH(0x56501236cbb0), HASH(0x565012b8d918)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm line 47
CosmoShop::Core::Object::HookBase::parseHooks(CosmoShop::Articles::Article=HASH(0x56501236cbb0), "CosmoShop::Articles::Article", "getAvailabilityInfo", "object") called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm line 17
CosmoShop::Core::Object::HookBase::AUTOLOAD(CosmoShop::Articles::Article=HASH(0x56501236cbb0)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Template/Component/Shop/Detailansicht.pm line 650
CosmoShop::Template::Component::Shop::Detailansicht::detail_wk_block("CosmoShop::Template::Component::Shop::Detailansicht", HASH(0x565012b816a8)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/TemplateEngine.pm line 242
CosmoShop::TemplateEngine::render(CosmoShop::TemplateEngine=HASH(0x565011d41e60), HASH(0x565012786bb8)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Template/Page/Shop/detail.pm line 134
CosmoShop::Template::Page::Shop::detail::detail("CosmoShop::Template::Page::Shop::detail", HASH(0x5650123918f8)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/TemplateEngine.pm line 242
CosmoShop::TemplateEngine::render(CosmoShop::TemplateEngine=HASH(0x565011d41e60), HASH(0x5650123cfaf0)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/TemplateEngine.pm line 120
CosmoShop::TemplateEngine::renderPage(CosmoShop::TemplateEngine=HASH(0x565011d41e60), HASH(0x565012302870)) called at /home/w19596/web/staging/cgi-bin/lshop.cgi line 52
-------------
in sub: CGI::Carp::fatalsToBrowser (called at /usr/share/perl5/CGI/Carp.pm, line 455)
-------------
in sub: CGI::Carp::die (called at /usr/share/perl5/CGI/Carp.pm, line 488)
-------------
in sub: CGI::Carp::confess (called at /home/w19596/web/staging/cgi-bin/lib/lshoputils_error_debug.pm, line 148)
-------------
in sub: main::dienice (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Object/Base.pm, line 22)
-------------
in sub: CosmoShop::Object::Base::_die (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Object/Base.pm, line 16)
-------------
in sub: CosmoShop::Object::Base::_dbDie (called at /home/w19596/web/staging/cgi-bin/plugins/bestands_handling/Plugin.pm, line 287)
-------------
in sub: plugins::bestands_handling::Plugin::getReservedStock (called at /home/w19596/web/staging/cgi-bin/plugins/bestands_handling/Hooks.pm, line 113)
-------------
in sub: plugins::bestands_handling::Hooks::getReservedStock (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm, line 103)
-------------
in sub: CosmoShop::Core::Object::HookBase::nextHook (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm, line 47)
-------------
in sub: CosmoShop::Core::Object::HookBase::parseHooks (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm, line 17)
-------------
in sub: CosmoShop::Core::Object::HookBase::AUTOLOAD (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Articles/Article/Stock.pm, line 77)
-------------
in sub: CosmoShop::Core::Articles::Article::Stock::getReservedStock (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm, line 113)
-------------
in sub: CosmoShop::Core::Object::HookBase::nextHook (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm, line 47)
-------------
in sub: CosmoShop::Core::Object::HookBase::parseHooks (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm, line 17)
-------------
in sub: CosmoShop::Core::Object::HookBase::AUTOLOAD (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Articles/Article/Stock.pm, line 84)
-------------
in sub: CosmoShop::Core::Articles::Article::Stock::getAvailableStock (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm, line 113)
-------------
in sub: CosmoShop::Core::Object::HookBase::nextHook (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm, line 47)
-------------
in sub: CosmoShop::Core::Object::HookBase::parseHooks (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm, line 17)
-------------
in sub: CosmoShop::Core::Object::HookBase::AUTOLOAD (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Articles/Article/Stock.pm, line 92)
-------------
in sub: CosmoShop::Core::Articles::Article::Stock::getOrderableStock (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm, line 113)
-------------
in sub: CosmoShop::Core::Object::HookBase::nextHook (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm, line 47)
-------------
in sub: CosmoShop::Core::Object::HookBase::parseHooks (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm, line 17)
-------------
in sub: CosmoShop::Core::Object::HookBase::AUTOLOAD (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Articles/Article.pm, line 237)
-------------
in sub: CosmoShop::Core::Articles::Article::getAvailabilityInfo (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm, line 113)
-------------
in sub: CosmoShop::Core::Object::HookBase::nextHook (called at /home/w19596/web/staging/cgi-bin/plugins/timeplaner/Hooks.pm, line 67)
-------------
in sub: plugins::timeplaner::Hooks::getAvailabilityInfo_tp (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm, line 103)
-------------
in sub: CosmoShop::Core::Object::HookBase::nextHook (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm, line 47)
-------------
in sub: CosmoShop::Core::Object::HookBase::parseHooks (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Core/Object/HookBase.pm, line 17)
-------------
in sub: CosmoShop::Core::Object::HookBase::AUTOLOAD (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Template/Component/Shop/Detailansicht.pm, line 650)
-------------
in sub: CosmoShop::Template::Component::Shop::Detailansicht::detail_wk_block (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/TemplateEngine.pm, line 242)
-------------
in sub: CosmoShop::TemplateEngine::render (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/Template/Page/Shop/detail.pm, line 134)
-------------
in sub: CosmoShop::Template::Page::Shop::detail::detail (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/TemplateEngine.pm, line 242)
-------------
in sub: CosmoShop::TemplateEngine::render (called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/TemplateEngine.pm, line 120)
-------------
in sub: CosmoShop::TemplateEngine::renderPage (called at /home/w19596/web/staging/cgi-bin/lshop.cgi, line 52)
Wir bitten um Ihr Verständnis!
DEBUGno cookie with name SHOP_SESSION_1697184791 found - need to set fresh cookie | CosmoShop::Core::Request::_init, Zeile 41 |
| ActionHandler action: showdetail | CosmoShop::ActionHandler::handle, Zeile 47 |
| ActionHandler result: showdetail ... (detail, shop) | CosmoShop::ActionHandler::handle, Zeile 51 |
| |
|