you obviously hit some database limit, but you will need to be more specific if were to help you. Are you adding new values to dropdown or are you using fieldX (where repeated fields makes sense) or what exactly are you trying to do?

Thanks Klas for looking at this.

Maybe this short video will help explain : https://cl.ly/3D1Q3L1e1T2A 

Anyone able to assist please?

Hi

So how many characters

a) Can be stored in the database

 can be stored in the database?

b) have you stored so far?

sorry how can I check this?

Hi

You need to get your head round Seblod storage.

each field has storage options.

Content types based on the article object can be stored in:

1. #__content (Joomla table)
2. #__cck_store_item_content (fields available to all content types based on article object)
3. #__cck_store_form_[content_type_here] (fields available only for that content type

You need to look at the correct table to see the correct field

Thanks that makes sense but it looks a little different on my setup

https://cl.ly/0k1m0818291C

If i tick the "alter" box i get some options which include varcher (options in brackets) - want to make sure i dont break anything so greatful for advice.

the field it is populating is the top heading (select an option) on this page https://www.bidefordarchive.org.uk/search-newspapers

You have you field storing in a ‘free’ table... is it a custom table or an error?..  sounds a bit dodgy to me :)

Are all the fields stored ‘Free’?

Is the content type ‘Free’?

Either way, click ‘Alter’, see what it says, increase the value if you need to.

You might need to change the value to a custom value as the value is not in the dropdown list, in that case you need to alter the db field directly in phpmyadmin.

thanks for trying with me, i havent a clue what im doing to be honest, this short video might help to show that i tried what you suggested but still cant save any more Options

https://cl.ly/15071b3D2T3l

Is there anything else i can try please?

thanks

Can you add any other fields to the form?

If not then it could be max_input_vars:

https://www.seblod.com/resources/tutorials/max-input-vars-quick-example

https://www.seblod.com/resources/tutorials/max-input-vars-quick-example-2

Note: I had no joy with example 2.

ok thanks for that

example 1 gave a site server error, the site wouldnt work at all.

example 2 made no difference

It has been suggested to me that i could possibly split the field into 2 with A-O on one and P-Z on another to see if that works, i have never used SEBLOD at all so wouldnt have a clue where to start with this, is it a simple process or can you explain what would be required please?

When new to Seblod things be tricky.

I can have look a look while do a Facetime call if hav convenient time otherwise would be tricky to help you.

Guru Klas probably has the answer anyway :)

Thanks for the offer that would be great, perhaps a teamviewer connection if you wouldnt mind?

my email is richard at gingerweb.co.uk

For the start answer my question:

Are you adding new values to dropdown or are you using fieldX (where repeated fields makes sense) or what exactly are you trying to do?

I am trying to add more headings and they wont save this screen recording shows what i am trying to do, they have been saving fine until i got to 138 of them and now further headings wont save.

https://cl.ly/3D1Q3L1e1T2A

So you are trying to add new options to select simple. Options are saved in options (or options2 for some fields, but not select simple by default) column in #__cck_core_fields table.which is normally set to mediumtext, you can change this to longtext https://stackoverflow.com/questions/13932750/tinytext-text-mediumtext-and-longtext-maximum-storage-sizes

Storage settings Bucklash mentioned affect storage of actual data while you are having a problem with the field itself.

ok might be getting somewhere but restricted by my phpadmin abilities!

this screenshot https://cl.ly/1A0u2f1O2e0E shows an error (it is very faint as i wasnt quick enough)

Can you please explain (as though to a 6 year old!) how to change to lontext and which table to change?

thanks again.

Click on Structure above, then edit on the options column

OK both of them were on TEXT i have changed them as in the screenshot below to LONGTEXT but it hasnt made any difference i still cannot add anymore options.

https://cl.ly/2g283r1f0f46 

Then your limitation is somewhere else - most likely in php settings, e-g- max_input_vars and post_max_size. Check System information -> Php Information tab for current settings and increase them, your hosting provider should be able to tell you how to do that.