SQLSTATE[HY000]: General error: 1 no such column:

Plural form of Aircraft is still aircraft, so when your table is aircrafts you have to defined in the model.

Because Laravel excepted plural name of the class as table name, but in this case it is aircraft.

Docs: https://laravel.com/docs/7.x/eloquent#eloquent-model-conventions (looking for Table Names)

Thank you for the response.

I partially understand the problem (10%), but what I don't understand is why this problem appears now. It has worked all the time. (I literally didn't change anything to the code, except for the update)

I read the docs you send of Laravel but I can figure out how to use it in practice.

Below is how my model looks like from Aircraft.php. The error also called that he requests a user_id, but the model aircraft has no relation with Aircraft.

namespace App;

use Illuminate\Database\Eloquent\Model;

class Aircraft extends Model

{
	public $table = "aircraft";

	public function operator()
	{
		// Makes relation with a operator that's the aircraft from.
		return $this->belongsTo(Operator::class);
	}

	public function manufacturer()
	{
		// Relation with the builder of the aircraft, Boeing or Airbus...
		return $this->belongsTo(Manufacturer::class);
	}

	public function postAircraft()
	{
		// Relation with uploaded pictures regarding the aircraft.
		return $this->hasMany(PostAircraft::class);
	}
}

I also tried to declare in the User model aircrafts, the error disappeared but the result was that I cant create users. What I believe makes sense because It goes to the aircrafts table, instead of users.

Hopefully, you can help me and if you need some more examples let me know.

If your aircrafts table doesn't have user_id column then, somewhere in your code you try to filter it by user_id

Which is this select

select * from "aircrafts" where "aircrafts"."user_id" = 1 and "aircrafts"."user_id" is not null limit 1

So just find it and fix it.

Haha, call me crazy or what so ever. But I didn't find this line of code. I looked at different ways how I could have written it, but with no result. So I don't have a clue where this is error is coming from, which all started after a composer update