CUNY Academic Commons

To add -- this also came in on the help desk last night

I'm working on a website that functions as a companion to a CUNY Teacher Education retreat. The website is https://citevisioning.commons.gc.cuny.edu

I've been making a series of updates over the past week that have disappeared and an older version has been restored. If it helps, I made a big push of updates on Thursday 9th Jan. I didn't have much luck finding version control options, and restoring an autosave didn't work either.

Laurie, can you please give specifics regarding your own experience so that we can narrow this down? You said:

I am also missing a significant amount of content that i added and edited on friday on the site here: https://tlcdevsite.commons.gc.cuny.edu/

To be clear, this means that you added content on Fri 2025-01-10, but you are not seeing it today, Mon 2025-01-13? Is there a specific piece of content you can point to? Do you have recollection of the specific time of day you added the content? When did you first notice it missing? Is content created before 2025-01-10 correct?

For the record, I don't know of any kind of reversion or other event that would have taken place in the last few days.

On Friday around 3-4pm on the home page of https://tlcdevsite.commons.gc.cuny.edu/ I added several blocks including a slider block, and edited the column block (as you see currently) to get rid the slider there and added <p> content and a button in the left column. Also during this time frame a deleted all blocks on the home page below "learn more about TLC" button.

Additionally on Friday at 11am I added 4 blogs posts to this site https://tlcassignments.commons.gc.cuny.edu/
all of which are missing now. The titles of the blog posts were (roughly):
*Pre-lab assignment for General Chemistry
*Group Dialogues
*Skimming: A reading assignment
*Building a Predictive Probabilistic Model

Thanks. Looking specifically at your sites because we have more control and info there:

1. tlcdevsite - site 35258

Here's the most recent content in the database for that site:

mysql> select ID, post_parent, post_type, post_name, post_status, post_date from wp_35258_posts order by post_date desc limit 10;
+------+-------------+---------------------+--------------------------------------+-------------+---------------------+
| ID   | post_parent | post_type           | post_name                            | post_status | post_date           |
+------+-------------+---------------------+--------------------------------------+-------------+---------------------+
| 4543 |           0 | post                |                                      | auto-draft  | 2025-01-13 10:47:29 |
| 4542 |           0 | customize_changeset | 09a1659d-38dc-4d67-a450-515f2b24fed1 | trash       | 2025-01-10 16:27:42 |
| 4390 |           0 | nav_menu_item       | 4390                                 | publish     | 2025-01-10 16:26:33 |
| 4392 |           0 | nav_menu_item       | 4392                                 | publish     | 2025-01-10 16:26:33 |
| 4541 |           0 | customize_changeset | beb10672-f191-4a9a-b2cd-631affb674c9 | trash       | 2025-01-10 16:26:33 |
| 4540 |          22 | revision            | 22-revision-v1                       | inherit     | 2025-01-10 15:50:37 |
| 4539 |          22 | revision            | 22-revision-v1                       | inherit     | 2025-01-10 15:49:23 |
| 4538 |          22 | revision            | 22-revision-v1                       | inherit     | 2025-01-10 15:48:48 |
| 4536 |          22 | revision            | 22-revision-v1                       | inherit     | 2025-01-10 15:48:21 |
| 4535 |           0 | customize_changeset | 2151b46b-ae77-443f-8b9c-10c2095c1053 | trash       | 2025-01-10 15:46:07 |
+------+-------------+---------------------+--------------------------------------+-------------+---------------------+
10 rows in set (0.01 sec)

You can see that some content is there from Fri 2025-01-10, as of about 4:27pm (timestamps are EST). The auto-draft from this morning is something you likely created in testing. Is there any way for you to confirm that your missing content was all created after this time? Trying to figure out if there's a specific point after which all content is missing, or whether it's more selective.

2. tlcassignments.commons.gc.cuny.edu 26466

Latest content:

mysql> select ID, post_parent, post_type, post_name, post_status, post_date from wp_26466_posts order by post_date desc limit 30;
+-----+-------------+------------+--------------------------------------------------------------------------------+-------------+---------------------+
| ID  | post_parent | post_type  | post_name                                                                      | post_status | post_date           |
+-----+-------------+------------+--------------------------------------------------------------------------------+-------------+---------------------+
| 647 |           0 | post       |                                                                                | auto-draft  | 2025-01-13 11:56:12 |
| 646 |         641 | revision   | 641-revision-v1                                                                | inherit     | 2025-01-10 13:13:34 |
| 645 |         641 | revision   | 641-revision-v1                                                                | inherit     | 2025-01-10 13:12:54 |
| 641 |           0 | post       | what-does-nycs-rising-waters-mean-for-us                                       | publish     | 2025-01-10 13:12:02 |
| 643 |         641 | revision   | 641-revision-v1                                                                | inherit     | 2025-01-10 13:12:02 |
| 642 |         641 | attachment | cuny-tv-sustainability-matters-assignment                                      | inherit     | 2025-01-10 13:09:11 |
| 640 |         632 | revision   | 632-revision-v1                                                                | inherit     | 2025-01-10 13:06:08 |
| 638 |         632 | revision   | 632-revision-v1                                                                | inherit     | 2025-01-10 13:04:22 |
| 636 |         632 | attachment | prob-and-statistics-project-remix-final-version-120525                         | inherit     | 2025-01-10 13:03:11 |
| 632 |           0 | post       | building-a-predictive-probabilistic-model                                      | publish     | 2025-01-10 12:59:20 |
| 635 |         632 | revision   | 632-revision-v1                                                                | inherit     | 2025-01-10 12:59:20 |
| 634 |         624 | revision   | 624-revision-v1                                                                | inherit     | 2025-01-10 12:56:29 |
| 633 |         627 | revision   | 627-revision-v1                                                                | inherit     | 2025-01-10 12:55:40 |
| 630 |         627 | revision   | 627-revision-v1                                                                | inherit     | 2025-01-10 12:50:09 |
| 627 |           0 | post       | skimming-reading                                                               | publish     | 2025-01-10 12:49:31 |
| 629 |         627 | revision   | 627-revision-v1                                                                | inherit     | 2025-01-10 12:49:31 |
| 628 |         627 | attachment | skimming-yom-topics-in-musicology-assignment                                   | inherit     | 2025-01-10 12:41:06 |
| 626 |         624 | revision   | 624-revision-v1                                                                | inherit     | 2025-01-10 12:04:01 |
| 624 |           0 | post       | group-dialogues                                                                | publish     | 2025-01-10 12:04:01 |
| 625 |         624 | attachment | group-dialogues-tabashshum-jahan-islam                                         | inherit     | 2025-01-10 12:01:55 |
| 621 |           0 | post       | colligative-properties-pre-lab-for-general-chemistry                           | publish     | 2025-01-10 11:57:22 |
| 623 |         621 | revision   | 621-revision-v1                                                                | inherit     | 2025-01-10 11:57:22 |
| 622 |         621 | attachment | beginners-pre-lab-assignment-in-general-chemistry-general-chemistry-laboratory | inherit     | 2025-01-10 11:49:46 |
| 620 |           0 | post       |                                                                                | auto-draft  | 2025-01-08 11:09:27 |
| 619 |         614 | revision   | 614-revision-v1                                                                | inherit     | 2024-12-18 13:52:37 |
| 617 |         614 | revision   | 614-revision-v1                                                                | inherit     | 2024-12-18 13:50:19 |
| 614 |           0 | post       | archiving-new-york-political-events                                            | publish     | 2024-12-18 13:50:19 |
| 616 |         614 | attachment | remixed-archive-exercise-pols1230-2                                            | inherit     | 2024-12-18 13:49:46 |
| 615 |         614 | attachment | remixed-archive-exercise-pols1230                                              | inherit     | 2024-12-18 13:49:14 |
| 613 |         605 | revision   | 605-autosave-v1                                                                | inherit     | 2024-12-18 13:29:25 |
+-----+-------------+------------+--------------------------------------------------------------------------------+-------------+---------------------+
30 rows in set (0.00 sec)

