Strange sql error

That is not an SQL error, it's a Cabon error. My guess is that it tries to treat a null value as a date or some other unexpected value.

Im guessing $dateselect is an instance of carbon

better;

    public static function getstartlistUsers($golfID,$dateselect,$userID)
    {
        return Startlist::where('golfclub_id', $golfID)
        ->select('startlists.*', 'users.name')
        ->where( 'startid', $starttid)
        ->whereDate('created_at', $dateselect)
        ->leftJoin('users', 'users.id', '=', 'startlists.user_id')
        ->get();

    }

but this won't work because you magic $startid from nowhere

show us your Startlist model

gone away?

Hi All!

Tryed everything to fix this issue, but no luck

Have a new colum in database table -> startlists.regdate This colum only have the Date...

Still get the same error as before.

Here is my model:

<?php

namespace App\Models;

use \DateTimeInterface;
use App\Support\HasAdvancedFilter;
use Carbon\Carbon;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use Illuminate\Support\Facades\DB;

class Startlist extends Model
{
    use HasAdvancedFilter;
    use SoftDeletes;
    use HasFactory;

    public $table = 'startlists';

    protected $dates = [
        'startid',
        'created_at',
        'updated_at',
        'deleted_at',
    ];

    protected $orderable = [
        'id',
        'match',
        'starthull',
        'startid',
        'hcp',
        'sh',
        'klasse',
        'status',
        'golfclub.name',
        'user.name',
        'tee.name',
        'typeofstartlist',
        'sloyfe.courcename',
        'nr_of_holes',
        'lasthole',
        'shotgun',
    ];

    protected $filterable = [
        'id',
        'match',
        'starthull',
        'startid',
        'hcp',
        'sh',
        'klasse',
        'status',
        'golfclub.name',
        'user.name',
        'tee.name',
        'typeofstartlist',
        'sloyfe.courcename',
        'nr_of_holes',
        'lasthole',
        'shotgun',
    ];

    protected $fillable = [
        'match',
        'starthull',
        'startid',
        'hcp',
        'sh',
        'klasse',
        'status',
        'golfclub_id',
        'user_id',
        'tee_id',
        'typeofstartlist',
        'sloyfe_id',
        'nr_of_holes',
        'lasthole',
        'shotgun',
        'created_at',
        'updated_at',
        'deleted_at',
    ];

    public function getStartidAttribute($value)
    {
        return $value ? Carbon::createFromFormat('Y-m-d H:i:s', $value)->format(config('project.time_format')) : null;
    }

    public function setStartidAttribute($value)
    {
        $this->attributes['startid'] = $value ? Carbon::createFromFormat(config('project.time_format'), $value)->format('H:i:s') : null;
    }

    public function golfclub()
    {
        return $this->belongsTo(Golfclub::class);
    }

    public function user()
    {
        return $this->belongsTo(User::class);
    }

    public function tee()
    {
        return $this->belongsTo(Tee::class);
    }

    public function sloyfe()
    {
        return $this->belongsTo(Courcegolfclub::class);
    }

    protected function serializeDate(DateTimeInterface $date)
    {
        return $date->format('Y-m-d H:i:s');
    }

    public static function getturneringsnavn()
    {
        return "TEST TURNERING";
    }


    public static function storestatustostartlist($status,$userID,$golfID,$datoen)
    {

        $datoen = date("Y-m-d");

        $query = Startlist::where('golfclub_id', $golfID)
            ->where('user_id', $userID)
            ->whereBetween('created_at',[$datoen,$datoen])
            ->update(['status' => $status]);
    
        return $query;
    
    }

    public static function getstartlists($userID,$golfID,$datoen)
    {
           
          $datoenfra = $datoen.' 00:00:00';
          $datoentil = $datoen.' 23:59:59';
          
          $query = Startlist::where('golfclub_id', $golfID)
          ->where('user_id', $userID)
          ->whereBetween('created_at',[$datoenfra,$datoentil])
          ->first();
          

          return  $query;

    }
    public static function getstartlistUsers($golfID,$dateselect,$userID)
    {
        // Finn start time user
        $startlist = Startlist::getstartlistForUser($golfID,$userID);

        if($startlist){
            $starttid = $startlist->startid;
        } else {
            $starttid = -1;
        }

        $dagensdato = date("Y-m-d");
        return Startlist::where('golfclub_id', $golfID)
        ->select('startlists.*')
        ->where( 'startid', $starttid)
        ->whereDate('regdate', '=', date('Y-m-d'))
        ->get();

        return $query;

    }
    
