Forum

Thread tagged as: Problem, Shop

Missing Countries List

I am in the process of setting up a Perch site with Perch shop and am experiencing an issue with missing country lists in the tax locations and shipping zones tabs.

I've checked the perch2_shop_countries table and this is empty.

Diagnostics below



GeneralEmailScheduled tasksDiagnostics
Viewing Diagnostic Information
Diagnostics report
PERCH INFORMATION

Perch: 2.8.29
Production mode: Production (100)
Installed apps: content (2.8.29), assets (2.8.29), categories (2.8.29), perch_shop_orders (1.0.2), perch_shop_products (1.0.2), perch_shop (1.0.2), perch_members (1.5)
DB driver: PDO
DB tables: perch2_categories (0), perch2_category_counts (0), perch2_category_sets (1), perch2_content_index (0), perch2_content_items (0), perch2_content_regions (0), perch2_members (1), perch2_members_forms (0), perch2_members_member_tags (0), perch2_members_sessions (0), perch2_members_tags (0), perch2_navigation (0), perch2_navigation_pages (0), perch2_page_templates (0), perch2_pages (0), perch2_resource_log (0), perch2_resource_tags (0), perch2_resources (0), perch2_resources_to_tags (0), perch2_settings (23), perch2_shop_addresses (0), perch2_shop_admin_index (0), perch2_shop_brands (1), perch2_shop_cart (1), perch2_shop_cart_data (0), perch2_shop_cart_items (0), perch2_shop_countries (0), perch2_shop_currencies (152), perch2_shop_customers (0), perch2_shop_emails (1), perch2_shop_index (46), perch2_shop_option_values (0), perch2_shop_options (0), perch2_shop_order_items (0), perch2_shop_order_promotions (0), perch2_shop_order_statuses (9), perch2_shop_orders (0), perch2_shop_orders_meta (1), perch2_shop_product_files (0), perch2_shop_product_option_values (0), perch2_shop_product_options (0), perch2_shop_product_tags (0), perch2_shop_products (1), perch2_shop_promotions (0), perch2_shop_search (1), perch2_shop_shipping_zone_countries (0), perch2_shop_shipping_zones (0), perch2_shop_shippings (0), perch2_shop_tax_exhibits (0), perch2_shop_tax_group_rates (2), perch2_shop_tax_groups (1), perch2_shop_tax_locations (2), perch2_shop_tax_rates (0), perch2_shop_variants (0), perch2_user_passwords (0), perch2_user_privileges (28), perch2_user_role_privileges (16), perch2_user_roles (2), perch2_users (1)
Users: 1
App runtimes:
<?php
    $apps_list = array(
        'content', 
        'categories',
        'perch_members',
        'perch_shop',        
    );
Editor plug-ins: markitup
H1: bc7aa741f3b395466156e719ee9a3480
L1: f5c14890cecdbb53d09849e1d4a575b2
F1: 2edba60ed1f613d6dd804feb202456a2
headerColour: #ffffff
content_singlePageEdit: 1
helpURL:
siteURL: /
hideBranding: 0
content_collapseList: 1
lang: en-gb
update_2.8.29: done
latest_version: 2.8.15
on_sale_version: 2.8.29
headerScheme: light
perch_members_login_page: /members/login.php?r={returnURL}
perch_shop_price_tax_mode: exc
perch_shop_site_url: https://
perch_shop_product_url: /shop/products/{slug}
perch_shop_default_currency: 47
perch_shop_reporting_currency: 47
perch_shop_invoice_number_format: Invoice%d
dashboard: 0
hide_pwd_reset: 0
content_hideNonEditableRegions: 0
content_frontend_edit: 0
perch_members_update: 1.4
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_DB_USERNAME: perch_admin
PERCH_DB_SERVER: localhost
PERCH_DB_DATABASE: perch
PERCH_DB_PREFIX: perch2_
PERCH_TZ: Europe/London
PERCH_EMAIL_FROM: lee@getunified.co.uk
PERCH_EMAIL_FROM_NAME: Lee Goodman
PERCH_LOGINPATH: /perch
PERCH_PATH: C:\wamp\www\prototype.perch\perch
PERCH_CORE: C:\wamp\www\prototype.perch\perch\core
PERCH_RESFILEPATH: C:\wamp\www\prototype.perch\perch\resources
PERCH_RESPATH: /perch/resources
PERCH_HTML5: 1
PERCH_DEBUG: 1
PERCH_RUNWAY:
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: C:\wamp\www\prototype.perch\perch\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_APPS_EDITOR_PLUGIN: markitup
PERCH_APPS_EDITOR_MARKUP_LANGUAGE: textile
HOSTING SETTINGS

