[SAC] [OSGeo] #2799: foss4g code sprint attendees unable to list projects in order to edit

OSGeoTrac · August 27, 2022, 3:08pm

#2799: foss4g code sprint attendees unable to list projects in order to edit
---------------------+-----------------------
Reporter: jive | Owner: vicky@…
Type: defect | Status: new
Priority: normal | Milestone: Unplanned
Component: WebSite | Keywords:
---------------------+-----------------------
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
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2799>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.

OSGeoTrac · August 27, 2022, 3:44pm

#2799: foss4g code sprint attendees unable to list projects in order to edit
---------------------+------------------------
Reporter: jive | Owner: vicky@…
Type: defect | Status: new
Priority: normal | Milestone: Unplanned
Component: WebSite | Resolution:
Keywords: |
---------------------+------------------------
Changes (by nickbearman):

* cc: Nickbearman (added)

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2799#comment:1>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.

OSGeoTrac · August 27, 2022, 5:53pm

#2799: foss4g code sprint attendees unable to list projects in order to edit
---------------------+------------------------
Reporter: jive | Owner: vicky@…
Type: defect | Status: new
Priority: normal | Milestone: Unplanned
Component: WebSite | Resolution:
Keywords: |
---------------------+------------------------
Comment (by robe):

That is taking a while. Still hasn't loaded for me.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2799#comment:2>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.

OSGeoTrac · August 27, 2022, 6:20pm

#2799: foss4g code sprint attendees unable to list projects in order to edit
---------------------+------------------------
Reporter: jive | Owner: vicky@…
Type: defect | Status: new
Priority: normal | Milestone: Unplanned
Component: WebSite | Resolution:
Keywords: |
---------------------+------------------------
Comment (by 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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2799#comment:3>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.

OSGeoTrac · August 27, 2022, 6:27pm

#2799: foss4g code sprint attendees unable to list projects in order to edit
---------------------+----------------------------------------
Reporter: jive | Owner: vicky@…
Type: defect | Status: new
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: WebSite | Resolution:
Keywords: |
---------------------+----------------------------------------
Changes (by robe):

* milestone: Unplanned => Sysadmin Contract 2022-II

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2799#comment:4>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.

jive · August 28, 2022, 5:56am

I helped people on Friday edit their pages.

···

–
Jody Garnett

OSGeoTrac · August 29, 2022, 7:59am

#2799: foss4g code sprint attendees unable to list projects in order to edit
---------------------+----------------------------------------
Reporter: jive | Owner: vicky@…
Type: defect | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: WebSite | Resolution: fixed
Keywords: |
---------------------+----------------------------------------
Changes (by robe):

* status: new => closed
* resolution: => fixed

Comment:

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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2799#comment:5>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.

OSGeoTrac · August 29, 2022, 9:40am

#2799: foss4g code sprint attendees unable to list projects in order to edit
---------------------+----------------------------------------
Reporter: jive | Owner: vicky@…
Type: defect | Status: reopened
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: WebSite | Resolution:
Keywords: |
---------------------+----------------------------------------
Changes (by Nick Bearman):

* status: closed => reopened
* resolution: fixed =>

Comment:

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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2799#comment:6>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.

OSGeoTrac · August 30, 2022, 8:52am

#2799: foss4g code sprint attendees unable to list projects in order to edit
---------------------+----------------------------------------
Reporter: jive | Owner: vicky@…
Type: defect | Status: reopened
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: WebSite | Resolution:
Keywords: |
---------------------+----------------------------------------
Comment (by 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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2799#comment:7>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.

OSGeoTrac · August 30, 2022, 1:56pm

#2799: foss4g code sprint attendees unable to list projects in order to edit
---------------------+----------------------------------------
Reporter: jive | Owner: vicky@…
Type: defect | Status: reopened
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: WebSite | Resolution:
Keywords: |
---------------------+----------------------------------------
Comment (by 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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2799#comment:8>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.

OSGeoTrac · October 4, 2022, 10:12pm

#2799: foss4g code sprint attendees unable to list projects in order to edit
---------------------+----------------------------------------
Reporter: jive | Owner: vicky@…
Type: defect | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2022-II
Component: WebSite | Resolution: fixed
Keywords: |
---------------------+----------------------------------------
Changes (by robe):

* status: reopened => closed
* resolution: => fixed

Comment:

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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2799#comment:9>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.