jDownloads Support Forum

jDownloads for Joomla 4.x and 5.x => jDownloads 4.0 => General => Topic started by: ByterBit on 02.12.2023 23:53:04

Title: Unknown column 'publish_down' in 'where clause'
Post by: ByterBit on 02.12.2023 23:53:04
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.
Title: Re: Unknown column 'publish_down' in 'where clause'
Post by: ColinM on 04.12.2023 22:53:35
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
Title: Re: Unknown column 'publish_down' in 'where clause'
Post by: mernst on 10.12.2023 11:51:06
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?
Title: Re: Unknown column 'publish_down' in 'where clause'
Post by: ColinM on 12.12.2023 17:01:33
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
Title: Re: Unknown column 'publish_down' in 'where clause'
Post by: mernst on 12.12.2023 22:30:11
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

Title: Re: Unknown column 'publish_down' in 'where clause'
Post by: ColinM on 13.12.2023 15:49:52
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