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

Thank you for helping to resolve that issue. It got me further. Now i am testing the integration. As customer i click on the link and made a purchase. checkout/success page showed error on top of the page:

Warning: file_get_contents (https://website.com/affiliates/sale/amount/56.8177/trans_id/19775/tracking_code/1-1-someone-KJA9FRZRB7S3IPL): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home/someplace/public_html/store/system/storage/modification/catalog/controller/checkout/success.php on line 178

And this is what i have on line 178 there:     

$aff_integrate = file_get_contents('https://website.com/affiliates/sale/amount/' . $aff_data['total'] . '/trans_id/' . $this->session->data['order_id'] . '/tracking_code/' . $_COOKIE['jamcom']);

(website.com is edited of course)

 

Share this post


Link to post
Share on other sites

first, try running the URL in your browser directly to make sure it works:

https://website.com/affiliates/sale/amount/56.8177/trans_id/19775/tracking_code/1-1-someone-KJA9FRZRB7S3IPL

 

Share this post


Link to post
Share on other sites

try https://website.com/affiliates/index.php/sale/amount/56.8177/trans_id/19775/tracking_code/1-1-someone-KJA9FRZRB7S3IPL

Share this post


Link to post
Share on other sites

Ithis way it does show the main page.

I have changed the url in the integration code to include index.php , but i am getting the same error on purchase. 

Share this post


Link to post
Share on other sites

looks like there is an issue with the .htaccess rewrite rules, did you have the .htaccess file in your /affiliates folder?

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...