Looking at this, I see posts that have similar slugs to what you've mentioned. More details:

mysql> select ID, post_type, post_name, post_title, substr(post_content, 1, 100) as partial_post_content from wp_26466_posts where ID in (624, 627, 621, 632);
+-----+-----------+------------------------------------------------------+------------------------------------------------------+--------------------------------------------------------------------------------------------------------+
| ID  | post_type | post_name                                            | post_title                                           | partial_post_content                                                                                   |
+-----+-----------+------------------------------------------------------+------------------------------------------------------+--------------------------------------------------------------------------------------------------------+
| 621 | post      | colligative-properties-pre-lab-for-general-chemistry | Colligative Properties Pre-Lab for General Chemistry | <!-- wp:paragraph -->
<p>This assignment is meant to prime students understanding on Colligative Pro   |
| 624 | post      | group-dialogues                                      | Group Dialogues                                      | <!-- wp:paragraph -->
<p>Prior to class, based on readings and/or lecture materials, learners are as   |
| 627 | post      | skimming-reading                                     | Skimming: An In-class Reading Activity               | <!-- wp:paragraph -->
<p>For this in-class assignment, students skim several short articles and para   |
| 632 | post      | building-a-predictive-probabilistic-model            | Building a Predictive Probabilistic Model            | <!-- wp:paragraph -->
<p>This assignment’s objective is to build a probabilistic model to predict th   |
+-----+-----------+------------------------------------------------------+------------------------------------------------------+--------------------------------------------------------------------------------------------------------+
4 rows in set (0.00 sec)

Are these the missing items? For some reason, they have post_status = 'inherit', which is not really a valid status for 'post' items. I don't know how it would have happened, but it could be what's happening elsewhere. Before digging further, can you confirm?

Actually, no, they don't have post_status='inherit' - sorry, I was misreading. When I look at https://tlcassignments.commons.gc.cuny.edu/wp-admin/edit.php I see the posts in question in the list. Can you confirm whether you're seeing the same thing?

Boone Gorges wrote in #note-5:

Thanks. Looking specifically at your sites because we have more control and info there:

1. tlcdevsite - site 35258

You can see that some content is there from Fri 2025-01-10, as of about 4:27pm (timestamps are EST). The auto-draft from this morning is something you likely created in testing. Is there any way for you to confirm that your missing content was all created after this time? Trying to figure out if there's a specific point after which all content is missing, or whether it's more selective.

Not sure about this -- The revisions I was doing on this site were on pages created before friday 1/10 and so I was only revising previously created pages. It seems that the revisions made around ~3:48 are what's missing - that would be when I added a full width slider etc. which is now its missing and page appears as it did before the revisions (with slider in column instead of full width) (..related to below, those edits on the page at ~3:48 have the inhereit tag too)

2. tlcassignments.commons.gc.cuny.edu 26466

Are these the missing items? For some reason, they have post_status = 'inherit', which is not really a valid status for 'post' items. I don't know how it would have happened, but it could be what's happening elsewhere. Before digging further, can you confirm?

Yes these are the posts that are missing on the site.

Okay yes i see everything corrected now. tlcdevsite and tlcassignments are back to how they were on friday. something really weird seems to be going on? All my changes on TLCdev are back to how they were on friday and everything is back on TLCassignemnts

One thing I did is to clear the object cache. We occasionally have issues on the Commons where it gets out of sync, in which case you might experience problems like what you saw here. Usually it's not so wholesale. Given that we're moving in a few days, my inclination is not to spend any more time investigating it. Could you follow up with reporters to see if things seem fixed on their end as well?

Thanks for the update and clearing the object cache - very weird but glad we are moving !

I can follow up with users to ask if they also are seeing the missing content again.

I have heard from one of the users who had contacted the help desk over the weekend. The object cache clearing fix has restored their missing content as well. They are very grateful. Thank you!!

Still waiting to hear from the other group.