Forum

Thread tagged as: Question, Shop

Missing Tax Evidence

Hi,

Everything apart from the IP address is missing from my Tax Evidence page for orders. This is my extended debug:

PERCH INFORMATION

Perch Runway: 2.8.29
Production mode: Production (100)
Installed apps: content (2.8.29), assets (2.8.29), categories (2.8.29), perch_forms (1.8.3), perch_mailchimp (2.0.1), perch_shop_orders (1.0), perch_shop_products (1.0), perch_shop (1.0), perch_members (1.5)
DB driver: PDO
DB tables: clocks_backup_plans (1), clocks_backup_resources (330), clocks_backup_runs (67), clocks_categories (7), clocks_category_counts (0), clocks_category_sets (2), clocks_collection_index (0), clocks_collection_items (0), clocks_collection_revisions (0), clocks_collections (0), clocks_content_index (4537), clocks_content_items (149), clocks_content_regions (27), clocks_forms (1), clocks_forms_responses (92), clocks_mailchimp_campaigns (0), clocks_mailchimp_history (76), clocks_mailchimp_log (0), clocks_mailchimp_stats (1), clocks_mailchimp_subscribers (491), clocks_members (826), clocks_members_forms (3), clocks_members_member_tags (79), clocks_members_sessions (14), clocks_members_tags (2), clocks_navigation (0), clocks_navigation_pages (0), clocks_page_routes (3), clocks_page_templates (62), clocks_pages (59), clocks_resource_log (2287), clocks_resource_tags (0), clocks_resources (3750), clocks_resources_to_tags (0), clocks_scheduled_tasks (24), clocks_settings (41), clocks_shop_addresses (1287), clocks_shop_admin_index (27), clocks_shop_brands (1), clocks_shop_cart (369706), clocks_shop_cart_data (3076), clocks_shop_cart_items (2588), clocks_shop_countries (248), clocks_shop_currencies (152), clocks_shop_customers (703), clocks_shop_emails (2), clocks_shop_index (20238), clocks_shop_option_values (0), clocks_shop_options (0), clocks_shop_order_items (1336), clocks_shop_order_promotions (0), clocks_shop_order_statuses (10), clocks_shop_orders (646), clocks_shop_orders_meta (1), clocks_shop_product_files (0), clocks_shop_product_option_values (0), clocks_shop_product_options (0), clocks_shop_product_tags (0), clocks_shop_products (295), clocks_shop_promotions (1), clocks_shop_search (328), clocks_shop_shipping_zone_countries (1), clocks_shop_shipping_zones (1), clocks_shop_shippings (1), clocks_shop_tax_exhibits (2265), clocks_shop_tax_group_rates (2), clocks_shop_tax_groups (1), clocks_shop_tax_locations (2), clocks_shop_tax_rates (2), clocks_shop_variants (0), clocks_user_passwords (3), clocks_user_privileges (35), clocks_user_role_privileges (12), clocks_user_roles (1), clocks_users (10)
Users: 10
App runtimes:
<?php
    $apps_list = array(
        'content', 
        'categories',
        'perch_forms',
        'perch_members',
        'perch_shop',
        'perch_mailchimp'
    );
