Jump to content

error in supercheckout addon


Recommended Posts

hey, i am using supercheckout addon by knowband for my checkout.

their support is just horrible.. so i am seeking for your help.

when  i submit the order with all the right details i get this error in the php log:

 

[Sun Jul 14 17:16:22.037605 2019] [proxy_fcgi:error] [pid 216904:tid 140272972580608] [client 79.178.57.211:65280] AH01071: Got error 'PHP message: 
            SELECT
                p.*, product_shop.*,
                stock.out_of_stock,
                IFNULL(stock.quantity, 0) as quantity,
                MAX(product_attribute_shop.id_product_attribute) id_product_attribute,
                product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,
                pl.`description`,
                pl.`description_short`,
                pl.`available_now`,
                pl.`available_later`,
                pl.`link_rewrite`,
                pl.`meta_description`,
                pl.`meta_keywords`,
                pl.`meta_title`,
                pl.`name`,
                pl.`id_product`,
                MAX(image_shop.`id_image`) id_image,
                il.`legend`,
                m.`name` AS manufacturer_name,
                cl.`name` AS category_default,
                product_shop.price AS orderprice FROM `ps_product` p
             INNER JOIN ps_product_shop product_shop
        ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
            LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product`)
             LEFT JOIN ps_product_attribute_shop product_attribute_shop
        ON (product_attribute_shop.id_product_attribute = pa.id_product_attri...
PHP message: 
            SELECT
                p.*, product_shop.*,
                stock.out_of_stock,
                IFNULL(stock.quantity, 0) as quantity,
                MAX(product_attribute_shop.id_product_attribute) id_product_attribute,
                product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,
                pl.`description`,
                pl.`description_short`,
                pl.`available_now`,
                pl.`available_later`,
                pl.`link_rewrite`,
                pl.`meta_description`,
                pl.`meta_keywords`,
                pl.`meta_title`,
                pl.`name`,
                pl.`id_product`,
                MAX(image_shop.`id_image`) id_image,
                il.`legend`,
                m.`name` AS manufacturer_name,
                cl.`name` AS category_default,
                product_shop.price AS orderprice FROM `ps_product` p
             INNER JOIN ps_product_shop product_shop
        ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
            LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product`)
             LEFT JOIN ps_product_attribute_shop product_attribute_shop
        ON (product_attribute_shop.id_product_attribute = pa.id_product_attri...
PHP message: 
            SELECT
                p.*, product_shop.*,
                stock.out_of_stock,
                IFNULL(stock.quantity, 0) as quantity,
                MAX(product_attribute_shop.id_product_attribute) id_product_attribute,
                product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,
                pl.`description`,
                pl.`description_short`,
                pl.`available_now`,
                pl.`available_later`,
                pl.`link_rewrite`,
                pl.`meta_description`,
                pl.`meta_keywords`,
                pl.`meta_title`,
                pl.`name`,
                pl.`id_product`,
                MAX(image_shop.`id_image`) id_image,
                il.`legend`,
                m.`name` AS manufacturer_name,
                cl.`name` AS category_default,
                product_shop.price AS orderprice FROM `ps_product` p
             INNER JOIN ps_product_shop product_shop
        ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
            LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product`)
             LEFT JOIN ps_product_attribute_shop product_attribute_shop
        ON (product_attribute_shop.id_product_attribute = pa.id_product_attri...
PHP message: 
            SELECT
                p.*, product_shop.*,
                stock.out_of_stock,
                IFNULL(stock.quantity, 0) as quantity,
                MAX(product_attribute_shop.id_product_attribute) id_product_attribute,
                product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,
                pl.`description`,
                pl.`description_short`,
                pl.`available_now`,
                pl.`available_later`,
                pl.`link_rewrite`,
                pl.`meta_description`,
                pl.`meta_keywords`,
                pl.`meta_title`,
                pl.`name`,
                pl.`id_product`,
                MAX(image_shop.`id_image`) id_image,
                il.`legend`,
                m.`name` AS manufacturer_name,
                cl.`name` AS category_default,
                product_shop.price AS orderprice FROM `ps_product` p
             INNER JOIN ps_product_shop product_shop
        ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
            LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product`)
             LEFT JOIN ps_product_attribute_shop product_attribute_shop
        ON (product_attribute_shop.id_product_attribute = pa.id_product_attri...
', referer: https://sadeflowers.nethost.co.il/module/supercheckout/supercheckout

Share this post


Link to post
Share on other sites

The error is uncompleted.. but probably the query is wrong. You should try to get the complete query or try to identify where it is executed, then log it, execute it manually and fix the error.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More