New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Error when using the On The Fly Category Creator #158

Closed

AdamHughes opened this issue Dec 7, 2014 · 3 comments

AdamHughes commented Dec 7, 2014

The error I get:
" SQLSTATE[42000]: Syntax error or access violation: 1055 'hoge_thehog_magento.cce.entity_type_id' isn't in GROUP BY - "

When I click the SKU it says there is no trace.

The CSV im using is here:
sku,attribute_set,categories,type
AAA-BBB,Catalogue Stock,"Harley-Davidson/FLST;;Harley-Davidson/FLT",simple

Owner

dweeves commented Dec 11, 2014

hard to debug without a trace. have you a trace.txt file in magmi/state directory ?

Author

AdamHughes commented Mar 19, 2015

Just got this error again. I wasnt able to figure out what it was last time. Here is a snippet of the CSV File I am using:

sku,categories,category_reset,store
HOG-HIL-310754,Sale Items,0,admin
HOG-HIL-310754,Default Category/Sale Items,0,admin
HOG-HIL-310765,Default Category/Sale Items,0,admin
HOG-HIL-310765,Default Category/Sale Items,0,admin
HOG-HIL-310765,Default Category/Sale Items,0,admin
HOG-HIL-310765,Default Category/Sale Items,0,admin
HOG-HIL-310767,Default Category/Sale Items,0,admin
HOG-HIL-310767,Default Category/Sale Items,0,admin
HOG-HIL-310767,Default Category/Sale Items,0,admin

Here is the trace. I have cut off the repeating messages at the end:

---- TRACE : 1 -----
---- DATE : 2015-03-19 10:10:05 ------

************************************
SQLSTATE[42000]: Syntax error or access violation: 1055 'magento.cce.entity_type_id' isn't in GROUP BY
*************************************
/inc/dbhelper.class.php:239 - PDOStatement->execute
----------------------------------------
Array
(
    [0] => Array
        (
            [0] => 2
        )

)

/inc/dbhelper.class.php:324 - DBHelper->exec_stmt
----------------------------------------
Array
(
    [0] => SELECT cce.entity_type_id,cce.attribute_set_id,cce.level+1 as level,COALESCE(MAX(eac.position),0)+1 as position
        FROM catalog_category_entity as cce
        LEFT JOIN  catalog_category_entity as eac ON eac.parent_id=cce.entity_id
        WHERE cce.entity_id=?
        GROUP BY eac.parent_id
    [1] => Array
        (
            [0] => 2
        )

    [2] => 
)

/inc/dbhelper.class.php:366 - DBHelper->select
----------------------------------------
Array
(
    [0] => SELECT cce.entity_type_id,cce.attribute_set_id,cce.level+1 as level,COALESCE(MAX(eac.position),0)+1 as position
        FROM catalog_category_entity as cce
        LEFT JOIN  catalog_category_entity as eac ON eac.parent_id=cce.entity_id
        WHERE cce.entity_id=?
        GROUP BY eac.parent_id
    [1] => Array
        (
            [0] => 2
        )

)

/inc/magmi_mixin.php:36 - /plugins/extra/itemprocessors/categories/categoryimport.php:124 - Magmi_Mixin->__call
----------------------------------------
Array
(
    [0] => selectAll
    [1] => Array
        (
            [0] => SELECT cce.entity_type_id,cce.attribute_set_id,cce.level+1 as level,COALESCE(MAX(eac.position),0)+1 as position
        FROM catalog_category_entity as cce
        LEFT JOIN  catalog_category_entity as eac ON eac.parent_id=cce.entity_id
        WHERE cce.entity_id=?
        GROUP BY eac.parent_id
            [1] => Array
                (
                    [0] => 2
                )

        )

)

/plugins/extra/itemprocessors/categories/categoryimport.php:124 - CategoryImporter->selectAll
----------------------------------------
Array
(
    [0] => SELECT cce.entity_type_id,cce.attribute_set_id,cce.level+1 as level,COALESCE(MAX(eac.position),0)+1 as position
        FROM catalog_category_entity as cce
        LEFT JOIN  catalog_category_entity as eac ON eac.parent_id=cce.entity_id
        WHERE cce.entity_id=?
        GROUP BY eac.parent_id
    [1] => Array
        (
            [0] => 2
        )

)

/plugins/extra/itemprocessors/categories/categoryimport.php:282 - CategoryImporter->getCategoryId
----------------------------------------
Array
(
    [0] => Array
        (
            [0] => 1
            [1] => 2
        )

    [1] => Array
        (
            [name] => Default Category
            [is_active] => 1
            [is_anchor] => 1
            [include_in_menu] => 1
            [url_key] => default-category
            [url_path] => default-category.html
        )

)

/plugins/extra/itemprocessors/categories/categoryimport.php:420 - CategoryImporter->getCategoryIdsFromDef
----------------------------------------
Array
(
    [0] => Default Category/Sale Items
    [1] => Array
        (
            [%RP:base%] => Array
                (
                    [path] => 1/2
                    [rootarr] => Array
                        (
                            [0] => 1
                            [1] => 2
                        )

                )

        )

)

/inc/magmi_engine.php:324 - CategoryImporter->processItemAfterId
----------------------------------------
Array
(
    [0] => Array
        (
            [sku] => HOG-HIL-310754
            [categories] => Default Category/Sale Items
            [category_reset] => 0
            [store] => admin
        )

    [1] => Array
        (
            [product_id] => 13077
            [new] => 
            [same] => 
            [asid] => 4
            [sku] => HOG-HIL-310754
            [pid] => 13077
            [type] => simple
            [__new] => 
        )

)

/engines/magmi_productimportengine.php:1685 - Magmi_Engine->callPlugins
----------------------------------------
Array
(
    [0] => itemprocessors
    [1] => processItemAfterId
    [2] => Array
        (
            [sku] => HOG-HIL-310754
            [categories] => Default Category/Sale Items
            [category_reset] => 0
            [store] => admin
        )

    [3] => Array
        (
            [product_id] => 13077
            [new] => 
            [same] => 
            [asid] => 4
            [sku] => HOG-HIL-310754
            [pid] => 13077
            [type] => simple
            [__new] => 
        )

)

