[4.0.5]: Column 'publish_down' cannot be null - [Solved]

[Boby]

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

[Boby]

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.

[ColinM]

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

[Boby]

Hi Colin, how's the procedure to not lose all data stored in the jdownloads tables?

Thanks,
Boby

[ColinM]

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

[Boby]

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!