problem with database

  • i'm nwely setup bagisto ec laravel shop but when i've navigated to public this showing to me

    Warning: mysqli::close(): Couldn't fetch mysqli in C:\xamp\htdocs\bagisto\public\installer\index.php on line 100

    this my env file database options![alt text](image url)


    and this my config/database.php options

    'mysql' => [
    'driver' => 'mysql',
    'host' => env('DB_HOST', ''),
    'port' => env('DB_PORT', '3306'),
    'database' => env('DB_DATABASE', 'bagisto'),
    'username' => env('DB_USERNAME', 'admin'),
    'password' => env('DB_PASSWORD', 'admin'),
    'unix_socket' => env('DB_SOCKET', ''),
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
    'prefix' => '',
    'strict' => false,
    'engine' => 'InnoDB ROW_FORMAT=DYNAMIC',

    and something else when i'm trying to use sqlite database it's showing error for me as i remember that sqlite does't accept that 2 things in one file
    [email protected] MINGW64 /c/xamp/htdocs/bagisto (master)
    $ touch database/database.sqlite

    [email protected] MINGW64 /c/xamp/htdocs/bagisto (master)
    $ pa migrate
    Migration table created successfully.

    BadMethodCallException : SQLite doesn't support multiple calls to dropColumn / renameColumn in a single modification.

    at C:\xamp\htdocs\bagisto\vendor\laravel\framework\src\Illuminate\Database\Schema\Blueprint.php:133
    129| protected function ensureCommandsAreValid(Connection $connection)
    130| {
    131| if ($connection instanceof SQLiteConnection &&
    132| $this->commandsNamed(['dropColumn', 'renameColumn'])->count() > 1) {

    133| throw new BadMethodCallException(
    134| "SQLite doesn't support multiple calls to dropColumn / renameColumn in a single modification."
    135| );
    136| }
    137| }

    Exception trace:

    1 Illuminate\Database\Schema\Blueprint::ensureCommandsAreValid(Object(Illuminate\Database\SQLiteConnection))

    2 Illuminate\Database\Schema\Blueprint::toSql(Object(Illuminate\Database\SQLiteConnection), Object(Illuminate\Database\Schema\Grammars\SQLiteGrammar))

    Please use the argument -v to see more details.

    alt text

  • Hi @adamkaram

    Can you tell us your mysql version.


  • hello brother i have this issue too with to way install bagisto with composer or GUI but for both ways when i type username and password these warnings report goes on
    #first in the admin login steps i have this report( #1045 - Access denied for user 'root'@'localhost' (using password: YES)
    #second in Environment Configuration step when type user and password as user 'root' and password 'admin123' but unfortunately same error showed
    #third: problem is for admin details also type user password with this issue(Warning: mysqli::close(): Couldn't fetch mysqli in C:\xampp\htdocs\bagisto\public\installer\index.php on line 100 ) and this error showed in next page load

Log in to reply