    public static function getstartlistForUser($golfID,$userID)
    {

        $datoen = date("Y-m-d");
        $startlist = Startlist::where('golfclub_id', $golfID)
        ->where('user_id', $userID)
        ->whereDate('regdate', '=',$datoen)
        ->first();

        return $startlist; 

    } 
    public static function getmatchnumber($golfclub_ID,$created_at,$startid)
    {

          // Check where player are
          $startlist = Startlist::where('golfclub_id', $golfclub_ID)
          ->where('startid', $startid)
          ->whereBetween('created_at',[$created_at,$created_at])
          ->first();
         

          if($startlist){
              $flightnumb =  $startlist->match;
          } else {
           

            $flightnumb2 = 0;

            $startlist = Startlist::where('golfclub_id', $golfclub_ID)
            ->whereBetween('created_at',[$created_at,$created_at])
            ->get();


            $flightnumb2 = $startlist->max('match');


            if($flightnumb2>0) {
                $flightnumb =  $flightnumb2+1;
            } else {
                $flightnumb = 1; 
            }

          }
          return  $flightnumb;

    }


    public static function storeStartlist($request,$userID)
    {
        
        $starthull = $request->startHole;
        $startid = $request->startTime;
        $startid = $startid.':00'; 
        $sloyfe_id =  $request->defcource;
        $utslagsted_id = $request->deftee;
        $shotgun = $request->shotgun;
        $nrOfHoles = $request->nrOfHoles;
        $golfID = $request->valggolfklubb;

        $timezone  = 2; //(GMT -5:00) EST (U.S. & Canada)
        $created_at = gmdate("Y-m-d", time() + 3600*($timezone+date("I")));
        
        $shotgunnr = 0;
        if($shotgun==="true"){
            $shotgunnr = 1;
        } 

        $nrOfHolesnr = 0;
        if($nrOfHoles==="true"){
            $nrOfHolesnr = 1;
        } 

        
        // Check if user exist
        //$statusPlayer =  Startlist::checkstatusstartlist($golfID,$userID,$created_at);

        $hcp = 0;
        $sh = 0;
        $klasse = "inegn";
        $firmanavn = "";


        $match = Startlist::getmatchnumber($golfID,$created_at,$startid);
        $starthull=$starthull;

        $startliste = new Startlist();
        $startliste->startid = $startid;
        $startliste->sloyfe_id = $sloyfe_id;
        $startliste->tee_id = $utslagsted_id;
        $startliste->match = $match;
        $startliste->user_id = $userID;
        $startliste->hcp = $hcp;
        $startliste->starthull = $starthull;
        $startliste->sh = $sh;
        $startliste->klasse = $klasse;
       // $startliste->created_at = $created_at;
        $startliste->status = 2;
        $startliste->nrOfHoles = $nrOfHolesnr; 
        $startliste->typeofstartlist = 1;
        $startliste->golfclub_id = $golfID;
        $startliste->lasthole = Startlist::getLastHole((int)$starthull,$shotgunnr,$nrOfHolesnr);  // MÅ Beregnes
        $startliste->shotgun = $shotgunnr;  // MÅ Beregnes
        $startliste->regdate = date("Y-m-d");
        $startliste->save();


        // $lagrerunde = Startlist::storeRoundUser();

        return  $startliste;


    }

    public static function checkstatusstartlist($userID,$golfID,$datoen)
    {

          /* 
          // Check where player are
          $startlist = DB::table('startlistes')
          ->select('startlistes.*')
          ->where('startlistes.golfclub_id', $golfID)
          ->where('startlistes.user_id', $userID)
          ->first();

          */

          $datofra = $datoen.' 00:00:00';
          $datotil = $datoen.' 23:59:59';

          $startlist = Startlist::where('golfclub_id', $golfID)
          ->where('user_id', $userID)
          ->whereBetween('created_at',[$datofra,$datotil])
          ->first();
          


        

          return  $startlist;

    }

   
    
    public static function getLastHole($starthull,$shotgun,$nrOfHolesnr)
    {
 
        $lasthole = 0;

        if(($starthull===1) and ($nrOfHolesnr===0)) {$lasthole=9;}
        if(($starthull===1) and ($nrOfHolesnr===1)) {$lasthole=18;}

        if(($starthull===10) and ($nrOfHolesnr===0)) {$lasthole=18;}
        if(($starthull===10) and ($nrOfHolesnr===1)) {$lasthole=9;}
      

        if($lasthole===0){
            if($shotgun===0)
            {
                if(($starthull===1) and ($nrOfHolesnr===0)) {$lasthole=9;}
                if(($starthull===1) and ($nrOfHolesnr===1)) {$lasthole=18;}
            } else {
                $lasthole = $starthull -1;
            }
             
        }

        return $lasthole;

    }

}