View Issue Details

WikiRelated ChangesetsJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0026661mantisbtinstallationpublic2020-02-02 14:052020-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

dregad

dregad

2020-02-02 14:29

developer   ~0063550

PR https://github.com/mantisbt/mantisbt/pull/1620

Related Changesets

MantisBT: master ad05c04e

2020-01-06 05:04

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