/engines/magmi_productimportengine.php:1937 - Magmi_ProductImportEngine->importItem
----------------------------------------
Array
(
    [0] => Array
        (
            [sku] => HOG-HIL-310754
            [categories] => Sale Items
            [category_reset] => 0
            [store] => admin
        )

)

/engines/magmi_productimportengine.php:2034 - Magmi_ProductImportEngine->processDataSourceLine
----------------------------------------
Array
(
    [0] => Array
        (
            [sku] => HOG-HIL-310754
            [categories] => Sale Items
            [category_reset] => 0
            [store] => admin
        )

    [1] => 117
    [2] => 1426759805.94
    [3] => 1426759805.94
    [4] => 0
    [5] => 0
)

/inc/magmi_engine.php:483 - Magmi_ProductImportEngine->engineRun
----------------------------------------
Array
(
    [0] => Array
        (
            [profile] => default
            [mode] => update
            [CSV:filename] => magento/www/var/import/categorys2.csv
            [chain] => default:update
        )

)

/cli/magmi.cli.php:139 - Magmi_Engine->run
----------------------------------------
Array
(
    [0] => Array
        (
            [profile] => default
            [mode] => update
            [CSV:filename] => magento/www/var/import/categorys2.csv
            [chain] => default:update
        )

)

+++++++++++++++++++++++++++++
CONTEXT DUMP
+++++++++++++++++++++++++++++
Magmi_ProductImportEngine Object
(
    [attrinfo] => Array
        (
            [category_ids] => Array
                (
                    [attribute_id] => 108
                    [entity_type_id] => 4
                    [attribute_code] => category_ids
                    [attribute_model] => 
                    [backend_model] => 
                    [backend_type] => static
                    [backend_table] => 
                    [frontend_model] => 
                    [frontend_input] => text
                    [frontend_label] => 
                    [frontend_class] => 
                    [source_model] => 
                    [is_required] => 0
                    [is_user_defined] => 0
                    [default_value] => 
                    [is_unique] => 0
                    [note] => 
                    [frontend_input_renderer] => 
                    [is_global] => 1
                    [is_visible] => 0
                    [is_searchable] => 0
                    [is_filterable] => 0
                    [is_comparable] => 0
                    [is_visible_on_front] => 0
                    [is_html_allowed_on_front] => 0
                    [is_used_for_price_rules] => 0
                    [is_filterable_in_search] => 0
                    [used_in_product_listing] => 0
                    [used_for_sort_by] => 0
                    [is_configurable] => 1
                    [apply_to] => 
                    [is_visible_in_advanced_search] => 0
                    [position] => 0
                    [is_wysiwyg_enabled] => 0
                    [is_used_for_promo_rules] => 0
                )

            [sku] => Array
                (
                    [attribute_id] => 74
                    [entity_type_id] => 4
                    [attribute_code] => sku
                    [attribute_model] => 
                    [backend_model] => catalog/product_attribute_backend_sku
                    [backend_type] => static
                    [backend_table] => 
                    [frontend_model] => 
                    [frontend_input] => text
                    [frontend_label] => SKU
                    [frontend_class] => 
                    [source_model] => 
                    [is_required] => 1
                    [is_user_defined] => 0
                    [default_value] => 
                    [is_unique] => 1
                    [note] => 
                    [frontend_input_renderer] => 
                    [is_global] => 1
                    [is_visible] => 1
                    [is_searchable] => 1
                    [is_filterable] => 0
                    [is_comparable] => 1
                    [is_visible_on_front] => 1
                    [is_html_allowed_on_front] => 0
                    [is_used_for_price_rules] => 0
                    [is_filterable_in_search] => 0
                    [used_in_product_listing] => 0
                    [used_for_sort_by] => 0
                    [is_configurable] => 1
                    [apply_to] => 
                    [is_visible_in_advanced_search] => 1
                    [position] => 0
                    [is_wysiwyg_enabled] => 0
                    [is_used_for_promo_rules] => 0
                )

        )

    [attrbytype] => Array
        (
            [static] => Array
                (
                    [data] => Array
                        (
                            [0] => Array
                                (
                                    [attribute_id] => 108
                                    [entity_type_id] => 4
                                    [attribute_code] => category_ids
                                    [attribute_model] => 
                                    [backend_model] => 
                                    [backend_type] => static
                                    [backend_table] => 
                                    [frontend_model] => 
                                    [frontend_input] => text
                                    [frontend_label] => 
                                    [frontend_class] => 
                                    [source_model] => 
                                    [is_required] => 0
                                    [is_user_defined] => 0
                                    [default_value] => 
                                    [is_unique] => 0
                                    [note] => 
                                    [frontend_input_renderer] => 
                                    [is_global] => 1
                                    [is_visible] => 0
                                    [is_searchable] => 0
                                    [is_filterable] => 0
                                    [is_comparable] => 0
                                    [is_visible_on_front] => 0
                                    [is_html_allowed_on_front] => 0
                                    [is_used_for_price_rules] => 0
                                    [is_filterable_in_search] => 0
                                    [used_in_product_listing] => 0
                                    [used_for_sort_by] => 0
                                    [is_configurable] => 1
                                    [apply_to] => 
                                    [is_visible_in_advanced_search] => 0
                                    [position] => 0
                                    [is_wysiwyg_enabled] => 0
                                    [is_used_for_promo_rules] => 0
                                )

                            [1] => Array
                                (
                                    [attribute_id] => 74
                                    [entity_type_id] => 4
                                    [attribute_code] => sku
                                    [attribute_model] => 
                                    [backend_model] => catalog/product_attribute_backend_sku
                                    [backend_type] => static
                                    [backend_table] => 
                                    [frontend_model] => 
                                    [frontend_input] => text
                                    [frontend_label] => SKU
                                    [frontend_class] => 
                                    [source_model] => 
                                    [is_required] => 1
                                    [is_user_defined] => 0
                                    [default_value] => 
                                    [is_unique] => 1
                                    [note] => 
                                    [frontend_input_renderer] => 
                                    [is_global] => 1
                                    [is_visible] => 1
                                    [is_searchable] => 1
                                    [is_filterable] => 0
                                    [is_comparable] => 1
                                    [is_visible_on_front] => 1
                                    [is_html_allowed_on_front] => 0
                                    [is_used_for_price_rules] => 0
                                    [is_filterable_in_search] => 0
                                    [used_in_product_listing] => 0
                                    [used_for_sort_by] => 0
                                    [is_configurable] => 1
                                    [apply_to] => 
                                    [is_visible_in_advanced_search] => 1
                                    [position] => 0
                                    [is_wysiwyg_enabled] => 0
                                    [is_used_for_promo_rules] => 0
                                )

                        )

                    [ids] => 108,74
                )

        )

    [attribute_sets] => Array
        (
            [Default] => 4
        )

    [prod_etype] => 4
    [default_asid] => 4
    [sidcache] => Array
        (
        )

    [mode] => update
    [_notattribs:Magmi_ProductImportEngine:private] => Array
        (
            [1] => categories
            [2] => category_reset
            [3] => store
        )

    [_attributehandlers:Magmi_ProductImportEngine:private] => Array
        (
            [attribute_code:.*] => Magmi_DefaultAttributeItemProcessor Object
                (
                    [_basecols:protected] => Array
                        (
                            [store] => admin
                            [type] => simple
                        )

                    [_baseattrs:protected] => Array
                        (
                            [status] => 1
                            [visibility] => 4
                            [page_layout] => 
                            [tax_class_id] => Taxable Goods
                        )

                    [_forcedefault:protected] => Array
                        (
                            [store] => admin
                        )

                    [_missingcols:protected] => Array
                        (
                            [1] => type
                        )

                    [_missingattrs:protected] => Array
                        (
                            [0] => status
                            [1] => visibility
                            [2] => page_layout
                            [3] => tax_class_id
                        )

                    [_class:protected] => Magmi_DefaultAttributeItemProcessor
                    [_plugintype:protected] => 
                    [_plugindir:protected] => 
                    [_config:protected] => Magmi_PluginConfig Object
                        (
                            [_prefix:protected] => Magmi_DefaultAttributeItemProcessor
                            [_conffile:protected] => 
                            [_profile:protected] => default
                            [_basedir:protected] => /home/magento/public_html/magmi/conf
                            [_confname:protected] => /home/magento/public_html/magmi/conf/Magmi_DefaultAttributeItemProcessor.conf
                            [_props:protected] => 
                            [inifile] => 
                            [_specialchars:protected] => Array
                                (
                                    ["] => :DQUOTE:
                                    ['] => :SQUOTE:
                                    [\t] => TAB
                                )

                        )

                    [_magmiconfig:protected] => Magmi_Config Object
                        (
                            [_defaultconfigname:Magmi_Config:private] => 
                            [_basedir:protected] => /home/magento/public_html/magmi/conf
                            [_confname:protected] => magmi.ini
                            [_props:protected] => Array
                                (
                                    [DATABASE] => Array
                                        (
                                            [connectivity] => net
                                            [host] => localhost
                                            [port] => 3306
                                            [resource] => default_setup
                                            [unix_socket] => /var/lib/mysql/mysql.sock
                                            [dbname] => magento
                                            [user] => magento
                                            [password] => 
                                            [table_prefix] => 
                                        )

                                    [MAGENTO] => Array
                                        (
                                            [version] => 1.9.x
                                            [basedir] => /home/magento/www
                                        )

                                    [GLOBAL] => Array
                                        (
                                            [step] => 0.1
                                            [multiselect_sep] => ,
                                            [dirmask] => 755
                                            [filemask] => 644
                                        )

                                )

                            [inifile] => /home/magento/public_html/magmi/conf/magmi.ini
                            [_specialchars:protected] => Array
                                (
                                    ["] => :DQUOTE:
                                    ['] => :SQUOTE:
                                    [\t] => TAB
                                )

                        )

                    [_pluginmeta:protected] => 
                    [_callers:protected] => Array
                        (
                            [0] => Magmi_ProductImportEngine Object
 *RECURSION*
                        )

                    [_params] => Array
                        (
                            [profile] => default
                            [mode] => update
                            [CSV:filename] => magento/www/var/import/categorys2.csv
                            [chain] => default:update
                        )

                )

        )

    [_current_row:Magmi_ProductImportEngine:private] => 1
    [_optidcache:Magmi_ProductImportEngine:private] => 
    [_curitemids:Magmi_ProductImportEngine:private] => Array
        (
            [sku] => HOG-HIL-310754
            [pid] => 13077
            [asid] => 4
            [type] => simple
            [__new] => 
        )

    [_dstore:Magmi_ProductImportEngine:private] => Array
        (
        )

    [_same:Magmi_ProductImportEngine:private] => 
    [_extra_attrs:Magmi_ProductImportEngine:private] => 
    [_profile:Magmi_ProductImportEngine:private] => default
    [_sid_wsscope:Magmi_ProductImportEngine:private] => Array
        (
            [admin] => Array
                (
                    [0] => 0
                )

        )

    [_sid_sscope:Magmi_ProductImportEngine:private] => Array
        (
        )

    [_prodcols:Magmi_ProductImportEngine:private] => Array
        (
            [0] => entity_id
            [1] => entity_type_id
            [2] => attribute_set_id
            [3] => type_id
            [4] => sku
            [5] => has_options
            [6] => required_options
            [7] => created_at
            [8] => updated_at
        )

    [_stockcols:Magmi_ProductImportEngine:private] => Array
        (
        )

    [_skustats:Magmi_ProductImportEngine:private] => Array
        (
            [nsku] => 0
            [ok] => 0
            [ko] => 0
        )

    [_handlercache:Magmi_ProductImportEngine:private] => Array
        (
        )

    [_conf:protected] => Magmi_Config Object
        (
            [_defaultconfigname:Magmi_Config:private] => 
            [_basedir:protected] => /home/magento/public_html/magmi/conf
            [_confname:protected] => magmi.ini
            [_props:protected] => Array
                (
                    [DATABASE] => Array
                        (
                            [connectivity] => net
                            [host] => localhost
                            [port] => 3306
                            [resource] => default_setup
                            [unix_socket] => /var/lib/mysql/mysql.sock
                            [dbname] => magento
                            [user] => magento
                            [password] => 
                            [table_prefix] => 
                        )

                    [MAGENTO] => Array
                        (
                            [version] => 1.9.x
                            [basedir] => /home/magento/www
                        )

                    [GLOBAL] => Array
                        (
                            [step] => 0.1
                            [multiselect_sep] => ,
                            [dirmask] => 755
                            [filemask] => 644
                        )

                )

            [inifile] => /home/magento/public_html/magmi/conf/magmi.ini
            [_specialchars:protected] => Array
                (
                    ["] => :DQUOTE:
                    ['] => :SQUOTE:
                    [\t] => TAB
                )

        )

    [_initialized:protected] => 1
    [_exceptions:protected] => Array
        (
            [SQLSTATE[42000]: Syntax error or access violation: 1055 'magento.cce.entity_type_id' isn't in GROUP BY] => Array
                (
                    [0] => 1
                    [1] => 1
                )

        )

    [tprefix] => 
    [_connected:protected] => 
    [_activeplugins:protected] => Array
        (
            [datasources] => Array
                (
                    [0] => Magmi_CSVDataSource Object
                        (
                            [_csvreader:protected] => Magmi_CSVReader Object
                                (
                                    [_filename:protected] => magento/www/var/import/categorys2.csv
                                    [_fh:protected] => Resource id #189
                                    [_cols:protected] => Array
                                        (
                                            [0] => sku
                                            [1] => categories
                                            [2] => category_reset
                                            [3] => store
                                        )

                                    [_csep:protected] => ,
                                    [_dcsep:protected] => ,
                                    [_params:protected] => Array
                                        (
                                            [CSV:importmode] => local
                                            [CSV:basedir] => var/import
                                            [CSV:filename] => magento/www/var/import/categorys2.csv
                                            [CSV:remoteurl] => 
                                            [CSV:remotecookie] => 
                                            [CSV:remoteuser] => 
                                            [CSV:remotepass] => 
                                            [CSV:separator] => 
                                            [CSV:enclosure] => 
                                            [CSV:headerline] => 
                                            [profile] => default
                                            [mode] => update
                                            [chain] => default:update
                                        )

                                    [_buffersize:protected] => 0
                                    [_curline:protected] => 1
                                    [_nhcols:protected] => 4
                                    [_cenc:protected] => "
                                    [_ignored:protected] => Array
                                        (
                                            [0] => 
                                        )

                                    [_callers:protected] => 
                                )

                            [_class:protected] => Magmi_CSVDataSource
                            [_plugintype:protected] => 
                            [_plugindir:protected] => 
                            [_config:protected] => Magmi_PluginConfig Object
                                (
                                    [_prefix:protected] => Magmi_CSVDataSource
                                    [_conffile:protected] => 
                                    [_profile:protected] => default
                                    [_basedir:protected] => /home/magento/public_html/magmi/conf
                                    [_confname:protected] => /home/magento/public_html/magmi/conf/Magmi_CSVDataSource.conf
                                    [_props:protected] => Array
                                        (
                                            [Magmi_CSVDataSource] => Array
                                                (
                                                    [CSV:importmode] => local
                                                    [CSV:basedir] => var/import
                                                    [CSV:filename] => /home/magento/public_html/var/import/productsWithImages.csv
                                                    [CSV:remoteurl] => 
                                                    [CSV:remotecookie] => 
                                                    [CSV:remoteuser] => 
                                                    [CSV:remotepass] => 
                                                    [CSV:separator] => 
                                                    [CSV:enclosure] => 
                                                    [CSV:headerline] => 
                                                )

                                        )

                                    [inifile] => /home/magento/public_html/magmi/conf/Magmi_CSVDataSource.conf
                                    [_specialchars:protected] => Array
                                        (
                                            ["] => :DQUOTE:
                                            ['] => :SQUOTE:
                                            [\t] => TAB
                                        )

                                )

                            [_magmiconfig:protected] => Magmi_Config Object
                                (
                                    [_defaultconfigname:Magmi_Config:private] => 
                                    [_basedir:protected] => /home/magento/public_html/magmi/conf
                                    [_confname:protected] => magmi.ini
                                    [_props:protected] => Array
                                        (
                                            [DATABASE] => Array
                                                (
                                                    [connectivity] => net
                                                    [host] => localhost
                                                    [port] => 3306
                                                    [resource] => default_setup
                                                    [unix_socket] => /var/lib/mysql/mysql.sock
                                                    [dbname] => magento
                                                    [user] => magento
                                                    [password] => 
                                                    [table_prefix] => 
                                                )

                                            [MAGENTO] => Array
                                                (
                                                    [version] => 1.9.x
                                                    [basedir] => /home/magento/www
                                                )

                                            [GLOBAL] => Array
                                                (
                                                    [step] => 0.1
                                                    [multiselect_sep] => ,
                                                    [dirmask] => 755
                                                    [filemask] => 644
                                                )

                                        )

                                    [inifile] => /home/magento/public_html/magmi/conf/magmi.ini
                                    [_specialchars:protected] => Array
                                        (
                                            ["] => :DQUOTE:
                                            ['] => :SQUOTE:
                                            [\t] => TAB
                                        )

                                )

                            [_pluginmeta:protected] => Array
                                (
                                    [class] => Magmi_CSVDataSource
                                    [dir] => /home/magento/public_html/magmi/plugins/base/datasources/csv
                                    [file] => magmi_csvdatasource.php
                                )

                            [_callers:protected] => Array
                                (
                                    [0] => Magmi_ProductImportEngine Object
 *RECURSION*
                                )

                            [_params] => Array
                                (
                                    [CSV:importmode] => local
                                    [CSV:basedir] => var/import
                                    [CSV:filename] => magento/www/var/import/categorys2.csv
                                    [CSV:remoteurl] => 
                                    [CSV:remotecookie] => 
                                    [CSV:remoteuser] => 
                                    [CSV:remotepass] => 
                                    [CSV:separator] => 
                                    [CSV:enclosure] => 
                                    [CSV:headerline] => 
                                    [profile] => default
                                    [mode] => update
                                    [chain] => default:update
                                )

                        )

                )

            [general] => Array
                (
                )

            [itemprocessors] => Array
                (
                    [0] => CategoryImporter Object
                        (
                            [_idcache:protected] => Array
                                (
                                )

                            [_catattr:protected] => Array
                                (
                                )

                            [_cattrinfos:protected] => Array
                                (
                                    [varchar] => Array
                                        (
                                            [name] => Array
                                                (
                                                    [attribute_id] => 41
                                                    [entity_type_id] => 3
                                                    [attribute_code] => name
                                                    [attribute_model] => 
                                                    [backend_model] => 
                                                    [backend_type] => varchar
                                                    [backend_table] => 
                                                    [frontend_model] => 
                                                    [frontend_input] => text
                                                    [frontend_label] => Name
                                                    [frontend_class] => 
                                                    [source_model] => 
                                                    [is_required] => 1
                                                    [is_user_defined] => 0
                                                    [default_value] => 
                                                    [is_unique] => 0
                                                    [note] => 
                                                )

                                            [url_key] => Array
                                                (
                                                    [attribute_id] => 43
                                                    [entity_type_id] => 3
                                                    [attribute_code] => url_key
                                                    [attribute_model] => 
                                                    [backend_model] => catalog/category_attribute_backend_urlkey
                                                    [backend_type] => varchar
                                                    [backend_table] => 
                                                    [frontend_model] => 
                                                    [frontend_input] => text
                                                    [frontend_label] => URL Key
                                                    [frontend_class] => 
                                                    [source_model] => 
                                                    [is_required] => 0
                                                    [is_user_defined] => 0
                                                    [default_value] => 
                                                    [is_unique] => 0
                                                    [note] => 
                                                )

                                            [url_path] => Array
                                                (
                                                    [attribute_id] => 57
                                                    [entity_type_id] => 3
                                                    [attribute_code] => url_path
                                                    [attribute_model] => 
                                                    [backend_model] => 
                                                    [backend_type] => varchar
                                                    [backend_table] => 
                                                    [frontend_model] => 
                                                    [frontend_input] => text
                                                    [frontend_label] => 
                                                    [frontend_class] => 
                                                    [source_model] => 
                                                    [is_required] => 0
                                                    [is_user_defined] => 0
                                                    [default_value] => 
                                                    [is_unique] => 0
                                                    [note] => 
                                                )

                                        )

                                    [int] => Array
                                        (
                                            [is_active] => Array
                                                (
                                                    [attribute_id] => 42
                                                    [entity_type_id] => 3
                                                    [attribute_code] => is_active
                                                    [attribute_model] => 
                                                    [backend_model] => 
                                                    [backend_type] => int
                                                    [backend_table] => 
                                                    [frontend_model] => 
                                                    [frontend_input] => select
                                                    [frontend_label] => Is Active
                                                    [frontend_class] => 
                                                    [source_model] => eav/entity_attribute_source_boolean
                                                    [is_required] => 1
                                                    [is_user_defined] => 0
                                                    [default_value] => 
                                                    [is_unique] => 0
                                                    [note] => 
                                                )

                                            [is_anchor] => Array
                                                (
                                                    [attribute_id] => 51
                                                    [entity_type_id] => 3
                                                    [attribute_code] => is_anchor
                                                    [attribute_model] => 
                                                    [backend_model] => 
                                                    [backend_type] => int
                                                    [backend_table] => 
                                                    [frontend_model] => 
                                                    [frontend_input] => select
                                                    [frontend_label] => Is Anchor
                                                    [frontend_class] => 
                                                    [source_model] => eav/entity_attribute_source_boolean
                                                    [is_required] => 0
                                                    [is_user_defined] => 0
                                                    [default_value] => 
                                                    [is_unique] => 0
                                                    [note] => 
                                                )

                                            [include_in_menu] => Array
                                                (
                                                    [attribute_id] => 67
                                                    [entity_type_id] => 3
                                                    [attribute_code] => include_in_menu
                                                    [attribute_model] => 
                                                    [backend_model] => 
                                                    [backend_type] => int
                                                    [backend_table] => 
                                                    [frontend_model] => 
                                                    [frontend_input] => select
                                                    [frontend_label] => Include in Navigation Menu
                                                    [frontend_class] => 
                                                    [source_model] => eav/entity_attribute_source_boolean
                                                    [is_required] => 1
                                                    [is_user_defined] => 0
                                                    [default_value] => 1
                                                    [is_unique] => 0
                                                    [note] => 
                                                )

                                        )

                                )

                            [_catroots:protected] => Array
                                (
                                    [1] => Array
                                        (
                                            [path] => 1/2
                                            [etid] => 3
                                            [name] => Default Category
                                            [rootarr] => Array
                                                (
                                                    [0] => 1
                                                    [1] => 2
                                                )

                                        )

                                )

                            [_catrootw:protected] => Array
                                (
                                    [1] => Array
                                        (
                                            [0] => 1
                                            [1] => 1
                                        )

                                )

                            [_cat_eid:protected] => 3
                            [_tsep:protected] => /
                            [_escapedtsep:protected] => ---
                            [_class:protected] => CategoryImporter
                            [_plugintype:protected] => 
                            [_plugindir:protected] => 
                            [_config:protected] => Magmi_PluginConfig Object
                                (
                                    [_prefix:protected] => CategoryImporter
                                    [_conffile:protected] => 
                                    [_profile:protected] => default
                                    [_basedir:protected] => /home/magento/public_html/magmi/conf
                                    [_confname:protected] => /home/magento/public_html/magmi/conf/CategoryImporter.conf
                                    [_props:protected] => Array
                                        (
                                            [CategoryImporter] => Array
                                                (
                                                    [CAT:baseroot] => Default Category
                                                    [CAT:lastonly] => 1
                                                    [CAT:urlending] => 
                                                    [CAT:treesep] => /
                                                )

                                        )

                                    [inifile] => /home/magento/public_html/magmi/conf/CategoryImporter.conf
                                    [_specialchars:protected] => Array
                                        (
                                            ["] => :DQUOTE:
                                            ['] => :SQUOTE:
                                            [\t] => TAB
                                        )

                                )

                            [_magmiconfig:protected] => Magmi_Config Object
                                (
                                    [_defaultconfigname:Magmi_Config:private] => 
                                    [_basedir:protected] => /home/magento/public_html/magmi/conf
                                    [_confname:protected] => magmi.ini
                                    [_props:protected] => Array
                                        (
                                            [DATABASE] => Array
                                                (
                                                    [connectivity] => net
                                                    [host] => localhost
                                                    [port] => 3306
                                                    [resource] => default_setup
                                                    [unix_socket] => /var/lib/mysql/mysql.sock
                                                    [dbname] => magento
                                                    [user] => magento
                                                    [password] => 
                                                    [table_prefix] => 
                                                )

                                            [MAGENTO] => Array
                                                (
                                                    [version] => 1.9.x
                                                    [basedir] => /home/magento/www
                                                )

                                            [GLOBAL] => Array
                                                (
                                                    [step] => 0.1
                                                    [multiselect_sep] => ,
                                                    [dirmask] => 755
                                                    [filemask] => 644
                                                )

                                        )

                                    [inifile] => /home/magento/public_html/magmi/conf/magmi.ini
                                    [_specialchars:protected] => Array
                                        (
                                            ["] => :DQUOTE:
                                            ['] => :SQUOTE:
                                            [\t] => TAB
                                        )

                                )

                            [_pluginmeta:protected] => Array
                                (
                                    [class] => CategoryImporter
                                    [dir] => /home/magento/public_html/magmi/plugins/extra/itemprocessors/categories
                                    [file] => categoryimport.php
                                )

                            [_callers:protected] => Array
                                (
                                    [0] => Magmi_ProductImportEngine Object
 *RECURSION*
                                )

                            [_params] => Array
                                (
                                    [CAT:baseroot] => Default Category
                                    [CAT:lastonly] => 1
                                    [CAT:urlending] => 
                                    [CAT:treesep] => /
                                    [profile] => default
                                    [mode] => update
                                    [CSV:filename] => magento/www/var/import/categorys2.csv
                                    [chain] => default:update
                                )

                        )

                    [1] => Magmi_DefaultAttributeItemProcessor Object
                        (
                            [_basecols:protected] => Array
                                (
                                    [store] => admin
                                    [type] => simple
                                )

                            [_baseattrs:protected] => Array
                                (
                                    [status] => 1
                                    [visibility] => 4
                                    [page_layout] => 
                                    [tax_class_id] => Taxable Goods
                                )

                            [_forcedefault:protected] => Array
                                (
                                    [store] => admin
                                )

                            [_missingcols:protected] => Array
                                (
                                    [1] => type
                                )

                            [_missingattrs:protected] => Array
                                (
                                    [0] => status
                                    [1] => visibility
                                    [2] => page_layout
                                    [3] => tax_class_id
                                )

                            [_class:protected] => Magmi_DefaultAttributeItemProcessor
                            [_plugintype:protected] => 
                            [_plugindir:protected] => 
                            [_config:protected] => Magmi_PluginConfig Object
                                (
                                    [_prefix:protected] => Magmi_DefaultAttributeItemProcessor
                                    [_conffile:protected] => 
                                    [_profile:protected] => default
                                    [_basedir:protected] => /home/magento/public_html/magmi/conf
                                    [_confname:protected] => /home/magento/public_html/magmi/conf/Magmi_DefaultAttributeItemProcessor.conf
                                    [_props:protected] => 
                                    [inifile] => 
                                    [_specialchars:protected] => Array
                                        (
                                            ["] => :DQUOTE:
                                            ['] => :SQUOTE:
                                            [\t] => TAB
                                        )

                                )

                            [_magmiconfig:protected] => Magmi_Config Object
                                (
                                    [_defaultconfigname:Magmi_Config:private] => 
                                    [_basedir:protected] => /home/magento/public_html/magmi/conf
                                    [_confname:protected] => magmi.ini
                                    [_props:protected] => Array
                                        (
                                            [DATABASE] => Array
                                                (
                                                    [connectivity] => net
                                                    [host] => localhost
                                                    [port] => 3306
                                                    [resource] => default_setup
                                                    [unix_socket] => /var/lib/mysql/mysql.sock
                                                    [dbname] => magento
                                                    [user] => magento
                                                    [password] => 
                                                    [table_prefix] => 
                                                )

                                            [MAGENTO] => Array
                                                (
                                                    [version] => 1.9.x
                                                    [basedir] => /home/magento/www
                                                )

                                            [GLOBAL] => Array
                                                (
                                                    [step] => 0.1
                                                    [multiselect_sep] => ,
                                                    [dirmask] => 755
                                                    [filemask] => 644
                                                )

                                        )

                                    [inifile] => /home/magento/public_html/magmi/conf/magmi.ini
                                    [_specialchars:protected] => Array
                                        (
                                            ["] => :DQUOTE:
                                            ['] => :SQUOTE:
                                            [\t] => TAB
                                        )

                                )

                            [_pluginmeta:protected] => 
                            [_callers:protected] => Array
                                (
                                    [0] => Magmi_ProductImportEngine Object
 *RECURSION*
                                )

                            [_params] => Array
                                (
                                    [profile] => default
                                    [mode] => update
                                    [CSV:filename] => magento/www/var/import/categorys2.csv
                                    [chain] => default:update
                                )

                        )

                )

        )

    [_pluginclasses:protected] => Array
        (
            [datasources] => Array
                (
                    [0] => Magmi_CSVDataSource
                )

            [general] => Array
                (
                )

            [itemprocessors] => Array
                (
                    [0] => CategoryImporter
                    [1] => Magmi_DefaultAttributeItemProcessor
                )

        )

    [_builtinplugins:protected] => Array
        (
            [itemprocessors] => /home/magento/public_html/magmi/plugins/inc/magmi_defaultattributehandler.php::Magmi_DefaultAttributeItemProcessor
        )

    [_ploop_callbacks:protected] => Array
        (
        )

    [_excid:Magmi_Engine:private] => 1
    [logger] => FileLogger Object
        (
            [_fname:protected] => /home/magento/public_html/magmi/state/progress.txt
        )

    [_timingcats:protected] => Array
        (
        )

    [_db:protected] => PDO Object
        (
        )

    [_debug:protected] => 
    [_laststmt:protected] => PDOStatement Object
        (
            [queryString] => SELECT cce.entity_type_id,cce.attribute_set_id,cce.level+1 as level,COALESCE(MAX(eac.position),0)+1 as position
        FROM catalog_category_entity as cce
        LEFT JOIN  catalog_category_entity as eac ON eac.parent_id=cce.entity_id
        WHERE cce.entity_id=?
        GROUP BY eac.parent_id
        )

    [_use_stmt_cache:protected] => 1
    [_nreq:protected] => 7
    [_indbtime:protected] => 0.00148463249207
    [_intrans:protected] => 1
    [prepared:protected] => Array
        (
            [SELECT * FROM eav_attribute WHERE entity_type_id=? AND attribute_code=?] => Array
                (
                    [0] => PDOStatement Object
                        (
                            [queryString] => SELECT * FROM eav_attribute WHERE entity_type_id=? AND attribute_code=?
                        )

                    [1] => 6
                )

            [SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code=?] => Array
                (
                    [0] => PDOStatement Object
                        (
                            [queryString] => SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code=?
                        )

                    [1] => 1
                )

            [SELECT attribute_set_id FROM eav_attribute_set WHERE attribute_set_name=? AND entity_type_id=?] => Array
                (
                    [0] => PDOStatement Object
                        (
                            [queryString] => SELECT attribute_set_id FROM eav_attribute_set WHERE attribute_set_name=? AND entity_type_id=?
                        )

                    [1] => 1
                )

            [SELECT `eav_attribute`.*,catalog_eav_attribute.* FROM `eav_attribute`
                LEFT JOIN catalog_eav_attribute ON eav_attribute.attribute_id=catalog_eav_attribute.attribute_id
                WHERE  (eav_attribute.attribute_code IN (?,?,?,?,?)) AND (entity_type_id=?)] => Array
                (
                    [0] => PDOStatement Object
                        (
                            [queryString] => SELECT `eav_attribute`.*,catalog_eav_attribute.* FROM `eav_attribute`
                LEFT JOIN catalog_eav_attribute ON eav_attribute.attribute_id=catalog_eav_attribute.attribute_id
                WHERE  (eav_attribute.attribute_code IN (?,?,?,?,?)) AND (entity_type_id=?)
                        )

                    [1] => 1
                )

            [SELECT sku,entity_id as pid,attribute_set_id  as asid,type_id as type FROM catalog_product_entity WHERE sku=?] => Array
                (
                    [0] => PDOStatement Object
                        (
                            [queryString] => SELECT sku,entity_id as pid,attribute_set_id  as asid,type_id as type FROM catalog_product_entity WHERE sku=?
                        )

                    [1] => 1
                )

            [DESCRIBE catalog_product_entity] => Array
                (
                    [0] => PDOStatement Object
                        (
                            [queryString] => DESCRIBE catalog_product_entity
                        )

                    [1] => 1
                )

            [UPDATE  `catalog_product_entity` SET sku=?,entity_type_id=?,updated_at=? WHERE entity_id=?] => Array
                (
                    [0] => PDOStatement Object
                        (
                            [queryString] => UPDATE  `catalog_product_entity` SET sku=?,entity_type_id=?,updated_at=? WHERE entity_id=?
                        )

                    [1] => 1
                )

            [SELECT csdep.store_id FROM core_store as csmain 
                 JOIN core_store as csdep ON csdep.website_id=csmain.website_id
                 WHERE csmain.code IN (?) ] => Array
                (
                    [0] => PDOStatement Object
                        (
                            [queryString] => SELECT csdep.store_id FROM core_store as csmain 
                 JOIN core_store as csdep ON csdep.website_id=csmain.website_id
                 WHERE csmain.code IN (?) 
                        )

                    [1] => 1
                )

            [SELECT website_id FROM core_store WHERE store_id!=0 GROUP BY website_id ] => Array
                (
                    [0] => PDOStatement Object
                        (
                            [queryString] => SELECT website_id FROM core_store WHERE store_id!=0 GROUP BY website_id 
                        )

                    [1] => 1
                )

            [SELECT cet.entity_id FROM catalog_category_entity as cet
              JOIN catalog_category_entity_varchar as cetv ON cetv.entity_id=cet.entity_id AND cetv.attribute_id=? AND cetv.value=?
              WHERE cet.parent_id=? ] => Array
                (
                    [0] => PDOStatement Object
                        (
                            [queryString] => SELECT cet.entity_id FROM catalog_category_entity as cet
              JOIN catalog_category_entity_varchar as cetv ON cetv.entity_id=cet.entity_id AND cetv.attribute_id=? AND cetv.value=?
              WHERE cet.parent_id=? 
                        )

                    [1] => 1
                )

            [SELECT cce.entity_type_id,cce.attribute_set_id,cce.level+1 as level,COALESCE(MAX(eac.position),0)+1 as position
        FROM catalog_category_entity as cce
        LEFT JOIN  catalog_category_entity as eac ON eac.parent_id=cce.entity_id
        WHERE cce.entity_id=?
        GROUP BY eac.parent_id] => Array
                (
                    [0] => PDOStatement Object
                        (
                            [queryString] => SELECT cce.entity_type_id,cce.attribute_set_id,cce.level+1 as level,COALESCE(MAX(eac.position),0)+1 as position
        FROM catalog_category_entity as cce
        LEFT JOIN  catalog_category_entity as eac ON eac.parent_id=cce.entity_id
        WHERE cce.entity_id=?
        GROUP BY eac.parent_id
                        )

                    [1] => 1
                )

        )

    [_timecounter:protected] => TimeCounter Object
        (
            [_timingcats:protected] => Array
                (
                    [db] => Array
                        (
                            [_counters] => Array
                                (
                                    [requests] => 17
                                )

                            [_timers] => Array
                                (
                                )

                        )

                    [global] => Array
                        (
                            [_counters] => Array
                                (
                                    [requests] => 17
                                )

                            [_timers] => Array
                                (
                                )

                        )

                    [line] => Array
                        (
                            [_counters] => Array
                                (
                                    [requests] => 7
                                )

                            [_timers] => Array
                                (
                                )

                        )

                )

            [_defaultsrc:protected] => Magmi_ProductImportEngine
            [_timingcontext:protected] => Array
                (
                )

        )

    [_tcats:protected] => db
    [datasource] => Magmi_CSVDataSource Object
        (
            [_csvreader:protected] => Magmi_CSVReader Object
                (
                    [_filename:protected] => magento/www/var/import/categorys2.csv
                    [_fh:protected] => Resource id #189
                    [_cols:protected] => Array
                        (
                            [0] => sku
                            [1] => categories
                            [2] => category_reset
                            [3] => store
                        )

                    [_csep:protected] => ,
                    [_dcsep:protected] => ,
                    [_params:protected] => Array
                        (
                            [CSV:importmode] => local
                            [CSV:basedir] => var/import
                            [CSV:filename] => magento/www/var/import/categorys2.csv
                            [CSV:remoteurl] => 
                            [CSV:remotecookie] => 
                            [CSV:remoteuser] => 
                            [CSV:remotepass] => 
                            [CSV:separator] => 
                            [CSV:enclosure] => 
                            [CSV:headerline] => 
                            [profile] => default
                            [mode] => update
                            [chain] => default:update
                        )

                    [_buffersize:protected] => 0
                    [_curline:protected] => 1
                    [_nhcols:protected] => 4
                    [_cenc:protected] => "
                    [_ignored:protected] => Array
                        (
                            [0] => 
                        )

                    [_callers:protected] => 
                )

            [_class:protected] => Magmi_CSVDataSource
            [_plugintype:protected] => 
            [_plugindir:protected] => 
            [_config:protected] => Magmi_PluginConfig Object
                (
                    [_prefix:protected] => Magmi_CSVDataSource
                    [_conffile:protected] => 
                    [_profile:protected] => default
                    [_basedir:protected] => /home/magento/public_html/magmi/conf
                    [_confname:protected] => /home/magento/public_html/magmi/conf/Magmi_CSVDataSource.conf
                    [_props:protected] => Array
                        (
                            [Magmi_CSVDataSource] => Array
                                (
                                    [CSV:importmode] => local
                                    [CSV:basedir] => var/import
                                    [CSV:filename] => /home/magento/public_html/var/import/productsWithImages.csv
                                    [CSV:remoteurl] => 
                                    [CSV:remotecookie] => 
                                    [CSV:remoteuser] => 
                                    [CSV:remotepass] => 
                                    [CSV:separator] => 
                                    [CSV:enclosure] => 
                                    [CSV:headerline] => 
                                )

                        )

                    [inifile] => /home/magento/public_html/magmi/conf/Magmi_CSVDataSource.conf
                    [_specialchars:protected] => Array
                        (
                            ["] => :DQUOTE:
                            ['] => :SQUOTE:
                            [\t] => TAB
                        )

                )

            [_magmiconfig:protected] => Magmi_Config Object
                (
                    [_defaultconfigname:Magmi_Config:private] => 
                    [_basedir:protected] => /home/magento/public_html/magmi/conf
                    [_confname:protected] => magmi.ini
                    [_props:protected] => Array
                        (
                            [DATABASE] => Array
                                (
                                    [connectivity] => net
                                    [host] => localhost
                                    [port] => 3306
                                    [resource] => default_setup
                                    [unix_socket] => /var/lib/mysql/mysql.sock
                                    [dbname] => magento
                                    [user] => magento
                                    [password] => 
                                    [table_prefix] => 
                                )

                            [MAGENTO] => Array
                                (
                                    [version] => 1.9.x
                                    [basedir] => /home/magento/www
                                )

                            [GLOBAL] => Array
                                (
                                    [step] => 0.1
                                    [multiselect_sep] => ,
                                    [dirmask] => 755
                                    [filemask] => 644
                                )

                        )

                    [inifile] => /home/magento/public_html/magmi/conf/magmi.ini
                    [_specialchars:protected] => Array
                        (
                            ["] => :DQUOTE:
                            ['] => :SQUOTE:
                            [\t] => TAB
                        )

                )

            [_pluginmeta:protected] => Array
                (
                    [class] => Magmi_CSVDataSource
                    [dir] => /home/magento/public_html/magmi/plugins/base/datasources/csv
                    [file] => magmi_csvdatasource.php
                )

            [_callers:protected] => Array
                (
                    [0] => Magmi_ProductImportEngine Object
 *RECURSION*
                )

            [_params] => Array
                (
                    [CSV:importmode] => local
                    [CSV:basedir] => var/import
                    [CSV:filename] => magento/www/var/import/categorys2.csv
                    [CSV:remoteurl] => 
                    [CSV:remotecookie] => 
                    [CSV:remoteuser] => 
                    [CSV:remotepass] => 
                    [CSV:separator] => 
                    [CSV:enclosure] => 
                    [CSV:headerline] => 
                    [profile] => default
                    [mode] => update
                    [chain] => default:update
                )

        )

    [_wsids] => Array
        (
            [admin] => Array
                (
                    [0] => 1
                )

        )

)

+++++++++++++++++++++++++++++
END CONTEXT DUMP
+++++++++++++++++++++++++++++
---- ENDTRACE : 1 -----
---- TRACE : 2 -----
---- DATE : 2015-03-19 10:10:05 ------
Duplicated exception - same trace as TRACE : 1
---- ENDTRACE : 2 -----

Author

AdamHughes commented Mar 19, 2015

@dweeves I solved this by temporarily removing the "ONLY_FULL_GROUP_BY" option from my MySQL configuration file.

AdamHughes closed this as completed

AdamHughes mentioned this issue

Fixes group by error when using "ONLY_FULL_GROUP_BY" SQL Mode #216

Open

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment