MariaDB: Fehler zwischen Ilias und MariaDB

comhansen

Grünschnabel
Hallo,

Ich betreibe einen Ilias-Server mit apache2 und MariaDB als Datenbank auf einer SuseDistribution.
Das Modul Wiki macht mir Probleme. Nachdem ich ein Wiki erstellt habe erscheint mir folgender Fehler im Browser:

Fatal Error: Called raise error two times.
First error: ilDB Error: manipulate(INSERT INTO wiki_stat_page (wiki_id, page_id, ts, int_links, ext_links, footnotes, num_words, num_chars, ts_day, ts_hour) VALUES (404, 4, '2016-09-12 13:00:00', 0, 2, 1, 1, 0, '2016-09-12', 13))
MDB2 Error: unknown error
_doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO wiki_stat_page (wiki_id, page_id, ts, int_links, ext_links, footnotes, num_words, num_chars, ts_day, ts_hour) VALUES (404, 4, '2016-09-12 13:00:00', 0, 2, 1, 1, 0, '2016-09-12', 13)] [Native code: 1364] [Native message: Field 'num_ratings' doesn't have a default value]
#0 /srv/www/htdocs/ilias/Services/Database/classes/class.ilDB.php(1599): ilDB->handleError(Object(MDB2_Error), 'manipulate(INSE...')
#1 /srv/www/htdocs/ilias/Modules/Wiki/classes/class.ilWikiStat.php(270): ilDB->manipulate('INSERT INTO wik...')
#2 /srv/www/htdocs/ilias/Modules/Wiki/classes/class.ilWikiStat.php(304): ilWikiStat::writeData('wiki_stat_page', Array, Array)
#3 /srv/www/htdocs/ilias/Modules/Wiki/classes/class.ilWikiStat.php(423): ilWikiStat::writeStatPage('404', '4', Array)
#4 /srv/www/htdocs/ilias/Modules/Wiki/classes/class.ilWikiStat.php(155): ilWikiStat::handlePageUpdated(Object(ilWikiPage), '359', Array)
#5 /srv/www/htdocs/ilias/Modules/Wiki/classes/class.ilWikiPage.php(258): ilWikiStat::handleEvent(2, Object(ilWikiPage), NULL, Array)
#6 /srv/www/htdocs/ilias/Services/COPage/classes/class.ilPageObject.php(2487): ilWikiPage->afterUpdate(Object(DOMDocument), '__afterUpdate(Object(DOMDocument), 'createFromXML()
#9 /srv/www/htdocs/ilias/Services/COPage/classes/class.ilPageObject.php(3057): ilWikiPage->createFromXML()
#10 /srv/www/htdocs/ilias/Modules/Wiki/classes/class.ilWikiPage.php(213): ilPageObject->create()
#11 /srv/www/htdocs/ilias/Modules/Wiki/classes/class.ilObjWiki.php(424): ilWikiPage->create()
#12 /srv/www/htdocs/ilias/Modules/Wiki/classes/class.ilObjWikiGUI.php(361): ilObjWiki->update()
#13 /srv/www/htdocs/ilias/Services/Object/classes/class.ilObjectGUI.php(1009): ilObjWikiGUI->afterSave(Object(ilObjWiki))
#14 /srv/www/htdocs/ilias/Modules/Wiki/classes/class.ilObjWikiGUI.php(325): ilObjectGUI->saveObject()
#15 /srv/www/htdocs/ilias/Modules/Wiki/classes/class.ilObjWikiGUI.php(257): ilObjWikiGUI->saveObject()
#16 /srv/www/htdocs/ilias/Services/UICore/classes/class.ilCtrl.php(188): ilObjWikiGUI->executeCommand()
#17 /srv/www/htdocs/ilias/Services/Repository/classes/class.ilRepositoryGUI.php(351): ilCtrl->forwardCommand(Object(ilObjWikiGUI))
#18 /srv/www/htdocs/ilias/Services/Repository/classes/class.ilRepositoryGUI.php(305): ilRepositoryGUI->show()
#19 /srv/www/htdocs/ilias/Services/UICore/classes/class.ilCtrl.php(188): ilRepositoryGUI->executeCommand()
#20 /srv/www/htdocs/ilias/Services/UICore/classes/class.ilCtrl.php(150): ilCtrl->forwardCommand(Object(ilRepositoryGUI))
#21 /srv/www/htdocs/ilias/ilias.php(21): ilCtrl->callBaseClass()
#22 {main}
Last Error:MDB2 Error: not lockedFatal Error: Called raise error two times.
First error: ilDB Error: query(SELECT 1 FROM usr_session WHERE session_id = 'h1j860pttiqp7ame70lit0s742')
MDB2 Error: not locked
_doQuery: [Error message: Could not execute statement] [Last executed query: SELECT 1 FROM usr_session WHERE session_id = 'h1j860pttiqp7ame70lit0s742'] [Native code: 1100] [Native message: Table 'usr_session' was not locked with LOCK TABLES]
#0 /srv/www/htdocs/ilias/Services/Database/classes/class.ilDB.php(1466): ilDB->handleError(Object(MDB2_Error), 'query(SELECT 1 ...')
#1 /srv/www/htdocs/ilias/Services/Database/classes/class.ilDBMySQL.php(640): ilDB->query('SELECT 1 FROM u...', true)
#2 /srv/www/htdocs/ilias/Services/Authentication/classes/class.ilSession.php(162): ilDBMySQL->query('SELECT 1 FROM u...')
#3 /srv/www/htdocs/ilias/Services/Authentication/classes/class.ilSession.php(114): ilSession::_exists('h1j860pttiqp7am...')
#4 /srv/www/htdocs/ilias/Services/Authentication/classes/class.ilSessionDBHandler.php(86): ilSession::_writeData('h1j860pttiqp7am...', '_authsession|a:...')
#5 [internal function]: ilSessionDBHandler->write('h1j860pttiqp7am...', '_authsession|a:...')
#6 [internal function]: session_write_close()
#7 {main}
Last Error:MDB2 Error: not locked
Kann mir vielleicht jemand sagen, wo ich ansetzen sollte? Die Berechtigungen für die DB schliesse ich aus.
Ich kann mit der Fehlermeldung leider gar nichts anfangen.

Die Ilias-Klassen sollten in Ordnung sein, da es bei anderen Usern nicht zu diesem Problem kommt.

Herzlichen Dank!
 
Zuletzt bearbeitet:
Gelöst.

Nachdem ich die Zeile

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

in /etc/my.cnf auskommentiert und anschliessend mysql neu gestartet hatte, war der Fehler verschwunden.
 
Zurück