jDownloads Support Forum

jDownloads for Joomla 4.x and 5.x => jDownloads 4.0 => Bugs! => Topic started by: Boby on 06.12.2022 20:23:40

Title: [4.0.5]: Column 'publish_down' cannot be null - [Solved]
Post by: Boby on 06.12.2022 20:23:40
When editing an existing download, I get this error message when I save the download.
If I add e.g. 31.12.2999 in the field "End date", I can save the download without problems.

When I look at the database, the field publish_down in the table _jdownload_files is defined as NOT NULL.

jDownloads version: 4.0.5
Title: Re: [4.0.5]: Column 'publish_down' cannot be null
Post by: Boby on 06.12.2022 20:28:44
Addition: After successfully saving the download as described, the fields url_download and previer_filename were empty too. Had to add them via the database again to get them back.
Title: Re: [4.0.5]: Column 'publish_down' cannot be null
Post by: ColinM on 07.12.2022 11:00:28
Hi
Because of the database 'corrections' jD beta 4.0.5 needed to be a complete fresh install.  That is the previous beta needs to be uninstalled, especially the database.  Then Install 4.0.5

Colin
Title: Re: [4.0.5]: Column 'publish_down' cannot be null
Post by: Boby on 07.12.2022 13:44:11
Hi Colin, how's the procedure to not lose all data stored in the jdownloads tables?

Thanks,
Boby
Title: Re: [4.0.5]: Column 'publish_down' cannot be null
Post by: ColinM on 07.12.2022 16:01:12
Boby
Really do not have a tested procedure at this time but you could make a copy of the database before deleting the 'running one'.

I usually have my categories and downloads stored in a set of 'matching' folders so I then upload them with the control panel so they get created again AOK.  But a lot of the settings need to be reset as you require.  The Export of the jD settings is not fully tested but you could try that and see if you can import.

Basically at this juncture it is painful and tiresome!!!!  But we believe this is the last time that such a move is required. 
Of course do an Akeeba first just in case.

Colin
Title: Re: [4.0.5]: Column 'publish_down' cannot be null
Post by: Boby on 08.12.2022 08:51:31
Hi Colin,
I managed it now. My process was:
1) Rename jdownloads tables (to have a backup in the DB)
2) I uninstalled jDownloads (including deletion of tables, but keeping the files and previews)
3) I installed 4.0.5 from the scratch
4) I moved the data from my backup tables to the new tables (INSERT INTO ... SELECT FROM); minor changes were necessary (e.g. the field tags were removed in the new version)

Now everything seems to work fine!
Thanks for your support!