Cannot update (from git / master): Syntax error or access violation: 1072 Key column 'subsection' doesn't exist in table

[count00zero]

Hi, help is appreciated, thanks in advance!!!

024_10_28_092803_drop_columns_from_settings_table ................................................................................... 3.48ms FAIL

   Illuminate\Database\QueryException 

  SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'subsection' doesn't exist in table (Connection: mariadb, SQL: alter table `settings` drop `section`, drop `subsection`, drop `hint`, drop `setting`)

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:825
    821\u2595                     $this->getName(), $query, $this->prepareBindings($bindings), $e
    822\u2595                 );
    823\u2595             }
    824\u2595 
  \u279c 825\u2595             throw new QueryException(
    826\u2595                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    827\u2595             );
    828\u2595         }
    829\u2595     }

      +9 vendor frames 

  10  database/migrations/2024_10_28_092803_drop_columns_from_settings_table.php:14
      Illuminate\Support\Facades\Facade::__callStatic()
      +23 vendor frames 

  34  app/Console/Commands/UpdateNNTmuxDB.php:36
      Illuminate\Console\Command::call()

[nakedgoat]

I was getting those and I had to checkout 3.0.1

[count00zero]

Thank you @nakedgoat, I will try that!

[DariusIII]

This issue should have been fixed couple of days ago, as i pushed couple of changes related to this migration.

[count00zero]

I checked out master again (no luck):
Updating database

   INFO  Running migrations.  

  2024_10_28_092803_drop_columns_from_settings_table ................................................................................... 4.04ms FAIL

   Illuminate\Database\QueryException 

  SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'subsection' doesn't exist in table (Connection: mariadb, SQL: alter table `settings` drop `section`, drop `subsection`, drop `hint`, drop `setting`)

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:825
    821\u2595                     $this->getName(), $query, $this->prepareBindings($bindings), $e
    822\u2595                 );
    823\u2595             }
    824\u2595 
  \u279c 825\u2595             throw new QueryException(
    826\u2595                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    827\u2595             );
    828\u2595         }
    829\u2595     }

      +9 vendor frames 

  10  database/migrations/2024_10_28_092803_drop_columns_from_settings_table.php:14
      Illuminate\Support\Facades\Facade::__callStatic()
      +23 vendor frames 

  34  app/Console/Commands/UpdateNNTmuxDB.php:36
      Illuminate\Console\Command::call()

[DariusIII]

Check if your settings table has these columns at all.

[count00zero]

yes it has, that's why I don't understand the error :-)

[DariusIII]

Drop them manually and then add the name of the migration into migration table so it is not run anymore. I cannot find why is the database doing this.

[DariusIII]

Check indexes in settings table, do you have a primary that has section, subsection in them?

[count00zero]

yeah those are here as well:

[DariusIII]

Drop them both and then try the migration.

[DariusIII]

I have pushed an update for that migration. Maybe try it before deleting the indexes by hand.

[count00zero]

Thank you very much, that did "the trick"

[DariusIII]

Which one? Deleting the indexes by hand or new migration change?