Forum

Thread tagged as: Problem, Error, Shop

No Shipping or Billing Address created during the register process

Hi

As you know i have been having issues with non shipping products during the beta testing. I know it is because the billing address and shipping address are not being created during the register process. I have used the default customer_create,html template that come with shop 1.0. with debug on here is the output

debug

when i use the demo on your site i get this demo image

my checkout does not have the shipping and billing demo image

once i get the no address error it does not go to the result page it stays on the checkout page.

here is the perch2_shop_cart table

database

Do you know what the issue is. I did install the github nest files locally and got the same error, i do remember that you used a script to copy the billing address to the shipping address and it looks like you are using that on your demo site.

Any help would be appreciated.

Regards,

Brett

Brett Warne

Brett Warne 0 points

  • 5 years ago
Rachel Andrew

Rachel Andrew 394 points
Perch Support

Hi Brett

please post your Diagnostics Report with any post to the forum.

As you were on the beta we need to know whether this is an update from a gamma version or a fresh install.

Viewing Diagnostic Information
Diagnostics report
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_blog (5.0), collection_2 (2.8.29), perch_forms (1.8.3), perch_gallery (2.8.6), perch_shop_orders (1.0), perch_shop_products (1.0), perch_shop (1.0), collection_1 (2.8.29), perch_members (1.5), perch_backup (1.2)
    DB driver: PDO
    DB tables: perch2_backup_plans (0), perch2_backup_resources (0), perch2_backup_runs (0), perch2_blog_authors (3), perch2_blog_categories (1), perch2_blog_comments (0), perch2_blog_index (571), perch2_blog_posts (21), perch2_blog_posts_to_categories (15), perch2_blog_posts_to_tags (21), perch2_blog_sections (1), perch2_blog_tags (7), perch2_blogs (1), perch2_categories (2), perch2_category_counts (1), perch2_category_sets (2), perch2_collection_index (157), perch2_collection_items (42), perch2_collection_revisions (21), perch2_collections (2), perch2_content_index (313), perch2_content_items (101), perch2_content_regions (46), perch2_gallery_albums (1), perch2_gallery_image_versions (30), perch2_gallery_images (5), perch2_members (7), perch2_members_forms (2), perch2_members_member_tags (0), perch2_members_sessions (1), perch2_members_tags (0), perch2_navigation (0), perch2_navigation_pages (0), perch2_page_routes (0), perch2_page_templates (25), perch2_pages (24), perch2_resource_log (41), perch2_resource_tags (0), perch2_resources (25), perch2_resources_to_tags (0), perch2_settings (39), perch2_shop_addresses (0), perch2_shop_admin_index (25), perch2_shop_brands (1), perch2_shop_cart (5), perch2_shop_cart_data (33), perch2_shop_cart_items (7), perch2_shop_countries (248), perch2_shop_currencies (151), perch2_shop_customers (7), perch2_shop_emails (0), perch2_shop_index (60), 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 (1), perch2_shop_product_files (1), 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 (1), perch2_shop_shippings (1), perch2_shop_tax_exhibits (0), perch2_shop_tax_group_rates (1), perch2_shop_tax_groups (1), perch2_shop_tax_locations (1), perch2_shop_tax_rates (1), perch2_shop_variants (0), perch2_user_passwords (0), perch2_user_privileges (44), 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',
            'perch_blog',
            'perch_gallery',
            'perch_forms',


        );

    Scheduled tasks for perch_blog: delete_spam_comments (1440 mins)
    Editor plug-ins: markitup
    H1: 6062840464241cbc8d875e43cfa236b1
    L1: ba70c1b0b1dc50e79ddf1bc62671a572
    F1: 2edba60ed1f613d6dd804feb202456a2
    headerColour: #ffffff
    content_singlePageEdit: 1
    helpURL:
    siteURL: /
    hideBranding: 0
    content_collapseList: 1
    lang: en-gb
    update_2.8.26: done
    perch_gallery_update: 2.8.5
    headerScheme: light
    update_runway_2.8.26: done
    latest_version: 2.8.15
    on_sale_version: 2.8.29
    perch_blog_site_name:
    perch_blog_post_url: /blog/post.php?s={postSlug}
    perch_blog_slug_format: %Y-%m-%d-{postTitle}
    perch_blog_akismet_key:
    perch_blog_max_spam_days: 0
    perch_gallery_bucket_mode: single
    perch_gallery_bucket: default
    perch_members_login_page: /members/login.php?r={returnURL}
    perch_shop_price_tax_mode: exc
    perch_shop_trade_price_tax_mode: exc
    perch_shop_site_url: https://www.gscmr.local
    perch_shop_product_url: /shop/products/{slug}
    perch_shop_default_currency: 8
    perch_shop_reporting_currency: 8
    perch_shop_invoice_number_format: Invoice%d
    dashboard: 0
    hide_pwd_reset: 0
    content_hideNonEditableRegions: 0
    content_frontend_edit: 0
    perch_blog_comment_notify: 0
    perch_gallery_basicUpload: 0
    logoPath: /perch/resources/logo.fw.png
    perch_blog_update: 5.0.1
    update_runway_2.8.29: done
    perch_backup_mysqldump_path:
    perch_members_update: 1.4
    PERCH_DEVELOPMENT: 10
    PERCH_STAGING: 50
    PERCH_PRODUCTION: 100
    PERCH_SITEPATH: D:\htdocs\gscmr
    PERCH_SCHEDULE_SECRET: 29RgvMiH1Bl7JFHY
    PERCH_DB_USERNAME: baw01966
    PERCH_DB_SERVER: localhost
    PERCH_DB_DATABASE: gscmr
    PERCH_DB_PREFIX: perch2_
    PERCH_EMAIL_FROM: brett@brandbureau.com.au
    PERCH_EMAIL_FROM_NAME: Brett Warne
    PERCH_LOGINPATH: /perch
    PERCH_PATH: D:\htdocs\gscmr\perch
    PERCH_CORE: D:\htdocs\gscmr\perch\core
    PERCH_RESFILEPATH: D:\htdocs\gscmr\perch\resources
    PERCH_RESPATH: /perch/resources
    PERCH_HTML5: 1
    PERCH_TZ: Australia/Melbourne
    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: D:\htdocs\gscmr\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.6.15
    Zend: 2.6.0
    OS: WINNT
    SAPI: apache2handler
    Safe mode: not detected
    MySQL client: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
    MySQL server: 5.7.9
    Free disk space: 1.72 TB
    Extensions: Core, bcmath, calendar, ctype, date, ereg, filter, ftp, hash, iconv, json, mcrypt, SPL, odbc, pcre, Reflection, session, standard, mysqlnd, tokenizer, zip, zlib, libxml, dom, PDO, bz2, SimpleXML, wddx, xml, xmlreader, xmlwriter, apache2handler, openssl, curl, com_dotnet, fileinfo, gd, gettext, gmp, intl, imap, ldap, mbstring, exif, mysql, mysqli, Phar, pdo_mysql, pdo_sqlite, soap, sockets, sqlite3, xmlrpc, xsl, mhash, Zend OPcache, xdebug
    GD: Yes
    ImageMagick: No
    PHP max upload size: 64M
    PHP max form post size: 128M
    PHP memory limit: 128M
    Total max uploadable file size: 64M
    Resource folder writeable: Yes
    Session timeout: 24 minutes
    Native JSON: Yes
    Filter functions: Yes
    Transliteration functions: Yes
    HTTP_HOST: www.gscmr.local
    HTTP_USER_AGENT: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0
    HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.5
    HTTP_ACCEPT_ENCODING: gzip, deflate
    HTTP_REFERER: https://www.gscmr.local/perch/core/settings/diagnostics/
    HTTP_COOKIE: _ga=GA1.2.320530684.1457648186; cmsa=1; p_m=5511093152ba91d4bfe9a9dc0ff2bcc906b67722; PHPSESSID=r05fkj0a998mfao0ih16g7gau3; _gat=1
    HTTP_CONNECTION: keep-alive
    PATH: C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\AMD\ATI.ACE\Core-Static;D:\HashiCorp\Vagrant\bin;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\Doctrine extensions for PHP\;
    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_SIGNATURE: <address>Apache/2.4.17 (Win32) PHP/5.6.15 Server at www.gscmr.local Port 80</address>
    SERVER_SOFTWARE: Apache/2.4.17 (Win32) PHP/5.6.15
    SERVER_NAME: www.gscmr.local
    SERVER_ADDR: ::1
    SERVER_PORT: 80
    REMOTE_ADDR: ::1
    DOCUMENT_ROOT: D:/htdocs/gscmr
    REQUEST_SCHEME: http
    CONTEXT_DOCUMENT_ROOT: D:/htdocs/gscmr
    SERVER_ADMIN: wampserver@otomatic.net
    SCRIPT_FILENAME: D:/htdocs/gscmr/perch/core/settings/diagnostics/index.php
    REMOTE_PORT: 61733
    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: 1460502548.332
    REQUEST_TIME: 1460502548



