Jump to content
Sign in to follow this  
jawas

PS 1.7.5 - zmiana koloru - An error occurred while processing your request

Recommended Posts

Mam problem z Prestą i to dziwny, bo nie wystąpił od razu. Mianowicie dodawałem produkty i kombinacje do nowego, świeżego sklepu - kolor i rozmiar. Wszystko działało, aż w końcu przestało... Mianowice teraz, gdy chcę zmienic kolor na froncie mam błąd: An error occurred while processing your request.

Czy ktoś może się spotkał i wie jak to rozwiązać ?

 

A dokładnie wygląda to tak jak podejrzę:

[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.     }

 

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
Sign in to follow this  

×

Important Information

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