Changes between Version 1 and Version 2 of TracUpgrade


Ignore:
Timestamp:
Jan 16, 2024, 12:52:37 AM (10 months ago)
Author:
trac
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • TracUpgrade

    v1 v2  
    55== Instructions
    66
    7 Typically, there are seven steps involved in upgrading to a newer version of Trac:
    8 
    9 === 1. Bring your server off-line
     7There are seven recommended steps for upgrading to a newer version of Trac:
     8
     9=== 1. Check your plugins
     10
     11Check whether your plugins are compatible with the version of Trac that you are upgrading to. Obsolete plugins listed in the [#VersionSpecificSteps version specific steps] below should be uninstalled or disabled.
     12
     13If you are upgrading to a minor release, plugin compatibility is usually not a concern because the Trac API is normally unchanged.
     14
     15If your plugins are installed from [https://trac-hacks.org trac-hacks.org] you can check compatibility by looking for a tag on the project page corresponding to a major release (e.g. `1.4`). If you are unsure, you'll want to contact the plugin author or ask on the [trac:MailingList MailingList].
     16
     17If you are running several Trac plugins it is good to test the upgrade and plugin functionality in a staging instance of your site before upgrading your production instance. Remember, plugin authors are responsible for Trac version compatibility and plugins can interact in unexpected ways. Your Trac instance may have a unique combination of plugins and therefore it's advised that you do some verification testing when making any changes to your site.
     18
     19=== 2. Bring your server off-line
    1020
    1121It is not a good idea to update a running server: the server processes may have parts of the current packages cached in memory, and updating the code will likely trigger [#ZipImportError internal errors].
    1222
    13 Although a database backup will be implicitly created by default when upgrading the environment, it is always a good idea to perform a full backup of the environment using the [TracBackup hotcopy] command before beginning.
    14 
    15 === 2. Update the Trac Code #UpdatetheTracCode
    16 
    17 Get the new version as described in TracInstall, or your operating system specific procedure.
    18 
    19 If you already have a 0.12 version of Trac installed via `easy_install`, it might be easiest to also use `easy_install` to upgrade your Trac installation:
    20 
    21 {{{#!sh
    22 easy_install --upgrade Trac==1.0
    23 }}}
    24 
    25 If you do a manual (not operating system-specific) upgrade, you should also stop any running Trac servers before the installation. Doing "hot" upgrades is not advised, especially on Windows ([trac:#7265]).
    26 
    27 You may also want to remove the pre-existing Trac code by deleting the `trac` directory from the Python `lib/site-packages` directory, or remove Trac `.egg` files from former versions.
    28 The location of the site-packages directory depends on the operating system and the location in which Python was installed. However, the following locations are typical:
    29  * on Linux: `/usr/lib/python2.X/site-packages`
    30  * on Windows: `C:\Python2.X\lib\site-packages`
    31  * on MacOSX: `/Library/Python/2.X/site-packages`
    32 
    33 You may also want to remove the Trac `cgi-bin`, `htdocs`, `templates` and `wiki-default` directories that are commonly found in a directory called `share/trac`. The exact location depends on your platform. This cleanup is not mandatory, but makes it easier to troubleshoot issues later on, as your installation is uncluttered by code or templates from a previous release that is not used anymore. As usual, make a backup before actually removing things.
    34 
    35 === 3. Upgrade the Trac Environment #UpgradetheTracEnvironment
    36 
    37 Environment upgrades are not necessary for minor version releases unless otherwise noted.
    38 
    39 After restarting, Trac should show the instances which need a manual upgrade via the automated upgrade scripts to ease the pain. These scripts are run via [TracAdmin trac-admin]:
    40 {{{#!sh
    41 trac-admin /path/to/projenv upgrade
    42 }}}
    43 
    44 This command will do nothing if the environment is already up-to-date.
    45 
    46 Note that a backup of your database will be performed automatically prior to the upgrade.
    47 This feature is relatively new for PostgreSQL or MySQL databases, so if it fails, you will have to backup the database manually. Then, to perform the actual upgrade, run:
    48 {{{#!sh
    49 trac-admin /path/to/projenv upgrade --no-backup
    50 }}}
    51 
    52 === 4. Update the Trac Documentation === #UpdatetheTracDocumentation
    53 
    54 By default, every [TracEnvironment Trac environment] includes a copy of the Trac documentation for the installed version. However, to keep the included documentation in sync with the installed version of Trac, use the following [TracAdmin trac-admin] command to upgrade the documentation:
    55 {{{#!sh
    56 trac-admin /path/to/projenv wiki upgrade
    57 }}}
    58 
    59 Note that this procedure will leave your `WikiStart` page intact.
    60 
    61 === 5. Refresh static resources
    62 
    63 If you have set up a web server to give out static resources directly (accessed using the `/chrome/` URL) then you will need to refresh them using the same command:
    64 {{{#!sh
    65 trac-admin /path/to/env deploy /deploy/path
    66 }}}
    67 this will extract static resources and CGI scripts (`trac.wsgi`, etc) from new Trac version and its plugins into `/deploy/path`.
    68 
    69 Some web browsers (IE, Opera) cache CSS and Javascript files aggressively, so you may need to instruct your users to manually erase the contents of their browser's cache, a forced refreshed (`<F5>`) should be enough.
     23Although a database backup will be implicitly created by default when upgrading the environment, it is always a good idea to perform a full backup of the environment using the [TracBackup hotcopy] command before beginning. You may also wish to create a full backup of your server.
     24
     25=== 3. Update Trac and dependencies #UpdatetheTracCode
     26
     27The packages are available through several channels, as described in [trac:TracDownload]. If your Trac instance was installed through an operating system package manager, proceed with the standard steps that are appropriate for your operating system package manager. If it was installed through a Windows installer, uninstall the old Trac package before installing new Trac package.
     28
     29If you are managing your Trac installation using command line tools, `pip` is the preferred tool to upgrade a Trac instance because it will uninstall the old version. The following command will upgrade your Trac installation using the package published to [https://pypi.python.org/pypi/Trac PyPI].
     30
     31{{{#!sh
     32$ pip install --upgrade Trac
     33}}}
     34
     35The upgrade command will give you the latest release of Trac. If instead you wish to upgrade to a different version, such as a minor release of Trac when there is a newer major release available, then specify the Trac version in the `pip` command.
     36
     37{{{#!sh
     38$ pip install --upgrade Trac==1.4.1
     39}}}
     40
     41You should also upgrade dependencies so they are compliant with the [TracInstall#Dependencies required versions].
     42
     43=== 4. Upgrade the Trac Environment #UpgradetheTracEnvironment
     44
     45Environment upgrades are not necessary for minor version releases unless otherwise noted.
     46
     47On starting your web server after upgrading Trac, a message will be displayed for projects that need to be upgraded and the projects will not be accessible until the upgrade is run.
     48
     49The upgrade is run using a [TracAdmin trac-admin] command:
     50{{{#!sh
     51$ trac-admin /path/to/projenv upgrade
     52}}}
     53
     54This command will not have any effect if the environment is already up-to-date.
     55
     56It is recommended that you set the [[TracIni#logging-log_level-option|log_level]] to `INFO` before running the upgrade. The additional information in the logs can be helpful in case something unexpected occurs during the upgrade.
     57
     58Note that a backup of your database will be performed automatically prior to the upgrade. The backup is saved in the location specified by [[TracIni#trac-backup_dir-option|backup_dir]].
     59
     60=== 5. Update the Trac Documentation === #UpdatetheTracDocumentation
     61
     62By default, every [TracEnvironment Trac environment] includes a copy of the Trac documentation for the installed version. To keep the documentation in sync with the installed version of Trac, upgrade the documentation:
     63{{{#!sh
     64$ trac-admin /path/to/projenv wiki upgrade
     65}}}
     66
     67Note that this procedure will leave your `WikiStart`, `InterMapTxt` and `SandBox` pages unaltered. Local changes to other pages that are distributed with Trac will be overwritten, however these pages are read-only by default for Environments created in Trac 1.3.3 and later.
     68
     69=== 6. Refresh static resources
     70
     71If you have configured your web server to serve static resources directly (accessed using the `/chrome/` URL) then you will need to refresh them using the [TracInstall#MappingStaticResources deploy command]. The `deploy` command will extract static resources and CGI scripts (`trac.wsgi`, etc) from the new Trac version and plugins into `/deploy/path`.
     72{{{#!sh
     73$ trac-admin /path/to/env deploy /deploy/path
     74}}}
     75
     76Before refreshing, it is recommended that you remove the directory in which your static resources are deployed. The directory location depends on the choice you made during installation. This cleanup is not mandatory, but makes it easier to troubleshoot issues as your installation is uncluttered by unused assets from a previous release. As usual, make a backup before deleting the directory.
     77
     78{{{#!div style="border: 1pt dotted; margin: 1em"
     79**Note:** Some web browsers (IE, Opera) cache CSS and !JavaScript files, so you should instruct your users to manually erase the contents of their browser's cache. A forced refreshed (SHIFT + <F5>) should be sufficient.
    7080{{{#!comment
    7181Remove above note once #9936 is fixed.
    7282}}}
    73 
    74 === 6. Steps specific to a given Trac version
     83}}}
     84
     85=== 7. Steps specific to a given Trac version #VersionSpecificSteps
     86
     87==== Upgrading from Trac 1.4 to 1.5 #to1.5
     88
     89===== Python 2.7 no longer supported
     90
     91Upgrade Python to 3.5 or later.
     92
     93==== Upgrading from Trac 1.2 to 1.4 #to1.4
     94
     95===== Python 2.6 no longer supported
     96
     97Upgrade Python to 2.7, but not 3.0 or greater.
     98
     99===== MySQL-python no longer supported
     100
     101[https://pypi.python.org/pypi/PyMySQL PyMySQL] is the supported MySQL database library, support for [https://pypi.python.org/pypi/MySQL-python MySQL-python] has been removed.
     102
     103===== Obsolete Plugins
     104
     105Trac has added functionality equivalent to the following plugins:
     106
     107* [https://trac-hacks.org/wiki/DynamicVariablesPlugin DynamicVariablesPlugin]: dynamic variables are autocompleted
     108* [https://trac-hacks.org/wiki/NavAddPlugin NavAddPlugin]: see TracNavigation
     109* [https://trac-hacks.org/wiki/FlexibleAssignToPlugin FlexibleAssignToPlugin]: subclass `ConfigurableTicketWorkflow` and override `get_allowed_owners`
     110* [https://trac-hacks.org/wiki/TracMigratePlugin TracMigratePlugin]: Use the `trac-admin` [TracAdmin#ChangingDatabaseBackend convert_db command]
     111
     112The plugins should be removed when upgrading Trac to 1.4.
     113
     114===== Jinja2 is the new template engine
     115
     116Content is now generated by using the Jinja2 template
     117engine. You should verify that your plugins are
     118compatible with this change.
     119
     120If you customized the Trac templates, or the `site.html`
     121template, you'll need to adapt that as well.
     122(TODO: expand...) See [#CustomizedTemplates]. Email [TracNotification#CustomizingContent notification templates] also need to
     123be adapted.
     124
     125===== New permission policies for Wiki and Ticket realms
     126
     127Since 1.3.2 there are new permission policies for the ticket and wiki systems. `DefaultTicketPolicy` allows an authenticated user with `TICKET_APPEND` or `TICKET_CHPROP` to modify the description of a ticket they reported. It also implements the pre-1.3.2 behavior of allowing users to edit their own ticket comments. [#Newpermissionspolicyforread-onlywikipages ReadonlyWikiPolicy], added in 1.1.2, is renamed to `DefaultWikiPolicy`. The new permission policies can be easily replaced with alternate implementations if the default behavior is not desired.
     128
     129If `[trac] permission_policy` has the default value `ReadonlyWikiPolicy, DefaultPermissionPolicy, LegacyAttachmentPolicy`, then `DefaultWikiPolicy, DefaultTicketPolicy` should be automatically appended to the list when upgrading the environment:
     130{{{#!ini
     131[trac]
     132permission_policies = DefaultWikiPolicy,
     133 DefaultTicketPolicy,
     134 DefaultPermissionPolicy,
     135 LegacyAttachmentPolicy
     136}}}
     137
     138If other permission policies are enabled, `trac.ini` will need to be edited to add `DefaultWikiPolicy, DefaultTicketPolicy` to `permission_policies`. See [wiki:TracFineGrainedPermissions#DefaultWikiPolicyandDefaultTicketPolicy] for additional details on the proper ordering.
     139
     140===== Description field added to ticket enums #enum-description-field
     141
     142The ticket enums now have a //description// field. An //ambiguous column name// error may be seen for reports that reference the `description` column of another table and join the `enum` table with that table (e.g. `ticket`, `component`). The reports {1}, {2}, {3}, {4}, {5}, {7}, and {8} are modified by an upgrade step to fix the issue, but the modification may not succeed if the default reports have been modified, in which case `upgrade` will output a message to the terminal instructing the user to modify the reports. User-created reports may also need to be modified.
     143
     144Reports that display the error need to be modified to prefix the `description` column with the appropriate table name or alias. For example, if the `ticket` table is aliased as `t` (`ticket t` or `ticket AS t`), replace `description` with `t.description` if the report should use the ticket's `description` column.
     145
     146===== Removed `<repostype>` and `<repospath>` arguments from `trac-admin` `initenv` command
     147
     148The TracAdmin `initenv` command allowed the default repository to be specified using the third and fourth positional arguments of `initenv`:
     149{{{#!sh
     150initenv [<projectname> <db> [<repostype> <repospath>]]
     151}}}
     152
     153The arguments were an artifact of Trac < 0.12, which only supported a single repository. Trac 0.12 and later supports multiple repositories, which can be specified at the time of environment creation using the `--inherit` and `--config` arguments. See the [TracEnvironment#SourceCodeRepository initenv documentation] for details on specifying source code repositories.
     154
     155==== Upgrading from Trac 1.0 to 1.2 #to1.2
     156
     157===== Python 2.5 no longer supported
     158
     159Upgrade Python to at least 2.6 or 2.7, but not 3.0 or greater.
     160
     161===== Obsolete Plugins
     162
     163Trac has added functionality equivalent to the following plugins:
     164* [https://trac-hacks.org/wiki/AdminEnumListPlugin AdminEnumListPlugin]
     165* [https://trac-hacks.org/wiki/AttachmentNotifyPlugin AttachmentNotifyPlugin]: attachment notifications are sent in Trac 1.0.3 and later
     166* [https://trac-hacks.org/wiki/DateFieldPlugin DateFieldPlugin]: see the **time** [TracTicketsCustomFields#AvailableFieldTypesandOptions custom field type]
     167* [https://trac-hacks.org/wiki/FlexibleReporterNotificationPlugin FlexibleReporterNotificationPlugin]: [trac:CookBook/Notification/Subscriptions custom subscribers] can be implemented in the new extensible notification system
     168* [https://trac-hacks.org/wiki/GroupBasedRedirectionPlugin GroupBasedRedirectionPlugin]: the default handler can set as a user preference
     169* [https://trac-hacks.org/wiki/GroupingAssignToPlugin GroupingAssignToPlugin]: groups and permissions can be used in the [TracWorkflow#BasicTicketWorkflowCustomization set_owner] workflow attribute
     170* [https://trac-hacks.org/wiki/LinenoMacro LinenoMacro]: see WikiProcessors#AvailableProcessors
     171* [https://trac-hacks.org/wiki/NeverNotifyUpdaterPlugin NeverNotifyUpdaterPlugin]: see [TracNotification#notification-subscriber-section notification subscribers]
     172* [https://trac-hacks.org/wiki/QueryUiAssistPlugin QueryUiAssistPlugin]: see TracQuery#Filters.
     173* [https://trac-hacks.org/wiki/TicketCreationStatusPlugin TicketCreationStatusPlugin]: see [#NewWorkflowActions]
     174
     175The plugins should be removed when upgrading Trac to 1.2.
     176
     177===== New workflow actions #NewWorkflowActions
     178
     179The ticket creation step is controlled with a workflow action. The default workflow has `create` and `create_and_assign` actions. The `create` action will always be added when upgrading the database. The `create_and_assign` action will be added if the workflow has an //assigned// state. You may want to edit your workflow after upgrading the database to customize the actions available on the //New Ticket// page.
     180
     181===== New permissions policy for read-only wiki pages
     182
     183Since 1.1.2 the read-only attribute of wiki pages is enabled and enforced only when `ReadonlyWikiPolicy` is in the list of active permission policies. If `[trac] permission_policy` has the default value `DefaultPermissionPolicy, LegacyAttachmentPolicy`, then `ReadonlyWikiPolicy` should be automatically appended to the list when upgrading the environment:
     184{{{#!ini
     185[trac]
     186permission_policies = ReadonlyWikiPolicy,
     187 DefaultPermissionPolicy,
     188 LegacyAttachmentPolicy
     189}}}
     190
     191If other permission policies are enabled, `trac.ini` will need to have `ReadonlyWikiPolicy` appended to the list of active `permission_policies`. See TracFineGrainedPermissions#ReadonlyWikiPolicy for additional details on the proper ordering.
     192
     193===== Navigation Ordering Moved
     194
     195The mainnav and metanav configuration ordering have
     196been moved from `[trac]` `mainnav` and `[trac]` `metanav` to the `[mainnav]` and `[metanav]` sections. The ordering is now specified using the `order` attribute as described in [TracNavigation#nav-order TracNavigation].
     197
     198The new configuration values will be written to trac.ini on upgrade, preserving the navigation order for the environment. You may need to edit trac.ini
     199if you use a shared [TracIni#GlobalConfiguration global configuration].
     200For example, if you wish to specify the navigation ordering for several environments in `global.ini`, you'll
     201need to add the `[mainnav]` and `[metanav]` sections
     202in that file and delete those sections from each
     203environment's trac.ini.
    75204
    76205==== Upgrading from Trac 0.12 to Trac 1.0 #to1.0
    77206
    78207===== Python 2.4 no longer supported
     208
    79209Upgrade Python to at least 2.5, but not 3.0.
    80210
     
    83213Trac has added functionality equivalent to the following plugins:
    84214
     215* [https://trac-hacks.org/wiki/AnchorMacro AnchorMacro]
    85216* [https://trac-hacks.org/wiki/BatchModifyPlugin BatchModifyPlugin]
    86 * [https://trac-hacks.org/wiki/GitPlugin GitPlugin]
     217* [https://trac-hacks.org/wiki/GitPlugin GitPlugin]
    87218* [https://trac-hacks.org/wiki/OverrideEditPlugin OverrideEditPlugin]
     219* [https://trac-hacks.org/wiki/ProgressMeterMacro ProgressMeterMacro]
    88220
    89221The plugins should be removed when upgrading Trac to 1.0.
    90222
    91223===== Subversion components not enabled by default for new installations
     224
    92225The Trac components for Subversion support are no longer enabled by default. To enable the svn support, you need to make sure the `tracopt.versioncontrol.svn` components are enabled, for example by setting the following in the TracIni:
    93226{{{#!ini
     
    95228tracopt.versioncontrol.svn.* = enabled
    96229}}}
     230
    97231The upgrade procedure should take care of this and change the TracIni appropriately, unless you already had the svn components explicitly disabled.
    98232
    99 ===== Attachments migrated to new location
    100 Another step in the automatic upgrade will change the way the attachments are stored. Create a backup of the `attachments` directory before upgrading. In case the `attachments` directory contains some files which are //not// attachments, the last step of the migration to the new layout will fail: the deletion of the now unused `attachments` directory can't be done if there are still files and folders in it. You may ignore this error, but better to move them elsewhere and remove the `attachments` directory manually. The attachments themselves are now all located in your environment below the `files/attachments` directory.
     233===== Attachments migrated to new location #AttachmentsMigrated
     234
     235Another step in the automatic upgrade will change the way the attachments are stored. There have been reports that the attachment migration [#AttachmentsNotMigrated sometimes fails], so it's extra important that you [TracBackup backup your environment].
     236
     237In case the `attachments` directory contains some files which are //not// attachments, the last step of the migration to the new layout will not be completed: the deletion of the now unused `attachments` directory can't be done if there are still files and folders in it. You may ignore this error, but better to move them elsewhere and remove the `attachments` directory manually. The attachments themselves are now all located in your environment below the `files/attachments` directory.
    101238
    102239===== Behavior of `[ticket] default_owner` changed
     240
    103241Prior to 1.0, the owner field of new tickets always defaulted to `[ticket] default_owner` when the value was not empty. If the value was empty, the owner field defaulted to to the Component's owner. In 1.0 and later, the `default_owner` must be set to `< default >` to make new tickets default to the Component's owner. This change allows the `default_owner` to be set to an empty value if no default owner is desired.
    104242
    105 ==== Upgrading from Trac 0.11 to Trac 0.12
    106 
    107 ===== Python 2.3 no longer supported
    108 The minimum supported version of Python is now 2.4.
    109 
    110 ===== SQLite v3.x required
    111 SQLite v2.x is no longer supported. If you still use a Trac database of this format, you'll need to convert it to SQLite v3.x first. See [trac:PySqlite#UpgradingSQLitefrom2.xto3.x] for details.
    112 
    113 ===== [trac:PySqlite] 2 required
    114 [trac:PySqlite] 1.1.x is no longer supported. Please install 2.5.5 or later if possible, see [#Tracdatabaseupgrade Trac database upgrade] below.
    115 
    116 ===== Obsolete Plugins
    117 
    118 Trac has added functionality equivalent to the following plugins:
    119 
    120 * [https://trac-hacks.org/wiki/AutoQueryPlugin AutoQueryPlugin]
    121 * ​[https://trac-hacks.org/wiki/AdminConsoleProviderPatch AdminConsoleProviderPatch]
    122 * [https://trac-hacks.org/wiki/AnchorMacro AnchorMacro]: see WikiFormatting#SettingAnchors
    123 * [https://trac-hacks.org/wiki/TicketChangePlugin TicketChangePlugin]: see [TracPermissions#TicketSystem TICKET_EDIT_COMMENT permission]
    124 * [https://trac-hacks.org/wiki/TicketDeletePlugin TicketDeletePlugin]: see `tracopt.ticket.deleter`
    125 * [https://trac-hacks.org/wiki/SubversionLocationPlugin SubversionLocationPlugin]: see TracRepositoryAdmin#Repositories
    126 * [https://trac-hacks.org/wiki/WikiCreoleRendererPlugin WikiCreoleRendererPlugin]: see [trac:WikiCreole]
    127 * [https://trac-hacks.org/wiki/RepoRevisionSyntaxPlugin RepoRevisionSyntaxPlugin] (added in 0.12.1)
    128 
    129 The plugins should be removed when upgrading Trac to 0.12.
    130 
    131 ===== Multiple Repository Support
    132 The latest version includes support for multiple repositories. If you plan to add more repositories to your Trac instance, please refer to TracRepositoryAdmin#Migration.
    133 
    134 This may be of interest to users with only one repository, since there is now a way to avoid the potentially costly resync check at every request.
    135 
    136 ===== Resynchronize the Trac Environment Against the Source Code Repository
    137 
    138 Each [TracEnvironment Trac environment] must be resynchronized against the source code repository in order to avoid errors such as "[trac:#6120 No changeset ??? in the repository]" while browsing the source through the Trac interface:
    139 
    140 {{{#!sh
    141 trac-admin /path/to/projenv repository resync '*'
    142 }}}
    143 
    144 ===== Improved repository synchronization
    145 In addition to supporting multiple repositories, there is now a more efficient method for synchronizing Trac and your repositories.
    146 
    147 While you can keep the same synchronization as in 0.11 adding the post-commit hook as outlined in TracRepositoryAdmin#Synchronization and TracRepositoryAdmin#ExplicitSync will allow more efficient synchronization and is more or less required for multiple repositories.
    148 
    149 Note that if you were using the `trac-post-commit-hook`, ''you're strongly advised to upgrade it'' to the new hook documented in the above references and [TracWorkflow#Howtocombinethetracopt.ticket.commit_updaterwiththetestingworkflow here], as the old hook will not work with anything else than the default repository and even for this case, it won't trigger the appropriate notifications.
    150 
    151 ===== Authz permission checking
    152 The authz permission checking has been migrated to a fine-grained permission policy. If you use authz permissions (aka `[trac] authz_file` and `authz_module_name`), you must add `AuthzSourcePolicy` in front of your permission policies in `[trac] permission_policies`. You must also remove `BROWSER_VIEW`, `CHANGESET_VIEW`, `FILE_VIEW` and `LOG_VIEW` from your global permissions with `trac-admin $ENV permission remove` or the "Permissions" admin panel.
    153 
    154 ===== Microsecond timestamps
    155 All timestamps in database tables, except the `session` table, have been changed from "seconds since epoch" to "microseconds since epoch" values. This change should be transparent to most users, except for custom reports. If any of your reports use date/time columns in calculations (e.g. to pass them to `datetime()`), you must divide the values retrieved from the database by 1'000'000. Similarly, if a report provides a calculated value to be displayed as a date/time (i.e. with a column named "time", "datetime", "changetime", "date", "created" or "modified"), you must provide a microsecond timestamp, that is, multiply your previous calculation with 1'000'000.
    156 
    157 ==== Upgrading from Trac 0.10 to Trac 0.11
    158 ===== Site Templates and Styles
    159 The templating engine has changed in 0.11 to Genshi, please look at TracInterfaceCustomization for more information.
    160 
    161 If you are using custom CSS or modified templates in the `templates` directory of the TracEnvironment, you will need to convert them to the Genshi way of doing things. To continue to use your style sheet, follow the instructions at TracInterfaceCustomization#SiteAppearance.
    162 
    163 ===== Trac Macros, Plugins
    164 The Trac macros will need to be adapted, as the old-style wiki-macros are not supported anymore due to the drop of [trac:ClearSilver] and the HDF. They need to be converted to the new-style macros, see WikiMacros. When they are converted to the new style, they need to be placed into the plugins directory instead and not wiki-macros, which is no longer scanned for macros or plugins.
    165 
    166 ===== For FCGI/WSGI/CGI users
    167 For those who run Trac under the CGI environment, run this command in order to obtain the trac.*gi file:
    168 {{{#!sh
    169 trac-admin /path/to/env deploy /deploy/directory/path
    170 }}}
    171 
    172 This will create a deploy directory with the following two subdirectories: `cgi-bin` and `htdocs`. Then update your Apache configuration file `httpd.conf` with this new `trac.cgi` location and `htdocs` location.
    173 
    174 ===== Web Admin plugin integrated
    175 If you had the [trac:WebAdmin] plugin installed, you can uninstall it as it is part of the Trac code base since 0.11.
    176 
    177 ===== New Default Configurable Workflow
    178 
    179 When you run `trac-admin <env> upgrade`, your `trac.ini` will be modified to include a `[ticket-workflow]` section. The workflow configured in this case is the original workflow, so that ticket actions will behave like they did in 0.10.
    180 
    181 Graphically, that looks like this:
    182 
    183 {{{#!Workflow width=500 height=240
    184 leave = * -> *
    185 leave.operations = leave_status
    186 leave.default = 1
    187 accept = new -> assigned
    188 accept.permissions = TICKET_MODIFY
    189 accept.operations = set_owner_to_self
    190 resolve = new,assigned,reopened -> closed
    191 resolve.permissions = TICKET_MODIFY
    192 resolve.operations = set_resolution
    193 reassign = new,assigned,reopened -> new
    194 reassign.permissions = TICKET_MODIFY
    195 reassign.operations = set_owner
    196 reopen = closed -> reopened
    197 reopen.permissions = TICKET_CREATE
    198 reopen.operations = del_resolution
    199 }}}
    200 
    201 There are some significant caveats in this, such as accepting a ticket sets it to 'assigned' state, and assigning a ticket sets it to 'new' state. So you will probably want to migrate to "basic" workflow; [trac:source:trunk/contrib/workflow/migrate_original_to_basic.py contrib/workflow/migrate_original_to_basic.py] may be helpful. See TracWorkflow for a detailed description of the new basic workflow.
    202 
    203 ===== Global Configuration
    204 In versions prior to 0.11, the global configuration was by default located in `$prefix/share/trac/conf/trac.ini` or `/etc/trac/trac.ini`, depending on the distribution. You may want to specify that file to inherit from when upgrading.  Literally, when upgrading you have to add an `[inherit]` section to your project's `trac.ini` file. Additionally, you have to move your customized templates and common images from `$prefix/share/trac/...` to the new location.
    205 
    206 === 7. Restart the Web Server #RestarttheWebServer
    207 
    208 If you are not running [wiki:TracCgi CGI], reload the new Trac code by restarting your web server.
     243===== Behavior of `* -> *` workflow transition
     244
     245The workflow transition `* -> *` must have the operation
     246`leave_status`. Due to a defect in Trac < 1.0.18
     247`leave_status` was not required, so it may be necessary
     248to add the operation when upgrading. The action will not
     249display for a `* -> *` transition if the action does
     250not have the `leave_status` operation.
     251
     252==== Upgrading from older versions of Trac #OlderVersions
     253
     254For upgrades from versions older than Trac 0.12, refer first to [trac:wiki:0.12/TracUpgrade#SpecificVersions TracUpgrade for 0.12].
     255
     256For upgrades from versions older than Trac 0.10, refer first to [trac:wiki:0.10/TracUpgrade#SpecificVersions TracUpgrade for 0.10].
    209257
    210258== Known Issues
     
    212260=== Customized Templates
    213261
    214 Trac supports customization of its Genshi templates by placing copies of the templates in the `<env>/templates` folder of your [TracEnvironment environment] or in a common location specified in the [[TracIni#GlobalConfiguration| [inherit] templates_dir]] configuration setting. If you choose to do so, be aware that you will need to repeat your changes manually on a copy of the new templates when you upgrade to a new release of Trac (even a minor one), as the templates will likely evolve. So keep a diff around.
    215 
    216 The preferred way to perform TracInterfaceCustomization is to write a custom plugin doing an appropriate `ITemplateStreamFilter` transformation, as this is more robust in case of changes: we usually won't modify element `id`s or change CSS `class`es, and if we have to do so, this will be documented in the [trac:TracDev/ApiChanges] pages.
     262Trac supports customization of its templates by placing copies of the templates in the `<env>/templates` folder of your [TracEnvironment environment] or in a common location specified in the [TracIni#GlobalConfiguration  inherit.templates_dir] configuration setting. If you choose to customize the templates, be aware that you will need to repeat your changes on a copy of the new templates when you upgrade to a new release of Trac (even a minor one), as the templates will evolve. So keep a diff around.
     263
     264The preferred way to perform TracInterfaceCustomization is a custom plugin doing client-side !JavaScript transformation of the generated output, as this is more robust in case of changes: we usually won't modify an element `id` or change its CSS `class`, and if we have to do so, this will be documented in the [trac:TracDev/ApiChanges] pages.
    217265
    218266=== !ZipImportError
    219267
    220 Due to internal caching of zipped packages, whenever the content of the packages change on disk, the in-memory zip index will no longer match and you'll get irrecoverable !ZipImportError errors. Better anticipate and bring your server down for maintenance before upgrading.
     268Due to internal caching of zipped packages, whenever the content of the packages change on disk, the in-memory zip index will no longer match and you'll get irrecoverable !ZipImportError errors. Better to anticipate and bring your server down for maintenance before upgrading.
    221269See [trac:#7014] for details.
    222270
    223271=== Wiki Upgrade
     272
    224273`trac-admin` will not delete or remove default wiki pages that were present in a previous version but are no longer in the new version.
    225274
    226 === Trac database upgrade
    227 
    228 A known issue in some versions of [trac:PySqlite] (2.5.2-2.5.4) prevents the trac-admin upgrade script from successfully upgrading the database format. It is advised to use either a newer or older version of the sqlite python bindings to avoid this error. For more details see ticket [trac:#9434].
    229 
    230275=== Parent dir
     276
    231277If you use a Trac parent env configuration and one of the plugins in one child does not work, none of the children will work.
    232278
     279=== Attachments not migrated #AttachmentsNotMigrated
     280
     281There have been reports that attachments are not [#AttachmentsMigrated migrated] when upgrading to Trac 1.0 or later. The cause of the issue has not yet been found. If you encounter this issue, see [https://trac.edgewall.org/wiki/TracFaq#Q:Attachmentsaremissingafterupgrade the FAQ] for a workaround and please report your findings to [trac:#11370].
     282
    233283== Related topics
    234284
    235285=== Upgrading Python
    236286
    237 Upgrading Python to a newer version will require reinstallation of Python packages: Trac itself of course, but also [http://pypi.python.org/pypi/setuptools easy_install], if you've been using that. If you are using Subversion, you'll also need to upgrade the Python bindings for svn.
    238 
    239 ==== Windows and Python 2.6
    240 
    241 If you've been using !CollabNet's Subversion package, you may need to uninstall that in favor of [http://alagazam.net/ Alagazam], which has the Python bindings readily available, see [trac:TracSubversion]. That package works without tweaking.
    242 
    243 === Changing Database Backend
    244 
    245 The [http://trac-hacks.org/wiki/TracMigratePlugin TracMigratePlugin] on [http://trac-hacks.org trac-hacks.org] has been written to assist in migrating between SQLite, MySQL and PostgreSQL databases.
    246 
    247 === Upgrading from older versions of Trac #OlderVersions
    248 
    249 For upgrades from versions older than Trac 0.10, refer first to [trac:wiki:0.10/TracUpgrade#SpecificVersions].
     287Upgrading Python to a newer version will require reinstallation of Python packages: Trac itself of course, but also [TracInstall#Dependencies dependencies]. If you are using Subversion, you'll need to upgrade the [trac:TracSubversion Python bindings for SVN].
     288
     289
    250290
    251291-----