New Reply

Good news! We have migrated all the Q&A on this site to https://forums.inedo.com, and are currently monitoring questions there!

Here are some important links:

All posts here are permanently locked (and will be redirected soon), and if you have any issues with the new site, please submit a support ticket, use the contact form, or visit our Slack Workspace.

Hello,

I'm having issues running a Database change script from BuildMaster.

The steps to reproduce:

  1. Create a Database change script file with the following:
    SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

  2. Add it to BuildMaster

  3. Try to execute it on a MySQL database.

When I run the same command from the MySQL command line (as the same user) it goes through as expected:
mysql> SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
Query OK, 0 rows affected (0.00 sec)

The error message I'm getting from the BuildMaster is simply "Fatal error encountered during command execution" which does not give me any information to go on.

Hi Tero,

The MySQL Database Provider is just passing the script as a command to the database. I did a quick search, and it looks like it might be configuration (connection string) related.

Does your connection string have "Allow User Variables=True" in it?

http://dev.mysql.com/doc/refman/5.0/en/connector-net-connection-options.html

Best,

Steve