Forum

Thread tagged as: Error, Shop

Product Variants variable

Hi everyone,

For some reason a part of my script stopped working.

  $product = perch_shop_product(perch_get('slug'), [
      'skip-template' => true
  ], true);

  $variants = perch_shop_product_variants(perch_get('slug'), [
      'skip-template' => true
  ], true);

  PerchSystem::set_var('variants', $variants);

  perch_shop_product(perch_get('slug'), [
      'template' => 'products/_product_page.html'
  ]);

perch_shop_product_variants(perch_get('slug')); returns NULL and $variants is an empty array although 4 variants have been assigned to it.

Many thanks, Damian

Perch Runway: 2.8.34
Production mode: Production (100)
Installed apps: content (2.8.34), assets (2.8.34), categories (2.8.34), perch_blog (5.0), perch_forms (1.8.3), perch_shop_orders (1.0.10), perch_shop_products (1.0.10), collection_2 (2.8.34), perch_shop (1.0.10), perch_members (1.5)
DB driver: PDO
DB tables: perch2_backup_plans (0), perch2_backup_resources (0), perch2_backup_runs (0), perch2_blog_authors (2), perch2_blog_comments (0), perch2_blog_index (156), perch2_blog_posts (1), perch2_blog_posts_to_tags (0), perch2_blog_sections (1), perch2_blog_tags (0), perch2_blogs (1), perch2_categories (8), perch2_category_counts (0), perch2_category_sets (3), perch2_collection_index (793), perch2_collection_items (88), perch2_collection_revisions (17), perch2_collections (1), perch2_content_index (25653), perch2_content_items (2166), perch2_content_regions (597), perch2_forms (7), perch2_forms_responses (25), perch2_members (30), perch2_members_forms (1), perch2_members_member_tags (0), perch2_members_sessions (1), perch2_members_tags (0), perch2_navigation (0), perch2_navigation_pages (0), perch2_page_routes (154), perch2_page_templates (27), perch2_pages (167), perch2_resource_log (788), perch2_resource_tags (48), perch2_resources (255), perch2_resources_to_tags (60), perch2_settings (41), perch2_shop_addresses (43), perch2_shop_admin_index (30), perch2_shop_brands (1), perch2_shop_cart (749), perch2_shop_cart_data (0), perch2_shop_cart_items (136), perch2_shop_countries (250), perch2_shop_currencies (152), perch2_shop_customers (30), perch2_shop_emails (2), perch2_shop_index (17480), perch2_shop_option_values (35), perch2_shop_options (8), perch2_shop_order_items (12), perch2_shop_order_promotions (2), perch2_shop_order_statuses (9), perch2_shop_orders (11), perch2_shop_orders_meta (1), perch2_shop_product_files (0), perch2_shop_product_option_values (29), perch2_shop_product_options (7), perch2_shop_product_tags (0), perch2_shop_products (367), perch2_shop_promotions (4), perch2_shop_search (358), perch2_shop_shipping_zone_countries (1), perch2_shop_shipping_zones (1), perch2_shop_shippings (1), perch2_shop_tax_exhibits (41), perch2_shop_tax_group_rates (29), perch2_shop_tax_groups (1), perch2_shop_tax_locations (29), perch2_shop_tax_rates (30), perch2_shop_variants (42), perch2_user_passwords (5), perch2_user_privileges (78), perch2_user_role_privileges (16), perch2_user_roles (2), perch2_users (6)
Users: 6
PHPMailer: 5.2.21
App runtimes:
<?php
    $apps_list = array(
        'content', 
        'categories',
        'perch_blog',
        'perch_forms',
        'perch_members',
        'perch_shop',
    );
Scheduled tasks for perch_blog: delete_spam_comments (1440 mins)
Editor plug-ins: markitup, redactor
H1: 3e4bc6a764d4522dcb518a67758246e7
L1: bed5a8bfe0e04530418296fc36347fb8
F1: 6a33f95eca3667f9e0c39bf5ca2980fe
headerColour: #0177b5
content_singlePageEdit: 1
helpURL:
siteURL: /
hideBranding: 1
content_collapseList: 1
lang: en-gb
update_2.8.25: done
latest_version: 2.8.15
on_sale_version: 2.8.34
headerScheme: dark
dashboard: 1
hide_pwd_reset: 0
content_hideNonEditableRegions: 1
content_frontend_edit: 0
logoPath: /cms/resources/docs_logo.png
perch_blog_update: 5.0.1
perch_blog_post_url: /blog/{postSlug}
perch_blog_site_name: Site
perch_blog_slug_format: {postTitle}
perch_blog_akismet_key:
perch_blog_max_spam_days: 30
perch_blog_comment_notify: 0
update_2.8.29: done
update_2.8.31: done
perch_shop_update: 1.0.10
perch_shop_price_tax_mode: exc
perch_shop_site_url: https://localhost
perch_shop_product_url: /product/{slug}
perch_shop_default_currency: 47
perch_shop_reporting_currency: 47
perch_shop_invoice_number_format: INV-%d
perch_members_login_page: /members/login.php?r={returnURL}
perch_members_update: 1.4
update_runway_2.8.31: done
update_runway_2.8.32: done
perch_shop_trade_price_tax_mode: exc
update_runway_2.8.33: done
update_runway_2.8.34: done
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_DB_USERNAME: docs_perch
PERCH_DB_SERVER: localhost
PERCH_DB_DATABASE: docs_perch
PERCH_SITEPATH: /home/docs/www/htdocs
PERCH_DB_PREFIX: perch2_
PERCH_TZ: UTC
PERCH_EMAIL_FROM: admin@admin.com
PERCH_EMAIL_FROM_NAME: Admin
PERCH_LOGINPATH: /cms
PERCH_PATH: /home/docs/www/htdocs/cms
PERCH_CORE: /home/docs/www/htdocs/cms/core
PERCH_RESFILEPATH: /home/docs/www/htdocs/cms/resources
PERCH_RESPATH: /cms/resources
PERCH_HTML5: 1
PERCH_YOUTUBE_API_KEY: 
PERCH_DEBUG: 1
PERCH_RUNWAY: 1
PERCH_ERROR_MODE: DIE
PERCH_DATE_LONG: %d %B %Y
PERCH_DATE_SHORT: %d %b %Y
PERCH_TIME_SHORT: %H:%M
PERCH_TIME_LONG: %H:%M:%S
PERCH_RUNWAY_ROUTED:
PERCH_STRONG_PASSWORDS:
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /home/docs/www/htdocs/cms/templates
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_PRODUCTION_MODE: 100
PERCH_RWD:
PERCH_HTML_ENTITIES:
PERCH_SSL:
PERCH_STRIPSLASHES:
PERCH_PROGRESSIVE_FLUSH: 1
PERCH_PARANOID:
PERCH_FORCE_SECURE_COOKIES:
PERCH_PASSWORD_MIN_LENGTH: 6
PERCH_MAX_FAILED_LOGINS: 10
PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR
PERCH_VERIFY_UPLOADS:
PERCH_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
PERCH_SESSION_TIMEOUT_MINS: 20
PERCH_SHOP_VERSION: 1.0.10
PERCH_APPS_EDITOR_PLUGIN: markitup
PERCH_APPS_EDITOR_MARKUP_LANGUAGE: textile
HOSTING SETTINGS

