Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Friday 4:26 am
Add a reply View Replies (6)

Resolved after upgrade to 1.1.7 SQL exception

  1. etsmedia
    etsmedia
  2. Bug Report
  3. Saturday, July 14 2018, 07:09 PM
Hi,
after upgrading the plugin to SocialNetworkPlugin_117 I can not login via Social Login Button (via Facebook) I get for every user an SQL exception:

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #24 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db-kms.Profile.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

please help !!
Responses (6)
etsmedia
etsmedia Accepted Answer
the problem for sure is related to versino 1.1.7 (I have checkec downgrading to 1.1.5 and the problem does not appear in the previous version)
  1. more than a month ago
  2. Bug Report
  3. # 1
admin
admin Accepted Answer
Admin
Hi,
sorry for late reply, it's a weekend.

I'm glad you solved it temporarily. Downgrade is also my suggestion for now.

The problem seems probably to your specific mysql configuration as I see from your error message "this is incompatible with sql_mode=only_full_group_by"

On Monday we will do some investigation about this error and come back with a solution.
  1. more than a month ago
  2. Bug Report
  3. # 2
admin
admin Accepted Answer
Admin
Hi,
please try this solution:
- Install version 1.1.7
- replace file at /plugins/jsn/socialnetwork/lib/Cake/Model/Model.php with attached file (unzip first)

If this fix will works for you then we will implement it in the next release.
Attachments (1)
Model.zip
  1. more than a month ago
  2. Bug Report
  3. # 3
etsmedia
etsmedia Accepted Answer
hi,
sorry I totally forgot to answer you. Yes this solves the problem.
thanks and waiting for new release
best regards
Marcin
  1. more than a month ago
  2. Bug Report
  3. # 4
admin
admin Accepted Answer
Admin
Thanks for your feedback
  1. more than a month ago
  2. Bug Report
  3. # 5
etsmedia
etsmedia Accepted Answer
could you please release this fix as well? thanks !
  1. more than a month ago
  2. Bug Report
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.