help to better help you:
Please: add always Joomla / JEM version and details to your posts, so we can try to reproduce your issue!
Error 1054 - Unknown Column "status" in "where clause"
Error 1054 - Unknown Column "status" in "where clause"
7 years 1 day ago
just installed JEM and hoping I can use it for our DJ calendar. My problem is while I can get to the control panel, clicking Events or Add Event results in:
An error has occurred.
1054 Unknown column 'status' in 'where clause'
Return to Control Panel - which takes me back to the Joomla CP.
i ran "housekeeping" and i think i had an old JEM install here from long ago when repeating events were not working for me, and i deleted 8 event images and now while i can hit EVENTS and get to the screen, hitting "NEW" results in the same error.
so my guess is there's something old in here to clean up but i have no idea if i'm right and if so, how do it. and if wrong, what do i need to do? >g<
thank you for the help!
jerry
An error has occurred.
1054 Unknown column 'status' in 'where clause'
Return to Control Panel - which takes me back to the Joomla CP.
i ran "housekeeping" and i think i had an old JEM install here from long ago when repeating events were not working for me, and i deleted 8 event images and now while i can hit EVENTS and get to the screen, hitting "NEW" results in the same error.
so my guess is there's something old in here to clean up but i have no idea if i'm right and if so, how do it. and if wrong, what do i need to do? >g<
thank you for the help!
jerry
Please Log in or Create an account to join the conversation.
Re: Error 1054 - Unknown Column "status" in "where clause"
7 years 22 hours agojust installed JEM
first of all: give more information about your system! we have to understand and reproduceyour issue. With such few information we can't help!what Icneed to do?
Please Log in or Create an account to join the conversation.
Re: Error 1054 - Unknown Column "status" in "where clause"
7 years 12 hours ago - 7 years 12 hours ago
and - what would you like to know?
Joomla 3.8.3
latest download yesterday from JEM installed.
i believe i used this well over a year ago and removed it due to how it handled repeating events. if that has not changed or been improved since then let me know and i'll just take it back off again and try something else. thought i read it was better or maybe i can make it work cause i really do like this product.
MySQLi database
Database client version: libmysql - 5.1.73
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
PHP version: 5.6.30
RocketTheme template (didn't make a difference last time and i'm using the same one today)
i looked at the plugins and some were not active. activated them all - no difference.
i've run all housekeeping again and no difference.
i can hit EVENTS and go to the events list. i hit NEW i get the error in the subject.
I hit "add event" and i get the error.
i can go to category and venue and hit NEW and am able to proceed w/o error.
if you need anything else please let me know, i'd LOVE to get this working. screenshot of the error included.
Joomla 3.8.3
latest download yesterday from JEM installed.
i believe i used this well over a year ago and removed it due to how it handled repeating events. if that has not changed or been improved since then let me know and i'll just take it back off again and try something else. thought i read it was better or maybe i can make it work cause i really do like this product.
MySQLi database
Database client version: libmysql - 5.1.73
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
PHP version: 5.6.30
RocketTheme template (didn't make a difference last time and i'm using the same one today)
i looked at the plugins and some were not active. activated them all - no difference.
i've run all housekeeping again and no difference.
i can hit EVENTS and go to the events list. i hit NEW i get the error in the subject.
I hit "add event" and i get the error.
i can go to category and venue and hit NEW and am able to proceed w/o error.
if you need anything else please let me know, i'd LOVE to get this working. screenshot of the error included.
Last edit: 7 years 12 hours ago by iceberg.
Please Log in or Create an account to join the conversation.
Time to create page: 0.438 seconds