SKU Test_simple_product – 2 SQLSTATE: 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
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
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.
Most Users Ever Online: 1012
Currently Browsing this Page:
Jim @ Moogento: 688
Steve Froggatt: 514
Badeth - UE: 513
Paul Cartwright: 414
Administrators: Matthew Ogborne: 4565, Dave Furness: 4606