Artisan migrate vyhazuje chyby

@dehtak (702), pred 4 rokmi

Ahoj, Nevim cim to, ale kdyz dam prikaz artisan migrate tak mi to vyhodi chyby a nevytvori vsechny tabulky a to chci jen vytvorit ty co uz jsou prednastaveny od laravelu (user, failed_jobs...) Microsoft Windows [Verze 6.1.7601] Copyright (c) 2009 Microsoft Corporation. Všechna práva vyhrazena.


w:\008>php artisan migrate
Migration table created successfully.
Migrating: 2014_10_12_000000_create_users_table

   Illuminate\Database\QueryException

  SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))

  at W:\008\vendor\laravel\framework\src\Illuminate\Database\Connection.php:671
    667▕         // If an exception occurs when attempting to run a query, we'll format the error
    668▕         // message to include the bindings with SQL, which will make this exception a
    669▕         // lot more helpful to the developer instead of just the database's errors.
    670▕         catch (Exception $e) {
  ➜ 671▕             throw new QueryException(
    672▕                 $query, $this->prepareBindings($bindings), $e
    673▕             );
    674▕         }
    675▕
     }
    675▕

  1   W:\008\vendor\laravel\framework\src\Illuminate\Database\Connection.php:464
      PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes")

  2   W:\008\vendor\laravel\framework\src\Illuminate\Database\Connection.php:464
      PDOStatement::execute()

Nekde sem udelal chybu nechapu

otázka artisan migrate

Zdieľať

Ešte nie si členom CZ/SK Laravel komunity?

To možeš ľahko zmeniť. Registrácia je zdarma a ako registrovaný člen získaš množstvo výhod. Prečítaj si prečo by si mal byť členom.

Prihlásiť sa Zaregistrovať

Zoradiť odpovede:

by @xvital (460), pred 4 rokmi

Je to tym, ze Laravel defaultne pouziva kodovanie utf8mb4 a v MySQL v. < 5.7.7 a MariaDB < 10.2.2 sa tam tieto kluce nezmestia.

Jednoduchy fix je zavolat v boot metode v AppServiceProvider toto:

Schema::defaultStringLength(191);

cim sa zabezpeci nastavenie pozadovanej dlzky indexov.

Viac info tu: https://laravel.com/docs/7.x/migrations#creating-indexes (Index Lengths & MySQL / MariaDB)

Zdieľať

by @Elmer11Jease (105), pred 3 rokmi

It's my first time come here [url=https://www.proggnosis.com/Forum/topic5616-hello-everyone.aspx?MessageID=6041]Hello, everyone[/url] [url=https://avigames.at.ua/forum/5-44-7#91245]Hello, everyone[/url] [url=https://nocens.boards.net/thread/1/welcome-new-forum?page=2#scrollTo=21]Hello, everyone[/url] [url=http://cosw.phorum.pl/viewtopic.php?f=1&t=174284]Hello, everyone[/url] [url=http://www.pp2263.com/forum.php?mod=viewthread&tid=207&pid=15372&page=1&extra=#pid15372]Hello, everyone[/url] 197c63c

Zdieľať

by @Elmer1321Jease (105), pred 2 rokmi

Hello,everyone https://wanelo.co/washclub18 https://historyhub.history.gov/external-link.jspa?url=https://pbase.com/topics/saltsheep79/h1human_hair_lace_wigs_la https://darcvigilante.site/member.php?action=profile&uid=268653 https://sportbookmark.stream/story.php?title=fast-shipping-wigs-in-inventory-wigs-transport-within-24-wigs-collection#discuss http://q2a.sydt.com.tw/index.php?qa=user&qa_1=pastoryew1

[url=https://www.chronocompendium.com/Forums/index.php?topic=13673.new#new]Hello, everyone[/url] [url=https://epitalon.pl/forum/viewtopic.php?f=3&t=67499]Hello, everyone[/url] [url=https://www.columnx.nl/cx-cafe/topic/hello-everyone-5/#postid-2828]Hello, everyone[/url] [url=https://parafarrf.ru/forum/?PAGE_NAME=message&FID=2&TID=12&TITLE_SEO=12-shtatnaya-magnitola-parafar-dlya-toyota-camry-v30-do-2006-na-android-8.1.0-_pf061xhd&MID=59551&result=reply#message59551]Hello, everyone[/url] [url=http://shiqi98.com/bbs/forum.php?mod=viewthread&tid=498&pid=22338&page=78&extra=#pid22338]Hello, everyone[/url] 63e53c3

Zdieľať

by @Dallas211Mig (5), pred 2 rokmi

Hello, it's my first time come here http://onderzoeksvragen.ou.nl/index.php?qa=user&qa_1=grambird3 http://www.ukr-inform.com/user/easepajama05/ http://adrestyt.ru/user/swimreason99/ http://forum.playstarfleet.com/index.php?action=profile;area=forumprofile;u=307584 https://www.adpost4u.com/user/profile/487461

[url=http://forum.4-pda.ru/viewtopic.php?f=138&t=41326]Hello, I am glad to this forum[/url] [url=https://forum.infinity-war.ru/index.php?/topic/4828-hello-i-am-glad-to-this-forum/]Hello, I am glad to this forum[/url] [url=https://db-turkiyeforum.freeforums.net/thread/73/seviyeleri?page=23#scrollTo=586]Hello, I am glad to this forum[/url] [url=http://rotary3271.com/forums/Upload/showthread.php?tid=149550]Hello, I am glad to this forum[/url] [url=http://ewfcollector.com/forum/viewtopic.php?f=3&t=69354]Hello, I am glad to this forum[/url] 43ca704

Zdieľať

by @Joshua3222ver (5), pred 2 rokmi

This is my first time come here https://superuser.com/users/1539537 https://www.pcb.its.dot.gov/PageRedirect.aspx?redirectedurl=https://nightlizard91.wordpress.com/2021/11/17/wholesale-brazilian-hair-bundles-for-beginning-your-hair-extension-enterprise/ http://ikeynote.cn/home.php?mod=space&uid=2786722 https://www.spreaker.com/user/14863965 https://quoras.trade/story.php?title=wigs-with-aspect-half#discuss

[url=https://what-is.com.ua/forum/viewtopic.php?f=71&t=47103]I am very happy to cme here[/url] [url=https://cancergyan.org/forum/viewtopic.php?f=12&t=579]I am very happy to cme here[/url] [url=http://avaya.newsystems.ru/forum/messages/forum1/topic220347/message529780/?result=reply#message529780]I am very happy to cme here[/url] [url=http://www.ottavio-informatik.com/forum/viewtopic.php?f=11&t=242]I am very happy to cme here[/url] [url=http://prachuap.go.th/forum/index.php?topic=94287.new#new]I am very happy to cme here[/url] 3ca7046

Zdieľať

by @Elmer1341Jease (5), pred 2 rokmi

It's my first time come here http://archives.bia.or.th/wiki/index.php?title=h1Alibaba_Categorical_Buying_And_Selling_Company_Provide_Gem_Stone_Jaw_Crusherh1 https://worknr.com/user/profile/235785 https://www.inventables.com/users/ramirezjensen6222 https://tagoverflow.stream/story.php?title=finest-12-duplicate-online-wholesalers-websites-to-purchase-fake-stuff#discuss http://maple.linppt.cc/home.php?mod=space&uid=2997441

[url=http://203.105.227.142/comments/bbs.cgi/html2wml.cgi]Hello, everyone[/url] [url=http://www.reo14.moe.go.th/phpBB3/viewtopic.php?f=6&t=1803208]Hello, everyone[/url] [url=https://www.adflyforum.com/viewtopic.php?f=12&t=104450]Hello, everyone[/url] [url=http://hnhtnmsc.com/forum.php?mod=viewthread&tid=2362&extra=]Hello, everyone[/url] [url=https://kinokicks.freeforums.net/thread/2/filme-2016?page=19#scrollTo=339]Hello, everyone[/url] 7197c63

Zdieľať

by @Joshua3234ver (5), pred 2 rokmi

This is my first time come here https://my.bankstreet.edu/ICS/Campus_Life/Campus_Groups/Child_Life_Program/Group_Collaboration.jnz?portlet=%5bICS%5d_ForumPortlet&screen=PostView&screenType=change&id=05335e9c-7d60-4d5e-b913-f6cc2e7c8448 http://goddessxuan.com/home.php?mod=space&uid=21160 https://forum.cyberpandit.org/member.php?action=profile&uid=219464 http://kolokolchik237.ru/user/tunacan7/ https://vendetodocomercial.com/author/pipecousin0

Zdieľať

by @Dallas422Mig (5), pred 2 rokmi

hello, everyone,This is my first time come here http://itiswiki.kpfu.ru/index.php?title=How_Else_To_Pay_If_Alibaba_Supplier_Does_Not_Accept_Paypal https://urlscan.io/result/05da5491-5004-4510-b1df-5b938c6262d0/ https://securityholes.science/wiki/Yyong_Lace_Closure_Human_Hair_Free_Part_4x4_Brazilian_Virgin_Hair_Physique http://forum.umbandaeucurto.com/index.php?qa=user&qa_1=ghanafoam26 http://pandora.nla.gov.au/external.html?link=https://digihair.net http://answerslistly.com/index.php?qa=user&qa_1=bumperpastor77 http://sc.devb.gov.hk/TuniS/squareblogs.net/rockrandom3/chemical-supply https://mccallvendelb.livejournal.com/profile http://86x.org/home.php?mod=space&uid=324954 https://peatix.com/user/10692707

Zdieľať

by @Joshua3239ver (5), pred 2 rokmi

Hello, it's my first time come here http://twojmasaz.pl/author/pvcknight0/ http://521test.com/home.php?mod=space&uid=20649 http://ask.klinikkarte.de/index.php?qa=user&qa_1=sistersmell69 https://humanlove.stream/wiki/H1Lowcost_Wholesale_Duplicate_Designer_Clothes_Online_From_Chinah1 https://ondashboard.win/story.php?title=acer-laptops-netbooks-12#discuss

Zdieľať

by @Raymond2393Waync (5), pred 2 rokmi

hello, everyone,nice to meet you http://maple.linppt.cc/home.php?mod=space&uid=3202560 https://phonographic.science/wiki/Beautyforever_7a_Unprocessed_Malaysian_A_Hundredhuman_Hair_3bundles_With_Ear_To_Ear_Lace_Frontal_Closure http://wiki.smwcentral.net/index.php?title=Brazilian_Virgin_Hair_Silk_Prime_Lace_Wigsglueless_Silk_Top_Full_Lace_Wigs_Human_Hair_Silk_Top_Lace_Wigs_Online_Supplier https://elearnportal.science/wiki/Lace_Entrance_Wigs_Youtube https://ask.fm/walkmatch954

Zdieľať

by @Joshua3349ver (5), pred 2 rokmi

Hello, it's my first time come here https://vuf.minagricultura.gov.co/Lists/Informacin%20Servicios%20Web/DispForm.aspx?ID=12527 http://wddol.com/home.php?mod=space&uid=281935 https://lexsrv3.nlm.nih.gov/fdse/search/search.pl?match=0&realm=all&terms=https://pkyeezy.ru http://chainblx.io/index.php?p=/profile/celerybill26 https://disqus.com/by/santabreak00/

Zdieľať

by @Dallas427Mig (5), pred 2 rokmi

hello, everyone,This is my first time come here https://cameradb.review/wiki/Closure_Physique_Wave_Wig http://q2a.sydt.com.tw/index.php?qa=user&qa_1=spadecarol18 http://professionalcarpetcleaners.com/user/profile/737640 https://bbs.pku.edu.cn/v2/jump-to.php?url=https://dailyuploads.net/3n7pmrcs714y https://www.indiegogo.com/individuals/27886254 https://anotepad.com/notes/5fi2r2q5 https://fkwiki.win/wiki/Post:2_Inch_Bundle_Critiques http://jieming.vip/home.php?mod=space&uid=30349 https://vvfit.com/members/hatpoppy0/activity/1157653/ http://twitter.com/home?status=http://xurl.es/c65n1

Zdieľať

by @MikeCep (10), pred 2 rokmi

[url=https://obs-studio.co]obs studio[/url] [url=https://obs-studio.co]download obs[/url]

Zdieľať

by @MikeCep (10), pred 2 rokmi

[url=https://obs-studio.co]obs studio[/url] [url=https://obs-studio.co]download obs[/url]

Zdieľať

by @Geraldrex (10), pred 2 rokmi

[center][b]These canvas prints are printed with solvent-free HP latex inks making them safe for all family. Multiple decorative frame designs available! Manually stretched! The Canvas Prints from CanvasDiscount.com are Ready to Ship in 24h & have The Lowest-Price-in-the-USA Guarantee.

Personalize Your Wall with Premium Photo Canvas Hand-stretched canvas on a real wood frame Range of striking edge designs available High-resolution photo printing in vivid colors UV-resistant inks, totally free of solvents Canvas certified for professional photo printing

HomaPage : [url=https://www.kristendecor.com]kristendecor Canvas[/url] [url=https://www.kristendecor.com]canvas[/url][/b] [img]https://i.icanvas.com/list-square/giant-art-abstract-2022.jpg[/img] [/center]

Zdieľať

by @Geraldrex (10), pred 2 rokmi

HomaPage : [url=https://www.kristendecor.com]kristendecor Canvas[/url] [url=https://www.kristendecor.com]uc canvas[/url][/b] [img]https://i.icanvas.com/list-square/giant-art-abstract-2022.jpg[/img] [/center]

Zdieľať

by @Scottsag (5), pred 2 rokmi

If you have straight hair, you may be wondering how to get curly hair for men. Fortunately, it’s very possible to make straight hair curly with the right men’s styling products and tools. As long as you don’t have very short hair that won’t curl at all, this tutorial will show you exactly how simple it is to get a wavy or curly hairstyle with thick, straight hair. I found this information on this website [url=]https://amazinghair4u.blogspot.com/[/url]

Zdieľať

by @Elmer1489Jease (10), pred 2 rokmi

Hello,everyone https://zenwriting.net/pyjamafire42/1-low-cost-adult-sex-toy-store http://cqms.skku.edu/b/lecture/520130 https://humanlove.stream/wiki/Hair_Colour_Numbering_System http://xinyue678.com/home.php?mod=space&uid=129026 https://kikipedia.win/wiki/H1Nike_Air_Yeezy_1_Internet_Tanh1

Zdieľať

by @Raymond2401Waync (10), pred 2 rokmi

Hello, it's my first time come here https://timeoftheworld.date/wiki/H1Reproduction_Designer_Scarves_Online_Faux_Designer_Scarves_China_Gucci_Scarf_Hermes_Scarfh1 https://writeablog.net/townpeak71/vibrator-offer-code-kristy-at-adam-and-eve-adult-t http://www.ccwin.cn/space-uid-5612845.html http://www.sdmnapoli.it/index.php?option=com_k2&view=itemlist&task=user&id=1894663 http://hz061.com/home.php?mod=space&uid=679119

Zdieľať

by @Elmer1489Jease (10), pred 2 rokmi

Hello, I am very happy come here http://test.dragonstar.ru/user/fatherrayon26/ http://fu9453.com/space-uid-574591.html http://qa.pandora-2.com/index.php?qa=user&qa_1=beanmargin19 https://www.instapaper.com/p/deathharbor01 https://bbs.now.qq.com/home.php?mod=space&uid=1273499

Zdieľať