6 years ago
Topic

I didnt build this site and have never used Seblod before so apologies for ignorance, hoping someone can help me solve this issue.

I have a website with this page https://www.bidefordarchive.org.uk/search-newspapers and a large amount of data "headings" they are just  repeated Fields which is up to 138 now, i have just added about 100 and all was going well until i found that it now wont save anymore, (I can remove one and add another so it is definitely a limit i have come across) i have about 75 more to add - can anyone please tell me how to remove this limit?

Many thanks

Get a VIP membership
4229 Posts
Kadministrator
6 years ago
1
Level 1

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?

6 years ago
0
Level 2

Thanks Klas for looking at this.

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

6 years ago
18
Level 1

Anyone able to assist please?

1283 Posts
Bucklash
6 years ago
17
Level 2

Hi

So how many characters

a) Can be stored in the database

 can be stored in the database?

b) have you stored so far?

6 years ago
16
Level 3

sorry how can I check this?

1283 Posts
Bucklash
6 years ago
15
Level 4

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
So you need to check your fieldd storage which you will see at the bottom.
It is probably/
Standard | Article | some_field 
You can now click a chevron to see the storage format, probably:
varchar255.
Compare 255 to the amount of data you are storing, if too small, increase it. Can do that in Seblod or in db itself using phpMyAdmin or similar.....

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

6 years ago
14
Level 5

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

1283 Posts
Bucklash
6 years ago
13
Level 6

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.

6 years ago
12
Level 7

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

1283 Posts
Bucklash
6 years ago
11
Level 8

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.

 

6 years ago
10
Level 9

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?

1283 Posts
Bucklash
6 years ago
9
Level 10

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 :)

6 years ago
8
Level 11

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

my email is richard at gingerweb.co.uk

4229 Posts
Kadministrator
6 years ago
7
Level 12

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?

6 years ago
6
Level 13

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

4229 Posts
Kadministrator
6 years ago
5
Level 14

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.

6 years ago
4
Level 15

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.

4229 Posts
Kadministrator
6 years ago
3
Level 16

Click on Structure above, then edit on the options column

6 years ago
2
Level 17

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 

4229 Posts
Kadministrator
6 years ago
1
Level 18

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.

6 years ago
0
Level 19

it was php indeed thanks for sticking with me on this, all sorted now.

Get a Book for SEBLOD