Mantis Bug Tracker

View Issue Details Jump to Notes ]
IDProjectCategoryView StatusLast Update
0000617ForumInstall scriptpublic2009-10-14 10:27
Reporterjavmard 
Assigned Toadministrator 
PrioritynormalSeveritycrashReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version0.7.0 
Target VersionFixed in Version0.7.1 
Summary0000617: When I tried create a New file extension fail.
DescriptionWhen I tried create a New file extension on Forum Index > Administration / General, this fail.

Appear the next error:

[Error in forum_admin.fileext_add : -1 ORA-00001: restricci├│n ├║nica (FORUM_APP.T_FORUM_UPLOAD_TYPES_PK) violada]

TagsNo tags attached.
Attached Filestxt file icon fix_617.sql.txt (326 bytes) 2009-10-14 10:24 [Show Content]

- Relationships

-  Notes
~0001429
administrator (administrator)


the issue is due to the sequence that is not used when adding the default file type.

~0001430
administrator (administrator)


here is a workaround

update the t_forum_upload_types_seq to start with a number upper than 15.
~0001431
administrator (administrator)


here is a fix, you need to apply it with the forum_app user

sqlplus forum_app/<pass>@<tns> @fix_617.sql

This fix will recreate the sequence with a good start with value.
~0001432
administrator (administrator)


A fix is now available for users that does not want to upgrade now to the 0.7.1

The inst_add_types.sql has been updated to use sequence for the primary key and no more the real id.

The upgrade script to 0.7.1 will apply the fix automatically

- Issue History
Date Modified Username Field Change
2009-10-13 22:39 javmard New Issue
2009-10-14 10:01 administrator Status new => assigned
2009-10-14 10:01 administrator Assigned To => administrator
2009-10-14 10:06 administrator Note Added: 0001429
2009-10-14 10:06 administrator Status assigned => confirmed
2009-10-14 10:07 administrator Note Added: 0001430
2009-10-14 10:09 administrator Category Administration => Install script
2009-10-14 10:09 administrator ETA none => < 1 day
2009-10-14 10:24 administrator File Added: fix_617.sql.txt
2009-10-14 10:25 administrator Note Added: 0001431
2009-10-14 10:27 administrator Note Added: 0001432
2009-10-14 10:27 administrator Status confirmed => resolved
2009-10-14 10:27 administrator Fixed in Version => 0.7.1
2009-10-14 10:27 administrator Resolution open => fixed