Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

Magmi Error: SQLSTATE[42000] 1055: Expression #2 of SELECT...

March 16, 2017 - 1:27 pm
Member Since: July 17, 2015
Forum Posts: 3
sp_UserOfflineSmall Offline

While importing products via Magmi, I am getting the following error message:

error 1:SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘db_name.cplai.value_id’ which is not functionality dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by –

Perhaps it’s a difference in PHP versions?!?! Any help on how to fix this would be greatly appreciated.

Thank you in advance.

Rodney - UE
March 20, 2017 - 5:03 am

Hello there. I hope that this would be able to help you out: http://craftcms.stackexchange……l-group-by



Why Should You Join UnderstandingE?

  • Access to over 500 step-by-step video tutorials
  • +20 video courses available
  • Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
  • Everything is in 100% Plain English
  • Learn how to build your own multi-channel software for eBay & Amazon
  • Access to the community forums, meet fellow business owners like yourself

Join Now with 2 Clicks


Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.


Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
12 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5223

Posts: 27502

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606