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 #19204 (Resolved): Github 'cac' repo access rightshttps://redmine.gc.cuny.edu/issues/192042023-11-03T18:51:46ZRaymond Hoh
<p>I'm about to push a fix for <a class="issue tracker-2 status-5 priority-4 priority-default closed" title="Feature: New AI Assistant? (Resolved)" href="https://redmine.gc.cuny.edu/issues/19192">#19192</a>, but it seems like my access to <code>cuny-academic-commons/cac/</code> Github repo has been removed.</p>
<p>Boone, can you check my permission access to the <code>cac</code> Github repo?</p> CUNY Academic Commons - System Upgrade #19144 (Resolved): Set 'bp-nelo' as template in developer ...https://redmine.gc.cuny.edu/issues/191442023-10-30T22:37:07ZRaymond Hoh
<p>This is just a message for Boone and Jeremy.</p>
<p>If you are running the latest version of <code>2.2.x</code> branch in your development environment, please make sure to set your <code>'template'</code> option to <code>'bp-nelo'</code>. Can do so with WP-CLI:</p>
<pre>
wp option update template bp-nelo
</pre>
<p>Previously, <code>'bp-nelo'</code> was a child theme of the <code>'bp-default'</code> theme, but in <code>2.2.x</code>, bp-nelo is now its own theme, so the template is now <code>'bp-nelo'</code>. I previously enforced the <code>'template'</code> option to <code>'bp-nelo'</code> with a filter, but that filter is now removed as of <a class="external" href="https://github.com/cuny-academic-commons/cac/commit/2582798911a1e990c07fe7194132438c08b696ee">https://github.com/cuny-academic-commons/cac/commit/2582798911a1e990c07fe7194132438c08b696ee</a> .</p>
<p>So this is a just a FYI.</p> CUNY Academic Commons - Bug #18235 (Hold): Lots of failed Cavalcade tasks as of 2023-05-13https://redmine.gc.cuny.edu/issues/182352023-05-16T16:22:18ZRaymond Hoh
<p>Was just checking the failed Cavalcade tasks log and noticed something peculiar. As of 2023-05-13 17:33:05 GMT and on, we've had a consistent stream of failed tasks.</p>
<p>Run the following MySQL query to view all results:</p>
<pre>
select * from wp_cavalcade_jobs where timestamp > '2023-05-13 17:32:00' and status = 'failed' order by id desc;
</pre>
<p>As the time of posting, the total number of failed jobs since about three days ago is greater than 15,000. Usually, the number is only a couple failed tasks a day.</p>
<p>I haven't done any further investigation yet, but just wanted to post this issue for now.</p> CUNY Academic Commons - Support #18128 (Resolved): Question about Jetpack on news.commons.gc.cuny...https://redmine.gc.cuny.edu/issues/181282023-04-27T17:04:08ZRaymond Hoh
<p>I was looking at our Cavalcade logs for failed scheduled tasks and most of the recent, failed tasks come from the Jetpack plugin on <code>news.commons.gc.cuny.edu</code>. In an attempt to fix this, I have reset all Jetpack options on <code>news.commons.gc.cuny.edu</code>.</p>
<p>I'm adding Scott and Colin as watchers to this ticket. Do we use Jetpack extensively on <code>news.commons.gc.cuny.edu</code>? If so, can either one of you re-enable and reconfigure the Jetpack modules that were being used on the site? Here's a direct link to the Jetpack modules page: <a class="external" href="https://news.commons.gc.cuny.edu/wp-admin/admin.php?page=jetpack_modules">https://news.commons.gc.cuny.edu/wp-admin/admin.php?page=jetpack_modules</a> .</p>
<p>If Jetpack is not vital for <code>news.commons.gc.cuny.edu</code>, it maybe worthwhile to disable the Jetpack plugin entirely.</p> CUNY Academic Commons - Bug #16351 (Resolved): No new Redmine emails since Sunday?https://redmine.gc.cuny.edu/issues/163512022-07-12T04:27:42ZRaymond Hoh
<p>Has anyone received any new emails from Redmine since the new Redmine update was deployed during the maintenance window on Sunday?</p>
<p>I just manually checked Redmine to find some new comments, but I did not receive the emails to those comments like I usually do.</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 #16176 (Resolved): Set up app password for GMail IMAP accounthttps://redmine.gc.cuny.edu/issues/161762022-05-30T19:27:53ZRaymond Hoh
<p>GMail is pushing for OAuth authentication for less secure, 3rd-party apps by the end of month. So for apps relying on the GMail password like our GMail IMAP account, we will need to set up 2FA and then set up an App Password for use solely with RBE.</p>
<p>Instructions can be found here:<br /><a class="external" href="https://support.google.com/accounts/answer/185833?hl=en#app-passwords">https://support.google.com/accounts/answer/185833?hl=en#app-passwords</a></p>
<p>Boone, I believe the original <code>cunyacademiccommons</code> GMail address was set up by you. Can you set up 2FA and then set up an app password for use with the Commons? Then, can you pass on the app password to me? If you're going to use TOTP for the 2FA, perhaps you can also pass the TOTP secret key to me. This isn't necessary, but will help if another person needs to access the GMail account. If you're using Android, <a href="https://getaegis.app/" class="external">Aegis Authenticator</a> works well, but similar apps would also work.</p>
<p>We should probably transition away from IMAP mode for RBE and switch to Inbound mode. I'll create another issue just for this.</p> CUNY Academic Commons - Bug #14908 (Resolved): Stale object cache on cdevhttps://redmine.gc.cuny.edu/issues/149082021-10-27T20:19:24ZRaymond Hoh
<p>This is a note for Boone that I've experienced some weird instances on cdev with stale object cache.</p>
<p>I noticed this in the admin area yesterday because the BuddyPress update routine kept running on each page load. The value for <code>bp_get_option( '_bp_db_version' )</code> kept returning the version before BuddyPress v8.0 (12385), whereas the version in the DB was the latest one (12850). <a href="https://github.com/buddypress/buddypress/blob/3922b761777c194fa0b05898b9dd636a5928d09b/src/bp-core/bp-core-update.php#L623" class="external">As a result</a>, the BP emails kept on installing on each admin page load. See <a class="external" href="https://commons.gc.cuny.edu/wp-admin/edit.php?post_status=trash&post_type=bp-email">https://commons.gc.cuny.edu/wp-admin/edit.php?post_status=trash&post_type=bp-email</a> where I've cleaned up all instances this has occurred.</p>
<p>Deleting the options object cache fixed this -- <code>wp_cache_delete( 'alloptions', 'options' )</code>.</p>
<p>This also fixed an issue just now where the homepage was throwing a fatal error because the CAC Home Creation plugin was not activated because the object cache was referencing the older '<code>active_plugins</code>' option.</p>
<p>Has something changed to our memcached set up that might explain the stale object cache?</p> CUNY Academic Commons - Bug #14496 (New): Mapped domain SSO uses third-party cookieshttps://redmine.gc.cuny.edu/issues/144962021-05-24T20:03:23ZRaymond Hoh
<p>Currently, our mapped domain plugin, Mercator, uses third-party cookies in order to automatically sign-on logged-in Commons users to mapped domains.</p>
<p>The problem with this is third-party cookies are increasingly being blocked by default and there are plans in Chrome to scrap third-party cookies entirely <a href="https://blog.chromium.org/2020/01/building-more-private-web-path-towards.html" class="external">in the next few years</a>.</p>
<p>This ticket is to track what we should do.</p>
<p>Some approaches include:</p>
<p>- Redirecting logged-in users to the Commons subdomain instead of the mapped domain<br />- Remove SSO entirely. Meaning that users will have to login again on the mapped domain even if they are already logged into the Commons.<br />- Find another sign-on approach that doesn't use third-party cookies. Could rely on a set of redirects, but has the potential to be error-prone.</p> CUNY Academic Commons - Bug #14276 (Deferred): Increase number of workers in Cavalcadehttps://redmine.gc.cuny.edu/issues/142762021-04-02T21:34:01ZRaymond Hoh
<p>I wanted to check in on how Cavalcade was doing since the upgrade in <a class="issue tracker-1 status-5 priority-4 priority-default closed" title="Bug: wp-ms-request-membership not added properly as a git submodule (Resolved)" href="https://redmine.gc.cuny.edu/issues/12240">#12240</a> and it looks like we are running into a backlog again.</p>
<p>Backlog was 1 hour behind, but I'm working to temporarily address this by removing some of the older items as mentioned in <a class="issue tracker-1 status-5 priority-4 priority-default closed" title="Bug: wp-ms-request-membership not added properly as a git submodule (Resolved)" href="https://redmine.gc.cuny.edu/issues/12240">#12240</a>. What this means is Cavalcade's workers cannot get through the job queue fast enough.</p>
<p>Boone, I think we might want to increase the number of workers used by Cavalcade. Currently, that number is set to 4 by default:<br /><a class="external" href="https://github.com/humanmade/Cavalcade-Runner/blob/0dfb42d505e9cd870a11366c49ee680d327c961a/inc/class-runner.php#L36">https://github.com/humanmade/Cavalcade-Runner/blob/0dfb42d505e9cd870a11366c49ee680d327c961a/inc/class-runner.php#L36</a></p>
<p>Perhaps 6 or 8 workers might be preferable. If we wanted to change this, we would need to do this at the <code>/bin/</code> script level. In the sample script provided by Cavalcade, that would be here:<br /><a class="external" href="https://github.com/humanmade/Cavalcade-Runner/blob/0dfb42d505e9cd870a11366c49ee680d327c961a/bin/cavalcade#L30">https://github.com/humanmade/Cavalcade-Runner/blob/0dfb42d505e9cd870a11366c49ee680d327c961a/bin/cavalcade#L30</a></p>
<p>The other way to address this is by patching the runner so it doesn't use the last updated <code>nextrun</code> timestamp with the interval as it does now when rescheduling jobs. See <a class="external" href="https://github.com/humanmade/Cavalcade-Runner/issues/51">https://github.com/humanmade/Cavalcade-Runner/issues/51</a>.</p>
<p>A workaround is to schedule a task to purge older <code>waiting</code> jobs that reschedule every hour or less than an hour on a daily or twice-daily basis.</p> CUNY Academic Commons - Bug #11243 (New): Audit bp-custom.phphttps://redmine.gc.cuny.edu/issues/112432019-03-20T04:10:58ZRaymond Hoh
<p>Over the years, we've added a lot of code to our BuddyPress custom code file - <code>bp-custom.php</code>.</p>
<p>Some of that code is no longer applicable to the Commons today. It's time to trim the fat for 1.15!</p> CUNY Academic Commons - Bug #9639 (Resolved): Users having problems posting to the forumshttps://redmine.gc.cuny.edu/issues/96392018-04-19T20:12:55ZRaymond Hoh
<p>Received a report that users are having problems posting on the cbox.org forums.</p>
<p>I can verify the report when logging in with an account with the role of <code>subscriber</code>. However, I can post with my admin account.</p>
<p>When attempting to add a forum post as a subscriber, the post submits to the group homepage and doesn't redirect to the forum topic. The post isn't in the "Replies > Spam" admin dashboard page either.</p>
<p>I don't have access to debug the issue further.</p>
<p>Boone, do we have any custom code on cbox.org that might be causing this issue?</p> CUNY Academic Commons - Bug #7825 (Rejected): WP Cron fails to spawn on productionhttps://redmine.gc.cuny.edu/issues/78252017-03-22T17:31:27ZRaymond Hoh
<p>I was checking to see if a scheduled task that I added to WP cron was there or not and it appears that WP cron doesn't appear to be working.</p>
<p>I used the following wp-cli command to see if WP cron was functioning correctly:<br /><code>wp cron test</code></p>
<p>And that throws back the following error:</p>
<p><code>Error: WP-Cron spawn failed with error: cURL error 28: Operation timed out after 3001 milliseconds with 0 out<br />of -1 bytes received</code></p>
<p>I then checked the cron schedule with:</p>
<p><code>wp cron event list</code></p>
<p>And there are a bunch of older cron events dating as far back as March 7th that haven't run. This might be the cause of other issues such as #7346. Also, I'm guessing that no one has received a daily digest since March 7th.</p>
<p>I did some brief research to see what might be causing the problem and a Github user notes that <code>commons.gc.cuny.edu</code> might not be in the HOSTS file during the cURL lookup:<br /><a class="external" href="https://github.com/Automattic/vip-quickstart/issues/421#issuecomment-91355870">https://github.com/Automattic/vip-quickstart/issues/421#issuecomment-91355870</a></p>
<p>We'd have to confirm with Lihua if that is the case or not.</p>
<p>I also just tested WP cron on the development server and it appears to be working there though.</p>