[SOLVED] Unknown column 'status' in 'field list'

After migration from Joomla 3 to Joomla 4 also JEM has been moved as described in the documentation.
All former data seems to be available.
But no new event can be created. Following error appears:
"Unknown column 'status' in 'field list'". See also attached screenshots.
Kind regards
Thomas

Please spend some minutes to read this subject (if not already done):
Unknown column 'places' in 'field list'
Could it be that your problem has the same source?
How did you migrate? Really as documented? - No accuse.
I will try if I run into the same problem somewhere. No, the column 'status' exists in all my installations.

Hello Wolfgang,
I've had a look on the tables in the old and new database. Both columns do not exist.
I have done the installation as described.
Does some "alter table" help?
Kind regards
Thomas

Hello Thomas,

If in your table `YOUR_PREFIX_jem_register´ the column `status` is missing, you could try the following:


Good luck!
Cheers
Wolfgang

Dear Wolfgang,
when I try to create a new event, the error " 1054 Unknown column 'places' in 'field list' " is already shown. Maybe also for that a column is needed.
And the third thing is that no default country "Austria" can be
Kind regards
Thomas

Hello Thomas,

Now I am nearly sure that you uninstalled (instead of disabled) the old JEM package before you installed the version 4.0.0.
At least you seem to face the same problems.
See www.joomlaeventmanager.net/forum/bugs/12387-1054-unknown-column-places-in-field-list?start=6#30615 for the fix - or redo the installation from the backup following all steps of the installation instructions closely.

For the other problem you already posted a topic. I did and could answer on that, sorry. (I am just a user of JEM and a moderator in this forum.)