News:

Support for jDownloads 3 has been ended
Since 17 August 2023 Joomla.org has discontinued support for Joomla 3.x. Therefore, we will no longer offer official support for our Joomla 3 jDownloads version 3.9.x from January 2024.
Please update your website to the latest Joomla version (Joomla 4 or Joomla 5) as soon as possible. Afterwards, please update jDownloads to the latest published version. The longer you delay, the more difficult the upgrade process for your website is likely to be.

Main Menu
Support-Forum

1054 Unknown column 'file_id' in 'field list'

Started by vodko-beer, 22.11.2022 20:21:47

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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' :-\


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
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!
  •  

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

QuoteIn the admin panel, the download (all) is not saved if you add tags to it
QuoteStill 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.
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!
  •  

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
  •