Having an issue with the Price field when importing a product. Doesn't seem to give me an error when File (Field) Paths is not active. Here is the error i have at the moment:

  PDOException: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1: 
  
  INSERT INTO 
        {field_data_commerce_price} 
        
        (entity_type0, 
        entity_id1, 
        revision_id2, 
        bundle3, 
        delta4, 
        language5, 
        commerce_price_amount6, 
        commerce_price_currency_code7, 
        commerce_price_data8) 
VALUES     
        (
        :db_insert_placeholder_0, 
        :db_insert_placeholder_1, 
        :db_insert_placeholder_2, 
        :db_insert_placeholder_3, 
        :db_insert_placeholder_4, 
        :db_insert_placeholder_5, 
        :db_insert_placeholder_6, 
        :db_insert_placeholder_7, 
        :db_insert_placeholder_8_include_tax, 
        :db_insert_placeholder_8_components); 

        Array ( 
            [:db_insert_placeholder_0] => commerce_product 
            [:db_insert_placeholder_1] => 106 
            [:db_insert_placeholder_2] => 106 
            [:db_insert_placeholder_3] => product 
            [:db_insert_placeholder_4] => 0 
            [:db_insert_placeholder_5] => und 
            [:db_insert_placeholder_6] => 1326 
            [:db_insert_placeholder_7] => GBP 
            [:db_insert_placeholder_8_include_tax] => standard_rate 
            [:db_insert_placeholder_8_components] => Array () ) 
        
        in field_sql_storage_field_storage_write() 
        
        (line 448 of D:\vhosts\scroll-design.co.uk\httpdocs\siop\modules\field\modules\field_sql_storage\field_sql_storage.module).

I require file (Field) Paths to be active as i get a product image from a webserver without file extensions. I can set up file Fields to add .jpg to every image i upload. But didn't think it would cause this issue to the price field when importing!