• laravel安装nova 运行php artisan migrate出错


    报错一
    $ php artisan migrate

    IlluminateDatabaseQueryException : could not find driver (SQL: select * fr
    om information_schema.tables where table_schema = dev_oms and table_name = migra
    tions)

    at D:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnection.
    php:664
    660| // If an exception occurs when attempting to run a query, we'll
    format the error
    661| // message to include the bindings with SQL, which will make th
    is exception a
    662| // lot more helpful to the developer instead of just the databa
    se's errors.
    663| catch (Exception $e) {
    > 664| throw new QueryException(
    665| $query, $this->prepareBindings($bindings), $e
    666| );
    667| }
    668|

    Exception trace:

    1 PDOException::("could not find driver")
    D:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnectors
    Connector.php:68

    2 PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=dev_oms", "root",
    "root", [])
    D:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnectors
    Connector.php:68

    Please use the argument -v to see more details.
    原因是php.ini 扩展"php_pdo_mysql.dll"没开启

    报错二
    $ php artisan migrate
    Migration table created successfully.

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

    at D:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnection.
    php:664
    660| // If an exception occurs when attempting to run a query, we'll
    format the error
    661| // message to include the bindings with SQL, which will make th
    is exception a
    662| // lot more helpful to the developer instead of just the databa
    se's errors.
    663| catch (Exception $e) {
    > 664| throw new QueryException(
    665| $query, $this->prepareBindings($bindings), $e
    666| );
    667| }
    668|

    Exception trace:

    1 PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Sp
    ecified key was too long; max key length is 767 bytes")
    D:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnection
    .php:458

    2 PDOStatement::execute()
    D:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnection
    .php:458

    Please use the argument -v to see more details.
    数据库编码改为utf8mb4

    报错三
    $ php artisan migrate
    Migration table created successfully.

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

    at D:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnection.
    php:664
    660| // If an exception occurs when attempting to run a query, we'll
    format the error
    661| // message to include the bindings with SQL, which will make th
    is exception a
    662| // lot more helpful to the developer instead of just the databa
    se's errors.
    663| catch (Exception $e) {
    > 664| throw new QueryException(
    665| $query, $this->prepareBindings($bindings), $e
    666| );
    667| }
    668|

    Exception trace:

    1 PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Sp
    ecified key was too long; max key length is 767 bytes")
    D:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnection
    .php:458

    2 PDOStatement::execute()
    D:WWWdev_omsvendorlaravelframeworksrcIlluminateDatabaseConnection
    .php:458

    Please use the argument -v to see more details.
    加上两行代码即可最后一句改成

     Schema::defaultStringLength(191);

  • 相关阅读:
    给一个二维数组随机赋值
    sql server use WAITFOR DELAY to wait some milliseconds
    sql server print time with milliseconds
    UE4 LeapMotion 获取手掌朝向
    Unity打包Android出现Failed to find Build Tools revision
    UE4中Yaw,Roll,Pitch分别对应什么轴?
    Unity 遍历场景所有物体(包括隐藏及被禁用的物体)
    C#-Linq扩展方法DistinctBy
    Unity编辑器扩展--Scene Manager
    Unity查找功能编辑器扩展Searcher
  • 原文地址:https://www.cnblogs.com/F4natasy/p/10694488.html
Copyright © 2020-2023  润新知