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(0x558a8d5668a0), "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(0x558a8d5668a0), "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(0x558a8d5668a0), 495, "default") called at /home/w19596/web/staging/cgi-bin/plugins/bestands_handling/Hooks.pm line 113
plugins::bestands_handling::Hooks::getReservedStock(CosmoShop::Orders=HASH(0x558a8cdf1498), HASH(0x558a8d538a20), 495, "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(0x558a8cdf1498), HASH(0x558a8d538a20), 495, "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(0x558a8cdf1498), "CosmoShop::Orders", "getReservedStock", "object", 495, "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(0x558a8cdf1498), 495, "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(0x558a8d51dd78)) 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(0x558a8d51db80), HASH(0x558a8d538888)) 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(0x558a8d51db80), "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(0x558a8d51db80)) 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(0x558a8d51dd78)) 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(0x558a8d51db80), HASH(0x558a8d51d9a0)) 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(0x558a8d51db80), "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(0x558a8d51db80)) 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(0x558a8d51dd78)) 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(0x558a8d51db80), HASH(0x558a8d51da90)) 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(0x558a8d51db80), "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(0x558a8d51db80)) 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(0x558a8cccf398)) 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(0x558a8cccf2a8), HASH(0x558a8d4d7b40)) called at /home/w19596/web/staging/cgi-bin/plugins/timeplaner/Hooks.pm line 67
plugins::timeplaner::Hooks::getAvailabilityInfo_tp(CosmoShop::Articles::Article=HASH(0x558a8cccf2a8), HASH(0x558a8d4d7b40)) 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(0x558a8cccf2a8), HASH(0x558a8d4d7b40)) 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(0x558a8cccf2a8), "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(0x558a8cccf2a8)) 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(0x558a8d4eec58)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/TemplateEngine.pm line 242
CosmoShop::TemplateEngine::render(CosmoShop::TemplateEngine=HASH(0x558a8c69e670), HASH(0x558a8d4ccb88)) 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(0x558a8cdf51d0)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/TemplateEngine.pm line 242
CosmoShop::TemplateEngine::render(CosmoShop::TemplateEngine=HASH(0x558a8c69e670), HASH(0x558a8cdf1b58)) called at /home/w19596/web/staging/cgi-bin/lib/CosmoShop/TemplateEngine.pm line 120
CosmoShop::TemplateEngine::renderPage(CosmoShop::TemplateEngine=HASH(0x558a8c69e670), HASH(0x558a8cc64fa8)) 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 |
| |
|