We are transitioning over to a new forum platform. Please post new issues there. Existing threads will be dealt with here unless you choose to move them over. Visit the new forum

Forum

Thread tagged as: Problem, Shop

Paypal redirect

Hi!

I've currently set up a shop and it's all worrking great until I get to the paypal redirect and it just gets stuck on the site without going off to paypal. Can you anyone help? I've used the same code as previous shops made but this one doesn't seem to work! Diagnostics below


Perch: 3.1.1 Production mode: Production (100) Installed apps: content (3.1.1), assets (3.1.1), categories (3.1.1), perch_blog (5.6.1), perch_events (1.9.5), perch_shop_orders (1.2.6), perch_shop_products (1.2.6), perch_shop (1.2.6), perch_members (1.6.4) DB driver: PDO DB tables: perch3_blog_authors (1), perch3_blog_comments (0), perch3_blog_index (276), perch3_blog_posts (10), perch3_blog_posts_to_tags (0), perch3_blog_sections (1), perch3_blog_tags (0), perch3_blog_webmention_queue (0), perch3_blogs (1), perch3_categories (24), perch3_category_counts (5), perch3_category_sets (4), perch3_content_index (26889), perch3_content_items (2236), perch3_content_regions (55), perch3_events (3), perch3_events_categories (0), perch3_events_to_categories (0), perch3_menu_items (14), perch3_navigation (0), perch3_navigation_pages (0), perch3_page_templates (1), perch3_pages (25), perch3_resource_log (2631), perch3_resource_tags (2), perch3_resources (295), perch3_resources_to_tags (2), perch3_settings (40), perch3_shop_addresses (0), perch3_shop_admin_index (30), perch3_shop_brands (1), perch3_shop_cart (6109), perch3_shop_cart_data (18), perch3_shop_cart_items (4), perch3_shop_countries (250), perch3_shop_currencies (152), perch3_shop_customers (0), perch3_shop_emails (2), perch3_shop_index (4186), perch3_shop_option_values (21), perch3_shop_options (7), perch3_shop_order_items (0), perch3_shop_order_promotions (0), perch3_shop_order_statuses (9), perch3_shop_orders (0), perch3_shop_orders_meta (1), perch3_shop_product_files (0), perch3_shop_product_option_values (21), perch3_shop_product_options (7), perch3_shop_product_tags (0), perch3_shop_products (112), perch3_shop_promotions (0), perch3_shop_sales (0), perch3_shop_search (4), perch3_shop_shipping_zone_countries (1), perch3_shop_shipping_zones (1), perch3_shop_shippings (1), perch3_shop_tax_exhibits (0), perch3_shop_tax_group_rates (1), perch3_shop_tax_groups (1), perch3_shop_tax_locations (1), perch3_shop_tax_rates (1), perch3_shop_variants (405), perch3_user_passwords (0), perch3_user_privileges (76), perch3_user_role_privileges (2), perch3_user_roles (2), perch3_users (1) Users: 1 App runtimes: <?php $apps_list = [ 'perch_events', 'perch_blog', 'perch_members', 'perch_shop' ]; Scheduled tasks for perch_blog: delete_spam_comments (1440 mins), publish_posts (1 mins), process_webmentions (1 mins) Editor plug-ins: ckeditor H1: 2ef5edb8902f7199e8a7ac7f2b097fde L1: fbabefe4d51e845bbde5b88b0655106c F1: 3b606135b33e6a102526838f4152a807 headerColour: #ffffff content_singlePageEdit: 1 helpURL: siteURL: / hideBranding: 1 content_collapseList: 1 lang: en-gb installedAt: 3.1.1 update_3.1.1: done latest_version: on_sale_version: 3.1.2 headerScheme: light perch_blog_site_name: perch_blog_post_url: /post.php?s={postSlug} perch_blog_slug_format: %Y-%m-%d-{postTitle} perch_blog_akismet_key: perch_blog_max_spam_days: 0 perch_events_detail_url: /event.php?s={eventSlug} dashboard: 0 sidebar_back_link: 0 hide_pwd_reset: 0 keyboardShortcuts: 0 content_hideNonEditableRegions: 0 content_frontend_edit: 0 content_skip_region_list: 0 assets_restrict_buckets: 0 perch_blog_comment_notify: 0 perch_blog_webmention_tx: 0 perch_blog_webmention_rx: 0 logoPath: /images/logo-col-1.png perch_events_update: 1.8 perch_blog_update: 5.6 perch_shop_update: 1.2.6 perch_members_login_page: /members/login.php?r={returnURL} perch_shop_price_tax_mode: inc perch_shop_site_url: https:// perch_shop_product_url: product.php?s={slug} perch_shop_default_currency: 47 perch_shop_reporting_currency: 47 perch_shop_invoice_number_format: Invoice%d PERCH_DEVELOPMENT: 10 PERCH_STAGING: 50 PERCH_PRODUCTION: 100 PERCH_DB_USERNAME: bfladmin PERCH_DB_SERVER: 213.171.200.80 PERCH_DB_DATABASE: BFL2018 PERCH_DB_PREFIX: perch3_ PERCH_TZ: UTC PERCH_EMAIL_FROM: jade@picseli.co.uk PERCH_EMAIL_FROM_NAME: Jade Marling PERCH_EMAIL_METHOD: mail PERCH_LOGINPATH: /admin PERCH_PATH: /home/linweb37/b/britonferryllansawelafc.com/user/htdocs/admin PERCH_CORE: /home/linweb37/b/britonferryllansawelafc.com/user/htdocs/admin/core PERCH_RESFILEPATH: /home/linweb37/b/britonferryllansawelafc.com/user/htdocs/images PERCH_RESPATH: /images 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_ASSET_VERSION: 8255e4c4a367cfa3e2bd PERCH_DEBUG: PERCH_PREVIEW_ARG: preview PERCH_TEMPLATE_PATH: /home/linweb37/b/britonferryllansawelafc.com/user/htdocs/admin/templates PERCH_TEMPLATE_FILTERS: PERCH_DEFAULT_DOC: index.php PERCH_DEFAULT_EXT: .php PERCH_PRODUCTION_MODE: 100 PERCH_XHTML_MARKUP: PERCH_RWD: 1 PERCH_HTML_ENTITIES: PERCH_SSL: PERCH_STRIPSLASHES: PERCH_PROGRESSIVE_FLUSH: 1 PERCH_PARANOID: PERCH_FORCE_SECURE_COOKIES: PERCH_DEFAULT_BUCKET: default PERCH_TRANSLATION_ASSIST: PERCH_PASSWORD_MIN_LENGTH: 6 PERCH_MAX_FAILED_LOGINS: 10 PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR PERCH_VERIFY_UPLOADS: PERCH_PRIV_ASSIST: PERCH_CUSTOM_EDITOR_CONFIGS: PERCH_ENABLE_EXIF: 1 PERCH_AUTH_PLUGIN: PERCH_DB_CHARSET: utf8 PERCH_DB_PORT: PERCH_DB_SOCKET: PERCH_SHOP_VERSION: 1.2.6 PERCH_APPS_EDITOR_PLUGIN: markitup PERCH_APPS_EDITOR_MARKUP_LANGUAGE: markdown Hosting settings PHP: 5.6.37 Zend: 2.6.0 OS: Linux SAPI: cgi-fcgi Safe mode: not detected MySQL client: 5.5.56-MariaDB MySQL server: 5.6.41-log Free disk space: 53.29 GB Extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bz2, calendar, ctype, curl, hash, fileinfo, filter, ftp, gettext, gmp, SPL, iconv, intl, pcntl, session, standard, posix, readline, Reflection, Phar, shmop, SimpleXML, sockets, mbstring, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, cgi-fcgi, bcmath, dba, dom, gd, imap, json, ldap, exif, mcrypt, mssql, mysql, mysqli, odbc, PDO, pdo_dblib, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, pspell, snmp, soap, tidy, xmlreader, xmlrpc, xmlwriter, xsl, zip, mhash, ionCube Loader, Zend OPcache GD: Yes ImageMagick: No PHP max upload size: 20M PHP max form post size: 20M PHP memory limit: 64M Total max uploadable file size: 20M Resource folder writeable: Yes Session timeout: 24 minutes Native JSON: Yes Filter functions: Yes Transliteration functions: Yes PATH: /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin PWD: /var/www/fcgi PHP_FCGI_MAX_REQUESTS: 100 ORIG_SCRIPT_NAME: /fcgi-bin/php56-cgi ORIG_PATH_TRANSLATED: /home/linweb37/b/britonferryllansawelafc.com/user/htdocs/admin/core/settings/diagnostics/index.php ORIG_PATH_INFO: /admin/core/settings/diagnostics/index.php ORIG_SCRIPT_FILENAME: /var/www/fcgi/php56-cgi SCRIPT_NAME: /admin/core/settings/diagnostics/index.php REQUEST_URI: /admin/core/settings/diagnostics/?extended QUERY_STRING: extended REQUEST_METHOD: GET SERVER_PROTOCOL: HTTP/1.0 GATEWAY_INTERFACE: CGI/1.1 REDIRECT_URL: /admin/core/settings/diagnostics/index.php REDIRECT_QUERY_STRING: extended REMOTE_PORT: 53316 SCRIPT_FILENAME: /home/linweb37/b/britonferryllansawelafc.com/user/htdocs/admin/core/settings/diagnostics/index.php SERVER_ADMIN: support@fasthosts.com CONTEXT_DOCUMENT_ROOT: /var/www/fcgi/ CONTEXT_PREFIX: /fcgi-bin/ REQUEST_SCHEME: http DOCUMENT_ROOT: /home/linweb37/b/britonferryllansawelafc.com/user/htdocs REMOTE_ADDR: 91.103.188.194 SERVER_PORT: 80 SERVER_ADDR: 127.0.0.1 SERVER_NAME: www.britonferryllansawelafc.com SERVER_SOFTWARE: Apache HTTP_UPGRADE_INSECURE_REQUESTS: 1 HTTP_COOKIE: _ga=GA1.2.631448787.1532359473; PHPSESSID=euonqijhcf86m78v5vckrr8nj0; _gid=GA1.2.1388267384.1534174186; cmsa=1 HTTP_REFERER: http://www.britonferryllansawelafc.com/admin/core/settings/diagnostics/ HTTP_ACCEPT_ENCODING: gzip, deflate HTTP_ACCEPT_LANGUAGE: en-GB,en;q=0.5 HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 HTTP_USER_AGENT: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:61.0) Gecko/20100101 Firefox/61.0 HTTP_CONNECTION: close HTTP_X_FORWARDED_FOR: 91.103.188.194 HTTP_X_REAL_IP: 91.103.188.194 HTTP_HOST: www.britonferryllansawelafc.com UNIQUE_ID: W3KxUMVCuufGE7QgxvWZLwAAACo on: 127.0.0.1 REDIRECT_STATUS: 200 REDIRECT_HANDLER: application/x-httpd-php56 REDIRECT_UNIQUE_ID: W3KxUMVCuufGE7QgxvWZLwAAACo REDIRECT_on: 127.0.0.1 FCGI_ROLE: RESPONDER PHP_SELF: /admin/core/settings/diagnostics/index.php REQUEST_TIME_FLOAT: 1534243152.5156 REQUEST_TIME: 1534243152
Jade Marling

