Forum

Thread tagged as: Problem, Error, Shop

Checkout error

On the confirmation page (secound step) I'm using perch_shop_customer_address(), but it does display some other address saved for some other user ( not the current one ). Also after submiting confirmation page and I get this error

Fatal error: Call to a member function memberID() on boolean in `/home/klient.dhosting.pl/zielonyslon/antibygibaszewski.pl/public_html/perch/addons/apps/perch_shop/lib/PerchShop_Order.class.php on line 315`

in the first step customer is crated successfully and is saved in admin panel under members & customers.

The perch_shop_customer_address should display this, but instead some other address is displayed which is not at all associated with the current user

UPDATE perch3_shop_addresses SET addressDynamicFields='{\"first_name\":\"Adam\",\"last_name\":\"Testowy\",\"address_1\":\"Testowa ulica\",\"postcode\":\"12345\",\"country\":\"176\",\"company\":\"Firma\",\"city\":\"Waw\",\"customer\":\"120\"}', addressTitle='default', addressCreated='2017-09-12 03:16:36', addressFirstName='Adam', addressLastName='Testowy', addressCompany='Firma', addressLine1='Testowa ulica', customerID='120', countryID='176', addressUpdated='2017-09-12 03:16:36' WHERE addressID='419'

Diagnostics

Perch: 3.0.8, PHP: 5.6.29-dh1, MySQL: mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $, with PDO
Server OS: Linux, litespeed
Installed apps: content (3.0.8), assets (3.0.8), categories (3.0.8), perch_blog (5.5.1), perch_forms (1.9), perch_shop_orders (1.2.4), perch_shop_products (1.2.4), perch_shop (1.2.4), perch_members (1.6.2)
App runtimes: <?php $apps_list = [ 'perch_forms', 'perch_members', 'perch_shop', ];
PERCH_LOGINPATH: /perch
PERCH_PATH: /../public_html/perch
PERCH_CORE: /..public_html/perch/core
PERCH_RESFILEPATH: /../public_html/perch/resources
Image manipulation: GD Imagick
PHP limits: Max upload 200M, Max POST 32M, Memory: 2048M, Total max file upload: 32M
F1: 0c66c2e1f82f9e0b7617b2cb8270f2c7
Resource folder writeable: Yes
HTTP_HOST: ..
DOCUMENT_ROOT: /.../public_html
REQUEST_URI: /perch/core/settings/diagnostics/
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php

checkout flow

<?php include($_SERVER['DOCUMENT_ROOT'].'/perch/runtime.php');?>
<?php
        if (!perch_member_logged_in()) {
            include($_SERVER['DOCUMENT_ROOT'].'/header.php');
            include($_SERVER['DOCUMENT_ROOT'].'/sklep/zamowienie/step-1-adres.php');
        }
        else  {
             if (!perch_shop_cart_has_property('terms_agreed')) {

                    include($_SERVER['DOCUMENT_ROOT'].'/header.php');
                    include($_SERVER['DOCUMENT_ROOT'].'/sklep/zamowienie/step-2-dostawa.php');
             } else {
                        if (isset($_POST['platnosc-przelewem'])){
                              $return_url = 'https://antibygibaszewski.pl/sklep/przelew.php';
                              $cancel_url = 'https://antibygibaszewski.pl/sklep/status.php';
                              perch_shop_checkout('manual', [
                                'status' => 'przelew_unpaid',
                                'return_url' => $return_url,
                                'cancel_url' => $cancel_url,
                              ]);
                        }
                        else {
                              $return_url = 'https://antibygibaszewski.pl/sklep/status.php';
                              $cancel_url = 'https://antibygibaszewski.pl/sklep/status.php';
                              perch_shop_checkout('paypal-express', [
                                'return_url' => $return_url,
                                'cancel_url' => $cancel_url,
                              ]);
                        }
            }
        }
    ?>
    <?php perch_content('Twoje zamowienie'); ?>
    <?php include($_SERVER['DOCUMENT_ROOT'].'/footer.php');?>

step-2 page

