help to better help you:

Please: add always Joomla / JEM version and details to your posts, so we can try to reproduce your issue!

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

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

1 year 4 months ago
#30621
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

Attachments:

Please Log in or Create an account to join the conversation.

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

1 year 4 months ago - 1 year 4 months ago
#30623
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.
Last edit: 1 year 4 months ago by Wolfgang.

Please Log in or Create an account to join the conversation.

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

1 year 4 months ago
#30627
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

Please Log in or Create an account to join the conversation.

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

1 year 4 months ago
#30628
Hello Thomas,

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

Code:
ALTER TABLE `YOUR_PREFIX_jem_register` ADD `status` tinyint(3) NOT NULL DEFAULT 1 AFTER `waiting`;

Good luck!
Cheers
Wolfgang

Please Log in or Create an account to join the conversation.

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

1 year 4 months ago
#30629
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

Please Log in or Create an account to join the conversation.

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

1 year 4 months ago
#30630
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.)

Please Log in or Create an account to join the conversation.

Time to create page: 0.694 seconds