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
)