Gambio Version: v3.12.1.0 Hallo, sobald wir eine Änderung des Inhalts im Content-Manager durchführen erhalten wir einen SQL-Error(256) und die Änderung wird nicht übernommen. Im Log taucht folgendes auf: Logs anzeigen 2019-07-12 11:48:08 (ffe698fd8c53287f7dd76b7c8409587f) SQL ERROR: "Query error: Column 'file_flag' cannot be null - Invalid query: REPLACE INTO `content_manager_history` (`languages_id`, `content_group`, `content_position`, `group_ids`, `file_flag`, `content_title`, `content_file`, `content_heading`, `content_text`, `content_type`, `content_status`) VALUES (3, '5', 'elements_', 'c_0_group,c_1_group,c_2_group,c_3_group,', NULL, 'Start Kompostwürmer, Komposthaufen, Eisenia fetida, Regenwürmer, Angelköder', '', '', '', 'content', '0')" in /www/htdocs/w013f130/svet-zizal/inc/xtc_db_error.inc.php:23 (Details) 10 File: /www/htdocs/w013f130/svet-zizal/inc/xtc_db_error.inc.php:23 #9 File: /www/htdocs/w013f130/svet-zizal/vendor/gambio/codeigniter-db/CIDB.php:147 #8 File: /www/htdocs/w013f130/svet-zizal/vendor/gambio/codeigniter-db/DB_driver.php:665 #7 File: /www/htdocs/w013f130/svet-zizal/vendor/gambio/codeigniter-db/DB_query_builder.php:1674 #6 File: /www/htdocs/w013f130/svet-zizal/GXMainComponents/Controllers/HttpView/Admin/ContentManager/ContentManagerContentNavigationTrait.inc.php:210 #5 File: /www/htdocs/w013f130/svet-zizal/GXMainComponents/Controllers/HttpView/Admin/ContentManager/ContentManagerElementsController.inc.php:349 #4 File: /www/htdocs/w013f130/svet-zizal/GXEngine/Services/System/Http/HttpViewController.inc.php:152 #3 File: /www/htdocs/w013f130/svet-zizal/GXEngine/Services/System/Http/HttpViewController.inc.php:107 #2 File: /www/htdocs/w013f130/svet-zizal/GXEngine/Services/System/Http/HttpDispatcher.inc.php:72 #1 File: /www/htdocs/w013f130/svet-zizal/GXEngine/Services/System/Http/HttpService.inc.php:67 #0 File: /www/htdocs/w013f130/svet-zizal/admin/admin.php:15 Request: POST /admin/admin.php?do=ContentManagerElements/update&id=5&type= (Details) Post: (Details) Get: (Details) Information: Query: CIDB Library Error 2019-07-12 11:48:08 (ffe698fd8c53287f7dd76b7c8409587f) USER ERROR(256): "SQL Error" in /www/htdocs/w013f130/svet-zizal/inc/xtc_db_error.inc.php:24 (Details) #10 File: /www/htdocs/w013f130/svet-zizal/inc/xtc_db_error.inc.php:24 (Details) #9 File: /www/htdocs/w013f130/svet-zizal/vendor/gambio/codeigniter-db/CIDB.php:147 (Details) #8 File: /www/htdocs/w013f130/svet-zizal/vendor/gambio/codeigniter-db/DB_driver.php:665 (Details) #7 File: /www/htdocs/w013f130/svet-zizal/vendor/gambio/codeigniter-db/DB_query_builder.php:1674 (Details) #6 File: /www/htdocs/w013f130/svet-zizal/GXMainComponents/Controllers/HttpView/Admin/ContentManager/ContentManagerContentNavigationTrait.inc.php:210 (Details) #5 File: /www/htdocs/w013f130/svet-zizal/GXMainComponents/Controllers/HttpView/Admin/ContentManager/ContentManagerElementsController.inc.php:349 (Details) #4 File: /www/htdocs/w013f130/svet-zizal/GXEngine/Services/System/Http/HttpViewController.inc.php:152 (Details) #3 File: /www/htdocs/w013f130/svet-zizal/GXEngine/Services/System/Http/HttpViewController.inc.php:107 (Details) #2 File: /www/htdocs/w013f130/svet-zizal/GXEngine/Services/System/Http/HttpDispatcher.inc.php:72 (Details) #1 File: /www/htdocs/w013f130/svet-zizal/GXEngine/Services/System/Http/HttpService.inc.php:67 (Details) #0 File: /www/htdocs/w013f130/svet-zizal/admin/admin.php:15 (Details) Request: POST /admin/admin.php?do=ContentManagerElements/update&id=5&type= (Details) Session: (Details) Post: (Details) Get: (Details) Vielen Dank im Voraus für Lösungsvorschläge!
Da scheint ein verstecktes Feld einen ungültigen Wert zu haben. Betrifft nur den einen Content? Wieviel kommt da zuück? SQL: SELECT * FROM `content_manager` WHERE file_flag IS NULL;
Hallo, betrifft auch andere Content-Artikel. Ergänzend muss erwähnt werden, das wir eine zusätzliche Spracher installiert haben. Viele Grüße
Das passt nicht zusammen. Mach mal ein Ticket, da muss jemand sich die Tabelle bei dir mal genauer anschauen.