Jade Marling 0 points

  • 11 months ago

So I've found another issue that when the you enter the details that it doesn't create a customer and logs in. So the user is stuck on the same form constantly. Form below

Any help is much appreciated!

<perch:form id="register" method="post" app="perch_shop">

    <h2>New customer</h2>


    <fieldset>
        <legend>About you</legend>
        <div>
            <perch:label for="first_name">First name</perch:label>
            <perch:input type="text" id="first_name" required="true" label="First name" />
            <perch:error for="first_name" type="required">Please add your name</perch:error>
        </div>

        <div>
            <perch:label for="last_name">Last name</perch:label>
            <perch:input type="text" id="last_name" required="true" label="Last name" />
            <perch:error for="last_name" type="required">Please add your name</perch:error>
        </div>

        <div>
            <perch:label for="email">Email</perch:label>
            <perch:input type="email" id="email" required="true" placeholder="you@company.com" helper="PerchMembers_Members::check_email" />
            <perch:error for="email" type="required">Please add your email address</perch:error>
            <perch:error for="email" type="helper">That email address is already in use</perch:error>
            <perch:input type="hidden" id="password" value="__auto__" />
        </div>

    </fieldset>

    <fieldset>
        <legend>Billing address</legend>
        <div>
            <perch:label for="company">Company</perch:label>
            <perch:input type="text" id="company" label="Company" />
        </div>

        <div>
            <perch:label for="address_1">Address 1</perch:label>
            <perch:input type="text" id="address_1" required="true" label="Address 1" />
            <perch:error for="address_1" type="required">Please add the first line of your address</perch:error>
        </div>

        <div>
            <perch:label for="address_2">Address 2</perch:label>
            <perch:input type="text" id="address_2" label="Address 2" />
        </div>

        <div>
            <perch:label for="postcode">Postal code</perch:label>
            <perch:input type="text" id="postcode" label="Postal code" />
        </div>

        <div>
            <perch:label for="city">City</perch:label>
            <perch:input type="text" id="city" label="City" />
        </div>

        <div>
            <perch:label for="county">State or County</perch:label>
            <perch:input type="text" id="county" label="County" />
        </div>

        <div>
            <perch:label for="country">Country</perch:label>
            <perch:input type="select" options="<perch:shop id="country_list" />" value="236" id="country" label="Country" />
        </div>

    </fieldset>


        <div>
            <perch:input type="submit" value="Register" />
        </div>


    <perch:success>
        <p>Thanks!</p>
        <a href="payment.php">Continue</a>
    </perch:success>

