dehtak

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

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:
Od najstarších Od najnovších
Joshua3234ver
by @Joshua3234ver (5), pred 4 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

[url=http://www.dinglan.cc/forum.php?mod=viewthread&tid=10867&extra=]I am very happy to cme here[/url] [url=http://sc686.net/forum.php?mod=viewthread&tid=22&pid=896782&page=303&extra=page%3D1#pid896782]I am very happy to cme here[/url] [url=https://oynayamayanlar.com/forum/viewtopic.php?f=2&t=11277]I am very happy to cme here[/url] [url=http://www.gugups.com/forum.php?mod=viewthread&tid=503128&extra=]I am very happy to cme here[/url] [url=http://www.qualityman.cn/bbs/forum.php?mod=viewthread&tid=156&pid=215290&page=21503&extra=#pid215290]I am very happy to[/url] [url=https://oodagurus.com/forums/showthread.php?tid=160]I am very happy to cme here[/url] [url=https://www.mfas.nl/wps/portal/home/forum/onderwerp/3628e94c-238a-44a0-84f7-4b83f29cae50/%21ut/p/z1/jZDNbsIwEISfyNqJY4fNkZ8iU5FSBIjEF-RCkgbRJIoQfX0i4Iphbyt9O7MzZCklW7tLVbpz1dTu1O-ZjXZxbGBClnN8BcDQ6G811wa8Bm1vAJ7MEGTfufcA1i-_JeuzAOMBeDQ-Xz3ZtyC7ZJyUZFt3_hVVXTSUNvUh7_7zrqU0jCTnsdoLGbITSjkIVsVAqB8OCxnvXa5BWR91sJuBleEVEl5MAyz1BB_T0ThAdO_CC7R_mxRHfTpqLq_JBDTM/]I am very happy to cme here[/url] [url=http://narutoperso3.free.fr/phpBB3/viewtopic.php?f=2&t=20050]I am very happy to cme here[/url] [url=http://strengkatholisch.de/YaBB.pl]I am very happy to cme here[/url] [url=https://black.volyn.net/forum/viewtopic.php?f=29&t=20811]I am very happy to cme here[/url] 046963e

Elmer1341Jease
by @Elmer1341Jease (5), pred 4 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

Joshua3222ver
by @Joshua3222ver (5), pred 4 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

Dallas211Mig
by @Dallas211Mig (5), pred 4 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

Elmer1321Jease
by @Elmer1321Jease (105), pred 4 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

Elmer11Jease
xvital
by @xvital (460), pred 5 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)