Support

    You are here:  
  1. Home
  2. Support
Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Online
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.

Request Support

Support is currently Online
Ask a Question
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.

We use a few cookies

Our site uses non fat, delicious cookies which help us improve your user experience. You can read more about it in our Legal page.