laravel-7 - 不支持的驱动程序 []
问题描述
我有多个数据库项目的 Laravel 项目在本地服务上运行良好,但是当我将项目上传到服务器时,它显示不支持的驱动程序 []错误 Laravel 版本7.0 php 版本7.4
登录后,我试图从索引页面上的第三个数据库获取数据,但显示错误
public function index()
{
$srno = 1;
$report = DB::connection('seocrm')->table('notifications')
->join('reports', 'reports.id', '=', 'notifications.report_id')
->orderBy('reporting_date','ASC')
->get();
return view('index',compact('srno','report'));
}
这是我的 database.php 文件
'mysql' => [
'driver' => 'mysql',
'url' => env('DATABASE_URL'),
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '3306'),
'database' => env('DB_DATABASE', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'unix_socket' => env('DB_SOCKET', ''),
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'prefix_indexes' => true,
'strict' => true,
'engine' => null,
'options' => extension_loaded('pdo_mysql') ? array_filter([
PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
]) : [],
],
'salescrm' => [
'driver' => env('DB_CONNECTION_SECOND'),
'host' => env('DB_HOST_SECOND', '127.0.0.1'),
'port' => env('DB_PORT_SECOND', '3306'),
'database' => env('DB_DATABASE_SECOND', 'forge'),
'username' => env('DB_USERNAME_SECOND', 'forge'),
'password' => env('DB_PASSWORD_SECOND', ''),
'unix_socket' => '',
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'prefix_indexes' => true,
'strict' => true,
'engine' => null,
],
'seocrm' => [
'driver' => env('DB_CONNECTION_THIRD'),
'host' => env('DB_HOST_THIRD', '127.0.0.1'),
'port' => env('DB_PORT_THIRD', '3306'),
'database' => env('DB_DATABASE_THIRD', 'forge'),
'username' => env('DB_USERNAME_THIRD', 'forge'),
'password' => env('DB_PASSWORD_THIRD', ''),
'unix_socket' => '',
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'prefix indexes' => true,
'strict' => true,
'engine' => null,
],
.env 文件
# for the first database
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=hrm
DB_USERNAME=root
DB_PASSWORD=somepassword
# for the second database
DB_CONNECTION_SECOND=mysql
DB_HOST_SECOND=127.0.0.1
DB_PORT_SECOND=3306
DB_DATABASE_SECOND=salescrmdb
DB_USERNAME_SECOND=root
DB_PASSWORD_SECOND=somepassword
# for the third database
DB_CONNECTION_third=mysql
DB_HOST_third=127.0.0.1
DB_PORT_third=3306
DB_DATABASE_third=seocrmdb
DB_USERNAME_third=root
DB_PASSWORD_third=somepassword
请帮助解决此错误。提前致谢
解决方案
推荐阅读
- python - google-cloud-profiler 元数据服务器警告
- r - 如何根据另一列的条件输出创建两个累积列?
- powershell - 如何使用 powershell 创建服务名
- android - 三星牛轧糖 SemClipboardManager
- javascript - 当覆盖设置为隐藏时,JavaScript 更新消失
- amazon-web-services - 如何在 buildspec 文件中使用 Git 命令?
- python - 两个小部件的相同颜色看起来不同
- bash - 用户创建和保存“别名”命令的最佳方法是什么?
- xml - Perl 调整 xsltMaxDepth (--maxdepth) 错误
- spring - AntMatcher 似乎与请求的路径不匹配(Spring Security)