Issues with MySQL integration

Hello,

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

The steps to reproduce:

Create a Database change script file with the following:
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
Add it to BuildMaster
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