Hallo!
Das steht bei mir in den Logs. Scheinbar versucht ein Angreifer es über die Suchfunktion. Ich kann nicht sagen ob er Erfolg hatte aber im Shop selber merke ich, noch, nichts.
Irgendwelche Verbesserungsvorschläge? Danke.
[05-05-2019 02:53:20] E_USER_WARNING : LoggingManager: 1267 - Illegal mix of collations (latin1_german1_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'<br/><br/>SELECT DISTINCT p.products_id FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id AND trim(pd.products_name) != '' AND pd.language_id = '1') LEFT OUTER JOIN specials AS s ON (p.products_id = s.products_id) AND s.status = '1' AND (now() >= s.start_date OR s.start_date IS NULL) WHERE p.products_status = '1' AND trim(pd.products_name) != '' AND ( ( pd.products_keywords LIKE ('%???%') OR pd.products_description LIKE ('%???%') OR pd.products_short_description LIKE ('%???%') OR pd.products_name LIKE ('%???%') OR p.products_model LIKE ('%???%') OR p.products_ean LIKE ('%???%') OR p.products_manufacturers_model LIKE ('%???%') ) ) GROUP BY p.products_id in File: /home/www/web/html/domain.de/inc/db_functions_mysqli.inc.php on Line: 161
[05-05-2019 02:53:20] E_USER_WARNING : LoggingManager: Backtrace #0 - /home/www/web/html/domain.de/inc/db_functions.inc.php called at Line 104
[05-05-2019 02:53:20] E_USER_WARNING : LoggingManager: Backtrace #1 - /home/www/web/html/domain.de/advanced_search_result.php called at Line 218
[05-05-2019 03:00:56] E_USER_WARNING : LoggingManager: 1267 - Illegal mix of collations (latin1_german1_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'<br/><br/>SELECT DISTINCT p.products_id FROM products AS p
Linkback: https://www.modified-shop.org/forum/index.php?topic=40221.0