SQL Syntax Error on solution Import
Posted: Wed Jul 01, 2015 5:40 pm
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 )
Both MySQL databases are using InnoDB & utf8_bin.
Servoy details are
When I try to 'Import Solution' I get this error
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
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 )
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
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