<main class="">
    <div class="col-12">
        <div class="checkout-process">
        <div class="checkout-status">
        <ul>
        <li><a href="../koszyk/">Twoj koszyk</a><i class="fa fa-long-arrow-right" aria-hidden="true"></i></li>
        <li><a href="https://antibygibaszewski.pl/sklep/zamowienie/logout.php">Twoje dane</a><i class="fa fa-long-arrow-right" aria-hidden="true"></i></li>
        <li  class="current">Dostawa i płatność</li>
        </ul>
        </div>
        </div>
    </div>
    <section class="checkout--address skinny-cont">
        <div class="checkout--wrap row">

            <?php    
            perch_shop_cart([
                'template'=>'cart/cart_static.html'
            ]); ?>

            <div class="col-12">
               <div class="row adresy-confirm">
                    <div class="col-4">
                        <h3 class="small">Dane Kontaktowe</h3>
                        <div class="email"><h5>Email</h5> <?php echo perch_member_get('email') ?> </div>
                        <div class="telefon"><h5>Telefon</h5> <?php echo perch_member_get('telefon') ?> </div>
                    </div>
                <?php perch_shop_order_addresses(); ?>
                </div>



                <?php 
                    perch_shop_shipping_options();
                    perch_shop_shipping_method_form();
                ?>

                <h4 class="col-12">Metoda płatności: </h4>




                <div class="payment-wrap">
                    <div class="payment-single karta">
                            <img src="../../img/paypal.png" alt="paypal">
                    </div>
                   <div class="payment-single przelew">
                            <h4 class="vAlign">Płatność przelewem</h4>


                    </div>
                </div>

                <?php 
                    perch_shop_form('checkout/confirm.html');

                ?>


            </div>
        </div>
    </section>
</main>

Debug

