Whoops, something went wrong :(

#0: PDOException: SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared

File: /www/storephp/src/Database/src/Drivers/CiPdoDriver.php
Line: 102
Trace:
/www/storephp/src/Database/src/Drivers/CiPdoDriver.php:102 - PDOStatement->execute(array[0])
/www/storephp/vendor/codeigniter/framework/system/database/DB_driver.php:792 - XM\Symphony\Database\Drivers\CiPdoDriver->_execute('DELETE FROM `bask...')
/www/storephp/vendor/codeigniter/framework/system/database/DB_driver.php:655 - CI_DB_driver->simple_query('DELETE FROM `bask...')
/www/storephp/src/Database/src/Drivers/CiPdoDriver.php:41 - CI_DB_driver->query('DELETE FROM `bask...', false, false)
/www/storephp/vendor/codeigniter/framework/system/database/DB_query_builder.php:2203 - XM\Symphony\Database\Drivers\CiPdoDriver->query('DELETE FROM `bask...')
/www/storephp/code/helpers/basket_helper.php:1269 - CI_DB_query_builder->delete('`basket_items`', array[2])
/www/storephp/code/controllers/cart/controllers/Cart.php:162 - Basket_helper::revalidate_promotions(false, true, true)
/www/storephp/code/core/CIEX_CodeIgniter.php:528 - Cart->index()
/www/storephp/public_html/index.php:98 - require_once('/www/storephp/cod...')

Debug



PHP Version - toggle (1)

-----------------------
Array
(
    [0] => 8.1.34
)

-----------------------


MVC info - toggle (9)

-----------------------
Array
(
    [0] => URI
    [1] => uri_string: s:4:"cart";
    [2] => segments: a:1:{i:1;s:4:"cart";}
    [3] => routed segments: a:2:{i:1;s:4:"cart";i:2;s:5:"index";}
    [4] => 
    [5] => Router
    [6] => class: s:4:"cart";
    [7] => class location: s:56:"/www/storephp/code/controllers/cart/controllers/Cart.php";
    [8] => method: s:5:"index";
)

-----------------------


SessionData - toggle (5)

-----------------------
Array
(
    [X-B3-TraceId] => fd63a0d4a2e7e0846d4904015968a13e
    [user_token] => NzBkNzA4NGIyOTFkMzc2NjBjMDcyYTU5NGNlYzViMTY0ZGUxYWNhOA==
    [price_code] => WEB
    [currency_used] => USD
    [symbol] => US$
)

-----------------------


DB Timing - toggle (1)

-----------------------
Array
(
    [0] => Total Query Time:             0.1330
)

-----------------------


Queries - toggle (28)

-----------------------
Array
(
    [0] => 
Time: 0.0092:
 SHOW TABLES FROM `s_craftmaster1`

    [1] => 
Time: 0.0093:
 SHOW TABLES FROM `s_craftmaster1`

    [2] => 
Time: 0.0032:
 SELECT `enabled`, `code`, `store_feature_values`.`value` AS `value`
FROM `store_features`
LEFT JOIN `store_feature_values` ON `store_features`.`id` = `store_feature_values`.`store_features_id` AND `store_feature_values`.`locale` = (SELECT xm_settings_value FROM xm_settings WHERE xm_settings_code = "store_default_language")
WHERE code IN(multilanguage_frontside, multilanguage_urls, multilanguage_tables)

    [3] => 
Time: 0.0019:
 SELECT *
FROM `site_email_settings`
ORDER BY `site_email_settings_code` ASC

    [4] => 
Time: 0.0016:
 SELECT *
FROM `xm_settings`
WHERE `xm_settings_code` = 'enable_using_cart_api'
 LIMIT 1

    [5] => 
Time: 0.0034:
 SELECT COUNT(*) AS `numrows`
FROM `basket_items`
WHERE `user_token` = 'NzBkNzA4NGIyOTFkMzc2NjBjMDcyYTU5NGNlYzViMTY0ZGUxYWNhOA=='

    [6] => 
Time: 0.0019:
 SELECT *
FROM `xm_settings`
WHERE xm_settings_code IN(enable_elastic_search_for_listings, enable_elastic_search_for_search, enable_elastic_search_for_menu, enable_elastic_search_for_product_details, use_pricing_library, is_password_policies_enable, enable_product_finder, enable_custom_filters, enable_csrf_at_product_search, api_endpoint, api_version)

    [7] => 
Time: 0.0022:
 SELECT *
FROM `countries`
WHERE `countries_preferred` != 0
AND `countries_active` = 1
ORDER BY `countries_preferred` ASC

    [8] => 
Time: 0.0020:
 SELECT *
FROM `clients`
 LIMIT 1

    [9] => 
Time: 0.0022:
 SELECT *
FROM `arcus_customers`
WHERE `arcus_customers_code` = 'WEBUS'

    [10] => 
Time: 0.0019:
 SELECT *
FROM `currencies`
WHERE `currencies_denom` = 'USD'

    [11] => 
Time: 0.0012:
 SELECT *
FROM `currencies`
WHERE `currencies_id` = 21

    [12] => 
Time: 0.0018:
 SELECT *
FROM `redirections`
WHERE `redirections_from` = '%2Fcart'
AND `redirections_active` = 1
 LIMIT 1

    [13] => 
Time: 0.0030:
 SELECT *
FROM `api_settings`
RIGHT JOIN `api` ON `api_id` = `api_settings_api_id`
WHERE `api_code` = 'moodle'

    [14] => 
Time: 0.0028:
 SELECT * FROM layout_settings
                      WHERE layout_settings_page_id = (SELECT layout_pages_id FROM layout_pages WHERE layout_pages_code = ?) LIMIT 1

    [15] => 
Time: 0.0014:
 SELECT *
FROM `currencies`
WHERE `currencies_symbol` = 'US$'
 LIMIT 1

    [16] => 
Time: 0.0037:
 SELECT
                                layout_settings_page_id page_id,
                                layout_settings_column_id column_id,
                                layout_settings_position_id position_id,
                                layout_settings_module_id module_id,
                                layout_settings_module_support_id support_id,
                                layout_settings_container_id container_id,
                                COALESCE(layout_pages_code,'') pages_code,
                                COALESCE(layout_positions_code,'') positions_code,
                                COALESCE(layout_modules_code,'') modules_code,
                                COALESCE(layout_modules_support_code,'') support_code,
                                COALESCE(layout_containers_code,'') containers_code
                            FROM layout_settings
                            LEFT JOIN layout_pages ON layout_settings_page_id = layout_pages_id
                            LEFT JOIN layout_positions ON layout_settings_position_id = layout_positions_id
                            LEFT JOIN layout_modules ON layout_settings_module_id = layout_modules_id
                            LEFT JOIN layout_modules_support ON layout_settings_module_support_id = layout_modules_support_id
                            LEFT JOIN layout_containers ON layout_settings_container_id = layout_containers_id
                            WHERE layout_settings_page_id = (SELECT layout_pages_id FROM layout_pages WHERE layout_pages_code = ?)
                            ORDER BY layout_settings_position_id, layout_settings_container_id

    [17] => 
Time: 0.0010:
 SELECT * FROM layout_settings
                      WHERE layout_settings_page_id = (SELECT layout_pages_id FROM layout_pages WHERE layout_pages_code = ?) LIMIT 1

    [18] => 
Time: 0.0010:
 SELECT
                                layout_settings_page_id page_id,
                                layout_settings_column_id column_id,
                                layout_settings_position_id position_id,
                                layout_settings_module_id module_id,
                                layout_settings_module_support_id support_id,
                                layout_settings_container_id container_id,
                                COALESCE(layout_pages_code,'') pages_code,
                                COALESCE(layout_positions_code,'') positions_code,
                                COALESCE(layout_modules_code,'') modules_code,
                                COALESCE(layout_modules_support_code,'') support_code,
                                COALESCE(layout_containers_code,'') containers_code
                            FROM layout_settings
                            LEFT JOIN layout_pages ON layout_settings_page_id = layout_pages_id
                            LEFT JOIN layout_positions ON layout_settings_position_id = layout_positions_id
                            LEFT JOIN layout_modules ON layout_settings_module_id = layout_modules_id
                            LEFT JOIN layout_modules_support ON layout_settings_module_support_id = layout_modules_support_id
                            LEFT JOIN layout_containers ON layout_settings_container_id = layout_containers_id
                            WHERE layout_settings_page_id = (SELECT layout_pages_id FROM layout_pages WHERE layout_pages_code = ?)
                            ORDER BY layout_settings_position_id, layout_settings_container_id

    [19] => 
Time: 0.0010:
 SELECT *
FROM `arcus_customers`
WHERE `arcus_customers_code` = 'WEBUS'

    [20] => 
Time: 0.0447:
 SELECT *
FROM `payment_methods`
WHERE `payment_methods_code` = 'paypal_express'
 LIMIT 1

    [21] => 
Time: 0.0068:
 SELECT *
FROM `gateway_settings`
WHERE `gateway_settings_gateway` = 'paypal_express'
AND `gateway_settings_terminal` = 1

    [22] => 
Time: 0.0057:
 SELECT *
FROM `payment_terms`
WHERE payment_terms_codeterm IN(MCV)

    [23] => 
Time: 0.0015:
 SELECT *
FROM `payment_methods`
WHERE `payment_methods_code` = 'paypalcheckout'
 LIMIT 1

    [24] => 
Time: 0.0015:
 SELECT *
FROM `gateway_settings`
WHERE `gateway_settings_gateway` = 'paypalcheckout'
AND `gateway_settings_terminal` = 1

    [25] => 
Time: 0.0006:
 SELECT *
FROM `payment_terms`
WHERE payment_terms_codeterm IN(MCV)

    [26] => 
Time: 0.0164:
 SELECT *
FROM `promotions_used`
JOIN `promotions` ON `promotions`.`promotions_code` = `promotions_used`.`promotions_used_code`
WHERE `promotions_used_utoken` = 'NzBkNzA4NGIyOTFkMzc2NjBjMDcyYTU5NGNlYzViMTY0ZGUxYWNhOA=='
AND `promotions_used_status` = 0
AND JSON_CONTAINS(promotions_scope, '"b2c"')

    [27] => 
Time: 0.0000:
 DELETE FROM `basket_items`
WHERE `user_token` = 'NzBkNzA4NGIyOTFkMzc2NjBjMDcyYTU5NGNlYzViMTY0ZGUxYWNhOA=='
AND `promoflag` = 1

)

-----------------------


Queries List - toggle (16)

-----------------------
Array
(
    [layout_settings] => ________________________________________4 queries, time: 8.53ms
    [currencies] => _____________________________________________3 queries, time: 4.55ms
    [s_craftmaster1] => _________________________________________2 queries, time: 18.51ms
    [xm_settings] => ____________________________________________2 queries, time: 3.52ms
    [basket_items] => ___________________________________________2 queries, time: 3.43ms
    [arcus_customers] => ________________________________________2 queries, time: 3.19ms
    [payment_methods] => ________________________________________2 queries, time: 46.19ms
    [gateway_settings] => _______________________________________2 queries, time: 8.31ms
    [payment_terms] => __________________________________________2 queries, time: 6.36ms
    [store_features] => _________________________________________1 queries, time: 3.15ms
    [site_email_settings] => ____________________________________1 queries, time: 1.86ms
    [countries] => ______________________________________________1 queries, time: 2.16ms
    [clients] => ________________________________________________1 queries, time: 2.02ms
    [redirections] => ___________________________________________1 queries, time: 1.83ms
    [api_settings] => ___________________________________________1 queries, time: 3.02ms
    [promotions_used] => ________________________________________1 queries, time: 16.38ms
)

-----------------------


Platform API Calls - toggle (6)

-----------------------
Array
(
    [0] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/store-features -> 200 [30.77ms]
            [2] => Array
                (
                    [X-B3-TraceId] => fd63a0d4a2e7e0846d4904015968a13e
                    [X-B3-SpanId] => 8e6274c6f074c1e7
                )

        )

    [1] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/xm-settings -> 200 [20.70ms]
            [2] => Array
                (
                    [X-B3-TraceId] => fd63a0d4a2e7e0846d4904015968a13e
                    [X-B3-SpanId] => e7c9826e80645919
                )

        )

    [2] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/store-mode -> 200 [22.17ms]
            [2] => Array
                (
                    [X-B3-TraceId] => fd63a0d4a2e7e0846d4904015968a13e
                    [X-B3-SpanId] => bebce2875ea8a26c
                )

        )

    [3] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/module/all -> 200 [23.09ms]
            [2] => Array
                (
                    [X-B3-TraceId] => fd63a0d4a2e7e0846d4904015968a13e
                    [X-B3-SpanId] => 096216e9d8934a70
                )

        )

    [4] => Array
        (
            [0] => XM\Symphony\SymphonyApi\SymphonyApiClient->get()
            [1] => GET /api/v/1/settings/labels -> 200 [22.32ms]
            [2] => Array
                (
                    [X-B3-TraceId] => fd63a0d4a2e7e0846d4904015968a13e
                    [X-B3-SpanId] => 1270244f0a72ba8c
                )

        )

    [5] => Array
        (
            [Total API Response Time:] => 0.11905 sec
        )

)

-----------------------


Timing - toggle (1)

-----------------------
Array
(
    [0] => Page Load Time:               0.973 seconds.
)

-----------------------