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
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
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 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
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.
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
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
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
Hello Thomas,
If in your table `YOUR_PREFIX_jem_register´ the column `status` is missing, you could try the following:
Good luck!
Cheers
Wolfgang
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
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
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
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.)
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