1054 Unknown column 'file_id' in 'field list'

[vodko-beer]

PHP Version 7.4.30
mysql 5.7.39
Joomla! 3.10.11
jDownloads 3.9.8.6


1054 Unknown column 'file_id' in 'field list'

Code Select Expand

Call stack
# Function Location
1 () JROOT\libraries\joomla\database\driver\mysqli.php:668
2 JDatabaseDriverMysqli->execute() JROOT\libraries\joomla\database\driver.php:1662
3 JDatabaseDriver->loadObject() JROOT\components\com_jcomments\plugins\com_jdownloads.plugin.php:23
4 jc_com_jdownloads->getObjectInfo() JROOT\components\com_jcomments\helpers\object.php:70
5 JCommentsObjectHelper::_call() JROOT\components\com_jcomments\helpers\object.php:98
6 JCommentsObjectHelper::_loadObjectInfo() JROOT\components\com_jcomments\helpers\object.php:124
7 JCommentsObjectHelper::fetchObjectInfo()
8 call_user_func_array() JROOT\libraries\src\Cache\Controller\CallbackController.php:173
9 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT\components\com_jcomments\helpers\object.php:159
10 JCommentsObjectHelper::getObjectInfo() JROOT\components\com_jcomments\helpers\object.php:46
11 JCommentsObjectHelper::getLink() JROOT\components\com_jcomments\classes\factory.php:255
12 JCommentsFactory::getTemplate() JROOT\components\com_jcomments\jcomments.php:200
13 JComments::show() JROOT\components\com_jcomments\jcomments.php:1323
14 JComments::showComments() JROOT\components\com_jdownloads\views\download\tmpl\default.php:1016
15 include() JROOT\libraries\src\MVC\View\HtmlView.php:701
16 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT\libraries\src\MVC\View\HtmlView.php:230
17 Joomla\CMS\MVC\View\HtmlView->display() JROOT\components\com_jdownloads\views\download\view.html.php:275
18 jdownloadsViewDownload->display() JROOT\libraries\src\MVC\Controller\BaseController.php:664
19 Joomla\CMS\MVC\Controller\BaseController->display() JROOT\components\com_jdownloads\controller.php:74
20 jdownloadsController->display() JROOT\libraries\src\MVC\Controller\BaseController.php:702
21 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT\components\com_jdownloads\jdownloads.php:43
22 require_once() JROOT\libraries\src\Component\ComponentHelper.php:402
23 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT\libraries\src\Component\ComponentHelper.php:377
24 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT\libraries\src\Application\SiteApplication.php:194
25 Joomla\CMS\Application\SiteApplication->dispatch() JROOT\libraries\src\Application\SiteApplication.php:233
26 Joomla\CMS\Application\SiteApplication->doExecute() JROOT\libraries\src\Application\CMSApplication.php:225
27 Joomla\CMS\Application\CMSApplication->execute() JROOT\index.php:49


1. This error is only on some downloads - the last 5-8
2. In the admin panel, the download (all) is not saved if you add tags to it

[Arno]

Hi,
Hello,
it seems that the JComments extension uses a database field identifier that no longer exists.
The field 'file_id' was used in jDownloads 3.2 but changed to 'id' with the jDownloads update to 3.9.

Maybe do you need this plugin?
https://www.jdownloads.com/index.php/downloads/download/18-special-extensions-jd3-9/59-jcoments-plugin-for-jd3-9.html

[vodko-beer]

Everything is cool! Thanks!

Still doesn't work: Loading in the administrative section is not saved if I add tags.

Error Failed to save due to an error:

[Arno]

In the admin panel, the download (all) is not saved if you add tags to it

Still doesn't work: Loading in the administrative section is not saved if I add tags.

I understand not really what you mean here. Please post pics.

[vodko-beer]

Step one: Add Tag
Step two: Save
Resume: Error Save failed with the following error:



jDownloads: Layouts: Category -> Standard Category Layout

Not supported {loadposition xxx} in Footer Area Layout