foss4g code sprint attendees unable to list projects in order to edit

[jive]

When logged in to osgeo website:

1. ​https://www.osgeo.org/wp-admin/about.php
2. Click on Projects and then All Projects

​https://www.osgeo.org/wp-admin/edit.php?post_type=project

3. The page is taking so long to load that people give up

[robe]

That is taking a while. Still hasn't loaded for me.

[robe]

I took a look at this and I'm not seeing any database activity when clicking (or if there is it's pretty fast). Also not seeing anything happening in network console of my browser.

Jody, you know last time you visited this link when it worked. Want to rule out any wordpress patch updates. I checked on staging and it seems to work there. So probably hasn't been much time. Could also be a data issue it is being stuck on.

[robe]

Okay finally figured out the issue. Must have been a Yeost upgrade.

I saw gigabytes of errors in the apache logs showing - error Unknown column 'object_last_modified' in 'field list' for query UPDATE fVT6y_yoast_indexable

So I followed the suggestions here - ​https://wordpress.org/support/topic/unknown-column-object_published_at-in-field-list/ To install the Yeost Testing Helper and to run the

1) go to ​https://www.osgeo.org/wp-admin/tools.php?page=yoast-test-helper

2) Run "Reset Indexable tables and migrations"

and that seemed to fix the issue.

Sorry it was too late for the code sprint.

Feel free to reopen if you still see issues.

[Nick Bearman]

Thanks very much robe - that mostly fixes the issue and I can now open and edit the page. We did have a chat during the code sprint, so I now know the changes I need to make!

However I seem unable to add contributors.

I log in, go to Projects > All Projects > R-Spatial. Go to About tab, add nowosad to the Who's involved section.

When I click 'Update' I get this message:

There has been a critical error on this website. Please check your site admin email inbox for instructions.

Learn more about troubleshooting WordPress.

Everything else I seem to be able to do fine.

[Nick Bearman]

It appears people can add themselves as Who's involved, so we have gotten around this one. If this is expected behaviour, feel free to close the ticket.

[robe]

You getting an error is not expected behavior. People being able to add themselves is allowed.

I can't remember last time I tried to add a person in "Who's involved" though, so might have been broken for sometime. I'll check out later.

[robe]

Okay I just tried going to

Projects > All Projects > R-Spatial then going to About, adding a person to "Who's involved" and then updating.

Then removing the person I added, and then click "Update". Both seemed to work.

So whatever the issue is seems to be gone. Could be related to the issue we were having earlier with people not being able to log in - #2821

Feel free to reopen if it still happens to you.