Jump to content

Recommended Posts

Trying to test this software. Added a tex link for one user. Clicking on that link shoes error. What would this error mean?

Error Number: 1055

Expression #79 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'something_affiliate.jam_members_photos.photo_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT `jam_members`.*, `jam_members`.`member_id` as `mid`, `jam_members_photos`.*, `jam_members_groups`.`group_id` FROM `jam_members` LEFT JOIN `jam_members_photos` ON `jam_members`.`member_id` = `jam_members_photos`.`member_id` LEFT JOIN `jam_members_groups` ON `jam_members`.`member_id` = `jam_members_groups`.`member_id` WHERE `jam_members`.`username` = 'someusername' AND `status` = '1' GROUP BY `jam_members`.`member_id`

Filename: models/Affiliate_marketing_model.php

Line Number: 373

Link to post
Share on other sites

thank you for your reply. I looked at that article and looked in my db .

If i will change this, will this throw anything off in my other working database there, such online store database? 

this is what i have there:

STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...