View Issue Details

IDProjectCategoryView StatusLast Update
0026661mantisbtinstallationpublic2020-03-15 15:23
Reporterdregad Assigned Todregad  
PrioritynormalSeverityfeatureReproducibilityN/A
Status closedResolutionfixed 
Target Version2.24.0Fixed in Version2.24.0 
Summary0026661: Add informational comments to SQL script generated by installer
Description

The SQL script is missing some information that can help the administrator to properly apply it when a manual installation or upgrade is required:

  • MantisBT version
  • Date generated
  • Schema step corresponding to SQL statements
  • PHP function with arguments, for UpdateFunction steps
  • indicate "no operation" steps
TagsNo tags attached.

Relationships

related to 0026662 closeddregad Final statement to set database version not logged in SQL script 

Activities

Related Changesets

MantisBT: master ad05c04e

2020-01-06 10:04:16

dregad

Details Diff
Install: improve generated SQL script

The script generated by the installer when printing SQL queries instead
of writing to the database has been improved with comments, as follows:

- Header indicating MantisBT version and date of generation
- Schema step number before each SQL statement(s)
- For UpdateFunction steps, print the PHP function to execute, with
arguments
- Empty upgrade steps are indicated as "No Operation"
- Set database version

Fixes 0026661, 0026662
Affected Issues
0026661, 0026662
mod - admin/install.php Diff File

Issue History

Date Modified Username Field Change
2020-02-02 14:05 dregad New Issue
2020-02-02 14:05 dregad Status new => assigned
2020-02-02 14:05 dregad Assigned To => dregad
2020-02-02 14:06 dregad Issue cloned: 0026662
2020-02-02 14:06 dregad Relationship added related to 0026662
2020-02-02 14:09 dregad Issue cloned: 0026663
2020-02-02 14:29 dregad Note Added: 0063550
2020-02-17 05:05 dregad Changeset attached => MantisBT master ad05c04e
2020-02-17 05:05 dregad Status assigned => resolved
2020-02-17 05:05 dregad Resolution open => fixed
2020-02-17 05:05 dregad Fixed in Version => 2.24.0
2020-03-15 15:23 vboctor Status resolved => closed