Bekomme folgenden Fehler im BE wenn ich einen Kunden löschen will:
PHP Fatal 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 '' at line 1 :: delete from zen_products_notifications where customers_id = ==> (as called by) /xxxxxx/customers.php on line 404 <== in /includes/classes/db/mysql/query_factory.php on line 167
Glaube in Zeile 404 in der admin/customers.php fehlt ein s:
$db->Execute("delete from " . TABLE_PRODUCTS_NOTIFICATIONS . " where customers_id = " . $customer_id);
Richtig wäre:
$db->Execute("delete from " . TABLE_PRODUCTS_NOTIFICATIONS . " where customers_id = " . $customers_id);
Nach der Änderung geht das löschen.
Bitte mal prüfen ob das so stimmt?
Lg. Dieter
PHP Fatal 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 '' at line 1 :: delete from zen_products_notifications where customers_id = ==> (as called by) /xxxxxx/customers.php on line 404 <== in /includes/classes/db/mysql/query_factory.php on line 167
Glaube in Zeile 404 in der admin/customers.php fehlt ein s:
$db->Execute("delete from " . TABLE_PRODUCTS_NOTIFICATIONS . " where customers_id = " . $customer_id);
Richtig wäre:
$db->Execute("delete from " . TABLE_PRODUCTS_NOTIFICATIONS . " where customers_id = " . $customers_id);
Nach der Änderung geht das löschen.
Bitte mal prüfen ob das so stimmt?
Lg. Dieter
Kommentar