Comment 1 for bug 1210471

Revision history for this message
Grzegorz Grzelak (OpenGLOBE.pl) (grzegorz-og.pl) wrote :

OpenERP log looks like:

2013-08-09 10:51:19,846 2965 DEBUG v70_ff_20130807_migrated_01 openerp.addons.connector.unit.mapper: converting record {'ff_vegan': None, 'msrp_enabled': None, 'type_id': 'simple', 'ff_wein_land': None, 'ff_laktosefrei': None, 'sku': '1002433a', 'ff_auf_startseite': None, 'ff_bio': None, 'custom_design_to': None, 'meta_title': 'NIVEA Shampoo for Men Strong Power', 'fett_gesaettigt': None, 'news_to_date': None, 'format': '331', 'tier_price': [], 'kalorien': None, 'categories': ['353'], 'ff_flugobst': None, 'name': 'NIVEA Shampoo for Men Strong Power', 'set': '9', 'options_container': 'container2', 'cost': '1.8300', 'ff_gp_einheit': 'ml', 'meta_description': 'NIVEA Shampoo for Men Strong Power, Schampoo', 'msrp_display_actual_price_type': None, 'is_imported': None, 'tax_class_id': '1', 'deposit_helper_isdeposit': None, 'ff_regional': None, 'rebsorte': None, 'enable_googlecheckout': '1', 'special_price': None, 'geschmack': None, 'manufacturer': None, 'delivery_time': None, 'required_options': '0', 'product_id': '897', 'region': None, 'ff_von_hier': None, 'generate_meta': '0', 'ff_glutenfrei': None, 'produktbezeichnung': None, 'small_image_label': 'NIVEA Shampoo for Men Strong Power 250ml', 'ff_naturland_neu': None, 'thumbnail_label': 'NIVEA Shampoo for Men Strong Power 250ml', 'url_key': 'nivea-shampoo-for-men-strong-power', 'group_price': [], 'page_layout': None, 'minimal_price': None, 'gift_message_available': None, 'type': 'simple', 'news_from_date': None, 'visibility': '4', 'ff_jahrgang': None, 'recurring_profile': None, 'is_recurring': None, 'eiweiss': None, 'custom_design_from': None, 'msrp': None, 'image_label': 'NIVEA Shampoo for Men Strong Power 250ml', 'updated_at': '2013-01-05 18:16:34', 'websites': ['1'], 'kohlenhydrate': None, 'fett': None, 'country_of_manufacture': None, 'ff_bioland': None, 'meta_keyword': 'NIVEA Shampoo for Men Strong Power, Schampoo', 'custom_layout_update': None, 'short_description': 'NIVEA - for Men Strong Power', 'ff_grundpreis': u'250 ml (100 ml = 1,32 \u20ac)', 'ff_demeter': None, 'status': '1', 'balaststoffe': None, 'description': u'Das Strong Power For Men Shampoo st\xe4rkt das Haar messbar, ist f\xfcr die t\xe4gliche Haarw\xe4sche geeignet.', 'old_id': None, 'price': '3.2900', 'deposit_helper_sku': None, 'zucker': None, 'ff_inhaltsstoffe': None, 'url_path': 'nivea-shampoo-for-men-strong-power.html', 'typ': None, 'created_at': '0000-00-00 00:00:00', 'ff_fairtrade': None, 'special_from_date': None, 'product_ingredients': None, 'special_to_date': None, 'custom_design': None, 'has_options': '0'} to model magento.product.product
2013-08-09 10:51:20,228 2965 ERROR v70_ff_20130807_migrated_01 openerp.sql_db: bad query: insert into "magento_product_product" (id,openerp_id,"updated_at","backend_id","created_at","backorders","manage_stock","product_type","magento_id",create_uid,create_date,write_uid,write_date) values (1106,7530,'2013-01-05 18:16:34',1,'0000-00-00 00:00:00','use_default','use_default','simple','897',1,(now() at time zone 'UTC'),1,(now() at time zone 'UTC'))
Traceback (most recent call last):
  File "/home/gg/openerp-server-7.0/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
DataError: date/time field value out of range: "0000-00-00 00:00:00"
LINE 1: ...e_date) values (1106,7530,'2013-01-05 18:16:34',1,'0000-00-0...
                                                             ^