PHP: 5.4.12
Zend: 2.4.0
OS: WINNT
SAPI: apache2handler
Safe mode: not detected
MySQL client: mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $
MySQL server: 5.6.12-log
Free disk space: 497.68 GB
Extensions: Core, bcmath, calendar, com_dotnet, ctype, date, ereg, filter, ftp, hash, iconv, json, mcrypt, SPL, odbc, pcre, Reflection, session, standard, mysqlnd, tokenizer, zip, zlib, libxml, dom, PDO, openssl, SimpleXML, wddx, xml, xmlreader, xmlwriter, apache2handler, curl, fileinfo, gd, intl, mbstring, mysql, mysqli, Phar, pdo_mysql, pdo_sqlite, mhash, xdebug
GD: Yes
ImageMagick: No
PHP max upload size: 120M
PHP max form post size: 120M
PHP memory limit: 128M
Total max uploadable file size: 120M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: Yes
HTTP_HOST: prototype.perch
HTTP_CONNECTION: keep-alive
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_UPGRADE_INSECURE_REQUESTS: 1
HTTP_USER_AGENT: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.102 Safari/537.36
HTTP_REFERER: https://prototype.perch/perch/core/settings/diagnostics/
HTTP_ACCEPT_ENCODING: gzip, deflate, sdch
HTTP_ACCEPT_LANGUAGE: en-GB,en-US;q=0.8,en;q=0.6
HTTP_COOKIE: cmsa=1; PHPSESSID=tafnaqlg5ffl99snid1u5me6f3
PATH: C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Common Files\Acronis\SnapAPI\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x64;C:\Program Files (x86)\Windows Kits\8.0\Windows Performance Toolkit\;C:\Program Files (x86)\Skype\Phone\;C:\Program Files (x86)\nodejs\;C:\WINDOWS\system32\config\systemprofile\.dnx\bin;C:\Program Files\Microsoft DNX\Dnvm\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;
SystemRoot: C:\WINDOWS
COMSPEC: C:\WINDOWS\system32\cmd.exe
PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
WINDIR: C:\WINDOWS
SERVER_SOFTWARE: Apache/2.4.4 (Win64) PHP/5.4.12
SERVER_NAME: prototype.perch
SERVER_ADDR: 127.0.0.1
SERVER_PORT: 80
REMOTE_ADDR: 127.0.0.1
DOCUMENT_ROOT: c:/wamp/www/prototype.perch
REQUEST_SCHEME: http
CONTEXT_DOCUMENT_ROOT: c:/wamp/www/prototype.perch
SERVER_ADMIN: admin@example.com
SCRIPT_FILENAME: C:/wamp/www/prototype.perch/perch/core/settings/diagnostics/index.php
REMOTE_PORT: 51295
GATEWAY_INTERFACE: CGI/1.1
SERVER_PROTOCOL: HTTP/1.1
REQUEST_METHOD: GET
QUERY_STRING: extended
REQUEST_URI: /perch/core/settings/diagnostics/?extended
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
PHP_SELF: /perch/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1465029093.602
REQUEST_TIME: 1465029093

Many thanks
Lee Goodman

Lee Goodman 0 points

  • 5 years ago
Lee Goodman

Lee Goodman 0 points

5 years ago

This maybe a separate issue but I am not seeing any products when I list them out either. I've created two dummy products and just used a default perch_shop_products(); page function to list them and I get nothing.

Debug Message
[1] SELECT * FROM perch2_pages WHERE pagePath='/home.php' LIMIT 1
[1] SELECT * FROM perch2_shop_cart WHERE cartID=2
[1] SELECT * FROM perch2_shop_cart WHERE cartID=2
Using template: \templates\pages\attributes\seo.html
[0] 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
[2] 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
[nil] 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 (NULL) AND idx.itemID IN ('1', '2') WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[23] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
Using template: \templates\shop\products\list.html
[0] 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
[2] 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
[nil] 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 (NULL) AND idx.itemID IN ('1', '2') WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
Using template: \templates\shop\products\list.html
[3] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/home.php' OR regionPage='*' ORDER BY regionPage DESC

I have checked perch2_shop_products and there are two products in there, I'm literally just trying to demo shop to determine it's suitability for a project so any guidance on this would be hugely appreciated, I've already lost a lot of time :-(

Many thanks

Lee
Lee Goodman

Lee Goodman 0 points

5 years ago

I've just tried using a Runway developer license, and countries list is still missing. I've also noticed the categories are not available for selection when adding a product despite having created category sets and a test category using the default templates. I think I'm ready to throw my toys out the pram after a wasted Saturday morning!! :-(
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

We're looking at the missing country list issue today. I'm not sure what the cause is, but it's likely a MySQL setting that we need to work around.
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

This should be fixed in the current version.
Lee Goodman

Lee Goodman 0 points

5 years ago

Thanks Drew, I will download and try again. Did you experience the missing products / categories also? Or is this unrelated.
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

Was your category set called Products? If not, you'll need to update the product.html template to use your new set.