Issues with MySQL integration

[Tero Miettinen]

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.

[Steve]

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