1054 Unknown column 'c.c.date' in 'order clause'

[btschmidt]

Got this error after install of upgrade 3.1.6 from 3.0.6

I assume a column is missing from #_phocadownload

But i'm not sure of the syntax to add it

any help would be appreciated

[btschmidt]

additional info:
Unknown column 'c.c.date' in 'order clause'

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/modules/mod_phocadownload_file/mod_phocadownload_file.php:118
4 include() JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/38/module/helper.php:68
5 JModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
6 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491
8 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783
9 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557
10 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044
11 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
12 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202
13 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49

[Jan]

Hi, which version of Phoca Dowload File module do you use?

Jan

[btschmidt]

Phoca Download File
Site Module 3.0.0