Sign Up

Sign In

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Sorry, you do not have a permission to ask a question, You must login to ask question.

Discy Latest Questions

  • 0
  • 0

I want use WhereIn and Groupby in Same Query to fetch Result. I’ve tried this: $loadids=explode("#@*",$reciptdet->loading_id); $loadingdatas=DB::table('loading')->groupBy('vehicle_no')->whereIn('id',$loadids)->get(); But I got this error message: SQLSTATE[42000]: Syntax error or access violation: 1055 ‘sbrtpt.loading.id’ isn’t in GROUP BY (SQL: select * from loading where id in (14, 15, ...

  • 0
  • 0

Migration error on Laravel 5.4 with php artisan make:auth [IlluminateDatabaseQueryException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter tabl e users add unique users_email_unique(email)) [PDOException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key ...

  • 0
  • 0

I want use WhereIn and Groupby in Same Query to fetch Result. I’ve tried this: $loadids=explode("#@*",$reciptdet->loading_id); $loadingdatas=DB::table('loading')->groupBy('vehicle_no')->whereIn('id',$loadids)->get(); But I got this error message: SQLSTATE[42000]: Syntax error or access violation: 1055 ‘sbrtpt.loading.id’ isn’t in GROUP BY (SQL: select * from loading where id in (14, 15, ...

close