PHP: 5.6.25
Zend: 2.6.0
OS: Linux
SAPI: apache2handler
Safe mode: not detected
MySQL client: 5.6.33
MySQL server: 5.6.33
Free disk space: 541.20 GB
Extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dbase, dom, hash, fileinfo, filter, ftp, gd, gettext, SPL, iconv, imagick, session, intl, json, mailparse, mbstring, mcrypt, standard, imap, memcached, mssql, mysql, mysqli, OAuth, PDFlib, PDO, pdo_mysql, pdo_sqlite, pspell, Reflection, SimpleXML, soap, ssh2, exif, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, memcache, apache2handler, mhash, ionCube Loader, Zend Guard Loader, Zend OPcache
GD: Yes
ImageMagick: Yes
PHP max upload size: 128M
PHP max form post size: 128M
PHP memory limit: 256M
Total max uploadable file size: 128M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: Yes
UNIQUE_ID: WGzFbVPfagoAAAX2ClIAAAAl
HTTP_HOST: localhost
HTTP_CONNECTION: keep-alive
HTTP_PRAGMA: no-cache
HTTP_CACHE_CONTROL: no-cache
HTTP_UPGRADE_INSECURE_REQUESTS: 1
HTTP_USER_AGENT: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_REFERER: https://localhost/cms/core/settings/diagnostics/
HTTP_ACCEPT_ENCODING: gzip, deflate, sdch
HTTP_ACCEPT_LANGUAGE: en-GB,en-US;q=0.8,en;q=0.6,pl;q=0.4
HTTP_COOKIE: cmssb=0; __distillery=586dbc2_21b79b38-cb66-44a0-947e-2b879e9665b6-1679b8131-379c01ab6627-c0bb; p_m=; muxData=mux_viewer_id=ca333f86-ad47-4039-be58-a4885f473a47&msn=0.4776333276302458&sid=c5a85817-75a2-42c4-95d2-5cb05d322bf8&sst=1482920749598&sex=1482924059190; cmsa=1; _ga=GA1.2.49413937.1473760650; PHPSESSID=ved729dutspls1edj1nlkm04f7
PATH: /usr/bin:/bin
SERVER_SIGNATURE: <address>Apache Server at localhost Port 80</address>
SERVER_SOFTWARE: Apache
SERVER_NAME: localhost
SERVER_ADDR: 83.223.102.11
SERVER_PORT: 80
REMOTE_ADDR: 91.127.112.61
DOCUMENT_ROOT: /home/docs/www/htdocs/
SERVER_ADMIN: postmaster@localhost
SCRIPT_FILENAME: /home/docs/www/htdocs/cms/core/settings/diagnostics/index.php
REMOTE_PORT: 51086
GATEWAY_INTERFACE: CGI/1.1
SERVER_PROTOCOL: HTTP/1.1
REQUEST_METHOD: GET
QUERY_STRING: extended
REQUEST_URI: /cms/core/settings/diagnostics/?extended
SCRIPT_NAME: /cms/core/settings/diagnostics/index.php
PHP_SELF: /cms/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1483523437.249
REQUEST_TIME: 1483523437
Damian Drozdowicz

Damian Drozdowicz 0 points

  • 4 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

What does debug output for the page?

Damian Drozdowicz

Damian Drozdowicz 0 points
Registered Developer

<table class="perch-debug"> <tbody><tr>     <th>Debug Message</th> </tr><tr><td class="db" title="PerchRouter.class.php: PerchRouter->get_route(): "> <span class="debug-badge"><span class="debug-brkt">[</span>238<span class="debug-brkt">]</span></span> SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate FROM perch2_pages p LEFT JOIN perch2_page_routes pr
                ON p.pageID=pr.pageID ORDER BY pr.routeOrder ASC, p.pagePath ASC</td></tr><tr><td class="log" title="PerchRouter.class.php: PerchRouter->get_route(): ">Matched route: product/[slug:slug]</td></tr><tr><td class="routing" title="start.php: ">Using master page: /templates/pages/product.php</td></tr><tr><td class="routing" title="start.php: ">Page arguments: <pre>Array
