------------------------------------------------------------------------------------------------------------------------ ************************************************************************************************************************* Array ( [src] => orm [msg] => [Mysql] Object:cms; Error "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 `ProductShopCategory_ShopProduct_id`.connection_type = 'member' AND 1 AND' at line 81" encountered while executing query [query] => SELECT shop_products.`tmp_id` AS `ShopProduct:tmp_id`, shop_products.`id` AS `ShopProduct:id`, shop_products.`u_id` AS `ShopProduct:u_id`, shop_products.`description_id` AS `ShopProduct:description_id`, shop_products.`category_id` AS `ShopProduct:category_id`, shop_products.`name` AS `ShopProduct:name`, shop_products.`price` AS `ShopProduct:price`, shop_products.`active` AS `ShopProduct:active`, shop_products.`manufacturer_id` AS `ShopProduct:manufacturer_id`, shop_products.`warranty` AS `ShopProduct:warranty`, shop_products.`weight` AS `ShopProduct:weight`, shop_products.`description_short` AS `ShopProduct:description_short`, shop_products.`description_long` AS `ShopProduct:description_long`, shop_products.`description_news` AS `ShopProduct:description_news`, shop_products.`availability` AS `ShopProduct:availability`, shop_products.`g_zamiennik` AS `ShopProduct:g_zamiennik`, shop_products.`on_depot` AS `ShopProduct:on_depot`, shop_products.`top` AS `ShopProduct:top`, shop_products.`promotion` AS `ShopProduct:promotion`, shop_products.`product_code` AS `ShopProduct:product_code`, shop_products.`product_code_clean` AS `ShopProduct:product_code_clean`, shop_products.`producent_code` AS `ShopProduct:producent_code`, shop_products.`seo_title` AS `ShopProduct:seo_title`, shop_products.`seo_keywords` AS `ShopProduct:seo_keywords`, shop_products.`seo_description` AS `ShopProduct:seo_description`, shop_products.`vat` AS `ShopProduct:vat`, shop_products.`sort` AS `ShopProduct:sort`, shop_products.`subiekt_id` AS `ShopProduct:subiekt_id`, shop_products.`export` AS `ShopProduct:export`, shop_products.`on_banner` AS `ShopProduct:on_banner`, shop_products.`price_netto` AS `ShopProduct:price_netto`, shop_products.`price_brutto` AS `ShopProduct:price_brutto`, shop_products.`price_unit` AS `ShopProduct:price_unit`, shop_products.`promotion_send` AS `ShopProduct:promotion_send`, shop_products.`updated` AS `ShopProduct:updated`, shop_products.`type` AS `ShopProduct:type`, shop_products.`amount` AS `ShopProduct:amount`, shop_products.`amount_min` AS `ShopProduct:amount_min`, shop_products.`rewrite_id` AS `ShopProduct:rewrite_id`, shop_products.`opak1` AS `ShopProduct:opak1`, shop_products.`nopak1` AS `ShopProduct:nopak1`, shop_products.`opak2` AS `ShopProduct:opak2`, shop_products.`nopak2` AS `ShopProduct:nopak2`, shop_products.`opak` AS `ShopProduct:opak`, shop_products.`jmprzelicz` AS `ShopProduct:jmprzelicz`, shop_products.`jmporown` AS `ShopProduct:jmporown`, shop_products.`value1_string` AS `ShopProduct:value1_string`, shop_products.`value2_string` AS `ShopProduct:value2_string`, shop_products.`value3_string` AS `ShopProduct:value3_string`, `ProductShopCategory_ShopProduct_id`.`id` AS `ProductShopCategory:id`, `ProductShopCategory_ShopProduct_id`.`product_id` AS `ProductShopCategory:product_id`, `ProductShopCategory_ShopProduct_id`.`category_id` AS `ProductShopCategory:category_id`, `ProductShopCategory_ShopProduct_id`.`connection_type` AS `ProductShopCategory:connection_type`, `ProductShopCategory_ShopProduct_id`.`tmp_id` AS `ProductShopCategory:tmp_id`, `ShopProductProperty_ShopProduct_id`.`id` AS `ShopProductProperty:id`, `ShopProductProperty_ShopProduct_id`.`product_id` AS `ShopProductProperty:product_id`, `ShopProductProperty_ShopProduct_id`.`property_id` AS `ShopProductProperty:property_id`, `ShopProductProperty_ShopProduct_id`.`property_dictionary_id` AS `ShopProductProperty:property_dictionary_id`, `ShopProductProperty_ShopProduct_id`.`text_value` AS `ShopProductProperty:text_value`, `ShopProductProperty_ShopProduct_id`.`tmp_id` AS `ShopProductProperty:tmp_id`, `ShopProperty_ShopProductProperty_property_id`.`id` AS `ShopProperty:id`, `ShopProperty_ShopProductProperty_property_id`.`category_id` AS `ShopProperty:category_id`, `ShopProperty_ShopProductProperty_property_id`.`name` AS `ShopProperty:name`, `ShopProperty_ShopProductProperty_property_id`.`type` AS `ShopProperty:type`, `ShopProperty_ShopProductProperty_property_id`.`unit` AS `ShopProperty:unit`, `ShopProperty_ShopProductProperty_property_id`.`propagation` AS `ShopProperty:propagation`, `ShopProperty_ShopProductProperty_property_id`.`sort` AS `ShopProperty:sort`, `ShopProperty_ShopProductProperty_property_id`.`show_in_filters` AS `ShopProperty:show_in_filters`, `ShopProperty_ShopProductProperty_property_id`.`show_in_short_desc` AS `ShopProperty:show_in_short_desc`, `ShopProperty_ShopProductProperty_property_id`.`filter_type` AS `ShopProperty:filter_type`, `ShopProperty_ShopProductProperty_property_id`.`multi_values` AS `ShopProperty:multi_values`, `ShopPropertyDictionary_ShopProductProperty_property_dictionary_id`.`id` AS `ShopPropertyDictionary:id`, `ShopPropertyDictionary_ShopProductProperty_property_dictionary_id`.`property_id` AS `ShopPropertyDictionary:property_id`, `ShopPropertyDictionary_ShopProductProperty_property_dictionary_id`.`value` AS `ShopPropertyDictionary:value` FROM shop_products LEFT JOIN shop_product_category AS `ProductShopCategory_ShopProduct_id` ON (shop_products.id=`ProductShopCategory_ShopProduct_id`.product_id ) LEFT JOIN shop_product_property AS `ShopProductProperty_ShopProduct_id` ON (shop_products.id=`ShopProductProperty_ShopProduct_id`.product_id ) LEFT JOIN shop_properties AS `ShopProperty_ShopProductProperty_property_id` ON (`ShopProductProperty_ShopProduct_id`.property_id=`ShopProperty_ShopProductProperty_property_id`.id ) LEFT JOIN shop_properties_dictionary AS `ShopPropertyDictionary_ShopProductProperty_property_dictionary_id` ON (`ShopProductProperty_ShopProduct_id`.property_dictionary_id=`ShopPropertyDictionary_ShopProductProperty_property_dictionary_id`.id ) WHERE shop_products.rewrite_id = AND `ProductShopCategory_ShopProduct_id`.connection_type = 'member' AND 1 AND 1 AND 1 AND 1 ORDER BY `ShopProperty_ShopProductProperty_property_id`.`sort` ASC , `ShopPropertyDictionary_ShopProductProperty_property_dictionary_id`.`sort` ASC ) *************************************************************************************************************************

