NOTE: Use your table prefix instead of 52x_ during testing.
- execute UPDATE 52x_Modules` SET AppliedDBRevisions = NULL;` sql to mark all db revisions as non-executed
- change contents of /modules/custom/install/project_upgrades.sql file to this:
# r1: Initial Project Task (#TASK_ID) UPDATE NonExistingTable; # r2: Initial Project Task (#TASK_ID) SELECT UNIX_TIMESTAMP();
- login to Admin Console
- go to Tools → System Tools section
- press "Deploy" button
- confirm, that upon attempt execute SQLs from r1 the result was shown as FAILED (in red color) instead of OK (in green color) and script execution was stopped