By Igor on Saturday, 06 June 2020
Posted in Technical Issues
Likes 0
Views 1.5K
Votes 0
Good afternoon! Your component is great! But there was a problem and I can’t fix it:

The site (Joomla! 3.9.19) is installed jDownloads (3.2.68) and after installing Komento, when downloading a file I get - 1054 Unknown column 'id' in 'where clause'
/public_html/libraries/joomla/database/driver/mysql.php:357

the server responded with a status of 500 (Internal Server Error)

Call stack
# Function Location
1 () JROOT/libraries/joomla/database/driver/mysql.php:357
2 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1662
3 JDatabaseDriver->loadObject()
4 call_user_func_array() JROOT/administrator/components/com_komento/includes/database/database.php:180
5 KomentoDatabaseJoomla15->__call()
6 KomentoDatabaseJoomla30->loadObject()
7 call_user_func_array() JROOT/administrator/components/com_komento/includes/database/database.php:38
8 KomentoDatabase->__call() JROOT/administrator/components/com_komento/includes/sql/sql.php:76
9 KomentoDatabase->loadObject() JROOT/administrator/components/com_komento/includes/sql/sql.php:76
10 KomentoSql->__call() JROOT/components/com_komento/komento_plugins/com_jdownloads.php:46
11 KomentoSql->loadObject() JROOT/components/com_komento/komento_plugins/com_jdownloads.php:46
12 KomentoComjdownloads->load() JROOT/administrator/components/com_komento/includes/komento.php:1370
13 KT::commentify() JROOT/plugins/content/komento/komento.php:233
14 plgContentKomento->execute() JROOT/plugins/content/komento/komento.php:141
15 plgContentKomento->onContentAfterDisplay()
16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70
17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
18 JEventDispatcher->trigger() JROOT/components/com_jdownloads/views/download/view.html.php:223
19 jdownloadsViewDownload->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
20 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jdownloads/controller.php:92
21 jdownloadsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
22 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jdownloads/jdownloads.php:34
23 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
24 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
25 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
26 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
27 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
28 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49

Is this a component incompatibility? Is there any solution?

Regards!
Hello Igor,

Can you please provide us with the site and ftp access to the site and also provide us with the steps to replicate this issue so that we can test it on your site directly?
·
Saturday, 06 June 2020 13:16
·
0 Likes
·
0 Votes
·
0 Comments
·
Ok, update first post.
·
Sunday, 07 June 2020 03:40
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks Igor, we have updated the compatibility of JDownloads as it seems like they have renamed the "file_id" column to "id". Since you are running on 3.2, this is why it is throwing errors.

I have applied some fixes by adding backward compatibility for JDownloads on your site and it should work fine now. I will also add these fixes into our core.
·
Sunday, 07 June 2020 12:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Yes it works! Thank you so much!
·
Sunday, 07 June 2020 14:11
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Igor
·
Sunday, 07 June 2020 14:24
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post