Skip to main content
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND prod_active = 1 AND prod_archived = 0 ORDER BY prod_pos ASC' at line 1
SELECT shop_products.* FROM shop_products WHERE prod_sectionID = AND prod_active = 1 AND prod_archived = 0 ORDER BY prod_pos ASC
array(4) {
  [0]=>
  array(4) {
    ["file"]=>
    string(91) "/srv/data/vhosts/sallyelford.co.uk/httpdocs/admin/extensions/shop/classes/class.section.php"
    ["line"]=>
    int(240)
    ["function"]=>
    string(7) "dbQuery"
    ["args"]=>
    array(1) {
      [0]=>
      string(129) "SELECT shop_products.* FROM shop_products WHERE prod_sectionID =  AND prod_active = 1 AND prod_archived = 0 ORDER BY prod_pos ASC"
    }
  }
  [1]=>
  array(7) {
    ["file"]=>
    string(82) "/srv/data/vhosts/sallyelford.co.uk/httpdocs/site/includes/content-shop_section.php"
    ["line"]=>
    int(72)
    ["function"]=>
    string(12) "get_products"
    ["class"]=>
    string(12) "shop_section"
    ["object"]=>
    object(shop_section)#57 (17) {
      ["id"]=>
      NULL
      ["parent"]=>
      NULL
      ["name"]=>
      NULL
      ["subhead"]=>
      NULL
      ["slug"]=>
      NULL
      ["details"]=>
      NULL
      ["dateAdded"]=>
      NULL
      ["dateModified"]=>
      NULL
      ["pos"]=>
      NULL
      ["active"]=>
      NULL
      ["show_nostock"]=>
      NULL
      ["show_archived"]=>
      NULL
      ["prods_per_page"]=>
      NULL
      ["pagination"]=>
      NULL
      ["in_sitemap"]=>
      NULL
      ["trans_id"]=>
      NULL
      ["lang":"shop_section":private]=>
      string(2) "en"
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(1) {
      [0]=>
      array(2) {
        ["orderby"]=>
        string(8) "prod_pos"
        ["sort"]=>
        string(3) "ASC"
      }
    }
  }
  [2]=>
  array(4) {
    ["file"]=>
    string(58) "/srv/data/vhosts/sallyelford.co.uk/httpdocs/site/index.php"
    ["line"]=>
    int(237)
    ["args"]=>
    array(1) {
      [0]=>
      string(82) "/srv/data/vhosts/sallyelford.co.uk/httpdocs/site/includes/content-shop_section.php"
    }
    ["function"]=>
    string(7) "include"
  }
  [3]=>
  array(4) {
    ["file"]=>
    string(53) "/srv/data/vhosts/sallyelford.co.uk/httpdocs/index.php"
    ["line"]=>
    int(2)
    ["args"]=>
    array(1) {
      [0]=>
      string(58) "/srv/data/vhosts/sallyelford.co.uk/httpdocs/site/index.php"
    }
    ["function"]=>
    string(7) "include"
  }
}