{"id":145661,"date":"2025-12-11T00:50:40","date_gmt":"2025-12-11T08:50:40","guid":{"rendered":"https:\/\/help.fooevents.com\/?post_type=docs&#038;p=145661"},"modified":"2025-12-11T00:50:40","modified_gmt":"2025-12-11T08:50:40","slug":"pro-velke-objednavky-se-nevytvareji-listky","status":"publish","type":"docs","link":"https:\/\/help.fooevents.com\/cs\/docs\/frequently-asked-questions\/tickets\/tickets-are-not-being-generated-for-large-orders\/","title":{"rendered":"Pro velk\u00e9 objedn\u00e1vky se l\u00edstky nevyd\u00e1vaj\u00ed."},"content":{"rendered":"<p>P\u0159\u00ed\u010dinou je pravd\u011bpodobn\u011b omezen\u00ed datov\u00e9ho typu v datab\u00e1zi va\u0161ich webov\u00fdch str\u00e1nek. FooEvents ukl\u00e1d\u00e1 \u00fadaje o l\u00edstc\u00edch pro danou objedn\u00e1vku v jedin\u00e9m serializovan\u00e9m <strong>meta_hodnota<\/strong>. U velk\u00fdch objedn\u00e1vek (p\u0159ibli\u017en\u011b 30 a v\u00edce l\u00edstk\u016f v jedn\u00e9 objedn\u00e1vce, v z\u00e1vislosti na tom, kolik dat ka\u017ed\u00fd l\u00edstek ukl\u00e1d\u00e1) m\u016f\u017ee tato serializovan\u00e1 hodnota p\u0159ekro\u010dit maxim\u00e1ln\u00ed velikost povolenou pro <strong>TEXT<\/strong> pole. Kdy\u017e k tomu dojde:<\/p>\n<ul>\n<li>Meta objedn\u00e1vky je <strong>zkr\u00e1cen\u00e9 nebo ne\u00fapln\u011b ulo\u017een\u00e9<\/strong>.<\/li>\n<li>FooEvents nem\u00e1 v\u0161echna data, kter\u00e1 o\u010dek\u00e1v\u00e1.<\/li>\n<li>Vstupenky pro tuto objedn\u00e1vku mohou <strong>neb\u00fdt generov\u00e1n spr\u00e1vn\u011b<\/strong> nebo v\u016fbec.<\/li>\n<\/ul>\n<h3>Koho se to t\u00fdk\u00e1?<\/h3>\n<p>To by se m\u011blo t\u00fdkat pouze obchod\u016f, kter\u00e9:<\/p>\n<ul>\n<li>M\u00edt <strong>HPOS<\/strong> (WooCommerce Vysoce v\u00fdkonn\u00e9 ukl\u00e1d\u00e1n\u00ed objedn\u00e1vek) povoleno.<\/li>\n<li>O\u010dek\u00e1vejte zpracov\u00e1n\u00ed <strong>velk\u00e9 objedn\u00e1vky<\/strong> (asi 30 nebo v\u00edce l\u00edstk\u016f v jedn\u00e9 objedn\u00e1vce).<\/li>\n<\/ul>\n<p>Pokud jste <strong>ne<\/strong> pou\u017e\u00edv\u00e1n\u00ed <strong>HPOS<\/strong>, nem\u011bl by v\u00e1s tento probl\u00e9m ovlivnit.<\/p>\n<h3>Pro\u010d se to net\u00fdk\u00e1 web\u016f, kter\u00e9 nepou\u017e\u00edvaj\u00ed HPOS?<\/h3>\n<p>Na str\u00e1nk\u00e1ch bez HPOS pou\u017e\u00edv\u00e1 WooCommerce standardn\u00ed WordPress. <strong>postmeta<\/strong> tabulka (nap\u0159\u00edklad wp_postmeta) pro meta \u00fadaje o objedn\u00e1vce.<\/p>\n<p>Na adrese <strong>postmeta<\/strong>... <strong>meta_hodnota<\/strong> sloupec je ji\u017e definov\u00e1n jako <strong>DLOUH\u00dd TEXT<\/strong>, kter\u00fd m\u016f\u017ee ukl\u00e1dat mnohem v\u011bt\u0161\u00ed hodnoty ne\u017e <strong>TEXT<\/strong>.<\/p>\n<p>Z tohoto d\u016fvodu mohou weby, kter\u00e9 nepou\u017e\u00edvaj\u00ed HPOS, bezpe\u010dn\u011b ukl\u00e1dat velk\u00e9 hodnoty meta ticket\u016f FooEvents bez jak\u00fdchkoli zm\u011bn.<\/p>\n<p>Pokud se s t\u00edmto probl\u00e9mem setk\u00e1te na webu, kter\u00fd nen\u00ed zalo\u017een na HPOS,  vy nebo v\u00e1\u0161 v\u00fdvoj\u00e1\u0159 jste pravd\u011bpodobn\u011b zm\u011bnili datov\u00fd typ <strong>meta_hodnota<\/strong> pole v WordPress <strong>postmeta<\/strong> tabulka.<\/p>\n<h3>Technick\u00e9 \u00fadaje<\/h3>\n<ul>\n<li><strong>TEXT<\/strong> maxim\u00e1ln\u00ed d\u00e9lka: 65 535 bajt\u016f.<\/li>\n<li><strong>DLOUH\u00dd TEXT<\/strong> maxim\u00e1ln\u00ed d\u00e9lka: 4 GB.<\/li>\n<\/ul>\n<p>FooEvents ukl\u00e1d\u00e1 \u00fadaje o jednotliv\u00fdch l\u00edstc\u00edch, jako nap\u0159\u00edklad:<\/p>\n<ul>\n<li>ID vstupenek<\/li>\n<li>\u00dadaje o \u00fa\u010dastn\u00edc\u00edch<\/li>\n<li>Informace o akci<\/li>\n<li>Dal\u0161\u00ed meta vstupenky<\/li>\n<\/ul>\n<p>V\u0161echno je to serializov\u00e1no do jedin\u00e9ho <strong>meta_hodnota<\/strong>. U velk\u00fdch objedn\u00e1vek m\u016f\u017ee tento \u0159et\u011bzec p\u0159ekro\u010dit hodnotu <strong>TEXT<\/strong> m\u016f\u017ee ukl\u00e1dat, co\u017e zp\u016fsobuje zkr\u00e1cen\u00ed a generov\u00e1n\u00ed neplatn\u00fdch l\u00edstk\u016f.<\/p>\n<h3>Doporu\u010den\u00e1 oprava<\/h3>\n<p>Pokud pou\u017e\u00edv\u00e1te HPOS a o\u010dek\u00e1v\u00e1te velk\u00e9 objedn\u00e1vky, zm\u011b\u0148te <strong>meta_hodnota<\/strong> sloupec v <strong>wc_objedn\u00e1vky_meta<\/strong> tabulka z <strong>TEXT<\/strong> na <strong>DLOUH\u00dd TEXT<\/strong>.<\/p>\n<p><strong>D\u016fle\u017eit\u00e9:<\/strong> To zahrnuje \u00fapravu z\u00e1kladn\u00ed tabulky WooCommerce. V\u017edy nejprve z\u00e1lohujte svou datab\u00e1zi. Pokud si na to netrouf\u00e1te, po\u017e\u00e1dejte o pomoc sv\u00e9ho hostitele nebo v\u00fdvoj\u00e1\u0159e.<\/p>\n<ol>\n<li><strong>Potvr\u010fte n\u00e1zev tabulky<\/strong><br \/>\nV\u011bt\u0161ina instalac\u00ed bude pou\u017e\u00edvat: wp_wc_orders_meta<br \/>\nPokud pou\u017e\u00edv\u00e1te vlastn\u00ed p\u0159edponu, prove\u010fte p\u0159\u00edslu\u0161n\u00e9 \u00fapravy (nap\u0159\u00edklad <code>myshop_wc_objedn\u00e1vky_meta<\/code>).<\/li>\n<li><strong>P\u0159\u00edklad spu\u0161t\u011bn\u00ed p\u0159\u00edkazu SQL (upravte n\u00e1zev tabulky podle pot\u0159eby)<\/strong>\n<pre><code class=\"language-sql\">ALTER TABLE `wp_wc_orders_meta` MODIFY `meta_value` LONGTEXT NULL;<\/code><\/pre>\n<\/li>\n<li><strong>Ov\u011b\u0159it<\/strong>\n<ul>\n<li>Ujist\u011bte se, \u017ee dotaz prob\u011bhne bez chyb.<\/li>\n<li>Zadejte zku\u0161ebn\u00ed objedn\u00e1vku s velk\u00fdm po\u010dtem l\u00edstk\u016f a ov\u011b\u0159te, zda jsou l\u00edstky generov\u00e1ny podle o\u010dek\u00e1v\u00e1n\u00ed.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h3>Poru\u0161\u00ed to WooCommerce nebo HPOS?<\/h3>\n<p>Ne. Tato zm\u011bna je bezpe\u010dn\u00e1 a odpov\u00edd\u00e1 zp\u016fsobu, jak\u00fdm WordPress ji\u017e ukl\u00e1d\u00e1 metadata:<\/p>\n<ul>\n<li>J\u00e1dro WordPress a WooCommerce ji\u017e pou\u017e\u00edvaj\u00ed <strong>DLOUH\u00dd TEXT<\/strong> pro <strong>meta_hodnota<\/strong> v <strong>postmeta<\/strong> tabulka.<\/li>\n<li>Zm\u011bna <strong>meta_hodnota<\/strong> na adrese <strong>wc_objedn\u00e1vky_meta<\/strong> z <strong>TEXT<\/strong> na <strong>DLOUH\u00dd TEXT<\/strong> pouze zvy\u0161uje mno\u017estv\u00ed dat, kter\u00e9 lze ulo\u017eit; nem\u011bn\u00ed zp\u016fsob, jak\u00fdm WooCommerce nebo FooEvents \u010dtou nebo zapisuj\u00ed data.<\/li>\n<\/ul>\n<p>To znamen\u00e1:<\/p>\n<ul>\n<li>V\u017edy <strong>prove\u010fte \u00faplnou z\u00e1lohu datab\u00e1ze<\/strong> prvn\u00ed.<\/li>\n<li>V ide\u00e1ln\u00edm p\u0159\u00edpad\u011b tuto zm\u011bnu otestujte na <strong>stagingov\u00e1 str\u00e1nka<\/strong> p\u0159ed jeho pou\u017eit\u00edm ve v\u00fdrob\u011b.<\/li>\n<\/ul>","protected":false},"featured_media":0,"parent":159,"menu_order":22,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"doc_tag":[],"class_list":["post-145661","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/help.fooevents.com\/cs\/wp-json\/wp\/v2\/docs\/145661","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.fooevents.com\/cs\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/help.fooevents.com\/cs\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/help.fooevents.com\/cs\/wp-json\/wp\/v2\/comments?post=145661"}],"version-history":[{"count":2,"href":"https:\/\/help.fooevents.com\/cs\/wp-json\/wp\/v2\/docs\/145661\/revisions"}],"predecessor-version":[{"id":145663,"href":"https:\/\/help.fooevents.com\/cs\/wp-json\/wp\/v2\/docs\/145661\/revisions\/145663"}],"up":[{"embeddable":true,"href":"https:\/\/help.fooevents.com\/cs\/wp-json\/wp\/v2\/docs\/159"}],"prev":[{"title":"Jak mohu p\u0159en\u00e9st nebo importovat tipy z jin\u00e9ho syst\u00e9mu?","link":"https:\/\/help.fooevents.com\/cs\/docs\/frequently-asked-questions\/tickets\/how-do-i-transfer-or-import-tickets-from-a-different-system\/","href":"https:\/\/help.fooevents.com\/cs\/wp-json\/wp\/v2\/docs\/133763"}],"wp:attachment":[{"href":"https:\/\/help.fooevents.com\/cs\/wp-json\/wp\/v2\/media?parent=145661"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/help.fooevents.com\/cs\/wp-json\/wp\/v2\/doc_tag?post=145661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}