Sign Up

Sign In

Forget Password

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

You must login to ask question.

Discy Latest Questions

  • 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

In my routes.php file I have : Route::get('/', function () {return view('login'); });Route::get('/index', function(){ return view('index'); });Route::get('/register', function(){ return view('register'); }); Route::post('/register',function(){$user = new AppUser; $user->username = input::get('username'); ...

  • 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

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