</perch:form>
Drew McLellan

Drew McLellan 2638 points
Perch Support

Can you show us the code for your checkout page?

<?php include('admin/runtime.php');?>
<!DOCTYPE html>
<html dir="ltr" lang="en-gb">
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<script>
     (adsbygoogle = window.adsbygoogle || []).push({
          google_ad_client: "ca-pub-9395141259683130",
          enable_page_level_ads: true
     });
</script>


    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="author" content="SA1 Creative" />
    <title><?php $my_var = perch_pages_title(true);
    echo $my_var; ?></title>

    <?php
    $domain        = 'http://'.$_SERVER["HTTP_HOST"];
    $url           = $domain.$_SERVER["REQUEST_URI"];
    $sitename      = "Briton Ferry Llansawel AFC";
    $twittername   = "@bflafc";

    PerchSystem::set_var('domain',$domain);
    PerchSystem::set_var('url',$url);
    PerchSystem::set_var('twittername',$twittername);

    perch_page_attributes(array(        
      'template' => 'default.html'    
    ));
    ?>
    <!-- Favicon -->
    <link rel="icon" href="img/favicon.png" sizes="32x32" />
    <link rel="icon" href="img/favicon.png" sizes="192x192" />
    <link rel="apple-touch-icon-precomposed" href="img/favicon.png" />
    <meta name="msapplication-TileImage" content="img/favicon.png" />
    <!-- Mobile Metas -->
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <!-- Vendor CSS -->
    <link href="css/vendors.css" rel="stylesheet">
    <!-- Theme CSS -->
    <link href="css/style.css" rel="stylesheet">
    <!-- Theme Custom CSS -->
    <link rel="stylesheet" href="css/custom.css">
    <!-- Web Fonts  -->
    <script>
        WebFontConfig = {
            google: {
                families: ['Montserrat:300,400,500,600,700']
            },
            active: function() {
                $(window).trigger('webfontLoaded');
            }
        };

        (function(d) {
            var wf = d.createElement('script'),
                s = d.scripts[0];
            wf.src = 'https://ajax.googleapis.com/ajax/libs/webfont/1.6.26/webfont.js';
            wf.async = true;
            s.parentNode.insertBefore(wf, s);
        })(document);
    </script>
