Hallo allerseits, ich habe gerade versucht in meinem noch nicht fertiggestellten Shop (Version Gambio GX3 v3.3.1.2, Homepage: www.feinmarkthalle.de) einen Artikel aufzurufen, der bis gestern noch funktionierte und es kommt mir eine weiße Seite mit der Meldung USER ERROR(256): "SQL Error" Ich habe dann versucht weitere Artikel aufzurufen, und ich bekomme überall die gleiche Meldung. Alle weitere Funktionen des Shops scheinen OK zu sein. Ich habe jetzt das LOG gereinigt und noch mal ein Produkt aufgerufen damit nur diese eine Meldung im LOG ist, und ich hoffe dass jemand daraus die Fehlerquelle auslesen kann. Der Anfang der Meldung sagt Syntax Error, ich kann leider nicht viel damit anfangen... Hier ist der Log: Code: 2017-01-23 12:31:40 (3af472b90051715381d0c5f46deed751) SQL ERROR(1064): "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 '.products_name, pd.products_short_description, pd.prod' at line 8" in /is/htdocs/wp12161028_ROM2SXPAMZ/www/inc/xtc_db_error.inc.php:23 #10 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/inc/xtc_db_error.inc.php:23 #9 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/inc/xtc_db_query.inc.php:69 #8 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/GXUserComponents/overloads/product/model_product.inc.php:231 #7 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/system/classes/listing/CrossSellingContentView.inc.php:76 #6 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/system/classes/listing/CrossSellingContentView.inc.php:46 #5 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/system/core/ContentView.inc.php:121 #4 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/system/classes/products/ProductInfoContentView.inc.php:455 #3 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/system/classes/products/ProductInfoContentView.inc.php:252 #2 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/system/classes/products/ProductInfoContentView.inc.php:105 #1 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/system/classes/products/ProductInfoContentView.inc.php:129 #0 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/product_info.php:101 Request: GET /product_info.php?info=p339_meersalz-griechisch-niki-halbgrob-1kg.html - duration: ~245ms - server: Apache - server address: 127.0.0.56 - user agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:50.0) Gecko/20100101 Firefox/50.0 - remote address: 3af472b90051715381d0c5f46deed751 Get: - info: p339_meersalz-griechisch-niki-halbgrob-1kg.html Information: Query: SELECT p.products_fsk18, p.products_tax_class_id, p.products_id, p.products_image, p.products_model,KkSsWwJjTtIi10 pd.products_name, pd.products_short_description, pd.products_meta_description, p.products_fsk18, p.products_price, pd.gm_alt_text, p.products_vpe, p.products_vpe_status, p.products_vpe_value, xp.sort_order FROM products_xsell xp, products p, products_description pd WHERE xp.xsell_id = '339' AND xp.products_id = p.products_id AND p.products_id = pd.products_id AND pd.language_id = '2' AND p.products_status = '1' ORDER BY xp.sort_order ASC ================================================================================ 2017-01-23 12:31:40 (3af472b90051715381d0c5f46deed751) USER ERROR(256): "SQL Error" in /is/htdocs/wp12161028_ROM2SXPAMZ/www/inc/xtc_db_error.inc.php:24 #10 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/inc/xtc_db_error.inc.php:24 Code: ¦ line 22: $coo_logger = LogControl::get_instance(); ¦ line 23: $coo_logger->notice($p_error, 'error_handler', 'errors', 'notice', 'SQL ERROR', $p_errno, 'Query:' . "\r\n" . trim($p_query)); +- line 24: trigger_error('SQL Error', E_USER_ERROR); ¦ line 25: } #9 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/inc/xtc_db_query.inc.php:69 Code: ¦ line 67: { ¦ line 68: # execute query +- line 69: $result = mysqli_query( $$link, $p_query) or xtc_db_error($p_query, ((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_errno($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_errno()) ? $___mysqli_res : false)), ((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false))); ¦ line 70: ¦ line 71: # save result to cache #8 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/GXUserComponents/overloads/product/model_product.inc.php:231 Code: ¦ line 229: xp.sort_order ASC"; ¦ line 230: +- line 231: $cross_query = xtc_db_query($t_query); ¦ line 232: ¦ line 233: while($xsell = xtc_db_fetch_array($cross_query, true)) #7 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/system/classes/listing/CrossSellingContentView.inc.php:76 Code: ¦ line 74: case 'reverse_cross_selling': ¦ line 75: $this->set_content_template('module/reverse_cross_selling.html'); +- line 76: return $this->coo_product->getReverseCrossSells(); ¦ line 77: ¦ line 78: default: #6 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/system/classes/listing/CrossSellingContentView.inc.php:46 Code: ¦ line 44: if(empty($t_uninitialized_array)) ¦ line 45: { +- line 46: $t_data_array = $this->get_data(); ¦ line 47: $this->add_data($t_data_array); ¦ line 48: } #5 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/system/core/ContentView.inc.php:121 Code: ¦ line 119: { ¦ line 120: $t_html_output = ''; +- line 121: $this->prepare_data(); ¦ line 122: if($this->build_html == true) ¦ line 123: { #4 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/system/classes/products/ProductInfoContentView.inc.php:455 Code: ¦ line 453: $view->set_type('reverse_cross_selling'); ¦ line 454: $view->set_coo_product($this->product); +- line 455: $html = $view->get_html(); ¦ line 456: $this->set_content_data('MODULE_reverse_cross_selling', $html); ¦ line 457: } #3 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/system/classes/products/ProductInfoContentView.inc.php:252 Code: ¦ line 250: $this->_assignAlsoPurchased(); ¦ line 251: $this->_assignCrossSelling(); +- line 252: $this->_assignReverseCrossSelling(); ¦ line 253: $this->_assignYoochoose(); ¦ line 254: } #2 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/system/classes/products/ProductInfoContentView.inc.php:105 Code: ¦ line 103: $this->_assignMedia(); ¦ line 104: $this->_assignReviews(); +- line 105: $this->_assignProductLists(); ¦ line 106: $this->_assignRichSnippetData(); ¦ line 107: #1 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/system/classes/products/ProductInfoContentView.inc.php:129 Code: ¦ line 127: else ¦ line 128: { +- line 129: $this->prepare_data(); ¦ line 130: $htmlOutput = $this->build_html(); ¦ line 131: } #0 File: /is/htdocs/wp12161028_ROM2SXPAMZ/www/product_info.php:101 Code: ¦ line 99: $coo_product_info_view->setFSK18DisplayAllowed($_SESSION['customers_status']['customers_fsk18_display'] == 1); // '1' => display allowed ¦ line 100: $coo_product_info_view->setShowPrice($_SESSION['customers_status']['customers_status_show_price'] == 1); +- line 101: $t_main_content = $coo_product_info_view->get_html(); ¦ line 102: ¦ line 103: $coo_layout_control = MainFactory::create_object('LayoutContentControl'); Request: GET /product_info.php?info=p339_meersalz-griechisch-niki-halbgrob-1kg.html - duration: ~248ms - server: Apache - server address: 127.0.0.56 - user agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:50.0) Gecko/20100101 Firefox/50.0 - remote address: 3af472b90051715381d0c5f46deed751 Session: - tpl: Honeygrid - MOBILE_ACTIVE: false - language: german - languages_id: 2 - language_charset: utf-8 - language_code: de - currency: EUR - customers_status: Array ( [customers_status_id] => 0 [customers_status_name] => Admin [customers_status_image] => admin_status.gif [customers_status_public] => 0 [customers_status_min_order] => 0 [customers_status_max_order] => 0 [customers_status_discount] => 0.00 [customers_status_ot_discount_flag] => 1 [customers_status_ot_discount] => 0.00 [customers_status_graduated_prices] => 1 [customers_status_show_price] => 1 [customers_status_show_price_tax] => 0 [customers_status_add_tax_ot] => 1 [customers_status_payment_unallowed] => [customers_status_shipping_unallowed] => [customers_status_discount_attributes] => 0 [customers_fsk18] => 1 [customers_fsk18_display] => 1 [customers_status_write_reviews] => 1 [customers_status_read_reviews] => 1 ) - cart: shoppingCart Object ( [contents] => Array ( ) [total] => 0 [weight] => 0 [cartID] => [content_type] => [tax] => Array ( ) ) - wishList: wishList Object ( [contents] => Array ( [224] => Array ( [qty] => 1.0000 ) [232] => Array ( [qty] => 1.0000 ) ) [total] => 0 [weight] => 0 [cartID] => 34813 [content_type] => ) - customer_id: 1 - payment: ### Session entry not present ### - shipping: ### Session entry not present ### - cartID: ### Session entry not present ### - sendto: ### Session entry not present ### - billto: ### Session entry not present ### Get: - info: p339_meersalz-griechisch-niki-halbgrob-1kg.html Vielen Dank im Voraus für einen hilfreichen Tipp wie man dieses Problem lösen könnte! Tasso EDIT / UPDATE: ich habe das Problem jetzt gelöst, der Fehler lag an eine USERMOD von mir, mit der Artikelnummern in der Listenansicht angezeigt werden können, ich habe jetzt den Ursprungszustand der 2 Dateien geänderten hergestellt und die Artikel lassen sich wieder aufrufen!