SELECT * FROM perch3_pages WHERE pagePath='/sklep/zamowienie/index.php' LIMIT 1
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1138
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1138
[35] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[0] SELECT COUNT(*) FROM perch3_members WHERE memberPassword IS NOT NULL AND memberEmail='maciej.pienczewski@gmail.com'
[0] SELECT COUNT(*) FROM perch3_members WHERE memberPassword IS NOT NULL AND memberEmail='maciej.pienczewski@gmail.com'
[1] SELECT * FROM perch3_members_forms WHERE formKey='register' LIMIT 1
INSERT INTO perch3_members(memberAuthType,memberEmail,memberPassword,memberStatus,memberCreated,memberProperties) VALUES('native','maciej.pienczewski@gmail.com','$P$BVucuzMBGW5RfAzvYx63gAZqyBBLPE0','pending','2017-09-12 03:16:36','{\"first_name\":\"Adam\",\"last_name\":\"Testowy\"}')
[1] SELECT * FROM perch3_members WHERE memberID='55' LIMIT 1
No ids to log.
UPDATE perch3_members SET memberAuthID='55', memberStatus='active' WHERE memberID='55'
No ids to log.
[1] SELECT * FROM perch3_members WHERE memberAuthType='native' AND memberPassword IS NOT NULL AND memberEmail='maciej.pienczewski@gmail.com' AND memberStatus='active' AND (memberExpires IS NULL OR memberExpires>'2017-09-12 03:16:36') LIMIT 1
Password is ok.
[1] SELECT * FROM perch3_members WHERE memberAuthType='native' AND memberAuthID='55' LIMIT 1
log them in
[0] SELECT t.tag FROM perch3_members_tags t, perch3_members_member_tags mt WHERE t.tagID=mt.tagID AND mt.memberID='55' AND (mt.tagExpires IS NULL OR mt.tagExpires>'2017-09-12 03:16:00')
INSERT INTO perch3_members_sessions(sessionID,sessionExpires,sessionHttpFootprint,memberID,sessionData) VALUES('87cffc4830a3efdd5080ed30c3c888015cf78737','2017-09-17 03:16:36','4647470f908ce8319691fa5d1bc789cfa8c1f497','55','{\"first_name\":\"Adam\",\"last_name\":\"Testowy\",\"memberID\":\"55\",\"memberAuthType\":\"native\",\"memberAuthID\":\"55\",\"memberEmail\":\"maciej.pienczewski@gmail.com\",\"memberStatus\":\"active\",\"memberCreated\":\"2017-09-12 03:16:36\",\"memberExpires\":null,\"tags\":[],\"token\":\"6af625b2630a60a419d2651599d66b9034e565f5\"}')
DELETE FROM perch3_members_sessions WHERE sessionExpires < '2017-09-12 03:16:36'
[1] SELECT * FROM perch3_members_sessions WHERE sessionID='87cffc4830a3efdd5080ed30c3c888015cf78737' AND sessionHttpFootprint='4647470f908ce8319691fa5d1bc789cfa8c1f497' AND sessionExpires>'2017-09-12 03:16:36' LIMIT 1
User is logged in
UPDATE perch3_shop_cart SET memberID='55' WHERE cartID='1138'
[1] SELECT * FROM perch3_shop_customers WHERE memberID=55
UPDATE perch3_shop_cart SET customerID='55' WHERE cartID='1138'
------------------------------ setting loc from adr default ------------------------------
default
[1] SELECT * FROM perch3_shop_customers WHERE memberID=55
[1] SELECT * FROM perch3_shop_addresses WHERE customerID='55' AND orderID IS NULL AND countryID>0 AND addressSlug='default'
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationDeleted IS NULL AND ((countryID=176 AND regionID IS NULL) OR locationIsDefault=1) ORDER BY locationIsDefault ASC LIMIT 1
UPDATE perch3_shop_cart SET locationID='1' WHERE cartID='1138'
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1138
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1138
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_customers WHERE memberID=55
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=110 LIMIT 1
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=1138
Tax mode: inc
[1] SELECT * FROM perch3_shop_cart_items WHERE cartID=1138 ORDER BY itemID ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=140 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT billingAddress, shippingAddress FROM perch3_shop_cart WHERE billingAddress IS NOT NULL AND cartID=1138
[1] SELECT * FROM perch3_shop_addresses WHERE customerID='55' AND orderID IS NULL AND countryID>0 AND addressSlug='shipping'
[1] SELECT z.* FROM perch3_shop_shipping_zones z LEFT JOIN perch3_shop_shipping_zone_countries c ON z.zoneID=c.zoneID WHERE z.zoneActive=1 AND z.zoneDeleted IS NULL AND (c.countryID=176 OR zoneIsDefault=1) ORDER BY zoneIsDefault ASC LIMIT 1
[2] SELECT * FROM perch3_shop_shippings WHERE shippingDeleted IS NULL ORDER BY shippingOrder ASC
[1] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1)
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch3_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1)
Qualifying shipping method ‘Kurier’
Qualifying shipping method ‘Odbiór osobisty’
[1] SELECT * FROM perch3_shop_shippings WHERE shippingID='1' AND shippingDeleted IS NULL LIMIT 1
Using shipping zone: Polska
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[nil] SELECT * FROM perch3_shop_promotions WHERE promoFrom<='2017-09-12 03:16:00' AND promoTo>'2017-09-12 03:16:00' AND promoActive=1 AND promoDeleted IS NULL ORDER BY promoOrder ASC
UPDATE perch3_shop_cart SET cartTotalItems='1', cartTotalProducts='1', cartTotalWithTax='324.00', cartTotalWithoutTax='299.00' WHERE cartID='1138'
Template file not found: /home/klient.dhosting.pl/zielonyslon/antibygibaszewski.pl/public_html/perchlogin/login_form.html
------------------------------ here mem ------------------------------
UPDATE perch3_members SET memberPassword=NULL WHERE memberID='55'
No ids to log.
Using template: /addons/apps/perch_shop/templates/shop/customers/customer.html
INSERT INTO perch3_shop_customers(customerDynamicFields,memberID,customerCreated) VALUES('{\"first_name\":\"Adam\",\"last_name\":\"Testowy\",\"email\":\"maciej.pienczewski@gmail.com\",\"tel\":\"790017890\"}','55','2017-09-12 03:16:36')
[1] SELECT * FROM perch3_shop_customers WHERE customerID='120' LIMIT 1
No ids to log.
UPDATE perch3_shop_customers SET customerDynamicFields='{\"first_name\":\"Adam\",\"last_name\":\"Testowy\",\"email\":\"maciej.pienczewski@gmail.com\",\"tel\":\"790017890\"}', memberID='55', customerCreated='2017-09-12 03:16:36', customerFirstName='Adam', customerLastName='Testowy', customerEmail='maciej.pienczewski@gmail.com', customerUpdated='2017-09-12 03:16:36' WHERE customerID='120'
No ids to log.
INSERT INTO perch3_shop_addresses(addressDynamicFields,addressTitle,addressCreated) VALUES('{\"first_name\":\"Adam\",\"last_name\":\"Testowy\",\"address_1\":\"Testowa ulica\",\"postcode\":\"12345\",\"country\":\"176\",\"company\":\"Firma\",\"city\":\"Waw\",\"customer\":\"120\"}','default','2017-09-12 03:16:36')
[1] SELECT * FROM perch3_shop_addresses WHERE addressID='419' LIMIT 1
No ids to log.
UPDATE perch3_shop_addresses SET addressDynamicFields='{\"first_name\":\"Adam\",\"last_name\":\"Testowy\",\"address_1\":\"Testowa ulica\",\"postcode\":\"12345\",\"country\":\"176\",\"company\":\"Firma\",\"city\":\"Waw\",\"customer\":\"120\"}', addressTitle='default', addressCreated='2017-09-12 03:16:36', addressFirstName='Adam', addressLastName='Testowy', addressCompany='Firma', addressLine1='Testowa ulica', customerID='120', countryID='176', addressUpdated='2017-09-12 03:16:36' WHERE addressID='419'
No ids to log.
INSERT INTO perch3_shop_addresses(addressDynamicFields,addressTitle,addressSlug,addressCreated) VALUES('{\"first_name\":\"Adam\",\"last_name\":\"Testowy\",\"address_1\":\"Testowa ulica\",\"postcode\":\"12345\",\"country\":\"176\",\"company\":\"Firma\",\"city\":\"Waw\",\"customer\":\"120\"}','shipping','shipping','2017-09-12 03:16:36')
[1] SELECT * FROM perch3_shop_addresses WHERE addressID='420' LIMIT 1
No ids to log.
UPDATE perch3_shop_addresses SET addressDynamicFields='{\"first_name\":\"Adam\",\"last_name\":\"Testowy\",\"address_1\":\"Testowa ulica\",\"postcode\":\"12345\",\"country\":\"176\",\"company\":\"Firma\",\"city\":\"Waw\",\"customer\":\"120\"}', addressTitle='shipping', addressSlug='shipping', addressCreated='2017-09-12 03:16:36', addressFirstName='Adam', addressLastName='Testowy', addressCompany='Firma', addressLine1='Testowa ulica', customerID='120', countryID='176', addressUpdated='2017-09-12 03:16:36' WHERE addressID='420'
No ids to log.
UPDATE perch3_shop_cart SET billingAddress='default', shippingAddress='shipping' WHERE cartID='1138'
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1138
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1138
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_customers WHERE memberID=55
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=110 LIMIT 1
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=1138
Tax mode: inc
[1] SELECT * FROM perch3_shop_cart_items WHERE cartID=1138 ORDER BY itemID ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=140 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT billingAddress, shippingAddress FROM perch3_shop_cart WHERE billingAddress IS NOT NULL AND cartID=1138
[1] SELECT * FROM perch3_shop_addresses WHERE customerID='55' AND orderID IS NULL AND countryID>0 AND addressSlug='shipping'
[1] SELECT z.* FROM perch3_shop_shipping_zones z LEFT JOIN perch3_shop_shipping_zone_countries c ON z.zoneID=c.zoneID WHERE z.zoneActive=1 AND z.zoneDeleted IS NULL AND (c.countryID=176 OR zoneIsDefault=1) ORDER BY zoneIsDefault ASC LIMIT 1
[2] SELECT * FROM perch3_shop_shippings WHERE shippingDeleted IS NULL ORDER BY shippingOrder ASC
[1] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1)
[1] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1)
Qualifying shipping method ‘Kurier’
Qualifying shipping method ‘Odbiór osobisty’
[1] SELECT * FROM perch3_shop_shippings WHERE shippingID='1' AND shippingDeleted IS NULL LIMIT 1
Using shipping zone: Polska
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[nil] SELECT * FROM perch3_shop_promotions WHERE promoFrom<='2017-09-12 03:16:00' AND promoTo>'2017-09-12 03:16:00' AND promoActive=1 AND promoDeleted IS NULL ORDER BY promoOrder ASC
UPDATE perch3_shop_cart SET cartTotalItems='1', cartTotalProducts='1', cartTotalWithTax='324.00', cartTotalWithoutTax='299.00' WHERE cartID='1138'
------------------------------ setting loc from adr default ------------------------------
default
[1] SELECT * FROM perch3_shop_customers WHERE memberID=55
[1] SELECT * FROM perch3_shop_addresses WHERE customerID='55' AND orderID IS NULL AND countryID>0 AND addressSlug='default'
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationDeleted IS NULL AND ((countryID=176 AND regionID IS NULL) OR locationIsDefault=1) ORDER BY locationIsDefault ASC LIMIT 1
UPDATE perch3_shop_cart SET locationID='1' WHERE cartID='1138'
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1138
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1138
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_customers WHERE memberID=55
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=110 LIMIT 1
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=1138
Tax mode: inc
[1] SELECT * FROM perch3_shop_cart_items WHERE cartID=1138 ORDER BY itemID ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=140 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT billingAddress, shippingAddress FROM perch3_shop_cart WHERE billingAddress IS NOT NULL AND cartID=1138
[1] SELECT * FROM perch3_shop_addresses WHERE customerID='55' AND orderID IS NULL AND countryID>0 AND addressSlug='shipping'
[1] SELECT z.* FROM perch3_shop_shipping_zones z LEFT JOIN perch3_shop_shipping_zone_countries c ON z.zoneID=c.zoneID WHERE z.zoneActive=1 AND z.zoneDeleted IS NULL AND (c.countryID=176 OR zoneIsDefault=1) ORDER BY zoneIsDefault ASC LIMIT 1
[2] SELECT * FROM perch3_shop_shippings WHERE shippingDeleted IS NULL ORDER BY shippingOrder ASC
[1] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1)
[1] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1)
Qualifying shipping method ‘Kurier’
Qualifying shipping method ‘Odbiór osobisty’
[1] SELECT * FROM perch3_shop_shippings WHERE shippingID='1' AND shippingDeleted IS NULL LIMIT 1
Using shipping zone: Polska
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=1
[nil] SELECT * FROM perch3_shop_promotions WHERE promoFrom<='2017-09-12 03:16:00' AND promoTo>'2017-09-12 03:16:00' AND promoActive=1 AND promoDeleted IS NULL ORDER BY promoOrder ASC
UPDATE perch3_shop_cart SET cartTotalItems='1', cartTotalProducts='1', cartTotalWithTax='324.00', cartTotalWithoutTax='299.00' WHERE cartID='1138'
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=1138
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='produkty' LIMIT 1
[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catPath='kategoria//') ORDER BY catTreePosition ASC
Using template: /templates/categories/cat-title.html
[nil] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
Using template: /templates/shop/products/product-title.html
[3] SELECT regionKey, regionHTML FROM perch3_content_regions WHERE regionPage='/sklep/zamowienie/index.php' OR regionPage='*' ORDER BY regionPage DESC
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
[16] SELECT main.* FROM perch3_categories main WHERE 1=1 ORDER BY catTreePosition ASC
[16] Using template: /templates/categories/category.html
Using cart from cache.
[1] SELECT * FROM perch3_shop_products WHERE productID=133 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=133 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=133 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='133' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] Using template: /templates/shop/cart/cart_static.html
Missing variant.
[1] SELECT * FROM perch3_shop_customers WHERE memberID=55
[1] SELECT * FROM perch3_shop_addresses WHERE customerID='55' AND orderID IS NULL AND countryID>0 AND addressSlug='default'
[1] SELECT * FROM perch3_shop_addresses WHERE customerID='55' AND orderID IS NULL AND countryID>0 AND addressSlug='shipping'
Using template: /templates/shop/addresses/confirm.html
[1] SELECT * FROM perch3_shop_countries WHERE countryID='176' LIMIT 1
[1] SELECT * FROM perch3_shop_countries WHERE countryID='176' LIMIT 1
[2] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_admin_index idx JOIN perch3_shop_shippings main ON idx.itemID=main.shippingID AND idx.itemKey='shippingID' JOIN perch3_shop_admin_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='shippingID' AND idx2.indexKey='_id' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, shippingID ) as tbl WHERE (shippingID IN (1, 2)) GROUP BY itemID, sortval ORDER BY sortval ASC
[2] Using template: /templates/shop/shippings/options.html
[1] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1)
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=110 LIMIT 1
[1] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1)
[2] SELECT * FROM perch3_shop_shippings WHERE shippingID IN (1, 2)
Using template: /templates/shop/shippings/method_form.html
Using template: /templates/shop/checkout/confirm.html
[6] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/sklep/zamowienie/index.php' LIMIT 1
[3] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-010-001-002', '000-010-001', '000-010', '000') ORDER BY pageTreePosition DESC
[5] Using template: /templates/navigation/item.html
Using template: /templates/forms/newsletter.html
Array
(
    [type] => 2
    [message] => is_readable(): open_basedir restriction in effect. File(/dev/urandom) is not within the allowed path(s): (/home/klient.dhosting.pl/zielonyslon/antibygibaszewski.pl/:/home/klient.dhosting.pl/zielonyslon/.tmp/:/demonek/www/public/bledy.demonek.com/:/usr/local/lsws/share/autoindex:/usr/local/php/)
    [file] => /home/klient.dhosting.pl/zielonyslon/antibygibaszewski.pl/public_html/perch/core/lib/PasswordHash.class.php
    [line] => 56
)
Maciej Pieńczewski