Hi

i created a new site today with just runway, gallery and shop. I get the exact same errors. No shipping or billing address added to the perch2_shop_cart table. when no shipping is required.

same error

Diagnostics report
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_gallery (2.8.6), perch_shop_orders (1.0), perch_shop_products (1.0), perch_shop (1.0), perch_members (1.5)
    DB driver: PDO
    DB tables: perch2_backup_plans (0), perch2_backup_resources (0), perch2_backup_runs (0), perch2_categories (1), perch2_category_counts (0), perch2_category_sets (1), perch2_collection_index (0), perch2_collection_items (0), perch2_collection_revisions (0), perch2_collections (0), perch2_content_index (4), perch2_content_items (2), perch2_content_regions (2), perch2_forms (0), perch2_forms_responses (0), perch2_gallery_albums (1), perch2_gallery_image_versions (18), perch2_gallery_images (3), perch2_members (3), 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 (0), perch2_page_templates (9), perch2_pages (8), perch2_resource_log (7), perch2_resource_tags (0), perch2_resources (7), perch2_resources_to_tags (0), perch2_settings (29), perch2_shop_addresses (0), perch2_shop_admin_index (25), perch2_shop_brands (1), perch2_shop_cart (1), perch2_shop_cart_data (22), perch2_shop_cart_items (3), perch2_shop_countries (248), perch2_shop_currencies (152), perch2_shop_customers (3), perch2_shop_emails (0), perch2_shop_index (54), 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 (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 (1), perch2_shop_shippings (1), perch2_shop_tax_exhibits (0), perch2_shop_tax_group_rates (1), perch2_shop_tax_groups (1), perch2_shop_tax_locations (1), perch2_shop_tax_rates (1), perch2_shop_variants (0), perch2_user_passwords (0), perch2_user_privileges (34), perch2_user_role_privileges (16), perch2_user_roles (2), perch2_users (1)
    Users: 1
    App runtimes:

    <?php
        $apps_list = array(
            'content', 
            'categories',
            'perch_gallery',
            'perch_members',
            'perch_shop',
            'perch_forms',
        );

    Editor plug-ins: ckeditor, markitup
    H1: bf5dbbf88e0884f780b2d9d105c10a78
    L1: 955d3f464dddd395e95af09ad5e22d33
    F1: 2edba60ed1f613d6dd804feb202456a2
    content_singlePageEdit: 1
    helpURL:
    siteURL: /
    hideBranding: 0
    content_collapseList: 1
    lang: en-gb
    update_2.8.29: done
    headerColour: #000000
    headerScheme: dark
    update_runway_2.8.29: done
    latest_version: 2.8.15
    on_sale_version: 2.8.29
    perch_gallery_update: 2.8.5
    perch_members_update: 1.4
    perch_gallery_bucket_mode: single
    perch_gallery_bucket: default
    perch_members_login_page: /members/login.php?r={returnURL}
    perch_shop_price_tax_mode: exc
    perch_shop_trade_price_tax_mode: exc
    perch_shop_site_url: https://shopr.local
    perch_shop_product_url: /shop/products/{slug}
    perch_shop_default_currency: 8
    perch_shop_reporting_currency: 8
    perch_shop_invoice_number_format: Invoice%d
    dashboard: 0
    hide_pwd_reset: 0
    content_hideNonEditableRegions: 0
    content_frontend_edit: 0
    perch_gallery_basicUpload: 0
    PERCH_DEVELOPMENT: 10
    PERCH_STAGING: 50
    PERCH_PRODUCTION: 100
    PERCH_SITEPATH: D:\htdocs\shopr
    PERCH_SCHEDULE_SECRET: 3inBoeL5BVImeMu4
    PERCH_DB_USERNAME: baw01966
    PERCH_DB_SERVER: localhost
    PERCH_DB_DATABASE: shopr
    PERCH_DB_PREFIX: perch2_
    PERCH_EMAIL_FROM: brett@brandbureau.com.au
    PERCH_EMAIL_FROM_NAME: Brett Warne
    PERCH_LOGINPATH: /perch
    PERCH_PATH: D:\htdocs\shopr\perch
    PERCH_CORE: D:\htdocs\shopr\perch\core
    PERCH_RESFILEPATH: D:\htdocs\shopr\perch\resources
    PERCH_RESPATH: /perch/resources
    PERCH_HTML5: 1
    PERCH_TZ: Australia/Melbourne
    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: D:\htdocs\shopr\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.6.15
    Zend: 2.6.0
    OS: WINNT
    SAPI: apache2handler
    Safe mode: not detected
    MySQL client: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
    MySQL server: 5.7.9
    Free disk space: 1.72 TB
    Extensions: Core, bcmath, calendar, ctype, date, ereg, filter, ftp, hash, iconv, json, mcrypt, SPL, odbc, pcre, Reflection, session, standard, mysqlnd, tokenizer, zip, zlib, libxml, dom, PDO, bz2, SimpleXML, wddx, xml, xmlreader, xmlwriter, apache2handler, openssl, curl, com_dotnet, fileinfo, gd, gettext, gmp, intl, imap, ldap, mbstring, exif, mysql, mysqli, Phar, pdo_mysql, pdo_sqlite, soap, sockets, sqlite3, xmlrpc, xsl, mhash, Zend OPcache, xdebug
    GD: Yes
    ImageMagick: No
    PHP max upload size: 64M
    PHP max form post size: 128M
    PHP memory limit: 128M
    Total max uploadable file size: 64M
    Resource folder writeable: Yes
    Session timeout: 24 minutes
    Native JSON: Yes
    Filter functions: Yes
    Transliteration functions: Yes
    HTTP_HOST: www.shopr.local
    HTTP_USER_AGENT: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0
    HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.5
    HTTP_ACCEPT_ENCODING: gzip, deflate
    HTTP_REFERER: https://www.shopr.local/perch/core/settings/diagnostics/
    HTTP_COOKIE: PHPSESSID=d7aujvaogdi028loke30o4aj55; cmsa=1; _ga=GA1.2.1629051120.1460510641; p_m=eadb190028d84a1b662c56e9b146757b02a91695; _gat=1
    HTTP_CONNECTION: keep-alive
    PATH: C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\AMD\ATI.ACE\Core-Static;D:\HashiCorp\Vagrant\bin;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\Doctrine extensions for PHP\;
    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_SIGNATURE: <address>Apache/2.4.17 (Win32) PHP/5.6.15 Server at www.shopr.local Port 80</address>
    SERVER_SOFTWARE: Apache/2.4.17 (Win32) PHP/5.6.15
    SERVER_NAME: www.shopr.local
    SERVER_ADDR: ::1
    SERVER_PORT: 80
    REMOTE_ADDR: ::1
    DOCUMENT_ROOT: D:/htdocs/shopr
    REQUEST_SCHEME: http
    CONTEXT_DOCUMENT_ROOT: D:/htdocs/shopr
    SERVER_ADMIN: wampserver@otomatic.net
    SCRIPT_FILENAME: D:/htdocs/shopr/perch/core/settings/diagnostics/index.php
    REMOTE_PORT: 54228
    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: 1460522408.346
    REQUEST_TIME: 1460522408

Regards,

Brett

Drew McLellan

Drew McLellan 2638 points
Perch Support

You'll need to tell us more about how you've put your checkout flow together, because its obviously the same issue each time you do it.

Straight off the docs today. Also tried the nest demo way same issue each time.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Can you try running:

ALTER TABLE `perch2_shop_addresses` CHANGE `countryID` `countryID` INT(10)  NULL;

Will try and let you know..