phplaravel怎么优化(laravel执行php artisan migrate报错的解决方法)
类别:编程学习 浏览量:409
时间:2021-10-10 00:54:59 phplaravel怎么优化
laravel执行php artisan migrate报错的解决方法报错一
$ php artisan migrate Illuminate\Database\QueryException : could not find driver (SQL: select * fr om information_schema.tables where table_schema = dev_oms and table_name = migra tions) at D:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connection. 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:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connectors \Connector.php:68 2 PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=dev_oms", "root", "root", []) D:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connectors \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. Illuminate\Database\QueryException : 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:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connection. 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:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connection .php:458 2 PDOStatement::execute() D:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connection .php:458 Please use the argument -v to see more details.数据库编码改为utf8mb4
报错三
$ php artisan migrate Migration table created successfully. Illuminate\Database\QueryException : 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:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connection. 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:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connection .php:458 2 PDOStatement::execute() D:\WWW\dev_oms\vendor\laravel\framework\src\Illuminate\Database\Connection .php:458 Please use the argument -v to see more details.加上两行代码即可
以上这篇laravel执行php artisan migrate报错的解决方法就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持免费资源网。
原文链接:https://blog.csdn.net/Code_Pupil/article/details/80371145
您可能感兴趣
热门推荐
- 购买了阿里云服务器之后怎么使用(阿里云服务器怎么买?阿里云服务器购买流程)
- mysql5.7.19下载及安装教程(Apache2.2.16+PHP5.3.3+MySQL5.1.49的配置方法)
- centos安装mysql8.0教程(Centos7 安装 Mysql8教程)
- 微信小程序引用模板的函数(微信小程序页面与组件之间信息传递与函数调用)
- python人脸识别库(python3人脸识别的两种方法)
- centos系统mysql安装及连接教程(CentOS8安装SQLServer2019的过程)
- mysql集群是用什么搭建的(MySQL5.7 集群配置的步骤)
- docker容器是怎么进行通信的(Docker容器间通信与外网通信的操作)
- Flash遮盖其它层,z-index无效
- redis的scan命令的使用(scrapy-redis源码分析之发送POST请求详解)