PS 1.7.5 - chaning color - An error occurred while processing your request

[jawas]

Hi,

I have a problem with prestashop 1.7.5. I added products and combinations to a new, fresh store - colors and sizes. Everything worked until it stopped 🙂 now, when I want to change the color on the front I have an error: An error occurred while processing your request.

I was looking for this problem, but it was about another issue (ajax, not mysql)

Can anyone meet and know how to solve it?

 

And it looks exactly like I suspect:

[PrestaShopDatabaseException]

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') GROUP BY pac.id_product_attribute ' at line 8
 

                    SELECT
                        pac.`id_product_attribute`
                    FROM
                        `ps_product_attribute_combination` pac
                        INNER JOIN `ps_product_attribute` pa ON pa.id_product_attribute = pac.id_product_attribute
                    WHERE
                        pa.id_product = 28
                        AND pac.id_attribute IN ()
                    GROUP BY
                        pac.id_product_attribute
                    HAVING
                        COUNT(pa.id_product) = 0 LIMIT 1

at line 769 in file classes/db/Db.php

 

764.         if ($webservice_call && $errno) {
765.             $dbg = debug_backtrace();
766.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97);
767.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
768.             if ($sql) {
769.                 throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>');
770.             }
771. 
772.             throw new PrestaShopDatabaseException($this->getMsgError());
773.         }
774.     }

 

[regatonseb]

Hello did you solde it ?

Thanks