'attribs' DB table column of 'flexicontent_fields' DB Table is not large enough to store large configurations

Hi all, sorry for my english!
I have a problem with a cascade fields.
I add to content group of field - (placement), that include cascade selects - Region and City.
regions saved ok, but cityes(1700 items) not save in Mysql database, while i change type of field "attribs" to "mediumtext" from "text".:
Now it works ok, but i want that field be as link to a page.

For example if user read an article with "region" field = REG_i he can link this field to a pages, which contain all articles(items) with field "region"=REG_i.
and if user read an article with "city" field = city_i he can link this field to a pages, which contain all articles(items) with field "city"=city_i.
In additional for it: how create a page, which contained all "regions" with(or whithout) alpha-filter that user can select "region" as he want, and create similar page for cities too?

I understanding that it make with creating a flexicontent category page with sensitive options, and link as Prefix text & suffix text. But how it make on practic - i do not understand :blush:

Hello

so 64 KBytes is not enough to save field's configuration
- accepted, will add the change to our installation/upgrade script,
as we do want to allow configuration to save properly, and 1700 row are not too long

another alternative for you could have been, to create a DB table and select your elements from there

thanks

what about another question - how can i make linkable field automaticly - 1700 pages for every city made hands - too hard

Hello

you can use 2 Database Tables
and configure the select fields to retrieve their options using an SQL query
(see popup description of the 'fields' parameter)

i dont understand how make automaticly links with sql

Now i make as prefix <a href="/regions/{{region##0##_value_}}">
And manually create a 90 menu items (flexi category pages) with locked filter field_region_id#value
it looks like http;;/mysite.com/regions/REG_i

Same operations for city: i manually create 1700 menu items for cityes with locked filter too

It is very hard.i say, however there is a way to make it by Flexi methods? or php code?

Basically how make a custom field linkable as a Tag or Category, without create every page manually?

Hello

ok. i misunderstood you, i thought you meant item form,
about viewing, you do it via Filters?
- why you do not create a single page and show the 2 or 3 fields that you need as filters ?

Sorry for my low knowledge about Flexi :dry:
I install on my site Flexi and now i have 1 alternative - learn it

I dont know - possible that i want in Flexi or not, whithout third-party components or plugins.

Now i make a menu item - Flexi Categories, with all categories of content, and give it alias "regions", then set Field Filter as custom field - my field regions.
Then i make a prefix for field "regions" <a href="/regions?filter_16={{field16##0##_value_}}">.
It works ok!

But there is a way to get more pretty links? Now it looks like /regions?filter_16=myregion,
but I want /regions/myregion
I write about cityes - there is 1700 cityes, and i missing some small sityes, so i want give a possibility add new city for user, who create content.

It possible with flexi+small PHP code (because my PHP very very weak) make that:
page "/regions" -> list of links to all regions
then page "regions/my_region" - -> list of all flexi items (news) with field "regions=my_region" + list of all city in my_ region (maybe as a module)
then page "regions/my_region/my_city" -> list of all flexi items (news) with field "city=my_city"

Then another question - it real or not - make subscribe for users for they choosen region (maybe with javascript Jquery cookies plugin or another)/
Some a little wider question - is it real make subscribe for custom field? Author, category, tag, custom fields - like my regions or city - that user (guest or registred) can subscribe for news with criteria as he want fully - by author, by category, by type... e.c.

If it real only in flexi - can you ask how it make or please ask moving direction,
if it real with some external JS code - please ask moving direction.

Hello

you can have "LOCKED" value for filters in category menu items


-- so to have links like:
regions/my_region/my_city

you need to create category menu items that will be in a tree structure (parent-child menu items in menu manager)

1. enable "Category Parameter override" in them !!
2. Enable locked filters parameter
3. Set the value of as following

regions/ should be a category(*) menu item without any filter
regions/my_city should be a category(*) (sub) menu item with locked filter city
regions/my_city/my_region should be a category(*) (sub) menu item with BOTH locked filter city and locked filter region

(*) it can also be multi-categories menu item