duplicate column name error on import

Classic Servoy
1

When trying to import an updated solution using servoy-admin, the import is failing with the error message:

[error] com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: Duplicate column name ‘web_id’

web_id is a new column that was added (since the last import/export) to one of the tables in the database that servoy connects to.

What might be causing this and how can I stop it?

2

How do you import? Through the server?

If the server is running and you create a column using a DB tool or Servoy developer, the server does not know about this column! All DB info is read on server start. And if the server doesn’t know about that column, it tries to create it…

3

Yes I was importing via the server. I’ve restarted the server and attempted the import again and everything went through ok.

Thanks for the quick response!