groupsview fails to load when there are no groups

[DiogoFilhoDeMorais]

When I go to Group List an error appears.

" Localhost say:
DataTables warning: table id=groupsTable - Ajax error. For more information about this error, please see http://datatables.bet/tn/7 "

[crossan007]

Do you have any existing groups? I think there is an open issue for this page being grumpy in a system with no groups.

[DiogoFilhoDeMorais]

When I click the page the error appears and the button to add new group stops working

[crossan007]

This might be #1547 or #1542

[DiogoFilhoDeMorais]

Using developer tool on Chrome, this show a message when I click on GroupList:

[DiogoFilhoDeMorais]

On the Families View, this error not exists. The page open normally and show families. It may be that the Json structure used to list the groups is causing this disorder.

[crossan007]

Is this still an issue?

I can't find any PR indicating it was fixed.
I also can't replicate it on the demo site... http://demo.churchcrm.io/master/

[DiogoFilhoDeMorais]

This problem was occurring on my personal machine. With that, I thought it was a general bug.
It has already been resolved in an online host.

You can close the issue.

Thank you.

[crossan007]

@braxmann Can you check what version of SQL was running?

[DiogoFilhoDeMorais]

@crossan007 ,
Server version: 5.7.17-0ubuntu0.16.04.1 (Ubuntu)

[crossan007]

SQL version?

[DawoudIO]

@braxmann are you fixing this?

[DiogoFilhoDeMorais]

@crossan007 That is the version of Mysql.
@DawoudIO This problem is not occurring again. This problem occurred on a local machine. When I put it in Vagrant or in a web hosting, this problem does not occur anymore.

The message that Charles had asked a question came now when George asked a question. Charles, sorry for not responding sooner.

[hdisplay]

what is the solution? I even have MySQL 5.7.17 ubuntu 16.04.02

[crossan007]

@hdisplay i edned up needing to change the SQL mode as described in #1547

[apmuthu]

PHP 5.6 gives this error and we cannot add a Group to alleviate this issue. Can anyone post a sample group set of insert sqls?

[ChurchCRMBugReport]

We can do it via the api

On Mon, Apr 24, 2017 at 8:46 AM Ap.Muthu ***@***.***> wrote: PHP 5.6 gives this error and we cannot add a Group to alleviate this issue. Can anyone post a sample group set of insert sqls? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#1963 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ARqbZq7AIWmKyXkaqVkBVZ5x_BiyT7wKks5rzMO4gaJpZM4MHm1K> .

-- Sent from mobile phone Random auto-corrects and typos are my special gift to you

[apmuthu]

Could you please elaborate on the steps needed to use the API on the CLI for adding a group?

[crossan007]

See #2380