/
[deployment] Database queries during deployment are cut off [5.2.2-B1]

[deployment] Database queries during deployment are cut off [5.2.2-B1]

In-Portal has 2 ways of database schema/data upgrading:

  • full: when /core/install.php script (the Installation Wizard) is used to update to the next version of a module (or In-Portal itself)
  • partial: when the "Deploy" button is used in the "Tools > System Tools" section (also has CLI invocation mode) to execute needed SQLs

In "partial" mode 120 first symbols of all executed database queries are shown on the screen:

The issue is that first the HTML-escaping of the database query is done and then trimming and single quotes encoded as &#091 are can be trimmed in the middle of the HTML code resulting in a question mark sign.

Solution

In the "\DeploymentHelper::applyRevisions" method first, trim the SQL and only then escape it.

Related Tasks