<?php include_once('includes/cookies.php');?>
<?php include('includes/analyticstracking.php');?>
</head>

<body class="has-site-header-8">

    <?php include('includes/header.php');
    ?>

        <div class="site-content single-entry single-entry--template-4-alt">
            <div class="mnmd-block mnmd-block--fullwidth mnmd-block--contiguous single-header-with-bg">
                <div class="container">
                    <header class="single-header inverse-text">
                        <div class="single-header__inner">
                            <h1 class="entry-title entry-title--lg">Enter your details</h1>

                        </div>
                    </header>
                </div>
            </div>
    <div class="mnmd-block mnmd-block--fullwidth single-entry-wrap">
                <div class="container">
                    <div class="row">
                        <div class="mnmd-main-col" role="main">
                            <?php 
if (perch_member_logged_in()) {

  // your 'success' return URL
  $return_url = 'http://www.britonferryllansawelafc.co.uk/order-complete.php';
  $cancel_url = 'http://www.britonferryllansawelafc.co.uk/cancel.php';
  perch_shop_checkout('paypal-express', [
    'return_url' => $return_url,
    'cancel_url' => $cancel_url,
  ]);


}else
{
    perch_shop_registration_form([
    'template' => 'checkout/customer_create_passwordless.html'
  ]);
}
?>
                        </div>
                        <!-- .mnmd-main-col -->
                        <!-- .mnmd-main-col -->
                        <?php include('includes/generic-sidebar.php');?>
                    </div>
                    <!-- .row -->
                </div>
                <!-- .container -->
            </div>
            <!-- .mnmd-block -->
        </div>
        <!-- .site-content -->

        <!-- .site-content -->
        <?php include('includes/footer.php');?>
        <?php include('includes/sticky-header.php');?>
        <?php include('includes/side-navigation.php');?>
        <a href="#" class="mnmd-go-top btn btn-default hidden-xs js-go-top-el"><i class="mdicon mdicon-arrow_upward"></i></a>
    </div>
    <!-- .site-wrapper -->
    <!-- Vendor -->
    <script type="text/javascript" src="js/jquery.js"></script>
    <script type="text/javascript" src="js/vendors.js"></script>
    <!-- Theme Scripts -->
    <script type="text/javascript" src="js/scripts.js"></script>
    <!-- Theme Custom Scripts -->
    <script src="js/custom.js"></script>