Maciej Pieńczewski 0 points

  • 4 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Are you logged in?

No, if you mean that I'm logged in to admin panel. I tried different browsers & incognito mode, but I get this all the time.

Drew McLellan

Drew McLellan 2638 points
Perch Support

No, I mean are you logged in as a member at the time?

i used

if (perch_member_logged_in()) {
     echo 'Hello!';
}

and yes I'm logged in. On the same page I use

<?php echo perch_member_get('email') ?>

and it echo correct email typed in step-1.

Ok, I managed to make it work somehow.

I think it was something with if else statement

this one does not work

<?php include($_SERVER['DOCUMENT_ROOT'].'/perch/runtime.php');?>
<?php
if (!perch_member_logged_in()) {
include($_SERVER['DOCUMENT_ROOT'].'/header.php');
include($_SERVER['DOCUMENT_ROOT'].'/sklep/zamowienie/step-1-adres.php');
}
else {
if (!perch_shop_cart_has_property('terms_agreed')) {

include($_SERVER['DOCUMENT_ROOT'].'/header.php');
include($_SERVER['DOCUMENT_ROOT'].'/sklep/zamowienie/step-2-dostawa.php');
} else {
if (isset($_POST['platnosc-przelewem'])){
$return_url = 'some-url';
$cancel_url = 'some-url';
perch_shop_checkout('manual', [
'status' => 'przelew_unpaid',
'return_url' => $return_url,
'cancel_url' => $cancel_url,
]);
}
else {
$return_url = 'some-url';
$cancel_url = 'some-url';
perch_shop_checkout('paypal-express', [
'return_url' => $return_url,
'cancel_url' => $cancel_url,
]);
}
}
}
?>
<?php perch_content('Twoje zamowienie'); ?>
<?php include($_SERVER['DOCUMENT_ROOT'].'/footer.php');?>

