Unknown column 'publish_down' in 'where clause'

[ByterBit]

Installed the newest version of jDownloads into a newly upgraded Joomla v3.10 to v4,  but ran into:

Unknown column 'publish_down' in 'where clause'
and
**Error installing **component****

This was my first upgrade. I'm a utter newbie here.
Any thoughts greatly appreciated.

[ColinM]

Hi
Looks like you are running with debug set on!
In the documentation there is an article specifically about upgrading from jD3.9  (on Joomla 3.10) to Joomla 4 and jD4.0.26
https://www.jdownloads.net/documentation/getting-started-v3-9/upgrading-from-jd3-9-to-jd4
Colin
PS I updated the article today

[mernst]

I have the same problem directly on joomla 4.
When I reinstalled the component it gave me the same message

I have debug turned off I guess it would be enough to add a column to the database table, I'll be glad if I don't have to look where.

Can you please advise me?

[ColinM]

Hi
Could you advise the versions of Joomla, of jD and PHP.

Assuming Joomla 4 please go to System - Global Configuration, the in System tab set Debug to Yes, next on the Server tab set Error
Reporting to Maximum.

Then run again the sequence that caused the problem. Usually you will get an error report of tyically 20 lines or so.  Copy those lines and the error report code into a reply.  Do not attach as an image,

Colin

[mernst]

php 8.1.26
joomla 4.4.1
jd 4.0.36

when I reinstall the component it says Unknown column 'publish_down' in 'where clause'
if I run this component it says:
An error occurred.
404 Component not found
Call stack
# Function Location
1 () JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:61
2 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361
3 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143
4 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186
5 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293
6 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61
7 require_once() JROOT/administrator/index.php:32

The error is apparently a missing column during reinstallation, but I don't know in which table

[ColinM]

Hi
Thanks for the error dump.
It says '404 Component not found' which seems that a component is missing!!
This  might be some other component than jDownloads
I will send you a Private Message (PM)
Colin