Exception Object
(
    [message:protected] =>      (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND catgd.name_main<>'' AND catgd.name_url<>'' AND FIND_IN_SET('ARCHIVED',catgd.' at line 13)
    [string:private] => exception 'Exception' with message '     (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND catgd.name_main<>'' AND catgd.name_url<>'' AND FIND_IN_SET('ARCHIVED',catgd.' at line 13)' in /home/salecent/salecenter.com.ua/library/Adelite/DB/MySQL.php:61
Stack trace:
#0 /home/salecent/salecenter.com.ua/library/Adelite/Query/Shop.php(196): Adelite_DB_MySQL->execute('SELECT catgd.id...')
#1 /home/salecent/salecenter.com.ua/library/Adelite/Model/Shop.php(191): Adelite_Query_Shop->_Products(NULL, Array)
#2 /home/salecent/salecenter.com.ua/library/Adelite/Model/Shop.php(202): Adelite_Model_Shop->getProducts(NULL, Array, '1.00')
#3 /home/salecent/salecenter.com.ua/webapp/modules/controllers/BrandController.php(77): Adelite_Model_Shop->getProductsWithImg(NULL, Array, 3, '1.00')
#4 /home/salecent/salecenter.com.ua/webapp/modules/controllers/BrandController.php(13): BrandController->brandAction('Fisher%20Price')
#5 /home/salecent/salecenter.com.ua/library/Zend/Controller/Action.php(512): BrandController->indexAction()
#6 /home/salecent/salecenter.com.ua/library/Zend/Controller/Dispatcher/Standard.php(288): Zend_Controller_Action->dispatch('indexAction')
#7 /home/salecent/salecenter.com.ua/library/Zend/Controller/Front.php(936): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#8 /home/salecent/salecenter.com.ua/www/index.php(51): Zend_Controller_Front->dispatch()
#9 {main}
    [code:protected] => 0
    [file:protected] => /home/salecent/salecenter.com.ua/library/Adelite/DB/MySQL.php
    [line:protected] => 61
    [trace:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/salecent/salecenter.com.ua/library/Adelite/Query/Shop.php
                    [line] => 196
                    [function] => execute
                    [class] => Adelite_DB_MySQL
                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT catgd.id, catgd.name_main AS name, catgd.name_main AS name, catgd.parent_id AS pid, ROUND(catgd.rating) AS rating, catgd.descr_small AS description, catgd.name_url , 
@is_akcia:=IF(is_akcia AND ( NOW() BETWEEN akcia_from AND akcia_to OR akcia_to = 0 ), is_akcia, NULL) AS is_akcia, 
@is_novelty:=IF(is_novelty AND ( NOW() BETWEEN novelty_from AND novelty_to OR novelty_to = 0 ), is_novelty, NULL) AS is_novelty, 
@is_discount:=IF(is_discount AND ( NOW() BETWEEN discount_from AND discount_to OR discount_to = 0), is_discount, NULL) AS is_discount,price_result, price_out, status_out, 
@price:=( IF( @is_akcia AND akcia_price>0, akcia_price, IF( @is_novelty AND novelty_price>0, novelty_price, IF( @is_discount AND discount_price>0, discount_price, catgd.price_result)))*1.00) AS new_price, 
(IF((@is_akcia OR @is_novelty OR @is_discount) AND @price>0 /*AND @price<>(catgd.price_out*1.00)*/, catgd.price_out, NULL)*1.00) AS old_price, round((price_out - @price) * 1.00, 2) as percent_count,
                         if( @price, round( (price_out - @price) / @price * 1.00 * 100, 0), 0 ) as percent_new ,
@akcia_percent:=IF(@is_akcia AND akcia_percent>0 AND akcia_price=0, akcia_percent,0) as akcia_percent,
@novelty_percent:=IF(@is_novelty AND novelty_percent>0 AND novelty_price=0 AND akcia_price=0, novelty_percent,NULL) as novelty_percent,
@discount_percent:=IF(@is_discount AND discount_percent>0 AND discount_price AND novelty_price=0 AND akcia_price=0, discount_percent,NULL) as discount_percent,
IF (@akcia_percent > 0,@akcia_percent,IF(@novelty_percent>0,@novelty_percent,IF(@discount_percent>0,@discount_percent,0))) as percent
FROM shop_catalog_goods catgd 
WHERE catgd.parent_id  AND catgd.brand_id =  AND catgd.name_main<>'' AND catgd.name_url<>'' AND FIND_IN_SET('ARCHIVED',catgd.flags)=0 AND FIND_IN_SET('HIDDEN',catgd.flags)=0 AND FIND_IN_SET('DELETED',catgd.flags)=0 AND catgd.price_result>0 AND catgd.status_out=2 /*catgd.flags NOT IN (0,2,3) AND (catgd.status_out=2 OR catgd.status_out=1)*/
GROUP BY catgd.id
ORDER BY ordering ASC
                        )

                )

            [1] => Array
                (
                    [file] => /home/salecent/salecenter.com.ua/library/Adelite/Model/Shop.php
                    [line] => 191
                    [function] => _Products
                    [class] => Adelite_Query_Shop
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
                            [1] => Array
                                (
                                    [select] => , 
@is_akcia:=IF(is_akcia AND ( NOW() BETWEEN akcia_from AND akcia_to OR akcia_to = 0 ), is_akcia, NULL) AS is_akcia, 
@is_novelty:=IF(is_novelty AND ( NOW() BETWEEN novelty_from AND novelty_to OR novelty_to = 0 ), is_novelty, NULL) AS is_novelty, 
@is_discount:=IF(is_discount AND ( NOW() BETWEEN discount_from AND discount_to OR discount_to = 0), is_discount, NULL) AS is_discount,price_result, price_out, status_out, 
@price:=( IF( @is_akcia AND akcia_price>0, akcia_price, IF( @is_novelty AND novelty_price>0, novelty_price, IF( @is_discount AND discount_price>0, discount_price, catgd.price_result)))*1.00) AS new_price, 
(IF((@is_akcia OR @is_novelty OR @is_discount) AND @price>0 /*AND @price<>(catgd.price_out*1.00)*/, catgd.price_out, NULL)*1.00) AS old_price, round((price_out - @price) * 1.00, 2) as percent_count,
                         if( @price, round( (price_out - @price) / @price * 1.00 * 100, 0), 0 ) as percent_new 
                                    [from] => 
                                    [where] => catgd.brand_id = 
                                    [group] => 
                                    [having] => 
                                    [order] => 
                                    [limit] => 
                                )

                        )

                )

            [2] => Array
                (
                    [file] => /home/salecent/salecenter.com.ua/library/Adelite/Model/Shop.php
                    [line] => 202
                    [function] => getProducts
                    [class] => Adelite_Model_Shop
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
                            [1] => Array
                                (
                                    [where] => catgd.brand_id = 
                                )

                            [2] => 1.00
                        )

                )

            [3] => Array
                (
                    [file] => /home/salecent/salecenter.com.ua/webapp/modules/controllers/BrandController.php
                    [line] => 77
                    [function] => getProductsWithImg
                    [class] => Adelite_Model_Shop
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
                            [1] => Array
                                (
                                    [where] => catgd.brand_id = 
                                )

                            [2] => 3
                            [3] => 1.00
                        )

                )

            [4] => Array
                (
                    [file] => /home/salecent/salecenter.com.ua/webapp/modules/controllers/BrandController.php
                    [line] => 13
                    [function] => brandAction
                    [class] => BrandController
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Fisher%20Price
                        )

                )

            [5] => Array
                (
                    [file] => /home/salecent/salecenter.com.ua/library/Zend/Controller/Action.php
                    [line] => 512
                    [function] => indexAction
                    [class] => BrandController
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [6] => Array
                (
                    [file] => /home/salecent/salecenter.com.ua/library/Zend/Controller/Dispatcher/Standard.php
                    [line] => 288
                    [function] => dispatch
                    [class] => Zend_Controller_Action
                    [type] => ->
                    [args] => Array
                        (
                            [0] => indexAction
                        )

                )

            [7] => Array
                (
                    [file] => /home/salecent/salecenter.com.ua/library/Zend/Controller/Front.php
                    [line] => 936
                    [function] => dispatch
                    [class] => Zend_Controller_Dispatcher_Standard
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Zend_Controller_Request_Http Object
                                (
                                    [_paramSources:protected] => Array
                                        (
                                            [0] => _GET
                                            [1] => _POST
                                        )

                                    [_requestUri:protected] => /default/Brand/index/Fisher%20Price/
                                    [_baseUrl:protected] => 
                                    [_basePath:protected] => 
                                    [_pathInfo:protected] => /default/Brand/index/Fisher%20Price/
                                    [_params:protected] => Array
                                        (
                                            [module] => default
                                            [controller] => Brand
                                            [action] => index
                                        )

                                    [_aliases:protected] => Array
                                        (
                                        )

                                    [_dispatched:protected] => 1
                                    [_module:protected] => default
                                    [_moduleKey:protected] => module
                                    [_controller:protected] => Brand
                                    [_controllerKey:protected] => controller
                                    [_action:protected] => index
                                    [_actionKey:protected] => action
                                )

                            [1] => Zend_Controller_Response_Http Object
                                (
                                    [_body:protected] => Array
                                        (
                                            [BigBanner] => 
                                            [LeftBanner] => 
                                            [RightBanner] => 
                                            [Listalka] => 
[Menu] => [Crumbs] =>
» » Fisher Price
[Cart] =>
- 0
- 0
[Footer] =>