https://bugzilla.wikimedia.org/show_bug.cgi?id=31241
Web browser: ---
Bug #: 31241
Summary: Oracle Schema: ON DELETE SET NULL with several tables
bring error on deletes
Product: MediaWiki
Version: 1.19-svn
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: doktor_dolit...@gmx.de
Classification: Unclassified
When you want to delete a page in an Mediawiki running on Oracle, you get the
following error:
1407: ORA-01407: cannot update ("SCHEMANAME"."RECENTCHANGES"."RC_CUR_ID") to
NULL“.
So therefore I checked the database schema for Oracle and found out, that e.g.
the RC_CUR_ID column is not allowed to NULL, but upon on delete of the foreign
key data, it should be set to NULL.
I found this definition for the following tables:
- archive
- filearchive
- image
- ipblocks
- logging
- oldimgae
- recentchanges
In the Postgre schmema I saw that these columns are allowed to be NULL.
Maybe th columns for Oracle could be changed that way, or they will be set to
the a default on delete?
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