</body>

</html>
Drew McLellan

Drew McLellan 2638 points
Perch Support

perch_shop_checkout() issues an HTTP Location header to redirect the user to PayPal. It can't do that if you've already started sending the body of the response. This needs to happen before you output anything to the body of the HTTP response.

I'm not sure if I follow. What needs to change in order for it to work?

Drew McLellan

Drew McLellan 2638 points
Perch Support

You need to call perch_shop_checkout() before you output anything.

Okay, so I've moved it so it's under <?php include('admin/runtime.php');?> and now it brings a blank page.

Drew McLellan

Drew McLellan 2638 points
Perch Support

[Tue Aug 14 17:04:01.908356 2018] [fcgid:warn] [pid 13274] [client 91.103.188.194:44034] mod_fcgid: stderr: PHP Fatal error: Call to a member function id() on null in /home/linweb37/b/britonferryllansawelafc.com/user/htdocs/admin/addons/apps/perch_shop/lib/PerchShop_Runtime.class.php on line 921, referer: http://www.britonferryllansawelafc.com/checkout.php

Drew McLellan

Drew McLellan 2638 points
Perch Support

Are you still logged in as a customer?

When the registration form is filled in it doesn't keep the customer log in and I can't figure out why so no

Drew McLellan

Drew McLellan 2638 points
Perch Support

You need to address that first.

I'm not sure how to fix it as the template I've used is the default template. Plus it's not saving customers in the database who have filled the form out

