Hi All,

I am having problems installing newly added modules.
I can install them, but they do not show up in the system. It looks as if the are installed, however when I want to configure the module I cannot find the newly installed module..

Also I get the error bellow....could there be a relation between the error and the above describe issue?

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'A1018437_nidg1.pr.misc' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: SELECT pr.path AS path, pr.misc AS misc FROM {profile2_regpath} pr WHERE (pr.status = :db_condition_placeholder_0) GROUP BY path; Array ( [:db_condition_placeholder_0] => 1 ) in profile2_regpath_get_reg_paths() (line 579 of /var/www/clients/client10517/web11641/web/sites/all/modules/profile2_regpath/profile2_regpath.module)

Comments

mmjvb’s picture

You forgot to mention specifics! Which version of Drupal, MySQL and Profile2 Registration Path ?

Did you check the issue queue of Profile2 Registration Path?

Possibly you are using an outdated version of MySQL.
Simple solution could be to add misc to the GROUP BY in profile2_regpath.module.

El Rey Mark’s picture

Thx. It seemed I missed some updates ;-)
The issue is resolved now!

John_B’s picture

First check the issue queue for the problem module: https://www.drupal.org/node/2658142

Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors