Jump to content
Sign in to follow this  
someone

Database error 1055

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

Share this post


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

Share this post


Link to post
Share on other sites

if you disable strict mode, it won't mess anything else up, as it just removes those rules that cause those errors.  it won't add any new errors.

Share this post


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.

Sign in to follow this  

×
×
  • Create New...