Oracle Schema: ON DELETE SET NULL with several tables bring error on deletes
Closed, ResolvedPublic
Actions

Assigned To

None

Authored By

	• bzimport
	Sep 29 2011, 6:54 AM

Description

Author: doktor_dolittle

Description:
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?

Version: 1.20.x
Severity: normal

Details

Reference: bz31241

Event Timeline

• bzimport raised the priority of this task from to Medium.Nov 21 2014, 11:47 PM

• bzimport added projects: MediaWiki-libs-Rdbms, good first task.

• bzimport set Reference to bz31241.

• bzimport created this task.Sep 29 2011, 6:54 AM

chughakshay16 wrote:

Considering the scope of this request, I think Jure Kajzer would be able to help out with the above stated issue.
Hence, assigning this bug to Jure.

freak wrote:

This one has been fixed a while ago. I guess i just forgot to close it.

tstarling added a project: Oracle Database.May 19 2017, 10:17 AM

Restricted Application added a subscriber: TerraCodes. · View Herald TranscriptMay 19 2017, 10:17 AM

tstarling removed a parent task: T40916: [DO NOT USE] Oracle DB support (tracking).May 19 2017, 10:21 AM

Oracle Schema: ON DELETE SET NULL with several tables bring error on deletesClosed, ResolvedPublicActions

Description

Details

Event Timeline

Oracle Schema: ON DELETE SET NULL with several tables bring error on deletes
Closed, ResolvedPublic
Actions