Internal Server Error

[Mysql] Object:cms; Error "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 `ProductShopCategory_ShopProduct_id`.connection_type = 'member' AND 1 AND' at line 81" encountered while executing query

Exception data:Line: 158; Code: 0; Time: Tuesday 26th September 2017 12:27:28 AM
Exception file:/new.upromex.pl/server/standardModels/org/arrowplatform/orm/db/ArrowOrmMysql.php
153                 //ArrowLogger::log("[Mysql] Object:{$this->alias}; Transaction rolled back",ArrowLogger::EL_INFO);
154             }            
155         }
156         //ArrowLogger::log("[Mysql] Object:{$this->alias}; Error \"{$error}\" encountered while executing \"{$action}\" ",ArrowLogger::EL_ERROR);        
157         //$action = nl2br($action);
158         throw new ArrowOrmException( array( "msg" => "[Mysql] Object:{$this->alias}; Error \"{$error}\" encountered while executing query", "query" => "{$action}"));//TODO::Tekst wyjÄ…tku    
159     }
160
161     /**
162      * Returns rows
[Stack Trace]
#0 /new.upromex.pl/server/standardModels/org/arrowplatform/orm/db/ArrowOrmMysql.php(303): ArrowOrmMysql->error('SELECT ???shop...', 'You have an err...') #1 /new.upromex.pl/server/standardModels/org/arrowplatform/orm/db/ArrowOrmMysql.php(516): ArrowOrmMysql->query('SELECT ???shop...') #2 /new.upromex.pl/server/standardModels/org/arrowplatform/orm/ArrowOrmSqlRouter.php(179): ArrowOrmMysql->join(Object(ArrowOrmJoinCriteria), false) #3 /new.upromex.pl/server/standardModels/org/arrowplatform/orm/ArrowOrmPersistent.php(268): ArrowOrmSqlRouter::join('cms', Object(ArrowOrmJoinCriteria), false) #4 /new.upromex.pl/server/standardModels/org/arrowplatform/orm/ArrowOrmPersistent.php(228): ArrowOrmPersistent::getByCriteriaJoin(Object(ArrowOrmJoinCriteria), 'ShopProduct') #5 /new.upromex.pl/projects/crm/models/abstract/ProjectPersistent.php(199): ArrowOrmPersistent::getByCriteria(Object(ArrowOrmJoinCriteria), 'ShopProduct') #6 /new.upromex.pl/cache/templates/classes/page_logic_crm_shop_plugins_products_one_product_120.php(150): ProjectPersistent::getByCriteria(Object(ArrowOrmJoinCriteria), 'ShopProduct') #7 /new.upromex.pl/server/standardModels/org/arrowplatform/engine/templatesSystem/templates/ArrowTemplateLinker.php(101): ArrowPageClass120->createView() #8 /new.upromex.pl/projects/crm/models/cms/persistent/pages/CMSPage.php(157): ArrowTemplateLinker->handleTemplateCall(Array, false) #9 /new.upromex.pl/cache/templates/classes/page_logic_crm_application_index_1.php(50): CMSPage->prepareModules() #10 /new.upromex.pl/index.php(116): ArrowSchemaClass1->createPage() #11 {main}
[Input Data]
  • ... (Array, 2 elements)
  • Krumo version 0.2.1a
    | http://krumo.sourceforge.net
    Called from /new.upromex.pl/server/standardModels/org/arrowplatform/standardHandlers/ExceptionHandler.php, line 179  
  • ... (Array, 0 elements)
  • Krumo version 0.2.1a
    | http://krumo.sourceforge.net
    Called from /new.upromex.pl/server/standardModels/org/arrowplatform/standardHandlers/ExceptionHandler.php, line 179  
  • ... (Array, 0 elements)
  • Krumo version 0.2.1a
    | http://krumo.sourceforge.net
    Called from /new.upromex.pl/server/standardModels/org/arrowplatform/standardHandlers/ExceptionHandler.php, line 179  
  • ... (NULL)
  • Krumo version 0.2.1a
    | http://krumo.sourceforge.net
    Called from /new.upromex.pl/server/standardModels/org/arrowplatform/standardHandlers/ExceptionHandler.php, line 179  
[Session Data]
  • ... (Array, 1 element)
  • Krumo version 0.2.1a
    | http://krumo.sourceforge.net
    Called from /new.upromex.pl/server/standardModels/org/arrowplatform/standardHandlers/ExceptionHandler.php, line 187  
[Stack Trace - long] Uruchom