/
[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 [ 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.