<perch:form id="register" method="post" app="perch_shop">

    <h2>New customer</h2>


    <fieldset>
        <legend>About you</legend>
        <div>
            <perch:label for="first_name">First name</perch:label>
            <perch:input type="text" id="first_name" required="true" label="First name" />
            <perch:error for="first_name" type="required">Please add your name</perch:error>
        </div>

        <div>
            <perch:label for="last_name">Last name</perch:label>
            <perch:input type="text" id="last_name" required="true" label="Last name" />
            <perch:error for="last_name" type="required">Please add your name</perch:error>
        </div>

        <div>
            <perch:label for="email">Email</perch:label>
            <perch:input type="email" id="email" required="true" placeholder="you@company.com" helper="PerchMembers_Members::check_email" />
            <perch:error for="email" type="required">Please add your email address</perch:error>
            <perch:error for="email" type="helper">That email address is already in use</perch:error>
            <perch:input type="hidden" id="password" value="__auto__" />
        </div>

    </fieldset>

    <fieldset>
        <legend>Billing address</legend>
        <div>
            <perch:label for="company">Company</perch:label>
            <perch:input type="text" id="company" label="Company" />
        </div>

        <div>
            <perch:label for="address_1">Address 1</perch:label>
            <perch:input type="text" id="address_1" required="true" label="Address 1" />
            <perch:error for="address_1" type="required">Please add the first line of your address</perch:error>
        </div>

        <div>
            <perch:label for="address_2">Address 2</perch:label>
            <perch:input type="text" id="address_2" label="Address 2" />
        </div>

        <div>
            <perch:label for="postcode">Postal code</perch:label>
            <perch:input type="text" id="postcode" label="Postal code" />
        </div>

        <div>
            <perch:label for="city">City</perch:label>
            <perch:input type="text" id="city" label="City" />
        </div>

        <div>
            <perch:label for="county">State or County</perch:label>
            <perch:input type="text" id="county" label="County" />
        </div>

        <div>
            <perch:label for="country">Country</perch:label>
            <perch:input type="select" options="<perch:shop id="country_list" />" value="236" id="country" label="Country" />
        </div>

    </fieldset>


        <div>
            <perch:input type="submit" value="Register" />
        </div>


    <perch:success>
        <p>Thanks!</p>
        <a href="payment.php">Continue</a>
    </perch:success>

</perch:form>
Drew McLellan

Drew McLellan 2638 points
Perch Support

It's probably not the template in that case. If you turn on debug and register as a customer, what does it output?

Debug Message - Perch 3.1.1
[40] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] SELECT * FROM perch3_pages WHERE pagePath='/payment.php' LIMIT 1
[1] SELECT * FROM perch3_shop_cart WHERE cartID=6637
[1] SELECT * FROM perch3_shop_cart WHERE cartID=6637
SELECT COUNT(*) FROM perch3_members WHERE memberPassword IS NOT NULL AND memberEmail='jade@picseli.co.uk'
[] Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'BFL2018.perch3_members' doesn't exist
SELECT COUNT(*) FROM perch3_members WHERE memberPassword IS NOT NULL AND memberEmail='jade@picseli.co.uk'
[] Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'BFL2018.perch3_members' doesn't exist
SELECT * FROM perch3_members_forms WHERE formKey='register' LIMIT 1
Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'BFL2018.perch3_members_forms' doesn't exist
INSERT INTO perch3_members_forms(formKey,formTitle,formSettings) VALUES('register','Registration form','')
Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'BFL2018.perch3_members_forms' doesn't exist
[250] SELECT country, countryID FROM perch3_shop_countries WHERE countryActive=1 ORDER BY country ASC
Using template: /templates/shop/checkout/customer_create_passwordless.html
Drew McLellan

Drew McLellan 2638 points
Perch Support

It looks like you don't have Members fully installed. If you go to Members in the control panel, what do you see?

It looks normal, but with no members in it. Debug below

Debug Message - Perch 3.1.1
[1] SELECT u.*, r.* FROM perch3_users u, perch3_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='f946dcddcedc9d0e24ff578ec9cc9e11' LIMIT 1
UPDATE perch3_users SET userHash='58d99eaed846c568444df45b3de594bf' WHERE userID='1'
[41] SELECT settingID, settingValue, userID FROM perch3_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
[12] SELECT itemValue FROM perch3_menu_items WHERE itemType='app'
[0] SELECT COUNT(*) FROM perch3_members WHERE memberStatus='pending'
[nil] SELECT * FROM perch3_members_tags ORDER BY tag ASC
[0] SELECT COUNT(*) FROM perch3_members WHERE memberStatus='pending'
[nil] SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM perch3_members ORDER BY memberEmail ASC LIMIT 0, 40
[0] SELECT FOUND_ROWS() AS `count`
Attempting app installation: perch_members
[1] SHOW TABLES LIKE "perch3_members"
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 0, 1
[7] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=1 ORDER BY mi.itemOrder ASC
[1] SELECT itemTitle FROM perch3_menu_items WHERE itemType='app' AND itemValue='perch_members' LIMIT 1
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 1, 10
[2] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=2 ORDER BY mi.itemOrder ASC
File: /addons/apps/perch_members/modes/members.list.post.php
Queries: 16
Memory: 1.769
Drew McLellan

Drew McLellan 2638 points
Perch Support

Do you see any perch3_members tables in your database? There should be 5 of them.