PHP Notice

Message

Undefined index: custom_company_headquarters_address

Error at

app/addons/sd_seo_jsonld/schemas/jsonld_objects/website_schema.php, line: 2

Backtrace

File:app/addons/sd_seo_jsonld/schemas/jsonld_objects/website_schema.php
Line:2
Function:{closure}
File:app/functions/fn.common.php
Line:2142
Function:include
File:app/addons/sd_seo_jsonld/func.php
Line:2
Function:fn_get_schema
File:app/addons/sd_seo_jsonld/controllers/frontend/init.post.php
Line:2
Function:fn_sd_seo_jsonld_create_object
File:app/functions/fn.control.php
Line:700
Function:include
File:app/functions/fn.control.php
Line:456
Function:fn_run_controller
File:index.php
Line:26
Function:fn_dispatch
SELECT 
  cscart_products.*, 
  cscart_product_descriptions.*, 
  MIN(
    IF(
      cscart_product_prices.percentage_discount = 0, 
      cscart_product_prices.price, 
      cscart_product_prices.price - (
        cscart_product_prices.price * cscart_product_prices.percentage_discount
      )/ 100
    )
  ) as price, 
  GROUP_CONCAT(
    IF(
      cscart_products_categories.link_type = 'M', 
      CONCAT(
        cscart_products_categories.category_id, 
        'M'
      ), 
      cscart_products_categories.category_id
    )
  ) as category_ids, 
  popularity.total as popularity, 
  IF(
    shared_prices.product_id IS NOT NULL, 
    MIN(
      IF(
        shared_prices.percentage_discount = 0, 
        shared_prices.price, 
        shared_prices.price - (
          shared_prices.price * shared_prices.percentage_discount
        )/ 100
      )
    ), 
    MIN(
      IF(
        cscart_product_prices.percentage_discount = 0, 
        cscart_product_prices.price, 
        cscart_product_prices.price - (
          cscart_product_prices.price * cscart_product_prices.percentage_discount
        )/ 100
      )
    )
  ) as price, 
  companies.company as company_name, 
  cscart_product_sales.amount as sales_amount, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path, 
  cscart_discussion.type as discussion_type 
FROM 
  cscart_products 
  LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id 
  AND cscart_product_prices.lower_limit = 1 
  AND cscart_product_prices.usergroup_id IN (0, 0, 1) 
  LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id 
  AND cscart_product_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_ult_product_prices shared_prices ON shared_prices.product_id = cscart_products.product_id 
  AND shared_prices.company_id = 2 
  AND shared_prices.lower_limit = 1 
  AND shared_prices.usergroup_id IN (0, 0, 1) 
  LEFT JOIN cscart_companies as companies ON companies.company_id = cscart_products.company_id 
  INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id 
  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id 
  AND cscart_categories.company_id = 2 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  ) 
  AND (
    cscart_products.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_products.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_products.usergroup_ids
    )
  ) 
  AND cscart_categories.status IN ('A', 'H') 
  AND cscart_products.status IN ('A', 'H') 
  LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = cscart_products.product_id 
  LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = cscart_products.product_id 
  AND cscart_product_sales.category_id = 509 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 8371 
  AND cscart_seo_names.type = 'p' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
  AND cscart_seo_names.company_id = 2 
  LEFT JOIN cscart_discussion ON cscart_discussion.object_id = cscart_products.product_id 
  AND cscart_discussion.object_type = 'P' 
  AND cscart_discussion.company_id = 2 
WHERE 
  cscart_products.product_id = 8371 
  AND (
    companies.status = 'A' 
    OR cscart_products.company_id = 0
  ) 
GROUP BY 
  cscart_products.product_id