Scheduled tasks for perch_mailchimp: update_list_stats (60 mins)
Scheduled tasks for Backup: plan_1 (10 mins)
Editor plug-ins: markitup
H1: 1a91fda3daee62a0c6851853c4d42f03
L1: 8db4d3366081207744442721cf335c1b
F1: 2edba60ed1f613d6dd804feb202456a2
headerColour: #000000
content_singlePageEdit: 1
hideBranding: 1
content_collapseList: 1
lang: en-gb
update_2.8.19: done
headerScheme: dark
update_runway_2.8.19: done
latest_version: 2.8.15
on_sale_version: 2.8.29
hide_pwd_reset: 1
dashboard: 0
content_hideNonEditableRegions: 1
content_frontend_edit: 0
perch_shop_price_tax_mode: inc
perch_shop_site_url: https://www.newgateclocks.com
perch_shop_default_currency: 47
perch_members_login_page: /trade?r={returnURL}
perch_shop_update: g33
perch_members_update: 1.4
perch_mailchimp_secret: 991187f885f3d4b6d06dbf642b1ada73
perch_mailchimp_update: 2.0
perch_mailchimp_api_key: 96f550754104cd3a3041562bf6adf0e4-us12
perch_mailchimp_list_id: d7d3a95a63
perch_mailchimp_campaign_url: /mailchimp/campaign.php?s={campaignSlug}
siteURL: https://newgateclocks.com
update_runway_2.8.21: done
logoPath: /admin/resources/1452605170_newgate-header-logo copy.png
update_runway_2.8.23: done
update_runway_2.8.24: done
update_runway_2.8.25: done
perch_shop_trade_price_tax_mode: exc
perch_shop_product_url: /shop/products/{slug}
update_runway_2.8.26: done
helpURL:
perch_shop_reporting_currency: 47
perch_shop_invoice_number_format: #%d
update_runway_2.8.28: done
update_runway_2.8.29: done
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_SITEPATH: /home/newgateclocks/public_html
PERCH_SCHEDULE_SECRET: bpfqEnYJVBFT6qGS
PERCH_DB_USERNAME: newgatec_user
PERCH_DB_SERVER: localhost
PERCH_DB_DATABASE: newgatec_db
PERCH_DB_PREFIX: clocks_
PERCH_EMAIL_FROM: admin@newgateclocks.com
PERCH_EMAIL_FROM_NAME: Newgate Clocks
PERCH_LOGINPATH: /admin
PERCH_PATH: /home/newgateclocks/public_html/admin
PERCH_CORE: /home/newgateclocks/public_html/admin/core
PERCH_RESFILEPATH: /home/newgateclocks/public_html/admin/resources
PERCH_RESPATH: /admin/resources
PERCH_HTML5: 1
PERCH_TZ: UTC
PERCH_SSL: 1
PERCH_EMAIL_METHOD: smtp
PERCH_EMAIL_HOST: smtp.mandrillapp.com
PERCH_EMAIL_SECURE: tls
PERCH_EMAIL_AUTH: 1
PERCH_EMAIL_PORT: 587
PERCH_EMAIL_USERNAME: mike.harrison@newgateclocks.com
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_DEBUG:
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /home/newgateclocks/public_html/admin/templates
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_PRODUCTION_MODE: 100
PERCH_RWD:
PERCH_HTML_ENTITIES:
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.5.32
Zend: 2.5.0
OS: Linux
SAPI: cgi-fcgi
Safe mode: not detected
MySQL client: mysqlnd 5.0.11-dev - 20120503 - $Id: 15d5c781cfcad91193dceae1d2cdd127674ddb3e $
MySQL server: 5.5.48-cll
Free disk space: 14.31 GB
Extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, calendar, ctype, curl, dom, fileinfo, filter, ftp, gd, hash, iconv, SPL, json, mbstring, session, mysql, standard, Phar, posix, Reflection, mysqlnd, SimpleXML, sockets, imap, tokenizer, xml, xmlreader, xmlwriter, cgi-fcgi, PDO, pdo_sqlite, pdo_mysql
GD: Yes
ImageMagick: No
PHP max upload size: 20M
PHP max form post size: 8M
PHP memory limit: 64M
Total max uploadable file size: 8M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: No
DOCUMENT_ROOT: /home/newgateclocks/public_html
GATEWAY_INTERFACE: CGI/1.1
HTTPS: on
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_ACCEPT_ENCODING: gzip, deflate, sdch
HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.8,fr;q=0.6,it;q=0.4
HTTP_CONNECTION: keep-alive
HTTP_COOKIE: cmssb=0; p_m=; __utma=150899881.1592446217.1450715762.1460561103.1460964831.168; __utmc=150899881; __utmz=150899881.1460558422.166.51.utmcsr=newgateclocks.dev|utmccn=(referral)|utmcmd=referral|utmcct=/admin/addons/apps/perch_shop/shippings/; cmsa=1; PHPSESSID=04faeb92f7110232e0a5f606826a0cdb
HTTP_HOST: newgateclocks.com
HTTP_REFERER: https://newgateclocks.com/admin/core/settings/diagnostics/
HTTP_UPGRADE_INSECURE_REQUESTS: 1
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.110 Safari/537.36
PATH: /bin:/usr/bin
QUERY_STRING: extended
REDIRECT_STATUS: 200
REMOTE_ADDR: 81.149.203.81
REMOTE_PORT: 57664
REQUEST_METHOD: GET
REQUEST_URI: /admin/core/settings/diagnostics/?extended
SCRIPT_FILENAME: /home/newgateclocks/public_html/admin/core/settings/diagnostics/index.php
SCRIPT_NAME: /admin/core/settings/diagnostics/index.php
SERVER_ADDR: 70.32.82.107
SERVER_ADMIN: webmaster@newgateclocks.com
SERVER_NAME: newgateclocks.com
SERVER_PORT: 443
SERVER_PROTOCOL: HTTP/1.1
SERVER_SOFTWARE: Apache
SSL_TLS_SNI: newgateclocks.com
UNIQUE_ID: VxXqfkYgUmsAAEkRXRIAAAAE
proto: https
PHP_SELF: /admin/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1461054078.46
REQUEST_TIME: 1461054078
argc: 1

This is the debug on the page:

SELECT u.*, r.* FROM clocks_users u, clocks_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='d3e4793b24abda0b475410231a0b63c7' LIMIT 1
UPDATE clocks_users SET userHash='1e61385ab787f88b8fa1e6c05443fbad' WHERE userID='1'
[35] SELECT p.privKey FROM clocks_user_privileges p
[39] SELECT * FROM (SELECT DISTINCT settingID, settingValue, userID FROM clocks_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID, settingValue, userID
[nil] SELECT collectionID, collectionKey, collectionEditRoles FROM clocks_collections WHERE collectionInAppMenu=1 ORDER BY collectionOrder ASC
[1] SELECT * FROM clocks_shop_orders WHERE orderID='653' AND orderDeleted IS NULL LIMIT 1
[1] SELECT * FROM clocks_shop_tax_exhibits WHERE orderID='653' ORDER BY exhibitDate ASC
[1] SELECT * FROM clocks_shop_countries WHERE countryID=0 LIMIT 1
Queries: 9
Memory: 3.8482

This isn't something major but it is useful to have

Mike Harrison

Mike Harrison 37 points

  • 5 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Which payment gateway are you using?

Using Stripe

Drew McLellan

Drew McLellan 2638 points
Perch Support

Found and fixed, thanks.