CODEWITHSUNDEEP
phpmysqllaravelgroup-concat
abu abu
abu abu

Reputation: 7052

Issue with group_concat() in Laravel 5

I am using group_concat() in my Laravel 5 model's Query. In this regard I use this statement. 

DB::statement('SET GLOBAL group_concat_max_len = 1000000');

It is working fine in Locally but it not working in Live online server.

Could anyone say where is the problem ??

Upvotes: 3

Views: 4413

Answers (1)

Dan Belden
Dan Belden

Reputation: 1217

A few further questions/answers may help us help you:

  • Does your hosting provider enable modification of global variables?
  • Does your user permissions have the "SET" privilege?
  • Is the query throwing an error of any kind in your non-local environment?

A better check would be to see if the transaction has processed successfully using a sub-sequent check request on the database, because if you have set it globally it should work for all sessions, even ones not executed by your code.

SHOW VARIABLES LIKE 'group%';

Should indicate the current group concat max length configured.

Goodluck.

Upvotes: 4

Related Questions