Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

mail_open
Cannot update or create config products
Steve Froggatt
Member
August 12, 2014 - 1:43 pm
Member Since: May 2, 2014
Forum Posts: 514
sp_UserOfflineSmall Offline

I cannot update or create config products, here is the error, any ideas

error 1:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)
WHERE cpec.entity_id=’1222” at line 3 – INSERT INTO mage_catalog_product_super_link (`parent_id`,`product_id`) SELECT cpec.entity_id as parent_id,cpes.entity_id as product_id
FROM mage_catalog_product_entity as cpec
JOIN mage_catalog_product_entity as cpes ON cpes.type_id IN (‘simple’,’virtual’) AND cpes.sku IN ()
WHERE cpec.entity_id=?
error 2:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)
WHERE cpec.entity_id=’1222” at line 3 – ERROR ON RECORD #1
plugin;ImageAttributeItemProcessor;warning:Image attributes processor v1.0.25 – no_selection cannot be found in images path
plugin;ImageAttributeItemProcessor;warning:Image attributes processor v1.0.25 – no_selection cannot be found in images path
plugin;ImageAttributeItemProcessor;warning:Image attributes processor v1.0.25 – no_selection cannot be found in images path
warning:Skus imported KO:1/8
4 warning(s) found Show Details
Runtime infos
Magmi Optimizer v1.0.5 – Optimizing magmi
Magmi Optimizer v1.0.5 – Adding index MAGMI_EAOV_OPTIMIZATION_IDX on mage_eav_attribute_option_value
Magmi Optimizer v1.0.5 – Already optmized!
Magmi Optimizer v1.0.5 – Adding index MAGMI_CPEM_OPTIMIZATION_IDX on mage_catalog_product_entity_media_gallery
Magmi Optimizer v1.0.5 – Already optmized!
Magmi Optimizer v1.0.5 – Adding index MAGMI_CCEV_OPTIMIZATION_IDX on mage_catalog_category_entity_varchar
Magmi Optimizer v1.0.5 – Already optmized!
Magmi Optimizer v1.0.5 – Adding index MAGMI_EA_CODE_OPTIMIZATION_IDX on mage_eav_attribute
Magmi Optimizer v1.0.5 – Already optmized!
Skus imported OK:7/8
Back to Configuration Page
Import Ended:Tue Aug 12 13:39:35 2014

Avatar
Matthew Ogborne

Founder
August 14, 2014 - 1:07 pm
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Howdy Steve,

Can you attach a copy of what you’re using to import for me to the forums and I’ll take a look to see if it’s not anything we’ve missed?

Matt

"Selling an item online is easy, but making living from a business that sells online, well that’s something different entirely!"

Ultimo Magento Theme

Howard
Member
September 10, 2014 - 10:26 pm
Member Since: November 6, 2013
Forum Posts: 117
sp_UserOfflineSmall Offline

Hi Steve

Did you get this sorted?
I had something similar this evening.
It did import the simple products, but not the configurable.
Eventually I sorted it by deleting the products and the attribute, re-made the attribute, added back into the attribute set and this time it worked.
I would swear that all the data was the same and that the only difference was in the attribute name changed form “config_itngmini” to “config_itng_mini”.
Just wondering what fixed it for you?
Howard

Aurélien Borst

New
July 30, 2015 - 1:31 pm
Member Since: June 2, 2014
Forum Posts: 3
sp_UserOfflineSmall Offline

I’ve got the same problems… And I cannot delete and recreate my configurable attribute

 

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:
17 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: 5221

Posts: 27486

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606