Menu Items disappearing/being empty on save or post edit

I’ve been having this weird issue on a site for a few weeks now, tried everything I found by searching but still not being able to find a clue of the issue.

Whenever I add some items to the Menu (Appearance > Menus), a few items become empty. And then gets removed when I click the Save button again. Similarly, if I edit any posts, the same thing happens with the menu items.

Here’s what I’ve tried so far,

  1. Increased max_execution_time, max_input_vars, max_input_time, memory_limit, post_max_size, upload_max_filesize, max_file_uploads in PHP.ini. I set those to very high numbers but still no luck
  2. Then I tried copying the site to another hosting and on my localhost, but no luck. Did #1 on all the environments.
  3. Changed the theme to default 2021 and deactivated all plugins, still no luck
  4. Checked the database, wp_posts table has 4.6k rows with size of total 10.8MB, with overheads of about 300KB. So, I tried changing the storage engine of that table to innoDB from MyISAM but the problem is still happening.

Is there anyone who faced similar condition? What could be the issue?

Best UI pattern to group multiple uncategorised items (i.e. questions)

Problem: User has an ability to add x number of questions (uncategorized questions). Normally, user adds 2 – 5 questions. However, the problem is when the user add more than 10. The tricky part that I haven’t thought of how to implement is when they add 200 questions.

The current implementation was just to stack up together the questions so user can easily make some changes to all questions. However, if that is more than 10 question, user needs to scroll down which is tedious but still works. But with 200 questions, that’s like unlimited scrolling.

enter image description here

Some solutions I thought:

Pagination
This definitely is not a good solution. It’s confusing. I was thinking maybe there’s a good way to make use of pagination though so maybe you have some ideas.

Checkbox Table
I think this approach could be possible. The problem though is user can’t easily make some changes on the question. In addition, that means I would have another functionality of adding groups. There are possible workflow changes to suit this kind of approach but can’t think of any yet at the moment.

Note: The user can select the type of question he wants to add: multiple choice or essay-type.

I’m currently exploring on the best solution and to be honest, I haven’t really thought of any design approach to take yet. Would love to know our thoughts if you encountered something similar.

enter image description here

sharepoint online – What happen to items with unique permission, if we should to have their list inherit its permission from the site rather than having unique permission

I am reading this official link inside Microsoft docs @ https://docs.microsoft.com/en-us/sharepoint/what-is-permissions-inheritance.. and the link mentioned the following sentence:-

When a user shares or stops sharing an item that contains other items
with broken inheritance, a one-time push down of that permission
addition or removal is sent to all child items, even those with broken
inheritance

but based on my test if I have a list which has unique permissions and this list contain items with unique permissions also >> then if I chose that the list should inherit the permissions from its site rather than having unique permission >> then this action will not push down to the items.. where the items will still have unique permissions.. so is the above sentence wrong? or i am missing something?

sharepoint online – Power Automate filter by ‘Modified’ date and update returned items

I have what I thought was going to be a simple scenario to solve:

  • Multiple SharePoint Lists, each with 40 000+ items in it
  • Running queries based on different columns and export to Excel to provide MI
  • To keep lists up to date and to a minimum I need power automate to check the last modified date and update items that haven’t been modified for a month & Delete items that haven’t been modified for 3 months.

I’m using the HTTP Get connector with a simple filter applied as _api/Web/Lists/GetByTitle('@{outputs('querySettings')('listName')}')/Items?$select=@{outputs('querySettings')('fields')}&$filter=Modified lt 'formatDateTime(getPastTime(1, 'Month'), 'dd-MM-yyyy')'&$top=5000

Problem:

  • The Get method is incredibly slow when using Modified date
  • I tried all kinds of configurations, but whenever I try to filter for either the Created or Modified date, the HTTP GET part alone takes way over 15+ minutes (at which point I usually just cancel it)
  • Updating items takes even longer.

If I filter for a single text column for instance, I get the results back in 1 second (about 3000 items)

I can’t seem to understand why power automate takes soo long with a date??! What am I missing here?

Any help would be much appreciated!

sorting – Sort items so that parents are created before their children

I’ve been asked to create some code to help automate the loading of data into a system based on employee data in a spreadsheet. However, the data isn’t clean, so some people may have no manager, some may be their own manager, some have managers who already exist in the system, so aren’t included in the export, and others managers are somewhere in the export.

The below sort algorithm is to allow a sort of such dirty data, to ensure that where a dependency chain can be resolved it is and the items are returned in the appropriate order; but if the data’s bad, we’ll still be able to do as much good as possible.

Sharing it here as there may be a more efficient solution. I’ve seem similar solutions which build a tree then traverse it; but all those I’ve seen require clean data to function correct, and I can’t think of a way to amend them whilst keeping their efficiency.

Function Sort-ParentChild {
    (CmdletBinding())
    Param (
        (Parameter(Mandatory, ValueFromPipeline))
        (PSCustomObject())$ListItems
        ,
        (Parameter(Mandatory))
        (string)$ParentPropertyName
        ,
        (Parameter(Mandatory))
        (string)$CurrentPropertyName
    )
    Begin {
        (System.Collections.Generic.List(PSCustomObject))$Pending = (System.Collections.Generic.List(PSCustomObject))::new()
    }
    Process {
        foreach ($item in $ListItems) {
            # first return items which have no parent, or which are their own parent (since circular dependencies would otherwise never be resolved
            if (($null -eq $item."$ParentPropertyName") -or (($item."$CurrentPropertyName" -eq $item."$ParentPropertyName"))) {
                $item
            } else {
                $Pending.Add($item)
            }
        }
    }
    End {
        while ($Pending.Count) {
            $circularLoop = $true
            # return any items whose parents are not in the pending list (i.e. they already existed so weren't in the todo list, or we've returned them earlier in the process)
            for ($i = ($Pending.Count-1); $i -ge 0; $i--) { # work down, so that removing an item won't have any odd impacts
                if ($Pending($i)."$ParentPropertyName" -notin @($Pending | Select-Object -ExpandProperty $CurrentPropertyName)) {
                    $Pending($i)
                    $Pending.RemoveAt($i)
                    $circularLoop = $false # if we've found something to return, we're not in a loop yet
                }
            }
            if ($circularLoop) {
                # in case there are any circular dependencies, to avoid getting stuck, return a single item, then try to unravel in dependency order from there
                Write-Warning "Circular dependency found; breaking loop by returning $($Pending(0)."$CurrentPropertyName")"
                $Pending(0)
                $Pending.RemoveAt(0)
            }
        }
    }
}

Example Usage

$users = @(
    @{Id = 'Subordinate17';   ManagerId = 'MiddleManager1'}      
    @{Id = 'Subordinate15';   ManagerId = 'MiddleManager1'}   
    @{Id = 'Subordinate14';   ManagerId = 'MiddleManager3'}   
    @{Id = 'Subordinate13';   ManagerId = 'MiddleManager1'}   
    @{Id = 'TopDog';          ManagerId = $null}      # this person's the top dog; they don't have a manager
    @{Id = 'MiddleManager1';  ManagerId = 'BigBoss1'}
    @{Id = 'BigBoss1';        ManagerId = 'BigBoss1'} # Big Boss is their own boss
    @{Id = 'AmbassadorX';     ManagerId = 'PilotX'}        
    @{Id = 'MiddleManager2';  ManagerId = 'BigBoss1'}
    @{Id = 'PilotX';          ManagerId = 'InstructorX'}   
    @{Id = 'Subordinate17';   ManagerId = 'MiddleManager1'}      
    @{Id = 'MiddleManager3';  ManagerId = 'TopDog'}
    @{Id = 'Subordinate16';   ManagerId = 'MiddleManager3'}      
    @{Id = 'Mya';             ManagerId = 'PilotX'}         
    @{Id = 'Subordinate12';   ManagerId = 'MiddleManager2'}      
    @{Id = 'Subordinate11';   ManagerId = 'MiddleManager1'}      
    @{Id = 'InstructorX';     ManagerId = 'AmbassadorX'}
    @{Id = 'Subordinate10';   ManagerId = 'MiddleManager2'}   
    @{Id = 'Subordinate09';   ManagerId = 'MiddleManager2'}   
    @{Id = 'Subordinate08';   ManagerId = 'MiddleManager2'}   
    @{Id = 'Subordinate07';   ManagerId = 'MiddleManager2'}   
    @{Id = 'Subordinate06';   ManagerId = 'MiddleManager2'}   
    @{Id = 'Subordinate05';   ManagerId = 'TopDog'}   
    @{Id = 'Subordinate04';   ManagerId = 'BigBoss1'}   
    @{Id = 'Subordinate03';   ManagerId = 'MiddleManager3'}   
    @{Id = 'Shark';           ManagerId = $null}           # alone shark :S
    @{Id = 'Subordinate02';   ManagerId = 'MiddleManager3'}   
    @{Id = 'Subordinate01';   ManagerId = 'MiddleManager3'}
) | %{(pscustomobject)$_} #| Sort -Property @{E={(Guid)::NewGuid()}} # optional chaos sort, to avoid any chance of my data being in some helpful order before testing

$users | Sort-ParentChild -ParentPropertyName 'ManagerId' -CurrentPropertyName 'Id'
WARNING: Circular dependency found; breaking loop by returning AmbassadorX
Id             ManagerId     
--             ---------     
TopDog                       
BigBoss1       BigBoss1      
Shark                        
Subordinate04  BigBoss1      
Subordinate05  TopDog        
MiddleManager3 TopDog        
MiddleManager2 BigBoss1      
MiddleManager1 BigBoss1      
Subordinate13  MiddleManager1
Subordinate14  MiddleManager3
Subordinate15  MiddleManager1
Subordinate17  MiddleManager1
Subordinate01  MiddleManager3
Subordinate02  MiddleManager3
Subordinate03  MiddleManager3
Subordinate06  MiddleManager2
Subordinate07  MiddleManager2
Subordinate08  MiddleManager2
Subordinate09  MiddleManager2
Subordinate10  MiddleManager2
Subordinate11  MiddleManager1
Subordinate12  MiddleManager2
Subordinate16  MiddleManager3
Subordinate17  MiddleManager1
AmbassadorX    PilotX        
InstructorX    AmbassadorX   
PilotX         InstructorX   
Mya            PilotX  

dnd 5e – Does wearing magic items with armor affect AC negatively?

Thanks for contributing an answer to Role-playing Games Stack Exchange!

  • Please be sure to answer the question. Provide details and share your research!

But avoid

  • Asking for help, clarification, or responding to other answers.
  • Making statements based on opinion; back them up with references or personal experience.

Use MathJax to format equations. MathJax reference.

To learn more, see our tips on writing great answers.

magic items – VtM magical artifact

In a current “Vampire the masquerade” game, my character (settite) was offered 1 magical item of my choosing from a group of mages. As this is a very rare occurrence, I don’t wish to blow my chance at something good. (setting is current day Chicago)
Any suggestions would be helpful.

Thanks,
Benoni

Any way to do a draw from a filtered SharePoint list (multiple random items)?

I have a list in SharePoint online where I want to filter on several columns and then select a specific number of random items that meet the filter criteria. Is this possible?

For example, I may have 3000 items in my list, but I want to choose some from the ones who have Status = Approved and School = Central High School. After I filter on the Status and School columns, I may have 75 list items. From those items, I need to define the number to be selected (let’s say in this case it was 50), and I’d like SharePoint to do a random selection of 50 items (from the 75 who met the filter criteria, out of the 3000 in the list). Ideally, I’d then like to use Flow to change the Status value for those list items, to change them from Approved to Placed.

I have a list where I’ll need to make multiple draws, where there may be 7-10 fields used to filter the list first.

My first thought was to do something manually (filter the list items, then have a “DrawNumber” column where I could assign each item a sequential number, then use a standalone RNG to pull from those numbers before manually reconciling the SharePoint list items to the RNG selections), but it will be time-consuming, so if I can automate it I’d prefer that.

If needed, I could create a view for each permutation and build some kind of flow around that, but what I’d love to do is be able to dynamically filter my results in the browser, choose the number of items to be picked, apply my “picker”, and then apply a flow to those items.

Another alternative that wouldn’t be too bad would be to generate the set of numbers in a standalone RNG if I could somehow paste them in (or otherwise access them) for the DrawNumber column filter.

So I could go to https://numbergenerator.org/ and set it to pull 50 numbers between 1 and 75, and then open that set of numbers in Excel:

Set of random numbers

But then, in my SharePoint list, the only way I see to choose the filter values is to click on each individual box (this screenshot shows ID, but I’d want to use my DrawNumber column):

SharePoint filter pane

Even if I create a view and try to paste in the numbers for the filter value, it only seems to accept a single number at a time (not a set of comma or space-delimited numbers). If I enter “1 2”, I get an error telling me that’s not a number. If I enter “1,2”, like this…

filter criteria

… it removes the comma and treats it like “12”.

Any suggestions on how to streamline this process?

pathfinder 1e – Do multiple baldric, bane items stack?

No, 2 bane baldrics don’t give +10 to inquisitor level

For one thing, a baldric is a chest-slot item. You can’t wear two at the same time. Whether or not you could combine two into one item, or create a bane non-baldric, is entirely up to the GM, and per the guidelines would cost 50% extra.

Even assuming your GM does let you get around that (and in the general case, combining or moving item effects should be a relatively low-friction ask of the GM—even the 50% extra that Paizo recommends is far, far too much in most cases), it wouldn’t help because both bane baldric effects are the same source. Just like having resist energy cast on you twice doesn’t give you resistance 20, having two bane baldric effects aren’t going to stack.

Technically, strict-RAW would have some pause here simply because there are rules about (non-)stacking bonuses, and (non-)stacking spells, but the more general case of non-bonus benefits from things other than spells isn’t directly discussed. However, the absence of rules on the subject (either way) doesn’t inherently allow anything; it just means you need a ruling from the GM. And the only plausible ruling I can see a GM giving is one that’s consistent with all the things we do have rules for. After all, for all that rule says “spells,” it’s in the “Magic Overview” section. Anyway, that rule is

Same Effect More than Once in Different Strengths

In cases when two or more identical spells are operating in the same area or on the same target, but at different strengths, only the one with the highest strength applies.

In this case, they don’t have different strengths—they have exactly the same strength—but again, it’s implausible to expect any ruling that acknowledges this as a legitimate “loophole” in the rules and allows these to stacks.