this one does

<?php include($_SERVER['DOCUMENT_ROOT'].'/perch/runtime.php');?>
<?php

    if (!perch_member_logged_in()) {
            perch_shop_set_cart_property('terms_agreed', null);
            include($_SERVER['DOCUMENT_ROOT'].'/header.php');
            include($_SERVER['DOCUMENT_ROOT'].'/sklep/zamowienie/step-1-adres.php');
            include($_SERVER['DOCUMENT_ROOT'].'/footer.php');

    }
    elseif (perch_member_logged_in() && !perch_shop_cart_has_property('terms_agreed')) {
                            include($_SERVER['DOCUMENT_ROOT'].'/header.php');
                            include($_SERVER['DOCUMENT_ROOT'].'/sklep/zamowienie/step-2-dostawa.php');
                            include($_SERVER['DOCUMENT_ROOT'].'/footer.php');

    }
    else {
                        if (isset($_POST['platnosc-przelewem'])){
                              $return_url = 'some-url';
                              $cancel_url = 'some-url';
                              perch_shop_checkout('manual', [
                                'status' => 'przelew_unpaid',
                                'return_url' => $return_url,
                                'cancel_url' => $cancel_url,
                              ]);
                        }
                        else {
                              $return_url = 'some-url';
                              $cancel_url = '.some-url';
                              perch_shop_checkout('paypal-express', [
                                'return_url' => $return_url,
                                'cancel_url' => $cancel_url,
                              ]);
                        }
    }


    ?>

    <?php perch_content('Twoje zamowienie'); ?>

Ok, it does not work. I have two shops, both use the same checkout flow, but in one it works now, in the other it does not.

Drew McLellan

Drew McLellan 2638 points
Perch Support

What's the difference between the two?