Query time 0.00156

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products const PRIMARY,status,product_id_idx,status_idx PRIMARY 3 const 1
1 SIMPLE popularity const PRIMARY,total PRIMARY 3 const 1
1 SIMPLE cscart_product_sales const PRIMARY,pa PRIMARY 6 const,const 1
1 SIMPLE cscart_product_prices ref usergroup,product_id,lower_limit,usergroup_id product_id 3 const 1 Using where
1 SIMPLE cscart_product_descriptions const PRIMARY,product_id PRIMARY 9 const,const 1 Using where
1 SIMPLE shared_prices ref usergroup,product_id,company_id,lower_limit,usergroup_id product_id 3 const 2 Using where
1 SIMPLE companies eq_ref PRIMARY PRIMARY 4 const 1 Using where
1 SIMPLE cscart_products_categories ref PRIMARY,pt,product_id_idx,category_id_idx,product_category_idx,category_product_idx product_id_idx 3 const 2
1 SIMPLE cscart_categories eq_ref PRIMARY,c_status,p_category_id,idx_category_id PRIMARY 3 mahm3t_cs443.cscart_products_categories.category_id 1 Using where
1 SIMPLE cscart_seo_names const PRIMARY,dispatch PRIMARY 210 const,const,const,const,const 1 Using where
1 SIMPLE cscart_discussion const object_id,company_id object_id 10 const,const,const 1 Using where

Result

product_id product_code product_type status company_id list_price amount weight length width height shipping_freight low_avail_limit timestamp updated_timestamp usergroup_ids is_edp edp_shipping unlimited_download tracking free_shipping zero_price_action is_pbp is_op is_oper is_returnable return_period avail_since out_of_stock_actions localization min_qty max_qty qty_step list_qty_count tax_ids age_verification age_limit options_type exceptions_type details_layout shipping_params shipping_availability_id ms_type master_id unit_price aval_status facebook_obj_type cp_additinal_product_enabled cp_additinal_product_items cp_delivery_date youtube_link show_youtube_video replace_main_image size_chart_id staff_notes emo_pn emo_paczka emo_dostawca emo_kreskowy emo_nrdostawcy emo_uwagi emo_source lang_code product shortname short_description full_description meta_keywords meta_description search_words page_title age_warning_message unit_name promo_text stop_words amp_description custom_header price category_ids popularity company_name sales_amount seo_name seo_path discussion_type
8371 STG-A-IZK2 P A 1 0.00 6.00 16.000 0 0 0 0.00 0 1454150637 1756381644 0 N N N B N R N N N Y 10 0 N 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 10 N 0 22 106 activity N [] 0 N N 0 0 en Impregnant for brick slips and decorative stone <p style="text-align: justify;">Impregnat for brick slips&nbsp;is a milk-white, water-soluble silicon emulsion with a little admixture of solvent designed for surface hydrophobisation of building materials such as: porous concrete tiles, concrete window sills and roofs, gypsum blocks, cellular concrete, roof tiles, cement-lime plasters and, in certain cases, acrylic plasters.</p> <h2>Use</h2> <p style="text-align: justify;">In order to achieve correct impregnation results it is necessary to adequately prepare the application surface. The surface should be evenly porous, dry, clean and free from grease. STEGU tiles should be impregnated together with joints at least 7 days after work completion. New cement-lime and acrylic plasters, as well as concrete must not be impregnated earlier than 24-30 days after the end of work. Surfaces repaired with the use of PCC-type mortar or filler should be impregnated after 6 days. Treated surfaces should be impregnated in dry weather and moderate wind conditions, at external temperatures in the range from +5 to +30°C. Prior to work, carefully secure all non-impregnated surfaces (e.g. window panels, metal and wooden parts, polished stones). In case of fouling, clean the surface immediately with mineral spirits.</p> <h2>Application</h2> <p style="text-align: justify;">Impregnation can be performed using a brush or by spraying. The application method depends on the absorbability and structure of the material. In order to achieve the best results, it is recommended to impregnate the surface twice, at short intervals and using the ‘wet to wet’ method (i.e. depending on the ambient temperature and porosity of the material the second layer should be applied within 30 minutes from the application of the first one i.e. when the surface is still wet). Surface should be impregnated completely and evenly.</p> <h2>Consumption</h2> <p style="text-align: justify;">Consumption of the impregnating agent depends on the absorbability of the treated material, as well as application method and amounts up to 10 m² per 1 litre of the emulsion (with a one impregnation). Store in original containers, in roofed and dry rooms, at temperatures in the range from +5 to +25°C.</p> 2L <p style="background: #ddd;"><strong>up to 10 m² per 1 litre of the emulsion</strong></p> 28.020000 499 548356 baubaY.de 630 impregnant 500/492/499 B