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] error 1054

[SOLVED] error 1054

8 years 1 month ago
#22939
JEM 2.2
I filled in some information in categories and venues.
Then when I press the botton event I get this error massage:

1054 Unknown column 'status' in 'field list' SQL=SELECT COUNT(id) as total, COUNT(IF(status = 1 AND waiting <= 0, 1, null)) AS registered, COUNT(IF(status = 1 AND waiting > 0, 1, null)) AS waiting, COUNT(IF(status = -1, 1, null)) AS unregistered, COUNT(IF(status = 0, 1, null)) AS invited, event FROM #__jem_register WHERE event IN (1) GROUP BY event

Knows someone whats wrong with my configuration?

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

Re: [SOLVED] error 1054

8 years 1 month ago
#22941
was this a new JEM installation or an update?

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

Re: [SOLVED] error 1054

8 years 1 month ago - 8 years 1 month ago
#22948
At first I updated from 2.1 to 2.2, then I had this error message, I deinstalled JEM and made a new installation, but I got also the same error information.
Last edit: 8 years 1 month ago by werner100.

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

Re: [SOLVED] error 1054

8 years 1 month ago
#22956
I had the Same Problem After deinstalling 3.0.7 and installIng 2.2.2 on a joomla 3.6.4.
I followed the Instruktion of First exporting the .csv Files. All importing wenn Well unwillkürlich importing the events. Same result erforderlich 1054

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

Re: [SOLVED] error 1054

8 years 1 month ago
#22957
@zugzwang: Sorry, I don't understand your emglish.
Perhaps a bad translation machine!

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

Re: [SOLVED] error 1054

8 years 1 month ago
#22958
I try once more:
We are running Joomla 3.6.4:
Since JEM 3.0.7 wasn't updateable any more,
So I followed an instrunction in this forum to get to a running JEM 2.2.x

Steps:
1.) In JEM3.0.7 I did an export of all diverse groups to *.csv files
2.) I uninstalled JEM3.0.7
3.) I installed JEM 2.2.0
4.) Then I did all the imports of the *.csv files
5.) Some files went well, but after importing the events.csv there was also the 1054 error with the very long errormessage which doesn't really help

Hopefully you understand our porblem!
The following user(s) said Thank You: jojo12

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

Time to create page: 0.523 seconds