# SQL Syntax Error on solution Import **URL:** \ **Category:** Classic Servoy\ **Created:** [July 1, 2015, 3:40pm UTC](https://forum.servoy.com/t/sql-syntax-error-on-solution-import/18494 "2015-07-01T15:40:21Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![rafig](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/rafig/32/4463_2.png) [@rafig](https://forum.servoy.com/u/rafig)\ **Post date:** [July 1, 2015, 3:40pm UTC](https://forum.servoy.com/t/sql-syntax-error-on-solution-import/18494/1 "2015-07-01T15:40:21Z")
I’m having a strange problem when trying to import a solution to a new Servoy server I have set up. I am using MySQL hosted on my ISP, with the Repository database on one MySQL instance/IP address and the actual Data database on another (never done this before) and the actual Servoy Application Server installed on a headless Ubuntu 14.04.2 LTS DigitalOcean ‘droplet’ somewhere else (never done this before, but eventually got it set up using SSH from Mac Terminal ![;-)]( "Wink") ) Both MySQL databases are using InnoDB & utf8\_bin. Servoy details are > Server Information > Servoy version 8.0.0 b2-releaseNumber 3017 > Port used by RMI Registry: 1099 > Repository version 46 > Current time: Wed Jul 01 16:35:25 BST 2015 > Uptime: 16 days 2 hours 32 minutes 14 seconds > Server ID: 567041DD-8F35-4430-B582-DB9C9ACC5203 > > Settings file for this server: /home/rafig/servoy/application\_server/servoy.properties > > User Information > Logged in as: servoy > > JVM Information > java.vm.name=OpenJDK 64-Bit Server VM > java.version=1.7.0\_79 > java.vm.info=mixed mode > java.vm.vendor=Oracle Corporation > > Operating System Information > os.name=Linux > os.version=3.13.0-52-generic > os.arch=amd64 > > System Information > Code Cache Non-heap memory: allocated=3776K, used=3694K, max=49152K > Perm Gen Non-heap memory: allocated=56320K, used=56140K, max=131072K > Heap memory: allocated=125308K, used=35760K, max=1013632K > Number of Processors: 1 When I try to ‘Import Solution’ I get this error [attachment=1]SAS\_ImportFail\_882x208.png[/attachment] I have NEVER seen this kind of a message before and couldn’t really find anything helpful on Forum, hence this post. I am assuming it is some error related to the Repository as the Data database & tables already exist. I am happily connected to both Database Servers using Servoy Developer on my local Mac and solution runs fine in Debug Client locally. I am also attaching Stack Dump from server. If anyone needs anything to help them solve this, please let me know Thanks for any help Rafi [SAS\_Stack\_Dump.txt.zip](https://forum.servoy.com/uploads/short-url/vBzuknywpe8C3EXD2KDLDl7ZPxZ.zip) (2.88 KB) ![SAS_ImportFail_882x208.png](https://canada1.discourse-cdn.com/flex010/uploads/servoy/original/2X/a/abbdb0d54d73397d91015403b26b1c53210d4a9f.png) ---
**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\ **Post date:** [July 2, 2015, 7:28am UTC](https://forum.servoy.com/t/sql-syntax-error-on-solution-import/18494/2 "2015-07-02T07:28:53Z")
Hi Rafi, What MySQL version(s) are you using ? Perhaps you need to update your JDBC driver to match your MySQL version. ---
**Author:** ![rafig](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/rafig/32/4463_2.png) [@rafig](https://forum.servoy.com/u/rafig)\ **Post date:** [July 2, 2015, 8:26pm UTC](https://forum.servoy.com/t/sql-syntax-error-on-solution-import/18494/3 "2015-07-02T20:26:00Z")
Hi Robert > ROCLASI: > What MySQL version(s) are you using ? Perhaps you need to update your JDBC driver to match your MySQL version. here are server details > Server type: MySQL > Server version: 5.1.73-log - Source distribution > Protocol version: 10 I was using driver > mysql-connector-java-5.1.35-bin but am just downloading 5.1.36 and will try that tomorrow and let you know. Thanks for the suggestion (which I hope will work ![;-)]( "Wink") ) ---
**Author:** ![rafig](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/rafig/32/4463_2.png) [@rafig](https://forum.servoy.com/u/rafig)\ **Post date:** [July 6, 2015, 9:03am UTC](https://forum.servoy.com/t/sql-syntax-error-on-solution-import/18494/4 "2015-07-06T09:03:16Z")
Hi Robert, I tried with the new driver, but same issue. Actually, I first had an issue with a timeout to the MySQL db. I was using ‘Connection validation type = Query Validation’ & had ‘SELECT 1;’ as the query. I then changed this back to ‘Exception Validation’ but still the same error. Thanks Rafi