Error when submitting a file by a logged user - [Fixed in 4.0.14]

[Boyblan]

Hi,
I encounter an error when sending a file, asking me to fill in fields that are not displayed on the form and in the backend are not mandatory.

Save failed with the following error: HY000, 1364, Field 'metakey' doesn't have a default value.

[Arno]

Hi,
thanks for the posted problem.

I have found a mistake in the last hour that could also be the reason for your problem.

I will test it a little bit more. It is possible that I will send you a new version for testing later (by e-mail).
Or I will publish a new version directly in the forum. Please test it again with it then and post your result. Thank you.

[Boyblan]

Thank You, I am still waiting for your message.

Cordially

[Boyblan]

Hey,

I tested Jdowloads 4.012 but unfortunately the problem is still persistent.

Sincerely

[Arno]

Hi,
really? 

Which pre-beta version did you use to update from 3.9.8.5 to version 4?
And could you post a screenshot of your jdownloads_files table structure?
You find it in your phpmyadmin.

[Boyblan]

Hey,

Which pre-beta version did you use to update from 3.9.8.5 to version 4?

I used the com_jdownloads_pre_beta_4_0_4 version for a new joomla 4 installation, then I put it to 4.0.5 which I completely uninstalled with the database to install 4.0.6

And could you post a screenshot of your jdownloads_files table structure?
You find it in your phpmyadmin.

I copied it to excel to have an overview

thank you very much

[ColinM]

Hi,
Not sure that the 'Null' column supports Oui and Non!  Think you should use Yes and No

[Boyblan]

Hi,
submitting a file with Jdownloads 3.9 component works on my published site even if the Null field value is Non.
see the first 2 images

but in localhost the file submission fails with Jdownloads 4.0.12. with Null field value is Non.
See the 2 other images in localhost

the only difference is this field 'Adjust privileges', it is disabled and read only on the production site. while on the localhost site this field is checked (even if I uncheck it, it returns to its default value)


Thanks.

[Arno]

Hi,
could I get an akeeba backup from your test page with the error?

Please try this:
Open phpmyadmin and goto 'More' Tab and select 'Variables' submenu. Scroll down to find sql mode. Edit sql mode and remove 'STRICT_TRANS_TABLES' Save it.

[Boyblan]

Hello,
frankly I could not locate the field of which you had spoken to me if there is possibility of a screen capture please.

on the other hand, when I validate the form even with the "Metadata tab" (I fill in the "Meta Keywords" & "Meta Description" values), the form validation gives me an error page but the submitted file is saved in the backend

[Arno]

Hi,
see pic.

When this not should work, could I get an akeeba backup from your test page with the error?

Edit:
I had forget the pic. 

[Boyblan]

Hello,
I followed the steps described to me, but I didn't find this 'STRICT_TRANS_TABLES' mention.

[Arno]

Hi,
please install the new version 4.0.14 and try it again.

[Boyblan]

hey, After installing this version the "metakey" and "meta description" fields are set.

Thanks a lot.