After installing Servoy 2.0b6 over 1.2final the first run of Servoy offers to upgrade the repository (as expected):
- Code: Select all
Loading servoy.properties from /home/neale/servoy.properties - Done
com.servoy.j2db.persistence.RepositoryException: Old repository found in the database. Repository version: 19, software version: 20. Upgrade the repository first.
Unfortunately, this didn't work so well:
- Code: Select all
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: Syntax error or access violation, message from server: "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 '.r_all' at line 1"
Neither did a subsequent attempt to run Servoy:
- Code: Select all
com.servoy.j2db.persistence.RepositoryException: Old repository found in the database. Repository version: 19, software version: 20. Upgrade the repository first.
java.sql.SQLException: connection already closed or transaction in progress
com.servoy.j2db.persistence.RepositoryException: A column on table servoy_releases/server repository_server with name release_number already exists
FWIW, this was with Connector/J 3.0.9 and upgrading to Connector/J 3.0.11 didn't help.
Yeah, zapping the repository does "fix" this, but I'd rather not do that to my workstation too. Obviously 2.0b6 isn't the endgame here, just the stepping-stone to 2.0rc<latest>.
Any ideas?
Thanks,
Neale.