(
    [0] =&gt; /product/test-product-1
    [slug] =&gt; test-product-1
    [1] =&gt; test-product-1
)
</pre></td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->find_by_path(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT * FROM perch2_pages WHERE pagePath='/product' LIMIT 1</td></tr><tr><td class="db" title="PerchShop_Cart.class.php: PerchShop_Cart->get_cart_field(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT * FROM perch2_shop_cart WHERE cartID=806</td></tr><tr><td class="db" title="PerchShop_Cart.class.php: PerchShop_Cart->get_cart_field(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT * FROM perch2_shop_cart WHERE cartID=806</td></tr><tr><td class="template" title="PerchContent_Page.class.php: PerchContent_Page->template_attributes(): ">Using template: /templates/pages/attributes/seo.html</td></tr><tr><td class="template" title="PerchContent_Page.class.php: PerchContent_Page->template_attributes(): ">Using template: /templates/pages/attributes/facebook.html</td></tr><tr><td class="template" title="PerchContent_Page.class.php: PerchContent_Page->template_attributes(): ">Using template: /templates/pages/attributes/twitter.html</td></tr><tr><td class="db" title="PerchContent_Runway.class.php: PerchContent_Runway->get_collection(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT collectionID, collectionTemplate  FROM perch2_collections WHERE collectionKey='Profiles'</td></tr><tr><td class="db" title="PerchContent_Runway.class.php: PerchContent_Runway->get_collection(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT * FROM ( SELECT  idx.itemID, ci.collectionID, ci.itemJSON,  idx2.indexValue as sortval  FROM perch2_collection_index idx 
                            JOIN perch2_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID
                            JOIN perch2_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID
                            JOIN perch2_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev   AND idx2.indexKey='_order'  WHERE (idx.collectionID=2) AND ((idx.indexKey='live' AND idx.indexValue=1))  AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
                    ) as tbl GROUP BY itemID, itemJSON, sortval  ORDER BY sortval ASC </td></tr><tr><td class="template" title="PerchContent_Runway.class.php: PerchContent_Runway->get_collection(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> Using template: /templates/content/partials/widget_how_can_i_help_you.html</td></tr><tr><td class="db" title="PerchSettings.class.php: PerchSettings->get(): "> <span class="debug-badge"><span class="debug-brkt">[</span>39<span class="debug-brkt">]</span></span> SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0</td></tr><tr><td class="template" title="PerchAPI_Template.class.php: PerchAPI_Template->set(): ">Using template: /templates/forms/callback-request.html</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->get_navigation(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/products-category-test' OR pageSortPath='/products-category-test' LIMIT 1</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->get_navigation(): "> <span class="debug-badge"><span class="debug-brkt">[</span>6<span class="debug-brkt">]</span></span> SELECT * FROM perch2_pages WHERE pageNew=0  AND pageHidden=0  AND pageTreePosition LIKE '000-004%'  AND pageDepth &gt;=1 AND pageDepth&lt;=2  ORDER BY pageTreePosition ASC</td></tr><tr><td class="db" title="PerchDB_MySQL.class.php: PerchDB_MySQL->get_value(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/product' LIMIT 1</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->find_parent_page_ids_by_path(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageID FROM perch2_pages WHERE  pageTreePosition IN ('000-019', '000') ORDER BY pageTreePosition DESC</td></tr><tr><td class="template" title="PerchContent_Pages.class.php: PerchContent_Pages->_template_nav(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> Using template: /templates/navigation/main_navigation.html</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->get_navigation(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/linkedin-profiles' OR pageSortPath='/linkedin-profiles' LIMIT 1</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->get_navigation(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT * FROM perch2_pages WHERE pageNew=0  AND pageHidden=0  AND pageTreePosition LIKE '000-003%'  AND pageDepth &gt;=1 AND pageDepth&lt;=2  ORDER BY pageTreePosition ASC</td></tr><tr><td class="db" title="PerchDB_MySQL.class.php: PerchDB_MySQL->get_value(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/product' LIMIT 1</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->find_parent_page_ids_by_path(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageID FROM perch2_pages WHERE  pageTreePosition IN ('000-019', '000') ORDER BY pageTreePosition DESC</td></tr><tr><td class="template" title="PerchContent_Pages.class.php: PerchContent_Pages->_template_nav(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> Using template: /templates/navigation/main_navigation.html</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->get_navigation(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/interview-coaching' OR pageSortPath='/interview-coaching' LIMIT 1</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->get_navigation(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT * FROM perch2_pages WHERE pageNew=0  AND pageHidden=0  AND pageTreePosition LIKE '000-005%'  AND pageDepth &gt;=1 AND pageDepth&lt;=2  ORDER BY pageTreePosition ASC</td></tr><tr><td class="db" title="PerchDB_MySQL.class.php: PerchDB_MySQL->get_value(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/product' LIMIT 1</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->find_parent_page_ids_by_path(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageID FROM perch2_pages WHERE  pageTreePosition IN ('000-019', '000') ORDER BY pageTreePosition DESC</td></tr><tr><td class="template" title="PerchContent_Pages.class.php: PerchContent_Pages->_template_nav(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> Using template: /templates/navigation/main_navigation.html</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->get_navigation(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/corporate-services' OR pageSortPath='/corporate-services' LIMIT 1</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->get_navigation(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT * FROM perch2_pages WHERE pageNew=0  AND pageHidden=0  AND pageTreePosition LIKE '000-006%'  AND pageDepth &gt;=1 AND pageDepth&lt;=2  ORDER BY pageTreePosition ASC</td></tr><tr><td class="db" title="PerchDB_MySQL.class.php: PerchDB_MySQL->get_value(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/product' LIMIT 1</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->find_parent_page_ids_by_path(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageID FROM perch2_pages WHERE  pageTreePosition IN ('000-019', '000') ORDER BY pageTreePosition DESC</td></tr><tr><td class="template" title="PerchContent_Pages.class.php: PerchContent_Pages->_template_nav(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> Using template: /templates/navigation/main_navigation.html</td></tr><tr><td class="db" title="PerchFactory.class.php: PerchFactory->get_filtered_listing_from_index(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT tbl.* FROM ( SELECT  idx.itemID, main.*,  idx2.indexValue as sortval  FROM perch2_shop_index idx
                            JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID'
                            JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID'  AND idx2.indexKey='_id'  WHERE 1=1  AND ((idx.indexKey='slug' AND idx.indexValue='test-product-1'))  AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey  ) as tbl  WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval  ORDER BY sortval ASC </td></tr><tr><td class="template" title="PerchAPI_Template.class.php: PerchAPI_Template->set(): ">Using template: /templates/shop/products/product.html</td></tr><tr><td class="db" title="PerchShop_Product.class.php: PerchShop_Product->get_variant_select_opts(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products
                WHERE parentID=1 AND productDeleted IS NULL
                ORDER BY productOrder ASC</td></tr><tr><td class="db" title="PerchShop_Options.class.php: PerchShop_Options->get_for_product(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po 
                WHERE o.optionID=po.optionID AND po.productID=1
                    AND o.optionDeleted IS NULL
                ORDER BY optionPrecendence ASC</td></tr><tr><td class="db" title="PerchShop_OptionValues.class.php: PerchShop_OptionValues->get_edit_values(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode
                FROM perch2_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL 
                ORDER BY valueOrder ASC</td></tr><tr><td class="db" title="PerchShop_OptionValues.class.php: PerchShop_OptionValues->get_for_product(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.*
                    FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov
                    WHERE pov.productID='1' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL
                        AND o.optionID='1'
                    ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC</td></tr><tr><td class="db" title="PerchCategories_Categories.class.php: PerchCategories_Categories->get_cat_paths_by_id_runtime(): "> <span class="debug-badge"><span class="debug-brkt">[</span>8<span class="debug-brkt">]</span></span> SELECT catID, catPath FROM perch2_categories</td></tr><tr><td class="db" title="PerchFactory.class.php: PerchFactory->get_one_by(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT * FROM perch2_shop_products WHERE productSlug='test-product-1'  AND productDeleted IS NULL  LIMIT 1</td></tr><tr><td class="db" title="PerchFactory.class.php: PerchFactory->_get_filter_sub_sql(): "> <span class="debug-badge"><span class="debug-brkt">[</span>361<span class="debug-brkt">]</span></span> SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND  idx.itemKey='productID'  AND ((idx.indexKey='status' AND idx.indexValue='1')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1 </td></tr><tr><td class="db" title="PerchFactory.class.php: PerchFactory->_get_filter_sub_sql(): "> <span class="debug-badge"><span class="debug-brkt">[</span>326<span class="debug-brkt">]</span></span> SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND  idx.itemKey='productID'  AND ((idx.indexKey='parentID' AND idx.indexValue='')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1 </td></tr><tr><td class="db" title="PerchFactory.class.php: PerchFactory->get_filtered_listing_from_index(): "> <span class="debug-badge"><span class="debug-brkt">[</span>nil<span class="debug-brkt">]</span></span> SELECT tbl.* FROM ( SELECT  idx.itemID, main.*,  idx2.indexValue as sortval  FROM perch2_shop_index idx
                            JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID'
                            JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID'  AND idx2.indexKey='title'  AND idx.itemID IN ('1', '10', '100', '101', '102', '103', '104', '105', '106', '107', '108', '109', '11', '110', '111', '112', '113', '114', '115', '116', '117', '118', '119', '12', '120', '121', '122', '123', '124', '125', '126', '127', '128', '129', '13', '130', '131', '132', '133', '134', '135', '136', '137', '138', '139', '14', '140', '141', '142', '143', '144', '145', '146', '147', '148', '149', '15', '150', '151', '152', '153', '154', '155', '156', '157', '158', '159', '16', '160', '161', '162', '163', '164', '165', '166', '167', '168', '169', '17', '170', '171', '172', '173', '174', '175', '176', '177', '178', '179', '18', '180', '181', '182', '183', '184', '185', '186', '187', '188', '189', '19', '190', '191', '192', '193', '194', '195', '196', '197', '198', '199', '2', '20', '200', '201', '202', '203', '204', '205', '206', '207', '208', '209', '21', '210', '211', '212', '213', '214', '215', '216', '217', '218', '219', '22', '220', '221', '222', '223', '224', '225', '226', '227', '228', '229', '23', '230', '231', '232', '233', '234', '235', '236', '237', '238', '239', '24', '240', '241', '242', '243', '244', '245', '246', '247', '248', '249', '25', '250', '251', '252', '253', '254', '255', '256', '257', '258', '259', '26', '260', '261', '262', '263', '264', '265', '266', '267', '268', '269', '27', '270', '271', '272', '273', '274', '275', '276', '277', '278', '279', '28', '280', '281', '282', '283', '284', '285', '286', '287', '288', '289', '29', '290', '291', '292', '293', '294', '295', '296', '297', '298', '299', '3', '30', '300', '301', '302', '303', '304', '305', '306', '307', '308', '309', '31', '310', '311', '312', '313', '314', '315', '316', '317', '318', '319', '32', '320', '321', '322', '323', '324', '33', '330', '331', '332', '333', '334', '335', '336', '337', '338', '339', '34', '340', '341', '342', '344', '345', '346', '347', '348', '349', '35', '350', '351', '352', '353', '354', '355', '356', '357', '358', '359', '36', '360', '361', '362', '363', '364', '365', '366', '367', '368', '37', '38', '39', '4', '40', '41', '42', '43', '44', '45', '46', '47', '48', '49', '5', '50', '51', '52', '53', '54', '55', '56', '57', '58', '59', '6', '60', '61', '62', '63', '64', '65', '66', '67', '68', '69', '7', '70', '71', '72', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '83', '84', '85', '86', '87', '88', '89', '9', '90', '91', '92', '93', '94', '95', '96', '97', '98', '99')  AND idx.itemID NOT IN ('1', '10', '100', '101', '102', '103', '104', '105', '106', '107', '108', '109', '11', '110', '111', '112', '113', '114', '115', '116', '117', '118', '119', '12', '120', '121', '122', '123', '124', '125', '126', '127', '128', '129', '13', '130', '131', '132', '133', '134', '135', '136', '137', '138', '139', '14', '140', '141', '142', '143', '144', '145', '146', '147', '148', '149', '150', '151', '152', '153', '154', '155', '156', '157', '158', '159', '160', '161', '162', '163', '164', '165', '166', '167', '168', '169', '170', '171', '172', '173', '174', '175', '176', '177', '178', '179', '180', '181', '182', '183', '184', '185', '186', '187', '188', '189', '19', '190', '191', '192', '193', '194', '195', '196', '197', '198', '199', '20', '200', '201', '202', '203', '204', '205', '206', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '219', '220', '221', '222', '223', '224', '225', '226', '227', '228', '229', '23', '230', '231', '232', '233', '234', '235', '236', '237', '238', '239', '24', '240', '241', '242', '243', '244', '245', '246', '247', '248', '249', '25', '250', '251', '252', '253', '254', '255', '256', '257', '258', '259', '26', '260', '261', '262', '263', '264', '265', '266', '267', '268', '269', '27', '270', '271', '272', '273', '274', '275', '276', '277', '278', '279', '28', '280', '281', '282', '283', '284', '285', '286', '287', '288', '289', '29', '290', '291', '292', '293', '294', '295', '296', '297', '298', '299', '30', '300', '301', '302', '303', '304', '305', '306', '307', '308', '309', '310', '311', '312', '313', '314', '315', '316', '317', '318', '319', '330', '331', '336', '337', '338', '339', '340', '341', '342', '343', '344', '348', '349', '350', '351', '352', '353', '354', '355', '356', '357', '358', '359', '360', '361', '362', '363', '364', '365', '366', '367', '368', '42', '47', '48', '49', '50', '51', '52', '53', '54', '55', '56', '57', '58', '59', '6', '60', '61', '62', '63', '64', '65', '66', '67', '68', '69', '7', '70', '71', '72', '73', '74', '75', '76', '77', '78', '79', '8', '80', '81', '82', '83', '84', '85', '86', '87', '88', '89', '9', '90', '91', '92', '93', '94', '95', '96', '97', '98', '99')  WHERE 1=1  AND ((idx.indexKey='parentID' AND idx.indexValue=1))  AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey  ) as tbl  WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval  ORDER BY sortval ASC </td></tr><tr><td class="template" title="PerchAPI_Template.class.php: PerchAPI_Template->set(): ">Using template: /addons/apps/perch_shop/templates/shop/products/variant_list.html</td></tr><tr><td class="db" title="PerchFactory.class.php: PerchFactory->get_filtered_listing_from_index(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT tbl.* FROM ( SELECT  idx.itemID, main.*,  idx2.indexValue as sortval  FROM perch2_shop_index idx
                            JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID'
                            JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID'  AND idx2.indexKey='_id'  WHERE 1=1  AND ((idx.indexKey='slug' AND idx.indexValue='test-product-1'))  AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey  ) as tbl  WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval  ORDER BY sortval ASC </td></tr><tr><td class="template" title="PerchAPI_Template.class.php: PerchAPI_Template->set(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> Using template: /templates/shop/products/_product_page.html</td></tr><tr><td class="db" title="PerchShop_Product.class.php: PerchShop_Product->get_variant_select_opts(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products
                WHERE parentID=1 AND productDeleted IS NULL
                ORDER BY productOrder ASC</td></tr><tr><td class="db" title="PerchShop_Options.class.php: PerchShop_Options->get_for_product(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po 
                WHERE o.optionID=po.optionID AND po.productID=1
                    AND o.optionDeleted IS NULL
                ORDER BY optionPrecendence ASC</td></tr><tr><td class="db" title="PerchShop_OptionValues.class.php: PerchShop_OptionValues->get_edit_values(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode
                FROM perch2_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL 
                ORDER BY valueOrder ASC</td></tr><tr><td class="db" title="PerchShop_OptionValues.class.php: PerchShop_OptionValues->get_for_product(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.*
                    FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov
                    WHERE pov.productID='1' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL
                        AND o.optionID='1'
                    ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC</td></tr><tr><td class="db" title="PerchContent.class.php: PerchContent->_get_content(): "> <span class="debug-badge"><span class="debug-brkt">[</span>8<span class="debug-brkt">]</span></span> SELECT regionKey, regionHTML FROM perch2_content_regions 
        WHERE regionPage='/product' OR regionPage='*' ORDER BY regionPage DESC</td></tr><tr><td class="db" title="PerchFactory.class.php: PerchFactory->get_filtered_listing_from_index(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT  idx.itemID, main.*,  idx2.indexValue as sortval  FROM perch2_blog_index idx
                            JOIN perch2_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID'
                            JOIN perch2_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID'  AND idx2.indexKey='postDateTime'  WHERE 1=1  AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey  ) as tbl  WHERE (postStatus='Published' AND postDateTime&lt;='2017-01-04 15:59:00' ) GROUP BY itemID, sortval  ORDER BY sortval DESC LIMIT 0, 1</td></tr><tr><td class="db" title="PerchDB_MySQL.class.php: PerchDB_MySQL->get_value(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT FOUND_ROWS() AS `count` </td></tr><tr><td class="template" title="PerchAPI_Template.class.php: PerchAPI_Template->set(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> Using template: /templates/blog/post_in_list_widget.html</td></tr><tr><td class="db" title="PerchFactory.class.php: PerchFactory->all(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT *
                FROM perch2_blog_sections ORDER BY sectionTitle ASC</td></tr><tr><td class="db" title="PerchFactory.class.php: PerchFactory->all(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT *
                FROM perch2_blogs ORDER BY blogTitle ASC</td></tr><tr><td class="template" title="PerchAPI_Template.class.php: PerchAPI_Template->set(): ">Using template: /templates/forms/contact.html</td></tr><tr><td class="log" title="start.php: ">Request time: 0.1174</td></tr><tr><td class="log" title="start.php: ">Process time: 0.1158</td></tr><tr><td class="log" title="start.php: ">Memory: 6.8084</td></tr><tr><td class="error" title="PerchUtil.class.php: PerchUtil->output_debug(): "><pre>Array
(
    [type] =&gt; 8
    [message] =&gt; Undefined index: on_sale
    [file] =&gt; /home/localhost/www/htdocs/cms/addons/apps/perch_shop/lib/PerchShop_Product.class.php
    [line] =&gt; 101
)
</pre></td></tr></tbody></table>
Drew McLellan

Drew McLellan 2638 points
Perch Support

We've just tracked down a bug with perch_shop_product_variants() - should be fixed in the next update.

Damian Drozdowicz

Damian Drozdowicz 0 points
Registered Developer

Thanks Drew. I'm glad we've found it.

Do you think there is a quick fix how to temporarily go around it?

Drew McLellan

Drew McLellan 2638 points
Perch Support

No, but I'll get that update out shortly.

Damian Drozdowicz

Damian Drozdowicz 0 points
Registered Developer

Many thanks Drew!

Damian Drozdowicz

Damian Drozdowicz 0 points
Registered Developer

We tried to downgrade the Perch to 2.8.32 where everything used to worked fine.

Now we are experiencing a PHP error when trying to call perch_shop_product_variants(perch_get('slug'));

Fatal error: Call to undefined function perch_shop_product_variants() in /www/htdocs/cms/templates/pages/product.php on line 9

I wonder what could go wrong?

Diagnostics:

Perch Runway: 2.8.32
Production mode: Production (100)
Installed apps: content (2.8.32), assets (2.8.32), categories (2.8.32), perch_blog (5.0), perch_forms (1.8.3), perch_shop_orders (PERCH_SHOP_VERSION), perch_shop_products (1.0.7), collection_2 (2.8.32), perch_shop (1.0.7), perch_members (1.5)
DB driver: PDO
DB tables: perch2_backup_plans (0), perch2_backup_resources (0), perch2_backup_runs (0), perch2_blog_authors (2), perch2_blog_comments (0), perch2_blog_index (162), perch2_blog_posts (1), perch2_blog_posts_to_tags (2), perch2_blog_sections (1), perch2_blog_tags (2), perch2_blogs (1), perch2_categories (8), perch2_category_counts (1), perch2_category_sets (3), perch2_collection_index (781), perch2_collection_items (86), perch2_collection_revisions (16), perch2_collections (1), perch2_content_index (25798), perch2_content_items (2166), perch2_content_regions (591), perch2_forms (7), perch2_forms_responses (1), perch2_members (31), perch2_members_forms (1), perch2_members_member_tags (0), perch2_members_sessions (0), perch2_members_tags (0), perch2_navigation (0), perch2_navigation_pages (0), perch2_page_routes (154), perch2_page_templates (27), perch2_pages (165), perch2_resource_log (792), perch2_resource_tags (49), perch2_resources (265), perch2_resources_to_tags (61), perch2_settings (41), perch2_shop_addresses (45), perch2_shop_admin_index (30), perch2_shop_brands (1), perch2_shop_cart (787), perch2_shop_cart_data (0), perch2_shop_cart_items (212), perch2_shop_countries (250), perch2_shop_currencies (152), perch2_shop_customers (31), perch2_shop_emails (2), perch2_shop_index (17763), perch2_shop_option_values (39), perch2_shop_options (9), perch2_shop_order_items (13), perch2_shop_order_promotions (2), perch2_shop_order_statuses (9), perch2_shop_orders (12), perch2_shop_orders_meta (1), perch2_shop_product_files (0), perch2_shop_product_option_values (33), perch2_shop_product_options (8), perch2_shop_product_tags (0), perch2_shop_products (372), perch2_shop_promotions (4), perch2_shop_search (363), perch2_shop_shipping_zone_countries (1), perch2_shop_shipping_zones (1), perch2_shop_shippings (1), perch2_shop_tax_exhibits (45), perch2_shop_tax_group_rates (29), perch2_shop_tax_groups (1), perch2_shop_tax_locations (29), perch2_shop_tax_rates (30), perch2_shop_variants (46), perch2_user_passwords (6), perch2_user_privileges (78), perch2_user_role_privileges (16), perch2_user_roles (2), perch2_users (6)
Users: 6
App runtimes:
<?php
    $apps_list = array(
        'content', 
        'categories',
        'perch_blog',
        'perch_forms',
        'perch_members',
        'perch_shop',
    );
Scheduled tasks for perch_blog: delete_spam_comments (1440 mins)
Editor plug-ins: markitup, redactor
H1: 3e4bc6a764d4522dcb518a67758246e7
L1: bed5a8bfe0e04530418296fc36347fb8
F1: 2edba60ed1f613d6dd804feb202456a2
headerColour: #0177b5
content_singlePageEdit: 1
helpURL:
siteURL: /
hideBranding: 1
content_collapseList: 1
lang: en-gb
update_2.8.25: done
latest_version: 2.8.15
on_sale_version: 2.8.34
headerScheme: dark
dashboard: 1
hide_pwd_reset: 0
content_hideNonEditableRegions: 1
content_frontend_edit: 0
logoPath: /cms/resources/www_logo.png
perch_blog_update: 5.0.1
perch_blog_post_url: /blog/{postSlug}
perch_blog_site_name: Sitename
perch_blog_slug_format: {postTitle}
perch_blog_akismet_key:
perch_blog_max_spam_days: 30
perch_blog_comment_notify: 0
update_2.8.29: done
update_2.8.31: done
perch_shop_update: 1.0.7
perch_shop_price_tax_mode: exc
perch_shop_site_url: https://sitename.com
perch_shop_product_url: /product/{slug}
perch_shop_default_currency: 47
perch_shop_reporting_currency: 47
perch_shop_invoice_number_format: INV-%d
perch_members_login_page: /members/login.php?r={returnURL}
perch_members_update: 1.4
update_runway_2.8.31: done
update_runway_2.8.32: done
perch_shop_trade_price_tax_mode: exc
update_runway_2.8.33: done
update_runway_2.8.34: done
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_DB_USERNAME: www_perch
PERCH_DB_SERVER: www.dns-systems.net
PERCH_DB_DATABASE: www_perch
PERCH_SITEPATH: /home/www/host/htdocs
PERCH_DB_PREFIX: perch2_
PERCH_TZ: UTC
PERCH_EMAIL_FROM: admin@admin.com
PERCH_EMAIL_FROM_NAME: Admin
PERCH_LOGINPATH: /cms
PERCH_PATH: /home/www/host/htdocs/cms
PERCH_CORE: /home/www/host/htdocs/cms/core
PERCH_RESFILEPATH: /home/www/host/htdocs/cms/resources
PERCH_RESPATH: /cms/resources
PERCH_HTML5: 1
PERCH_YOUTUBE_API_KEY: AIzaSyBhNJDmq1U8HuaiK3bUDQ2UikU3UqId6OY
PERCH_DEBUG: 1
PERCH_RUNWAY: 1
PERCH_ERROR_MODE: DIE
PERCH_DATE_LONG: %d %B %Y
PERCH_DATE_SHORT: %d %b %Y
PERCH_TIME_SHORT: %H:%M
PERCH_TIME_LONG: %H:%M:%S
PERCH_RUNWAY_ROUTED:
PERCH_STRONG_PASSWORDS:
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /home/www/host/htdocs/cms/templates
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_PRODUCTION_MODE: 100
PERCH_RWD:
PERCH_HTML_ENTITIES:
PERCH_SSL:
PERCH_STRIPSLASHES:
PERCH_PROGRESSIVE_FLUSH: 1
PERCH_PARANOID:
PERCH_FORCE_SECURE_COOKIES:
PERCH_PASSWORD_MIN_LENGTH: 6
PERCH_MAX_FAILED_LOGINS: 10
PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR
PERCH_VERIFY_UPLOADS:
PERCH_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
PERCH_SESSION_TIMEOUT_MINS: 20
PERCH_SHOP_VERSION: 1.0.7
PERCH_APPS_EDITOR_PLUGIN: markitup
PERCH_APPS_EDITOR_MARKUP_LANGUAGE: textile
HOSTING SETTINGS

PHP: 5.6.25
Zend: 2.6.0
OS: Linux
SAPI: apache2handler
Safe mode: not detected
MySQL client: 5.6.33
MySQL server: 5.6.33
Free disk space: 539.81 GB
Extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dbase, dom, hash, fileinfo, filter, ftp, gd, gettext, SPL, iconv, imagick, session, intl, json, mailparse, mbstring, mcrypt, standard, imap, memcached, mssql, mysql, mysqli, OAuth, PDFlib, PDO, pdo_mysql, pdo_sqlite, pspell, Reflection, SimpleXML, soap, ssh2, exif, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, memcache, apache2handler, mhash, ionCube Loader, Zend Guard Loader, Zend OPcache
GD: Yes
ImageMagick: Yes
PHP max upload size: 128M
PHP max form post size: 128M
PHP memory limit: 256M
Total max uploadable file size: 128M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: Yes
UNIQUE_ID: WG5xKlPfagoAAEhDaXcAAAA-
HTTP_HOST: www.dns-systems.net
HTTP_CONNECTION: keep-alive
HTTP_PRAGMA: no-cache
HTTP_CACHE_CONTROL: no-cache
HTTP_UPGRADE_INSECURE_REQUESTS: 1
HTTP_USER_AGENT: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_REFERER: https://www.dns-systems.net/cms/core/settings/diagnostics/
HTTP_ACCEPT_ENCODING: gzip, deflate, sdch
HTTP_ACCEPT_LANGUAGE: en-GB,en-US;q=0.8,en;q=0.6,pl;q=0.4
HTTP_COOKIE: cmssb=0; __distillery=586dbc2_21b79b38-cb66-44a0-947e-2b879e9665b6-1679b8131-379c01ab6627-c0bb; muxData=mux_viewer_id=ca333f86-ad47-4039-be58-a4885f473a47&msn=0.4776333276302458&sid=a8f39f9d-a3d3-4f88-9473-11884635619a&sst=1483525170496&sex=1483527036006; p_m=; cmsa=1; _ga=GA1.2.49413937.1473760650; PHPSESSID=dgfqd7ne13t3m5p3sbqbt0nlm6
PATH: /usr/bin:/bin
SERVER_SIGNATURE: <address>Apache Server at www.dns-systems.net Port 80</address>
SERVER_SOFTWARE: Apache
SERVER_NAME: www.dns-systems.net
SERVER_ADDR: 83.223.106.10
SERVER_PORT: 80
REMOTE_ADDR: 95.103.3.183
DOCUMENT_ROOT: /home/www/host/htdocs/
SERVER_ADMIN: postmaster@www.dns-systems.net
SCRIPT_FILENAME: /home/www/host/htdocs/cms/core/settings/diagnostics/index.php
REMOTE_PORT: 63819
GATEWAY_INTERFACE: CGI/1.1
SERVER_PROTOCOL: HTTP/1.1
REQUEST_METHOD: GET
QUERY_STRING: extended
REQUEST_URI: /cms/core/settings/diagnostics/?extended
SCRIPT_NAME: /cms/core/settings/diagnostics/index.php
PHP_SELF: /cms/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1483632938.833
REQUEST_TIME: 1483632938

Debug msg:

<table class="perch-debug"> <tbody><tr>     <th>Debug Message</th> </tr><tr><td class="db" title="PerchRouter.class.php: PerchRouter->get_route(): "> <span class="debug-badge"><span class="debug-brkt">[</span>238<span class="debug-brkt">]</span></span> SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate FROM perch2_pages p LEFT JOIN perch2_page_routes pr
                ON p.pageID=pr.pageID ORDER BY pr.routeOrder ASC, p.pagePath ASC</td></tr><tr><td class="log" title="PerchRouter.class.php: PerchRouter->get_route(): ">Matched route: product/[slug:slug]</td></tr><tr><td class="routing" title="start.php: ">Using master page: /templates/pages/product.php</td></tr><tr><td class="routing" title="start.php: ">Page arguments: <pre>Array
(
    [0] =&gt; /product/product-test
    [slug] =&gt; product-test
    [1] =&gt; product-test
)
</pre></td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->find_by_path(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT * FROM perch2_pages WHERE pagePath='/product' LIMIT 1</td></tr><tr><td class="db" title="PerchShop_Cart.class.php: PerchShop_Cart->get_cart_field(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT * FROM perch2_shop_cart WHERE cartID=833</td></tr><tr><td class="db" title="PerchShop_Cart.class.php: PerchShop_Cart->get_cart_field(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT * FROM perch2_shop_cart WHERE cartID=833</td></tr><tr><td class="template" title="PerchContent_Page.class.php: PerchContent_Page->template_attributes(): ">Using template: /templates/pages/attributes/seo.html</td></tr><tr><td class="template" title="PerchContent_Page.class.php: PerchContent_Page->template_attributes(): ">Using template: /templates/pages/attributes/facebook.html</td></tr><tr><td class="template" title="PerchContent_Page.class.php: PerchContent_Page->template_attributes(): ">Using template: /templates/pages/attributes/twitter.html</td></tr><tr><td class="db" title="PerchContent_Runway.class.php: PerchContent_Runway->get_collection(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT collectionID, collectionTemplate  FROM perch2_collections WHERE collectionKey='Profiles'</td></tr><tr><td class="db" title="PerchContent_Runway.class.php: PerchContent_Runway->get_collection(): "> <span class="debug-badge"><span class="debug-brkt">[</span>4<span class="debug-brkt">]</span></span> SELECT * FROM ( SELECT  idx.itemID, ci.collectionID, ci.itemJSON,  idx2.indexValue as sortval  FROM perch2_collection_index idx 
                            JOIN perch2_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID
                            JOIN perch2_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID
                            JOIN perch2_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev   AND idx2.indexKey='_order'  WHERE (idx.collectionID=2) AND ((idx.indexKey='live' AND idx.indexValue=1))  AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev
                    ) as tbl GROUP BY itemID, itemJSON, sortval  ORDER BY sortval ASC </td></tr><tr><td class="template" title="PerchContent_Runway.class.php: PerchContent_Runway->get_collection(): "> <span class="debug-badge"><span class="debug-brkt">[</span>4<span class="debug-brkt">]</span></span> Using template: /templates/content/partials/widget_how_can_i_help_you.html</td></tr><tr><td class="db" title="PerchSettings.class.php: PerchSettings->get(): "> <span class="debug-badge"><span class="debug-brkt">[</span>39<span class="debug-brkt">]</span></span> SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0</td></tr><tr><td class="template" title="PerchAPI_Template.class.php: PerchAPI_Template->set(): ">Using template: /templates/forms/callback-request.html</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->get_navigation(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/category' OR pageSortPath='/category' LIMIT 1</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->get_navigation(): "> <span class="debug-badge"><span class="debug-brkt">[</span>6<span class="debug-brkt">]</span></span> SELECT * FROM perch2_pages WHERE pageNew=0  AND pageHidden=0  AND pageTreePosition LIKE '000-004%'  AND pageDepth &gt;=1 AND pageDepth&lt;=2  ORDER BY pageTreePosition ASC</td></tr><tr><td class="db" title="PerchDB_MySQL.class.php: PerchDB_MySQL->get_value(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/product' LIMIT 1</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->find_parent_page_ids_by_path(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageID FROM perch2_pages WHERE  pageTreePosition IN ('000-018', '000') ORDER BY pageTreePosition DESC</td></tr><tr><td class="template" title="PerchContent_Pages.class.php: PerchContent_Pages->_template_nav(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> Using template: /templates/navigation/main_navigation.html</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->get_navigation(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/linkedin-profiles' OR pageSortPath='/linkedin-profiles' LIMIT 1</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->get_navigation(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT * FROM perch2_pages WHERE pageNew=0  AND pageHidden=0  AND pageTreePosition LIKE '000-003%'  AND pageDepth &gt;=1 AND pageDepth&lt;=2  ORDER BY pageTreePosition ASC</td></tr><tr><td class="db" title="PerchDB_MySQL.class.php: PerchDB_MySQL->get_value(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/product' LIMIT 1</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->find_parent_page_ids_by_path(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageID FROM perch2_pages WHERE  pageTreePosition IN ('000-018', '000') ORDER BY pageTreePosition DESC</td></tr><tr><td class="template" title="PerchContent_Pages.class.php: PerchContent_Pages->_template_nav(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> Using template: /templates/navigation/main_navigation.html</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->get_navigation(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/interview-coaching' OR pageSortPath='/interview-coaching' LIMIT 1</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->get_navigation(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT * FROM perch2_pages WHERE pageNew=0  AND pageHidden=0  AND pageTreePosition LIKE '000-005%'  AND pageDepth &gt;=1 AND pageDepth&lt;=2  ORDER BY pageTreePosition ASC</td></tr><tr><td class="db" title="PerchDB_MySQL.class.php: PerchDB_MySQL->get_value(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/product' LIMIT 1</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->find_parent_page_ids_by_path(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageID FROM perch2_pages WHERE  pageTreePosition IN ('000-018', '000') ORDER BY pageTreePosition DESC</td></tr><tr><td class="template" title="PerchContent_Pages.class.php: PerchContent_Pages->_template_nav(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> Using template: /templates/navigation/main_navigation.html</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->get_navigation(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/corporate-services' OR pageSortPath='/corporate-services' LIMIT 1</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->get_navigation(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT * FROM perch2_pages WHERE pageNew=0  AND pageHidden=0  AND pageTreePosition LIKE '000-006%'  AND pageDepth &gt;=1 AND pageDepth&lt;=2  ORDER BY pageTreePosition ASC</td></tr><tr><td class="db" title="PerchDB_MySQL.class.php: PerchDB_MySQL->get_value(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/product' LIMIT 1</td></tr><tr><td class="db" title="PerchContent_Pages.class.php: PerchContent_Pages->find_parent_page_ids_by_path(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT pageID FROM perch2_pages WHERE  pageTreePosition IN ('000-018', '000') ORDER BY pageTreePosition DESC</td></tr><tr><td class="template" title="PerchContent_Pages.class.php: PerchContent_Pages->_template_nav(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> Using template: /templates/navigation/main_navigation.html</td></tr><tr><td class="db" title="PerchFactory.class.php: PerchFactory->get_filtered_listing_from_index(): "> <span class="debug-badge"><span class="debug-brkt">[</span>6<span class="debug-brkt">]</span></span> SELECT tbl.* FROM ( SELECT  idx.itemID, main.*,  idx2.indexValue as sortval  FROM perch2_shop_index idx
                            JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID'
                            JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID'  AND idx2.indexKey='_id'  WHERE 1=1  AND ((idx.indexKey='slug' AND idx.indexValue='product-test'))  AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey  ) as tbl  WHERE (productDeleted IS NULL) GROUP BY itemID, sortval  ORDER BY sortval ASC </td></tr><tr><td class="template" title="PerchAPI_Template.class.php: PerchAPI_Template->set(): ">Using template: /templates/shop/products/product.html</td></tr><tr><td class="db" title="PerchShop_Product.class.php: PerchShop_Product->get_variant_select_opts(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products
                WHERE parentID=1 AND productDeleted IS NULL
                ORDER BY productOrder ASC</td></tr><tr><td class="db" title="PerchShop_Options.class.php: PerchShop_Options->get_for_product(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po 
                WHERE o.optionID=po.optionID AND po.productID=1
                    AND o.optionDeleted IS NULL
                ORDER BY optionPrecendence ASC</td></tr><tr><td class="db" title="PerchShop_OptionValues.class.php: PerchShop_OptionValues->get_edit_values(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode
                FROM perch2_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL 
                ORDER BY valueOrder ASC</td></tr><tr><td class="db" title="PerchShop_OptionValues.class.php: PerchShop_OptionValues->get_for_product(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.*
                    FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov
                    WHERE pov.productID='1' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL
                        AND o.optionID='1'
                    ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC</td></tr><tr><td class="db" title="PerchFactory.class.php: PerchFactory->find(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT * FROM perch2_shop_products WHERE productID=1 AND productDeleted IS NULL  LIMIT 1</td></tr><tr><td class="db" title="PerchShop_Product.class.php: PerchShop_Product->get_variant_select_opts(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products
                WHERE parentID=1 AND productDeleted IS NULL
                ORDER BY productOrder ASC</td></tr><tr><td class="db" title="PerchShop_Options.class.php: PerchShop_Options->get_for_product(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po 
                WHERE o.optionID=po.optionID AND po.productID=1
                    AND o.optionDeleted IS NULL
                ORDER BY optionPrecendence ASC</td></tr><tr><td class="db" title="PerchShop_OptionValues.class.php: PerchShop_OptionValues->get_edit_values(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode
                FROM perch2_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL 
                ORDER BY valueOrder ASC</td></tr><tr><td class="db" title="PerchShop_OptionValues.class.php: PerchShop_OptionValues->get_for_product(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.*
                    FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov
                    WHERE pov.productID='1' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL
                        AND o.optionID='1'
                    ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC</td></tr><tr><td class="db" title="PerchFactory.class.php: PerchFactory->find(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT * FROM perch2_shop_products WHERE productID=1 AND productDeleted IS NULL  LIMIT 1</td></tr><tr><td class="db" title="PerchShop_Product.class.php: PerchShop_Product->get_variant_select_opts(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products
                WHERE parentID=1 AND productDeleted IS NULL
                ORDER BY productOrder ASC</td></tr><tr><td class="db" title="PerchShop_Options.class.php: PerchShop_Options->get_for_product(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po 
                WHERE o.optionID=po.optionID AND po.productID=1
                    AND o.optionDeleted IS NULL
                ORDER BY optionPrecendence ASC</td></tr><tr><td class="db" title="PerchShop_OptionValues.class.php: PerchShop_OptionValues->get_edit_values(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode
                FROM perch2_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL 
                ORDER BY valueOrder ASC</td></tr><tr><td class="db" title="PerchShop_OptionValues.class.php: PerchShop_OptionValues->get_for_product(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.*
                    FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov
                    WHERE pov.productID='1' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL
                        AND o.optionID='1'
                    ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC</td></tr><tr><td class="db" title="PerchFactory.class.php: PerchFactory->find(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT * FROM perch2_shop_products WHERE productID=1 AND productDeleted IS NULL  LIMIT 1</td></tr><tr><td class="db" title="PerchShop_Product.class.php: PerchShop_Product->get_variant_select_opts(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products
                WHERE parentID=1 AND productDeleted IS NULL
                ORDER BY productOrder ASC</td></tr><tr><td class="db" title="PerchShop_Options.class.php: PerchShop_Options->get_for_product(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po 
                WHERE o.optionID=po.optionID AND po.productID=1
                    AND o.optionDeleted IS NULL
                ORDER BY optionPrecendence ASC</td></tr><tr><td class="db" title="PerchShop_OptionValues.class.php: PerchShop_OptionValues->get_edit_values(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode
                FROM perch2_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL 
                ORDER BY valueOrder ASC</td></tr><tr><td class="db" title="PerchShop_OptionValues.class.php: PerchShop_OptionValues->get_for_product(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.*
                    FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov
                    WHERE pov.productID='1' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL
                        AND o.optionID='1'
                    ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC</td></tr><tr><td class="db" title="PerchFactory.class.php: PerchFactory->find(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT * FROM perch2_shop_products WHERE productID=1 AND productDeleted IS NULL  LIMIT 1</td></tr><tr><td class="db" title="PerchShop_Product.class.php: PerchShop_Product->get_variant_select_opts(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products
                WHERE parentID=1 AND productDeleted IS NULL
                ORDER BY productOrder ASC</td></tr><tr><td class="db" title="PerchShop_Options.class.php: PerchShop_Options->get_for_product(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po 
                WHERE o.optionID=po.optionID AND po.productID=1
                    AND o.optionDeleted IS NULL
                ORDER BY optionPrecendence ASC</td></tr><tr><td class="db" title="PerchShop_OptionValues.class.php: PerchShop_OptionValues->get_edit_values(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode
                FROM perch2_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL 
                ORDER BY valueOrder ASC</td></tr><tr><td class="db" title="PerchShop_OptionValues.class.php: PerchShop_OptionValues->get_for_product(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.*
                    FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov
                    WHERE pov.productID='1' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL
                        AND o.optionID='1'
                    ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC</td></tr><tr><td class="db" title="PerchFactory.class.php: PerchFactory->find(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT * FROM perch2_shop_products WHERE productID=1 AND productDeleted IS NULL  LIMIT 1</td></tr><tr><td class="db" title="PerchShop_Product.class.php: PerchShop_Product->get_variant_select_opts(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products
                WHERE parentID=1 AND productDeleted IS NULL
                ORDER BY productOrder ASC</td></tr><tr><td class="db" title="PerchShop_Options.class.php: PerchShop_Options->get_for_product(): "> <span class="debug-badge"><span class="debug-brkt">[</span>1<span class="debug-brkt">]</span></span> SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po 
                WHERE o.optionID=po.optionID AND po.productID=1
                    AND o.optionDeleted IS NULL
                ORDER BY optionPrecendence ASC</td></tr><tr><td class="db" title="PerchShop_OptionValues.class.php: PerchShop_OptionValues->get_edit_values(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode
                FROM perch2_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL 
                ORDER BY valueOrder ASC</td></tr><tr><td class="db" title="PerchShop_OptionValues.class.php: PerchShop_OptionValues->get_for_product(): "> <span class="debug-badge"><span class="debug-brkt">[</span>5<span class="debug-brkt">]</span></span> SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.*
                    FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov
                    WHERE pov.productID='1' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL
                        AND o.optionID='1'
                    ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC</td></tr><tr><td class="db" title="PerchCategories_Categories.class.php: PerchCategories_Categories->get_cat_paths_by_id_runtime(): "> <span class="debug-badge"><span class="debug-brkt">[</span>8<span class="debug-brkt">]</span></span> SELECT catID, catPath FROM perch2_categories</td></tr><tr><td class="error" title="PerchUtil.class.php: PerchUtil->output_debug(): "><pre>Array
(
    [type] =&gt; 8
    [message] =&gt; Undefined index: on_sale
    [file] =&gt; /home/host/htdocs/cms/addons/apps/perch_shop/lib/PerchShop_Product.class.php
    [line] =&gt; 100
)
</pre></td></tr></tbody></table>
Drew McLellan

Drew McLellan 2638 points
Perch Support

Downgrading isn't supported. I've no idea what might happen if you try to do that.

The only supported solution would be to roll back both database and files to the backups you took before the update.

Damian Drozdowicz

Damian Drozdowicz 0 points
Registered Developer

Thanks for letting me know.

I wonder if there is any info on when the patch will be available?

Drew McLellan

Drew McLellan 2638 points
Perch Support

It would have been today, but the forum has been busy. So tomorrow morning if I can.

Damian Drozdowicz

Damian Drozdowicz 0 points
Registered Developer

I wonder if there is an update available on this?

Duncan Revell

Duncan Revell 78 points
Registered Developer

Damian,

I think Perch shop 1.0.11 fixed this:

https://docs.grabaperch.com/addons/shop/changelog/

Damian Drozdowicz

Damian Drozdowicz 0 points
Registered Developer

Brilliant! Thanks a lot.