SQL-Fehler in Herstelleradministration, manufacturers.php (v1.05)
Aus Wiki | modified eCommerce Shopsoftware
Zur Navigation springenZur Suche springenBetrifft nur die modified eCommerce Shopsoftware 1.05
Beim Speichern eines Herstellers erscheint folgender Fehler:
1054 - Unknown column 'language_id' in 'where clause' select * from manufacturers_info where language_id = '2' and manufacturers_id = '6'
Korrektur:
Datei: admin/manufacturers.php, Zeile 60 ca.
Finde:
$manufacturers_query = xtc_db_query("select * from ".TABLE_MANUFACTURERS_INFO." where language_id = '".$language_id."' and manufacturers_id = '".xtc_db_input($manufacturers_id)."'");
Ersetze gegen:
$manufacturers_query = xtc_db_query("select * from ".TABLE_MANUFACTURERS_INFO." where languages_id = '".$language_id."' and manufacturers_id = '".xtc_db_input($manufacturers_id)."'");