MySQL auto deployment

RocketRod

Trying to deploy a MySQL version of my app and I get the folowing error message. Using latest build 1420 and MySQL 5.5. Not used MySQL before so I've probably made a simple mistake. Can anyone assist?

Cheers Rod

Unable to auto-deploy application app.bsv due to the following exception Error creating data base tables You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Change MEDIUMTEXT, ChangedOn datetime, VMStatus varchar(20), UpdatedOn datetime,' at line 1

aware_support

Have you tried to run your application under MySQL on your own machine first? It seems to be a MySQL specific problem rather than the runtime problem. Try running integrity checker on your BSV under MySQL - you may find some compatibility errors and you may need to rename some of your objects or attributes.

RocketRod

Thank you for the suggestion. I'll test that out and let you know what happens.

Cheers Rod

RocketRod

Just to let everyone know I had a BS that tested under default DB ok. Problem under MySQL was that I found I was using two keywords as BO Names! All resolved with supports assistance.

Cheers Rod