Save error: "Field 'context' doesn't have a default value" Topic is solved

[pborga]

Sorry to intrude, but I think only you can help me!
When I try to use the additional fields and save this is what I get "Save failed with the following error: Field 'context' doesn't have a default value". Can you help me find out what I'm doing wrong?
Database version 10.6.17-MariaDB-cll-lve-log
PHP version 8.2.18
Joomla! version Joomla! 5.1.1-dev Development [ Kudumisha ] 16-April-2024 16:59 GMT

[toivo]

Welcome to the Joomla forum!

More information is required.

When I try to use the additional fields and save

Are those custom fields related to articles, categories or users?

Are you using the latest Nightly Build of Joomla 5.1.1-dev, built on 7 May, 2024?

Use phpMyAdmin from the cPanel provided by your host, or in your workstation, if this is a localhost site, browse the database table _fields, locate the title of the custom field in question in the column 'title' and check the contents of the column 'context'.

[pborga]

Good morning toivo! pborga Joomla! Fledgling has woken up and with the help of google translate I reply to your kind reply yesterday:
1. Additional fields for use with articles;
2. Joomla_5.1.1-dev-Development-Update_Package of ‎Tuesday ‎7 ‎May ‎2024, ‏‎05:27:04;
3. Currently the phpMyAdmin tables on Host.it: fields, fields_categories, fields_groups, fields_values ​​are completely empty.
Thanks for everything and have a nice day!!!

[toivo]

It is not clear if you are just trying to create a new custom field or if you are filling in a custom field while editing an article.

Did you install Joomla originally, did you download the first version from https://downloads.joomla.org or did you download the full development version?

[pborga]

Step by step I came from an initial installation of Joomla 3 and subsequently updated from https://developer.joomla.org/nightly-builds.html. I don't know what happened, but as I wrote the four fields tables are empty. Three days ago I uploaded Joomla_5.1.1-dev-Development-Full_Package with Filezilla.

[toivo]

Step by step I came from an initial installation of Joomla 3 and subsequently updated from https://developer.joomla.org/nightly-builds.html. I don't know what happened, but as I wrote the four fields tables are empty.

It sounds like one of Joomla updates may have failed along the way. Have you checked the update log administrator/logs/joomla_update.php?

Three days ago I uploaded Joomla_5.1.1-dev-Development-Full_Package with Filezilla.

If you uploaded the full Joomla 5.1.1-dev package on the top of an existing Joomla filesystem, rather than using the Joomla! Update or installing the full package in an otherwise empty folder and a new database schema, the results would be unpredictable.

[pborga]

My site https://www.pborga.it works perfectly for me, I just can't use the additional fields.
Anyway, many thanks!!!

[ceford]

In the #__fields and the #__fields_groups tables the context columns need to have the default value set to an empty string. You can use phpMyAdmin to find the tables and columns. Select Change and make sure the Default is set to As Defined and the defined value is empty.

[pborga]

Dear Ceford! I can't figure it out, I'm asking too much if you can send me the 4 tables: fields, fields_categories, fields_group and fields_values ​​with a single first line. Thanks in advance.
Pierantonio Borga - https://www.pborga.it

[ceford]

That won't help at all! Do you have phpMyAdmin? Have you used it to examine your database?

[pborga]

I can use phpmyadmin and I can see the database and its tables but I am not able to adjust the four fields tables.

[ceford]

In phpMyAdmin, the list of your tables should have Browse and Structure as the first two buttons in the row of buttons. For the #__fields table select the Structure button. That should give you a list of fields in the table. One of them is 'context' - over to the right select the Change button. Set the Default value as I described previously. If you can't do any of that please say exactly why and use screenshots if necessary.

[pborga]

The forum won't load the screenshot for me!

[ceford]

To post a screenshot use the Attachments button beneath the post data entry field.

Is your problem fixed?

[pborga]

I'm still at sea; not knowing the English language the problem is double! Thank you ...

[pborga]

If I try to attach a screenshot the "forum" responds like this!
Joomla forum is about Joomla CMS. Please do not link to non-Joomla websites as it can be considered spam and lead to a ban. Please avoid using AI to generate your answer, as our forum encourages authentic human interactions. Thanks for your cooperation!

[pborga]

https://www.pborga.it/images/Amici/1Joomla.jpg

[ceford]

https://www.pborga.it/images/Amici/1Joomla.jpg

This table structure is significantly different from the current nightly build! The Nightly Builds site does warn you that the builds are for testing only! You have missed out executing sql queries along the way and there is no knowing what other tables are not up to date. You could just delete the four empty #__fields... tables and use the queries in installation/sql/mysql/supports.sql from line 133 to line 230. The chances are you will meet more problems tomorrow, next week or next month.

You really need to be using the Joomla 5.1 Stable version. I recommend you install that locally on your laptop or
workstation and completely rebuild your site there using Joomla core components as far as possible.

[pborga]

Eureka ceford! I followed your advice: I reinstalled Joomla 5.1.0, deleted the four "fields" tables and learned a new function to reinstall them with phpmyadmin. Thanks so much and...

[pborga]

https://www.pborga.it/images/Amici/1Joomla.jpg

This table structure is significantly different from the current nightly build! The Nightly Builds site does warn you that the builds are for testing only! You have missed out executing sql queries along the way and there is no knowing what other tables are not up to date. You could just delete the four empty #__fields... tables and use the queries in installation/sql/mysql/supports.sql from line 133 to line 230. The chances are you will meet more problems tomorrow, next week or next month.

You really need to be using the Joomla 5.1 Stable version. I recommend you install that locally on your laptop or
workstation and completely rebuild your site there using Joomla core components as far as possible.

Eureka ceford! I followed your advice: I reinstalled Joomla 5.1.0, deleted the four "fields" tables and learned a new function to reinstall them with phpmyadmin. Thanks so much and...
Top

[pborga]

https://www.pborga.it/images/Amici/1Joomla.jpg

This table structure is significantly different from the current nightly build! The Nightly Builds site does warn you that the builds are for testing only! You have missed out executing sql queries along the way and there is no knowing what other tables are not up to date. You could just delete the four empty #__fields... tables and use the queries in installation/sql/mysql/supports.sql from line 133 to line 230. The chances are you will meet more problems tomorrow, next week or next month.

You really need to be using the Joomla 5.1 Stable version. I recommend you install that locally on your laptop or
workstation and completely rebuild your site there using Joomla core components as far as possible.

Many thanks for your help in solving the error and... see you next time!