Solution suddenly wont import

Classic Servoy
1

I have added two field to my solution in order to explore the IT2 and MIG calendar bean

they are two DATETIME fields app_start and app_end.

Both are fine in MYSQL and dont have any autoenter properties set.

The solution works fine in Developer 3.1.3,

now when i come to import it into my server it wont, as it says

[error]	com.servoy.j2db.persistence.RepositoryException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Duplicate column name 'app_end'

But the column is not duplicated?!?

So i dont understand what has happened? My server is on Linux and i havent upgraded it from 3.1, but i dont htink that the problem.

Ideas?

David

2

David

Could it be that you have modified the DB tables on your Server outside Servoy - ie by copying tables across? This could cause the problem when Servoy tries to create ‘new’ columns/fields as part of the import but finds they are already there.

If so I suggest you export any data then delete the field(s) and retry the import.

Regards

Graham Greensall
Worxinfo Ltd

3

If you do changes on the datamodel outside of Servoy, you have to restart the developer/server to get back in sync with the database.

4

That must be what it was,

i had modifed the solution in Developer and not restarted the server before doing the import, that must be why it suddenly worked!

David.