Forum

Thread tagged as: Problem, Error, Shop

Perch Shop Missing Country List - again

Hi guys

I am still experiencing the problem with missing country lists. I have created a new perch site from scratch, installed the Perch shop as per the instructions and have begun to work my way through the configuration steps in order as presented by the Shop app in the CMS. I have got to the stage of adding a tax location as per the instruction "Create a home tax location for tax calculation purposes."

I am using a WAMP environment on Windows 10.1 and my diagnostics are below:

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.5), perch_shop_products (1.0.5), perch_shop (1.0.5), 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 (3), perch2_navigation (0), perch2_navigation_pages (0), perch2_page_templates (2), perch2_pages (1), 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 (0), perch2_shop_cart (0), perch2_shop_cart_data (0), perch2_shop_cart_items (0), perch2_shop_countries (0), perch2_shop_currencies (1), perch2_shop_customers (0), perch2_shop_emails (0), perch2_shop_index (0), perch2_shop_option_values (0), perch2_shop_options (0), perch2_shop_order_items (0), perch2_shop_order_promotions (0), perch2_shop_order_statuses (0), perch2_shop_orders (0), perch2_shop_orders_meta (0), perch2_shop_product_files (0), perch2_shop_product_option_values (0), perch2_shop_product_options (0), perch2_shop_product_tags (0), perch2_shop_products (0), perch2_shop_promotions (0), perch2_shop_search (0), 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 (0), perch2_shop_tax_groups (0), perch2_shop_tax_locations (0), perch2_shop_tax_rates (0), perch2_shop_variants (0), perch2_user_passwords (0), perch2_user_privileges (64), 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: e9a51b2d1355bf65603c35210c0fa3cf
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
perch_shop_update: 1.0.5
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: 1
perch_shop_reporting_currency: 1
perch_shop_invoice_number_format: Invoice%d
dashboard: 0
hide_pwd_reset: 0
content_hideNonEditableRegions: 0
content_frontend_edit: 0
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_DB_USERNAME: ecogen_admin
PERCH_DB_SERVER: localhost
PERCH_DB_DATABASE: ecogen
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\ecogen\perch
PERCH_CORE: C:\wamp\www\ecogen\perch\core
PERCH_RESFILEPATH: C:\wamp\www\ecogen\perch\resources
PERCH_RESPATH: /perch/resources
PERCH_HTML5: 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_DEBUG:
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: C:\wamp\www\ecogen\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_SHOP_VERSION: 1.0.5
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: 487.86 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: ecogen
HTTP_CONNECTION: keep-alive
HTTP_UPGRADE_INSECURE_REQUESTS: 1
HTTP_USER_AGENT: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_REFERER: https://ecogen/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=qksc4opbsfl7qcju0c1oqj7jr0
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: ecogen
SERVER_ADDR: 127.0.0.1
SERVER_PORT: 80
REMOTE_ADDR: 127.0.0.1
DOCUMENT_ROOT: c:/wamp/www/ecogen
REQUEST_SCHEME: http
CONTEXT_DOCUMENT_ROOT: c:/wamp/www/ecogen
SERVER_ADMIN: admin@example.com
SCRIPT_FILENAME: C:/wamp/www/ecogen/perch/core/settings/diagnostics/index.php
REMOTE_PORT: 31655
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: 1466593673.759
REQUEST_TIME: 1466593673

Many thanks

Lee

Lee Goodman

Lee Goodman 0 points

  • 5 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

This looks like a different problem. You're also missing emails, currencies, order meta and statuses. Basically the full set of default data.

What happened during install?

I'm yet to get a successful shop install so I don't know exactly how it all should look, but after set up I noticed that it said "upgraded to 1.0.5" even though this is a completely new site.

I literally created a new empty folder and hosts entry and copied in my downloaded Perch and Perch Shop files. One thing I did do was repurpose an existing license in Perch admin, this license was previously a floating Perch license I had been using for testing and I had attempted to set up a Perch shop previously using different domain details and different local site, this is when I first experienced the missing countries problem.

Not sure if that is relevant at all but I can not think of anything else.

Drew McLellan

Drew McLellan 2638 points
Perch Support

No errors displayed and nothing logged in your error log?

Drew McLellan

Drew McLellan 2638 points
Perch Support

Ah, ok, I've found the issue. Drop your perch2_shop... database tables and visit the Shop app again and you should be fine.

Ah ha!! That worked, I now have countries listed. Thanks Drew!

Drew another error when walking through config steps


! ) Fatal error: Call to a member function index() on a non-object in C:\wamp\www\ecogen\perch\addons\apps\perch_shop\modes\shipping.edit.pre.php on line 45 Call Stack # Time Memory Function Location 1 0.0006 258576 {main}( ) ..\index.php:0 2 0.0010 268480 include( 'C:\wamp\www\ecogen\perch\addons\apps\perch_shop\_default_index.php' ) ..\index.php:4 3 0.1675 4243776 include( 'C:\wamp\www\ecogen\perch\addons\apps\perch_shop\modes\shipping.edit.pre.php' ) ..\_default_index.php:21
Drew McLellan

Drew McLellan 2638 points
Perch Support

What Priority have you set?

Ah ha - I haven't. Have to admit I missed that one, although there is no default or asterisk to denote a required field. Cheers Drew

It looks like I have Green lights all the way, now to test pulling products on to a page! Thanks again.