Plötzlich MYSQL Fehler - Hilfe

[Jürgen]

Hallo,

habe plötzlich folgenden Fehler bei Aufruf der index Seite

Code: XML  [Auswählen]

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 '' at line 11

SELECT * FROM products p, products_description pd WHERE p.products_id = pd.products_id and p.products_startpage = '1' and p.products_fsk18!=1 and p.products_status = '1' and pd.language_id = '2' order by p.products_startpage_sort ASC limit

Bei Kategorieaufruf

Code: XML  [Auswählen]

Warning: Division by zero in /homepages/36/XXX/htdocs/XXX/includes/modules/categorie_listing.php on line 79

Warning: Division by zero in /homepages/36/XXX/htdocs/XXX/includes/modules/categorie_listing.php on line 79

Warning: Division by zero in /homepages/36/XXX/htdocs/XXX/includes/modules/categorie_listing.php on line 79

Warning: Division by zero in /homepages/36/XXX/htdocs/XXX/includes/modules/categorie_listing.php on line 79

Warning: Division by zero in /homepages/36/XXX/htdocs/XXX/includes/modules/categorie_listing.php on line 79

Warning: Division by zero in /homepages/36/XXX/htdocs/XXX/includes/modules/categorie_listing.php on line 79

Warning: Division by zero in /homepages/36/XXX/htdocs/XXX/includes/modules/categorie_listing.php on line 79

Warning: Division by zero in /homepages/36/XXX/htdocs/XXX/includes/classes/split_page_results.php on line 114

Warning: Division by zero in /homepages/36/XXX/htdocs/XXX/includes/classes/split_page_results.php on line 115

Warning: Division by zero in /homepages/36/XXX/htdocs/XXX/includes/classes/split_page_results.php on line 117

Warning: Division by zero in /homepages/36/XXX/htdocs/XXX/includes/classes/split_page_results.php on line 118
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 '' at line 40

-- /includes/modules/default.php SELECT DISTINCT pr.price_incl_tax AS products_real_price, p.products_manufacturers_model, p.products_id, p.products_ean, p.products_quantity, p.products_shippingtime, p.products_model, p.products_image, p.products_price, p.products_discount_allowed, p.products_weight, p.products_tax_class_id, p.manufacturers_id, p.products_fsk18, p.products_vpe, p.products_vpe_status, p.products_vpe_value, pd.products_name, pd.products_description, pd.products_short_description FROM products_description pd JOIN products p JOIN products_to_categories p2c on p2c.products_id = pd.products_id LEFT JOIN manufacturers m on p.manufacturers_id = m.manufacturers_id JOIN pricing pr ON p.products_id = pr.products_id WHERE p.products_status = '1' AND p.products_id = pd.products_id AND pd.language_id = '2' AND p.products_fsk18!=1 AND p2c.categories_id = '18' and pr.customers_status = '0' -- filter start -- filter specials -- filter price -- filter end ORDER BY p.products_sort ASC LIMIT 0,

Danke für Hilfe

Gruss

Linkback: https://www.modified-shop.org/forum/index.php?topic=33601.0

[Jürgen]

..Fehler gefunden... Hatte einen Wert im backend unter Konfiguration - Maximum Werte geändert und gespeichert...

Dabei wurden offensichtlich alle Werte auf dieser Seite gelöscht, zumindest waren die Felder ohne inhalt und daher "division by zero"

Jemand eine Idee woran das liegen kann??

Danke