Moving download via front error fails - [Fixed in 4.0.12]

[svherpen]

Hi Arno,
When I try to move an existing download to another category, via the frontend I get this error message:
Column "extern_file" cannot be null

However, the actual file itself is moved to the new directory/category. See picture front-error.png

Then obviously it goes wrong when trying to delete that same file, see picture delete-error.png

One comment I need to make here: I use 2 different user accounts, but those are both superusers.
And another quick test reveals that performing the same action with 1 user account also shows the error (....) cannot be null

Looking in the backend shows that the download is locked, see pic 3

Regards,
Sjaak

[Arno]

Hi,
this is again an error about wrong data field conversion and not a bug.
Please look in the _files table and check the field extern_file.
It should be defined like this, see pic.

You can also try this scenario on the server Testsite: https://jd40.jdownloads.org
And you will see that it works as expected.

Nearly all posted problems and error messages are the result from an incorrect update.
The reason are are always tables structures that do not correspond to the standard! And it is always the same 2-3 users who report this. It doesn't make sense for me to follow up on this every time because they are not really bugs.

I will therefore only process bug reports where it is clearly stated that the update was carried out completely new with at least version 4.0.11 (or newer).

In all other cases, I will try to help as much as I can to get the database tables back into the correct format. Within a limited time frame.

[svherpen]

Hi Arno,

I fully understand that you cannot spent to much time in trying to fix abnormalities. And I'm perfectly fine with that.

What I do not understand however is that this happens AFTER I've applied the SQL table structure that you provided me. Remember my problems with incorrect tables.
After the upgrade I dropped all jdownload tables and replaced them with the SQL set you sent me.

So I'm expecting these to be correct now, or is that a misunderstanding?

If you provide me with the basic set of tables in SQL format, I can verify again if alle my tables have the correct data fields and repair them where needed.
If these can be extracted from the zip installer I'm fine with that as well.

Sjaak

[Arno]

Hi Sjaak,
Please send me the exported JD tables you are currently working with again via e-mail. 

[Arno]

Hi,
I was probably able to solve your problem. I will test it a little more first. If it remains successful, I will release a new version tonight or tomorrow ? .

It would also eliminate almost all other DB error messages with 'cannot be NULL'.