Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

mail_open
not importing products using magmi
gopalvenu033

New
April 12, 2016 - 5:13 am
Member Since: April 7, 2016
Forum Posts: 1
sp_UserOfflineSmall Offline

I am using magento 1.8.1.0 and magmi 0.7.21 , when importing products it shows error

SKU Test_simple_product – 1 SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘magmi.ccev.value’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by –
SKU Test_simple_product – 2 SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘magmi.ccev.value’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by – ERROR ON RECORD #1

not importing the products.after that i changed some part of this file /plugins/extra/itemprocessors/itemindexer/otfindexer.php , with version 0.7.20 then the error still showing but only one row of product is importing

Avatar
Dave Furness

Founder
June 6, 2016 - 2:37 pm
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

Hey @Paul Cartwright any ideas on this one?

Dave

Every expert was once a beginner

Paul Cartwright
West Midlands, UK

Partner
June 6, 2016 - 4:27 pm
Member Since: January 7, 2015
Forum Posts: 414
sp_UserOfflineSmall Offline

Hi,

Are you using the understandinge version of magmi? As i see from your message that you changed back to 0.7.20.

I would re install magmi incase a file didn’t correctly upload then most issues are file/attribute heading related rather than anything more serious. Then put up a copy of your csv file and I will look at that first.

Hope this helps

Paul

Everyday is an opportunity to learn something new

 

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:
23 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