Error: Cause: needs column or cannot drop sole column of table

Support
#1

I have tried several different ways to add an Entity in a new project…

With every new project, I always get the following error:

Cause: needs column or cannot drop sole column of table

Here are the steps:

  1. Create a new project.
  2. Add a new entity.
  3. Compile.
  4. When prompted, click Update Database.
  5. Note the error : Cause: needs column or cannot drop sole column of table

https://drive.google.com/file/d/1qExfaRT0fNghUouxM4YoAB0_h5HZqWzR/view?usp=sharing

#2

Support,

I’m a subscriber with a Commercial license. I’m wondering if someone could get back to me.

Thanks!

#4

Hi

In the demo project attached you have invalid database scripts that are not applied.
Run CUBA -> Generate Database Scripts… in menu. In the appeared Warning dialog click Continue.
In the Database Scripts dialog click Update database button to update existing database or Create database to create new one from scratch. Existing database will be overwritten in this case.

#5

Support,

I appreciate you getting back to me.

When I follow the steps you suggested, I get the following error:

Cause: needs column or cannot drop sole column of table

Over the past week, I’ve created several new test projects. I followed the steps I gave in my original post. Every time I get the same error:

Cause: needs column or cannot drop sole column of table

I have also uninstalled and reinstalled the latest version of IntelliJ IDEA and the Cuba plugin.

Thanks for your help.

#6

Hi

Could you please attach screencast of you following the steps above?

If it is not possible, please provide more details.

  • What is the third step: Compile?
  • Also the message in the dialog is needed, where you click Update Database
  • Where does the error message appear?