-
Bug
-
Resolution: Fixed
-
Critical
-
1.7, 1.7.1, 1.7.2, 1.8
-
None
-
Solaris 10,
Oracle 10g
-
Oracle
-
MOODLE_17_STABLE, MOODLE_18_STABLE
-
MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE
-
/mod/wiki/view.php...
Someone wanted to save a really long wiki page and got only [[errorsaving]] as error-message (its from within ewiki.php)
The following ORA error message is thrown, when developer messages are on:
ORA-04098: trigger 'ORA_MONITOR.ALERT_TR_ERRORS' is invalid and failed re-validation ORA-01704: string literal too long
INSERT INTO m_wiki_pages ( PAGENAME, VERSION, FLAGS, CONTENT, AUTHOR, USERID, CREATED, LASTMODIFIED, REFS, META, HITS, WIKI ) VALUES ( 'Übungsaufgabe 2.1 - Antwort', 4, 1, '
.......
here comes the really huge content text of the wiki page...approximately 3900 characters
.......
', 'dednis drotger (123.134.62.153:2362)', 3, 1177657076, 1178630599, ' Sozialversicherungsbeiträge Sozialbeiträge Prioritäten Einschränkung Ausbildungsplätzen Universität Tertiärbereich ', '', 106, 312 );
Do you have to use a special variable for this INSERT
or is the (clob,4000) column for "content" too short?!