{"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":"2026-06-03T05:36:11","modified_gmt":"2026-06-03T12:36:11","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 class=\"wp-block-paragraph\">This is most likely caused by a data type limitation in your sites database.&nbsp;FooEvents stores ticket data for an order in a single serialized <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\n\n\n<ul class=\"wp-block-list\">\n<li>Meta objedn\u00e1vky je <strong>zkr\u00e1cen\u00e9 nebo ne\u00fapln\u011b ulo\u017een\u00e9<\/strong>.<\/li>\n\n\n\n<li>FooEvents nem\u00e1 v\u0161echna data, kter\u00e1 o\u010dek\u00e1v\u00e1.<\/li>\n\n\n\n<li>Vstupenky pro tuto objedn\u00e1vku mohou <strong>neb\u00fdt generov\u00e1n spr\u00e1vn\u011b<\/strong> nebo v\u016fbec.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Koho se to t\u00fdk\u00e1?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To by se m\u011blo t\u00fdkat pouze obchod\u016f, kter\u00e9:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>M\u00edt <strong>HPOS<\/strong> (WooCommerce Vysoce v\u00fdkonn\u00e9 ukl\u00e1d\u00e1n\u00ed objedn\u00e1vek) povoleno.<\/li>\n\n\n\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\n\n\n<p class=\"wp-block-paragraph\">Pokud jste <strong>ne<\/strong> pou\u017e\u00edv\u00e1n\u00ed <strong>HPOS<\/strong>, nem\u011bl by v\u00e1s tento probl\u00e9m ovlivnit.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Pro\u010d se to net\u00fdk\u00e1 web\u016f, kter\u00e9 nepou\u017e\u00edvaj\u00ed HPOS?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">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\n\n\n<p class=\"wp-block-paragraph\">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\n\n\n<p class=\"wp-block-paragraph\">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\n\n\n<p class=\"wp-block-paragraph\">If you do experiance this issue on a non-HPOS site,&nbsp; you or your developer may gave changed the data type of the <strong>meta_hodnota<\/strong> pole v WordPress <strong>postmeta<\/strong> tabulka.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Technick\u00e9 \u00fadaje<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>TEXT<\/strong> maxim\u00e1ln\u00ed d\u00e9lka: 65 535 bajt\u016f.<\/li>\n\n\n\n<li><strong>DLOUH\u00dd TEXT<\/strong> maxim\u00e1ln\u00ed d\u00e9lka: 4 GB.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">FooEvents ukl\u00e1d\u00e1 \u00fadaje o jednotliv\u00fdch l\u00edstc\u00edch, jako nap\u0159\u00edklad:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>ID vstupenek<\/li>\n\n\n\n<li>\u00dadaje o \u00fa\u010dastn\u00edc\u00edch<\/li>\n\n\n\n<li>Informace o akci<\/li>\n\n\n\n<li>Dal\u0161\u00ed meta vstupenky<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">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\n\n\n<h3 class=\"wp-block-heading\">Doporu\u010den\u00e1 oprava<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">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\n\n\n<p class=\"wp-block-paragraph\"><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\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Potvr\u010fte n\u00e1zev tabulky<\/strong><br><br>V\u011bt\u0161ina instalac\u00ed bude pou\u017e\u00edvat: wp_wc_orders_meta<br><br>Pokud 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\n\n\n<li><strong>P\u0159\u00edklad spu\u0161t\u011bn\u00ed p\u0159\u00edkazu SQL (upravte n\u00e1zev tabulky podle pot\u0159eby)<\/strong><br><pre><code class=\"language-sql\">ALTER TABLE `wp_wc_orders_meta`<br>MODIFY `meta_value` LONGTEXT NULL;<\/code><\/pre><\/li>\n\n\n\n<li><strong>Ov\u011b\u0159it<\/strong>\n<ul class=\"wp-block-list\">\n<li>Ujist\u011bte se, \u017ee dotaz prob\u011bhne bez chyb.<\/li>\n\n\n\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\n\n\n<h3 class=\"wp-block-heading\">Poru\u0161\u00ed to WooCommerce nebo HPOS?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">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\n\n\n<ul class=\"wp-block-list\">\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\n\n\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\n\n\n<p class=\"wp-block-paragraph\">To znamen\u00e1:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>V\u017edy <strong>prove\u010fte \u00faplnou z\u00e1lohu datab\u00e1ze<\/strong> prvn\u00ed.<\/li>\n\n\n\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},"excerpt":{"rendered":"<p>This is most likely caused by a data type limitation in your sites database.&nbsp;FooEvents stores ticket data for an order in a single serialized meta_value. On large orders (roughly 30+ tickets in one order, depending on how much data each ticket stores), that serialized value can exceed the maximum size allowed for a TEXT field. [&hellip;]<\/p>\n","protected":false},"featured_media":0,"parent":159,"menu_order":22,"template":"","doc_tag":[],"class_list":["post-145661","docs","type-docs","status-publish","hentry"],"_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"}],"version-history":[{"count":3,"href":"https:\/\/help.fooevents.com\/cs\/wp-json\/wp\/v2\/docs\/145661\/revisions"}],"predecessor-version":[{"id":148440,"href":"https:\/\/help.fooevents.com\/cs\/wp-json\/wp\/v2\/docs\/145661\/revisions\/148440"}],"up":[{"embeddable":true,"href":"https:\/\/help.fooevents.com\/cs\/wp-json\/wp\/v2\/docs\/159"}],"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}]}}