laravel的后台模板

最新推荐文章于 2024-09-04 10:55:22 发布

精哥哥yxkj5558

最新推荐文章于 2024-09-04 10:55:22 发布

阅读量380

点赞数

文章标签： Dcat Admin SQLSTATE错误 MySQL配置字符串长度 Apache伪静态

本文链接：https://blog.csdn.net/qq_36602939/article/details/123059645

版权

文档地址：

https://learnku.com/docs/dcat-admin/2.x

安装是出现：

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

解决方法：

通过修改MySQL的配置文件，在配置文件中查找sql-mode，将此行修改成为：

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

还有

app\Providers\AppServiceProvider.php 下
修改boot()方法添加如下代码

<?php

namespace App\Providers;

use Illuminate\Support\ServiceProvider;
use Illuminate\Support\Facades\Schema;
class AppServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot()
    {
        Schema::defaultStringLength(191);
    }

    /**
     * Register any application services.
     *
     * @return void
     */
    public function register()
    {
       
    }
}

apache伪静态：

<IfModule mod_rewrite.c>
    <IfModule mod_negotiation.c>
        Options -MultiViews -Indexes
    </IfModule>

    RewriteEngine On

    # Handle Authorization Header
    RewriteCond %{HTTP:Authorization} .
    RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]

    # Redirect Trailing Slashes If Not A Folder...
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteCond %{REQUEST_URI} (.+)/$
    RewriteRule ^ %1 [L,R=301]

    # Send Requests To Front Controller...
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteRule ^ index.php [L]
</IfModule>