Guten Morgen, mit ist soeben aufgefallen das ich meine Kategorien nicht mehr bearbeiten kann. Es kommt die Meldung: USER ERROR(256): "SQL Error" Der Log zeigt folgendes: Code: 2016-12-14 08:22:00 (aa043f798d7c8332c3a66ec7981188c3) SQL ERROR(1054): "Unknown column 'categories_contents' in 'field list'" in /var/www/vhosts/christophkoelsch.www68.hostkraft.de/httpdocs/gx3/inc/xtc_db_error.inc.php:23 (Details) #4 File: /var/www/vhosts/christophkoelsch.www68.hostkraft.de/httpdocs/gx3/inc/xtc_db_error.inc.php:23 #3 File: /var/www/vhosts/christophkoelsch.www68.hostkraft.de/httpdocs/gx3/inc/xtc_db_query.inc.php:78 #2 File: /var/www/vhosts/christophkoelsch.www68.hostkraft.de/httpdocs/gx3/GXUserComponents/overloads/AdminEditCategoryExtenderComponent/IS_EditKatExtender.inc.php:26 #1 File: /var/www/vhosts/christophkoelsch.www68.hostkraft.de/httpdocs/gx3/admin/html/compatibility/new_category.php:72 #0 File: /var/www/vhosts/christophkoelsch.www68.hostkraft.de/httpdocs/gx3/admin/categories.php:557 Request: GET /admin/categories.php?cID=2&cPath=0&action=edit_category (Details) Get: (Details) Information: Query: select categories_contents, categories_manufacturers from categories_description where categories_id = '2' and language_id = '2' 2016-12-14 08:22:00 (aa043f798d7c8332c3a66ec7981188c3) USER ERROR(256): "SQL Error" in /var/www/vhosts/christophkoelsch.www68.hostkraft.de/httpdocs/gx3/inc/xtc_db_error.inc.php:24 (Details) #4 File: /var/www/vhosts/christophkoelsch.www68.hostkraft.de/httpdocs/gx3/inc/xtc_db_error.inc.php:24 (Details) 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: }#3 File: /var/www/vhosts/christophkoelsch.www68.hostkraft.de/httpdocs/gx3/inc/xtc_db_query.inc.php:78 (Details) Code: │ line 76: # ALL OTHER RUN MODES │ line 77: # execute query ├─ line 78: $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 79: } │ line 80: #2 File: /var/www/vhosts/christophkoelsch.www68.hostkraft.de/httpdocs/gx3/GXUserComponents/overloads/AdminEditCategoryExtenderComponent/IS_EditKatExtender.inc.php:26 (Details) Code: │ line 24: │ line 25: if (isset($this->v_data_array['GET']['cID'])) { ├─ line 26: $contentda = xtc_db_fetch_array(xtc_db_query("select categories_contents, categories_manufacturers from categories_description where categories_id = '" . $this->v_data_array['GET']['cID'] . "' and language_id = '" . $_SESSION['languages_id'] . "' ")); │ line 27: $contentda2 = xtc_db_fetch_array(xtc_db_query("select parent_id, section from categories where categories_id = '" . $this->v_data_array['GET']['cID'] . "' ")); │ line 28: } #1 File: /var/www/vhosts/christophkoelsch.www68.hostkraft.de/httpdocs/gx3/admin/html/compatibility/new_category.php:72 (Details) Code: │ line 70: $adminEditCategoryExtenderComponent->set_data('GET', $_GET); │ line 71: $adminEditCategoryExtenderComponent->set_data('POST', $_POST); ├─ line 72: $adminEditCategoryExtenderComponent->proceed(); │ line 73: $adminEditCategoryExtenderComponentTopOutputArray = $adminEditCategoryExtenderComponent->get_output('top'); │ line 74: $adminEditCategoryExtenderComponentLeftOutputArray = $adminEditCategoryExtenderComponent->get_output('left'); #0 File: /var/www/vhosts/christophkoelsch.www68.hostkraft.de/httpdocs/gx3/admin/categories.php:557 (Details) Code: │ line 555: //----- new_category / edit_category (when ALLOW_CATEGORY_DESCRIPTIONS is 'true') ----- │ line 556: if ($_GET['action'] == 'new_category' || $_GET['action'] == 'edit_category') { ├─ line 557: include DIR_FS_ADMIN . 'html/compatibility/new_category.php'; │ line 558: } │ line 559: elseif ($_GET['action'] == 'new_product') { Request: GET /admin/categories.php?cID=2&cPath=0&action=edit_category (Details) - duration: ~156ms - server: Apache - server address: 37.218.252.78 - user agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:50.0) Gecko/20100101 Firefox/50.0 - remote address: aa043f798d7c8332c3a66ec7981188c3 Session: (Details) Get: (Details) Kann mir vielleicht jemand helfen? Vielen Dank.
Hallo, die Spalten 'categories_contents' und 'categories_manufacturers' sind eigentlich nicht in der Tabelle 'categories_description' enthalten. Bei dir aktuell auch nicht: Kann so ein Select auch nicht bei uns im Shop finden. Sieht für mich nach einer Anpassung aus, die mit deiner Datenbank nicht kompatibel ist.
Wenn ich das richtig sehe is indiv style wohl die erweiterung von steffen die nicht korrekt installiert ist