CUNY Graduate Center - Project Tracking System: Issueshttps://redmine.gc.cuny.edu/https://redmine.gc.cuny.edu/favicon.ico2024-03-08T17:41:09ZCUNY Graduate Center - Project Tracking System
Redmine CUNY Academic Commons - Bug #19928 (New): Forum Topic by Email Statshttps://redmine.gc.cuny.edu/issues/199282024-03-08T17:41:09ZRaymond Hoh
<p>Matt wanted to know the number of topics created by email vs. total number of topics.</p>
<p>Here are the stats:</p>
<p>2024 - 192/515 (so far)<br />2023 - 964/3260<br />2022 - 1058/3272<br />2021 - 1333/4010<br />2020 - 1284/4225<br />2019 - 801/2604<br />2018 - 405/2868<br />2017 - 104/1540<br />2016 - 116/1430<br />2015 - 65/1414<br />2014 - 12/1305</p> CUNY Academic Commons - Bug #19431 (New): cc'd people don't show up on Help tickets! https://redmine.gc.cuny.edu/issues/194312023-12-18T17:14:51ZMarilyn WeberMweber@gc.cuny.eduCUNY Academic Commons - Bug #16655 (New): Formatting on CETLS Events pagehttps://redmine.gc.cuny.edu/issues/166552022-08-24T17:47:40ZGina Cherry
<p>The formatting of my site's events page appears to have changed, even though I have not made any changes to it. Any idea what might have happened?</p>
<p><a class="external" href="https://cetls.bmcc.cuny.edu/events/">https://cetls.bmcc.cuny.edu/events/</a></p> CUNY Academic Commons - Bug #16307 (New): Add brief messaging to accept/decline group membership ...https://redmine.gc.cuny.edu/issues/163072022-06-27T22:13:20ZMatt Goldmattgold@gmail.com
<p>This is not a huge issue, but when I decline a group membership request, I usually like to write to the person who made the request to tell them why I had to decline. Currently, there is no way to do that other than going to the person's profile and sending a message through it. we might want to add a space for messaging to the decline action, so that people receive the decline notification along with a rationale. But maybe this is too small an edge case to be worth of development -- I'd guess this happens only a few times a year</p> CUNY Academic Commons - Bug #16255 (New): Need to define 'MULTISITE' constant in wp-config.phphttps://redmine.gc.cuny.edu/issues/162552022-06-18T01:19:20ZRaymond Hoh
<p>While debugging the WebAuthn plugin database prefix problem in <a class="issue tracker-1 status-5 priority-4 priority-default closed" title="Bug: Save Button missing on WordPress Profile page (Resolved)" href="https://redmine.gc.cuny.edu/issues/16245">#16245</a>, I found out that we have never set the following line in our <code>wp-config.php</code> file:</p>
<pre>
define( 'MULTISITE', true );
</pre>
<p>This explains why our main site's database tables are prefixed with <code>wp_1_</code> rather than just <code>wp_</code>. See <a class="external" href="https://github.com/WordPress/WordPress/blob/c70a5c547f187e3a8c58779ae18155874cb412df/wp-includes/wp-db.php#L1065-L1069">https://github.com/WordPress/WordPress/blob/c70a5c547f187e3a8c58779ae18155874cb412df/wp-includes/wp-db.php#L1065-L1069</a>.</p>
<p>I just did a SQL query to see how many DB tables are affected and this is the result:</p>
<pre>
mysql> show tables like 'wp\_1\_%';
+---------------------------------+
| wp_1_2fa_webauthn_credentials |
| wp_1_2fa_webauthn_users |
| wp_1_ak_twitter |
| wp_1_avhec_category_groups |
| wp_1_bdprss_errors_v3 |
| wp_1_bdprss_items_v3 |
| wp_1_bdprss_lists_v3 |
| wp_1_bdprss_sites_v3 |
| wp_1_cac_invites |
| wp_1_cac_library_items |
| wp_1_commentmeta |
| wp_1_comments |
| wp_1_contact_form_7 |
| wp_1_eo_events |
| wp_1_eo_venuemeta |
| wp_1_flickr_post |
| wp_1_links |
| wp_1_ngg_album |
| wp_1_ngg_gallery |
| wp_1_ngg_pictures |
| wp_1_now_reading |
| wp_1_now_reading_books2tags |
| wp_1_now_reading_meta |
| wp_1_now_reading_tags |
| wp_1_options |
| wp_1_podpress_statcounts |
| wp_1_podpress_stats |
| wp_1_pollsa |
| wp_1_pollsip |
| wp_1_pollsq |
| wp_1_postmeta |
| wp_1_posts |
| wp_1_quotescollection |
| wp_1_ratings |
| wp_1_redirection_404 |
| wp_1_redirection_groups |
| wp_1_redirection_items |
| wp_1_redirection_logs |
| wp_1_redirection_modules |
| wp_1_rg_form |
| wp_1_rg_form_meta |
| wp_1_rg_form_view |
| wp_1_rg_incomplete_submissions |
| wp_1_rg_lead |
| wp_1_rg_lead_detail |
| wp_1_rg_lead_detail_long |
| wp_1_rg_lead_meta |
| wp_1_rg_lead_notes |
| wp_1_subscribe2 |
| wp_1_term_relationships |
| wp_1_term_taxonomy |
| wp_1_termmeta |
| wp_1_terms |
| wp_1_wordtube |
| wp_1_wordtube_med2play |
| wp_1_wordtube_playlist |
| wp_1_wpo_campaign |
| wp_1_wpo_campaign_category |
| wp_1_wpo_campaign_feed |
| wp_1_wpo_campaign_post |
| wp_1_wpo_campaign_word |
| wp_1_wpo_log |
| wp_1_wysija_bounce |
| wp_1_wysija_campaign |
| wp_1_wysija_campaign_list |
| wp_1_wysija_custom_field |
| wp_1_wysija_email |
| wp_1_wysija_email_user_stat |
| wp_1_wysija_email_user_url |
| wp_1_wysija_form |
| wp_1_wysija_list |
| wp_1_wysija_queue |
| wp_1_wysija_url |
| wp_1_wysija_url_mail |
| wp_1_wysija_user |
| wp_1_wysija_user_field |
| wp_1_wysija_user_history |
| wp_1_wysija_user_list |
+---------------------------------+
78 rows in set (0.27 sec)
</pre>
<p>Most of these tables are for plugins we do not use on the main site anymore, so we can safely delete and ignore them. But before we add in the <code>define( 'MULTISITE', true )</code> line to <code>wp-config.php</code>, we'd have to copy the affected DB tables to use the <code>wp_</code> prefix first.</p>
<p>This is not really urgent to address (we've gone this long without the MULTISITE constant!), so we can look at this when Boone is back from vacation.</p> CUNY Academic Commons - Bug #16177 (New): Switch to Inbound mode for RBEhttps://redmine.gc.cuny.edu/issues/161772022-05-30T20:32:45ZRaymond Hoh
<p>For the reply-by-email plugin, we use IMAP mode, which relies on connecting to a GMail account to check for new replies and posting items to the Commons.</p>
<p>This isn't the best for performance because IMAP mode uses a long-running process to do the new email checks. RBE also has another mode called Inbound mode, which works on a per-email basis. This mode is already being used to create new forum topics with a custom, group email address (<code>GROUP@groups.commons.gc.cuny.edu</code>), but we haven't fully switched over to using Inbound for replies and private messages because IMAP was already in use.</p>
<p>Some things-to-do before switching:</p>
<p>1. Since we already have set up the <code>GROUP@groups.commons.gc.cuny.edu</code> email address for new forum topics, would it be okay to keep using this email domain for replies as well? (Regular reply email addresses would look something like <code>fb2da051ba2b7220193cca6ada@groups.commons.gc.cuny.edu</code>). The alternative is to set up another email address domain like <code>X@reply.commons.gc.cuny.edu</code>, but RBE hasn't been tested with two different email domains yet. Some background info here: <a class="external" href="https://redmine.gc.cuny.edu/issues/2880#note-24">https://redmine.gc.cuny.edu/issues/2880#note-24</a>. I'd say for now, we should keep using the same email domain unless anyone has any objections.</p>
<p>2. Once we switch to Inbound mode exclusively, replying to older items with the <code>cunyacademiccommons+IDENTIFIER@gmail.com</code> GMail address would no longer work. I was thinking we can set up an auto-replier in GMail, so if a new email matches the body of the RBE format, an auto-reply with the following message could be sent:</p>
<pre>
Hi,
You attempted to reply to our older reply-by-email address that is no longer in service. We have transitioned to a new email address.
If you would like to try emailing your reply with the new email address, please copy the IDENTIFIER portion of the "To" email address in the format of:
cunyacademiccommons+IDENTIFIER@gmail.com
to:
IDENTIFIER@groups.commons.gc.cuny.edu
And resend your previous email using this new email address.
You can always login to the CUNY Academic Commons to view your thread and make your reply there as well.
If you have any questions, please contact us at support@cunycommons.zendesk.com.
</pre> CUNY Academic Commons - Bug #14987 (New): Elementor update causes database freeze-uphttps://redmine.gc.cuny.edu/issues/149872021-11-23T21:19:15ZBoone Gorgesboone@gorg.es
<p>On Nov 9 and Nov 23, as part of regular maintenance updates, I tried updating Elementor from version 3.4.4 to the latest version (3.4.6 or 3.4.8). Both times, the Commons database was brought to a halt by an influx of database connections, within minutes.</p>
<p>See <a class="external" href="https://redmine.gc.cuny.edu/issues/14986">https://redmine.gc.cuny.edu/issues/14986</a>, <a class="external" href="https://redmine.gc.cuny.edu/issues/14951">https://redmine.gc.cuny.edu/issues/14951</a></p>
<p>Effective immediately, I won't be updating Elementor anymore during regular maintenance updates. Specifically, I will add it to the list of blocked plugins in my wp-cli-cac update tools. Ray, if you have your own version of these tools, please do the same.</p>
<p>The next time Elementor is updated to a new major version, say 3.5, I might consider trying the update again in isolation. I'll leave this ticket open for further investigation.</p> CUNY Academic Commons - Bug #13949 (New): Continued debugging of runaway MySQL connectionshttps://redmine.gc.cuny.edu/issues/139492021-02-07T00:47:10ZMatt Goldmattgold@gmail.com
<p>Hi Boone,</p>
<p>FYI -- there were MySQL restart alerts at 4:11pm today. I wanted to let you know in case you are better able to track info related to such outages following our recent conversations with Lihua</p> CUNY Academic Commons - Bug #13430 (New): Delay in RBEhttps://redmine.gc.cuny.edu/issues/134302020-10-06T12:27:23ZLuke Waltzerlwaltzer@gc.cuny.edu
<p>Have noticed that Reply By Email forum posts are taking a while to go through... here's one I sent this morning at 7:02 to the TLC Group that took over an hour to land: <a class="external" href="https://commons.gc.cuny.edu/?p=99426">https://commons.gc.cuny.edu/?p=99426</a>. Similar thing happened yesterday with <a class="external" href="https://commons.gc.cuny.edu/?p=99360">https://commons.gc.cuny.edu/?p=99360</a>.</p> CUNY Academic Commons - Bug #12438 (New): Site appearing twicehttps://redmine.gc.cuny.edu/issues/124382020-02-18T17:31:59ZLaurie Hurson
<p>Instructor's site is appearing twice, see screenshot. Looks like both URLs are the same so I am not sure what is causing the duplication.</p>
<p>Site is: <a class="external" href="https://introsocmonday.commons.gc.cuny.edu/">https://introsocmonday.commons.gc.cuny.edu/</a></p>
<p>When the instructor updates one, both sites update.</p>
<p>On an unrelated note - and apologies for asking here I didn't know if I should make a ticket about seeing another ticket... I am a watcher on ticket 12428 but when i search for it, I cannot find it or see that ticket. How can i get access to private ticket 12428?</p>
<p><img src="https://redmine.gc.cuny.edu/attachments/download/13734/double%20monday.png" alt="" /></p> CUNY Academic Commons - Bug #11879 (New): Hypothesis comments appearing on multiple, different pd...https://redmine.gc.cuny.edu/issues/118792019-09-19T16:36:30ZLaurie Hurson
<p>Hi All,</p>
<p>A professor has reported a very weird hypothesis issue. I am not sure if this is a Commons bug or hypothesis bug.</p>
<p>This professor uploaded a PDF (book chapters 5-7) for a course in 2017 link here: <a class="external" href="https://via.hypothes.is/https://spa114fall171.commons.gc.cuny.edu/wp-content/blogs.dir/3395/files/2017/09/La-Frontera-5-6-7.pdf">https://via.hypothes.is/https://spa114fall171.commons.gc.cuny.edu/wp-content/blogs.dir/3395/files/2017/09/La-Frontera-5-6-7.pdf</a></p>
<p>This semester, the professor will be using the same reading (only chapter 5) so she uploaded a shortened version to the media library for her new course: <a class="external" href="https://via.hypothes.is/https://span2204.commons.gc.cuny.edu/wp-content/blogs.dir/8302/files/2019/09/Chapter-5.pdf">https://via.hypothes.is/https://span2204.commons.gc.cuny.edu/wp-content/blogs.dir/8302/files/2019/09/Chapter-5.pdf</a></p>
<p>*to view the readings page on the Span2204 site the pw is Fall2019</p>
<p>The problem: the new chapter 5 pdf pulls in the old comments from the original chapters 5-7 pdf. The pdfs are on different commons sites in different media libraries. It appears that both pdfs are stored in WP-content blogs directory but seem to have different file numbers and names.</p>
<p>I dont think this is a plugin issue since she was using the via hypothesis link, not the plugin to add the annotation layer on these pdfs. Moreover, when I installed the plugin on the Span2204 site, the pdfs cannot be read because the via hypothesis link is added to the pdf url twice.</p> CUNY Academic Commons - Bug #10794 (New): Memcached connection occasionally breakshttps://redmine.gc.cuny.edu/issues/107942018-12-06T20:30:55ZBoone Gorgesboone@gorg.es
<p>A handful of times over the past month or so, the Memcached connection seems to have failed completely. This manifests first by extreme slowness in Commons load times. With Query Monitor enabled, I can then see that there are hundreds of database hits instead of the normal small handful. Occasionally, `wp cache flush` fixes it. But more often, I have to go in and switch from one to the other item in the $memcached_servers array. When I do this (and, importantly, run `wp cache flush` immediately afterward, to ensure that WP doesn't access stale cache in the other node) things come back to life immediately.</p>
<p>I don't really have the tools at my disposal to debug this fully. If the problem is that the cache is corrupted and thus inaccessible, I guess I would know that by looking at some sort of Memcached log <a class="external" href="https://serverfault.com/questions/422350/memcached-debuging-server-logs-monitor-the-memcached-servers">https://serverfault.com/questions/422350/memcached-debuging-server-logs-monitor-the-memcached-servers</a> and perhaps by examining the contents of the cache directly via Telnet. Or the problem could be a connection issue, though I'm unsure how to test that directly.</p>
<p>I don't know the proper next steps, but I'm starting this ticket so that the issue is on Ray's radar and so that we have a place to collect ideas and incident reports.</p> CUNY Academic Commons - Bug #9346 (New): Clone cetls.bmcc.cuny.edu for developmenthttps://redmine.gc.cuny.edu/issues/93462018-03-05T20:45:01ZOwen Roberts
<p>Hi there,</p>
<p>I'm working on some change to the BMCC CETLS site at cetls.bmcc.cuny.edu and it would be great to have a development clone available for testing, something at celtsdev.bmcc.cuny.edu if possible.</p>
<p>Thanks!</p>
<p>Owen</p> CUNY Academic Commons - Bug #8440 (New): Create Test Email Accounts for Onboarding Projecthttps://redmine.gc.cuny.edu/issues/84402017-07-26T11:05:46ZStephen Realsbrnlb@gmail.com
<p>This issue is intended to ensure that we don't forget to create a bunch (not sure how big a bunch is) of test email accounts that we can "invite" to join the commons when testing the upcoming revised Onboarding process.</p> CUNY Academic Commons - Bug #7928 (New): Duplicate Forum posthttps://redmine.gc.cuny.edu/issues/79282017-04-07T16:57:35ZLuke Waltzerlwaltzer@gc.cuny.edu
<p>posted through web form, posted twice: <a class="external" href="https://commons.gc.cuny.edu/groups/cac-community-team-project-planning/forum/topic/tomorrows-weekly-check-in/#post-54584">https://commons.gc.cuny.edu/groups/cac-community-team-project-planning/forum/topic/tomorrows-weekly-check-in/#post-54584</a></p>