View Issue Details

IDProjectCategoryView StatusLast Update
0003450mantisbtbugtrackerpublic2004-02-06 16:15
Reporterepu Assigned Tojlatour  
PrioritynormalSeverityfeatureReproducibilityalways
Status closedResolutionfixed 
PlatformMozilla Firebird 0.7OSWinXPOS VersionMantis 0.18.0
Summary0003450: some upgrades fail if table exists already
Description

when upgrading from 0.17.5 to 0.18.0-CVS, upgrades that add new tables fail if the table exists already. These upgrades need to correctly recognize that the table exists and be marked as "previously applied". Includes updates 0.15-8, 0.16-14, 0.16-15, 0.17-jf-2, 0.17-custom-field-1,0.17-custom-field-2,0.17-custom-field-3.

Additional Information

Create bug history table 0.15-8
ERROR: Table 'mantis_bug_history_table' already exists

Workaround: uncheck each update and try again in upgrade_advanced.php until most updates are applied

TagsNo tags attached.

Activities

jlatour

jlatour

2004-02-06 10:01

reporter   ~0004968

Added 'IF NOT EXISTS' keyword.

Related Changesets

MantisBT: master 8be526f4

2004-02-06 09:51

jlatour


Details Diff
Fix 0003450: Certain database upgrade scripts fail if table already exists.

git-svn-id: http://mantisbt.svn.sourceforge.net/svnroot/mantisbt/trunk@2313 <a class="text" href="/?p=mantisbt.git;a=object;h=f5dc347c">f5dc347c</a>-c33d-0410-90a0-b07cc1902cb9
Affected Issues
0003450
mod - admin/upgrades/0_15_inc.php Diff File
mod - doc/ChangeLog Diff File
mod - admin/upgrades/0_17_inc.php Diff File
mod - admin/upgrades/0_16_inc.php Diff File