I want to change the Cardinality of a field which has existed values in drupal 8.
120766
I have two content types: Person and Office with existing content. The Person content type has an entity reference field to Office nodes, which only allows a single reference. I need to change this to allow an unlimited number of Office nodes to be selected.  Drupal 8 prevents changing the cardinality of the field, and it gives the following error message.     There is data for this field in the database. The field settings can no longer be changed.   At first, I thought I needed to write a migration, but they seem to be aimed at bringing data into a Drupal instance. Then, I read about writing  (also ).  I discovered a migrate-plus plugin that adds a couple pages me to export the field storage settings, change the cardinality, and re-import the settings. Given that I'm going from cardinality of 1 to unlimited, I could imagine this change wouldn't destroy data. And my empirical data suggests this is the case. I've now made this change via the migrate-plus screens as well as via configuration export and import and the data is still in the field.  Is this a safe operation, or should I write an update function?
89452
In Drupal 7 (i18n) there is a possibility to select an existing node as a translation of another node.  In Drupal 8, is there also that possibility?
30068
I have a content type that has a taxonomy field with two options. If Option A is selected, I want a further taxonomy field with items from Taxonomy X. If Option B is selected, I want another taxonomy field, but with items from Taxonomy Y.   In Drupal 6 I used , which was great. However, there exists no stable D7 version yet, and I need this functionality for a project due this week. The project page even says: "Drupal 7 version (3.x): 7.x-3.x is currently in development. It is a complete rewrite of the module that leverages the new entities system and the States API. Not ready for use on production sites yet." So I feel like I'd be really dumb if I put this on a production site and something broke, when the module project page itself specifically tells me not to.  The other option seems to be , but that's used on a total of 274 sites (compared to the ~18,000 of Conditional Fields).   Are there any other D7-compatible modules that allow forking of field display based on the value of another field? If not, how stable is Field Conditional State? Should I just suck it up and write a module that does what I'm wanting?   Many thanks.
11491
I know that in MySQL at the command line I can reset a table's auto-increment field to 1 with this:  ALTER TABLE tablename AUTO_INCREMENT = 1   I am curious if there is a way to do this from within phpMyAdmin.  Something like a check box to reset the auto-increment or something else along those lines?  Not that there is anything wrong with the command line approach.  More one of those curiosity things I keep thinking on...  Thanks in advance!
94232
When creating a new Column, the default value for the length of the name is 10. Using the Field Calculator via the Model Builder, I want to include the names of regional areas into the columns which has more than 10 characters.  Can the length of the Output Field Name be increased?
61417
create table T(ID int identity primary key) insert into T default values insert into T default values  go  select cast(ID as varchar(10)) as ID from T where ID = 1   The query above has a warning in the query plan.  &lt;Warnings&gt;   &lt;PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT(varchar(10),[xx].[dbo].[T].[ID],0)" /&gt; &lt;/Warnings&gt;   Why does it have the warning?  How could a cast in the field list affect the cardinality estimate?
17815
I need to change a field in a node without altering the 'changed' timestamp. I know this was possible in Drupal 7 using field_attach_update(), but that has been removed since then.  I could use an update query and change the field directly in the database, but I was wondering if there is a better way (or a replacement for field_attach_update()).
95683
I am working on a geodatabase. In some of my features, I would like to add a field, in which I will type the values on my own. On this field no duplicates must be allowed. In other words I want it to be a unique value field. I know ObjectID exists to certain uniqueness of the object, but I am working on a relational db and I want this field to be used as primary key.  I have tried adding a field and through access editing it as a "no duplicates allowed" field, but after that, I cannot edit in arcmap and the message "Warning: Unique index on non-OID field" appears.
79723
I need to hide field 'B' when the value in field 'A' is NOT equal to 'Other'.  This is a custom list form.  Is jquery the way to go?
111000
I need to change the Text format of the body field of 200 node of the "flats" content type.  I guess I can do it in the database but I don't know where to look.
105548
I make a new column in my attribute table and it has a default value (for example 0). I want to (probably using the field calculator) have the result that row 1 has the value 1, row 2=2 and so on, just like a numbered index.  I'd be thankful for a code example for the field calculator (including the use of $rownum (I think I need this for switching to the line)).
26011
I have 1 field collection  Field collection: CKT Info child2   machine name: field_ckt_info_child2  In that have 2 fields:  Field1: English CKT child2   machine name: field_eng  Field2: Maths CKT Child2   Machine name: field_maths_ckt_child2  I have set field setting "unlimited" to this field collection. Now I just want to add new field collection item in existing Field collection(CKT Info child2) programmatically. I have tried below code but it's not creating new field collection item.   function createFC()  {    $field_collection_item = entity_create('field_collection_item', array('field_name' =&gt; 'field_maths_ckt_child2'));    $field_collection_item-&gt;setHostEntity($node);    $field_collection_item-&gt;set('field_maths_ckt_child2', "SET SUCCESS");    $field_collection-&gt;save(); }
27677
Can we direct change it from sql database? if yes then how?  or  any other solution?
65259
Goal:  Add a database index to a 'created' field.  Given:  There is a custom entity with a base field created. The field is stored the entity table.  Field source code of the created field:  $fields['created'] = BaseFieldDefinition::create('created')   -&gt;setLabel(t('Created'))   -&gt;setDescription(t('The time that the entity was created.'))   -&gt;setDisplayOptions('view', [     'label' =&gt; 'hidden',     'type' =&gt; 'timestamp',     'weight' =&gt; 3,     'settings' =&gt; [       'date_format' =&gt; 'medium',       'custom_date_format' =&gt; '',       'timezone' =&gt; '',     ],   ])   -&gt;setDisplayConfigurable('view', TRUE);   What I researched:  I have not found a way to add index using the \Drupal\Core\Field\BaseFieldDefinition().  As I understand indexes are defined in a @FieldType plugin. The created field is implemented via the \Drupal\Core\Field\Plugin\Field\FieldType\TimestampItem() plugin and obviously does not have have indexes there.  P.S. I know, that I can write an updatescript to add an index to the table manually.
25332
I tried uploading non-English text to my Data Extensions but the system is throwing error named &quot;Invalid Field Count&quot;.
47324
Is there a way to alter the precision of an existing decimal column in Sql Server?
74093
I have 30+ fields in a field set, and in the update part of my trigger, I want to see if any of those fields have been changed. Can I access them using field sets?  Anyway to do it, short of writing out every field in my trigger?  I'm doing something similar to this: