Error 1054 - Unknown column in where clause
By matto_ on Thursday, 14 March 2019
Posted in JEvents (Free Access)
Replies 5
Likes 0
Views 3.3K
Votes 0
When I trying to reach my events I get this message "Error 1054 - Unknown column "..." in where clause".
Here is website: www.iskramedical.eu/en/events

Does anyone know what could be wrong?

Thanks



PHP Version : 5.6.40

MySQL Version : 10.1.37-MariaDB-cll-lve

Server Information : Linux cpanel-16.controlpanel.si 3.10.0-962.3.2.lve1.5.24.5.el7.x86_64 #1 SMP Thu Nov 22 09:42:49 EST 2018 x86_64

Fix jQuery? : Yes

Load JEvents Bootstrap CSS? : Yes

Max Input Vars ? : 5000

Club code set? : No  

User Agent : Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.121 Safari/537.36  

Joomla : 3.9.4

component_com_jevents : 3.4.49

component_com_jce : 2.5.17

module_mod_jevents_cal : 3.4.49

module_mod_jevents_custom : 3.4.49

module_mod_jevents_filter : 3.4.49

module_mod_jevents_latest : 3.4.49

module_mod_jevents_legend : 3.4.49

module_mod_jevents_switchview : 3.4.49

plugin_content_jevents : 3.4.49

plugin_finder_jevents : 3.4.49

plugin_installer_jeventsinstaller : 3.4.49

plugin_search_eventsearch : 3.4.49

plugin_system_gwejson : 3.4.49
Hello,

The issue appears to be with com_nicepage. Please display the nicepage plugin and try again.

Many thanks
Tony
tonyp
·
5 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Matto,

Firstly can you try reinstalling JEvents. Failing that, can you enable Joomla! Debug mode and maximum error reporting and try again? It should give some more detail on the issue.

Many thanks
Tony
tonyp
·
5 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,
right now I reinstalling JEvent and it is the same. I enable Debug mode and here is report: www.iskramedical.eu/en/events

or code bellow:



1054 - Unknown column '5c8a403b64ffb' in 'where clause'



You may not be able to visit this page because of:



    an out-of-date bookmark/favourite

    a search engine that has an out-of-date listing for this site

    a mistyped address

    you have no access to this page

    The requested resource was not found.

    An error has occurred while processing your request.



Please try one of the following pages:



    Home Page



If difficulties persist, please contact the System Administrator of this site and report the error below.



Unknown column '5c8a403b64ffb' in 'where clause'

/home/servic97/iskramedical.eu/httpdocs/libraries/joomla/database/driver/mysqli.php:665

Call stack

# 	Function 	Location

1 	() 	JROOT/libraries/joomla/database/driver/mysqli.php:665

2 	JDatabaseDriverMysqli->execute() 	JROOT/libraries/joomla/database/driver.php:1695

3 	JDatabaseDriver->loadObjectList() 	JROOT/administrator/components/com_nicepage/models/sections.php:145

4 	NicepageModelsSections::getSectionsObject() 	JROOT/plugins/content/nicepage/nicepage.php:42

5 	PlgContentNicepage->onContentPrepare() 	 

6 	call_user_func_array() 	JROOT/libraries/joomla/event/event.php:70

7 	JEvent->update() 	JROOT/libraries/joomla/event/dispatcher.php:160

8 	JEventDispatcher->trigger() 	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:19

9 	DefaultLoadModules() 	 

10 	call_user_func_array() 	JROOT/components/com_jevents/views/default/abstract/abstract.php:160

11 	JEventsDefaultView->__call() 	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:10

12 	flatViewYear->loadModules() 	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:10

13 	FlatViewHelperHeader16() 	 

14 	call_user_func_array() 	JROOT/components/com_jevents/views/default/abstract/abstract.php:160

15 	JEventsDefaultView->__call() 	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:5

16 	flatViewYear->_header16() 	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:5

17 	FlatViewHelperHeader() 	 

18 	call_user_func_array() 	JROOT/components/com_jevents/views/default/abstract/abstract.php:160

19 	JEventsDefaultView->__call() 	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:4

20 	flatViewYear->_header() 	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:4

21 	include() 	JROOT/components/com_jevents/views/flat/year/tmpl/listevents.php:4

22 	include() 	JROOT/libraries/src/MVC/View/HtmlView.php:697

23 	Joomla\CMS\MVC\View\HtmlView->loadTemplate() 	JROOT/libraries/src/MVC/View/HtmlView.php:230

24 	Joomla\CMS\MVC\View\HtmlView->display() 	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92

25 	JEventsAbstractView->display() 	JROOT/components/com_jevents/controllers/year.php:80

26 	YearController->listevents() 	JROOT/libraries/src/MVC/Controller/BaseController.php:710

27 	Joomla\CMS\MVC\Controller\BaseController->execute() 	JROOT/components/com_jevents/jevents.php:299

28 	require_once() 	JROOT/libraries/src/Component/ComponentHelper.php:402

29 	Joomla\CMS\Component\ComponentHelper::executeComponent() 	JROOT/libraries/src/Component/ComponentHelper.php:377

30 	Joomla\CMS\Component\ComponentHelper::renderComponent() 	JROOT/libraries/src/Application/SiteApplication.php:194

31 	Joomla\CMS\Application\SiteApplication->dispatch() 	JROOT/libraries/src/Application/SiteApplication.php:233

32 	Joomla\CMS\Application\SiteApplication->doExecute() 	JROOT/libraries/src/Application/CMSApplication.php:196

33 	Joomla\CMS\Application\CMSApplication->execute() 	JROOT/index.php:49
matto_
·
5 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Yes you have right. I just installed a few days ago Nicepage pluging and it seem that this was incompatible.

Many thanks for help now is working

Matic
matto_
·
5 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
No problem, they could work around the issue if they just check for com_jevents or to run only on com_content.

Many thanks
Tony
tonyp
·
5 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post