I installed invite
I did a drush cr
i got the admin page, /admin/config/invite/invite_config

I click on 'Invite list' and I get a WSOD and this:

|1||Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'devsocial30oneba.invite__field_invite_email_address' doesn't exist: SELECT COUNT(*) AS expression#012FROM #012(SELECT 1 AS expression#012FROM #012{invite} i#012LEFT OUTER JOIN {users} u ON i.user_id = u.uid#012LEFT OUTER JOIN {users_field_data} ufd ON u.uid = ufd.uid#012LEFT OUTER JOIN {invite__field_invite_email_address} ie ON i.id = ie.entity_id) subquery; Array#012(#012)#012 in Drupal\invite\Controller\InviteList->view() (line 81 of /var/aegir/platforms/drupal/8/servers/1-dev/sng-contrib/dev-social-3.0/html/modules/contrib/invite/src/Controller/InviteList.php).
Sep 2 07:34:12 insitehost pound: 24.63.88.111 GET /invite/list HTTP/1.1 - HTTP/1.1 500 500 Service unavailable (with message)

I have not installed invite_by_email yet

CommentFileSizeAuthor
#16 invite_list_wsod-2996758-16.patch2.31 KBvj
#13 2996758-invite-list-gives-wsod.patch1.04 KBsocialnicheguru
#12 Screenshot from 2020-05-08 11-21-59.png13.95 KBpaulocs
#10 invite-list-wsod-2996758-10.patch1.5 KBryan osītis
#8 Screenshot from 2020-05-05 14-19-24.png22.16 KBpaulocs
#6 invite-list-wsod-2996758-6.patch2.07 KBryan osītis
#2 2996758-02.patch1.04 KBvj

Comments

SocialNicheGuru created an issue. See original summary.

vj’s picture

vj commented
Status: Active » Needs review
StatusFileSize
new 2996758-02.patch1.04 KB
dwkitchen’s picture

dwkitchen commented
Status: Needs review » Reviewed & tested by the community

Reviewed and tested, the same issue as not using invite by email

dwkitchen’s picture

dwkitchen commented

There is still a further change on the table rows on line 97

socialnicheguru’s picture

socialnicheguru commented
Status: Reviewed & tested by the community » Needs work

needs work to include changes on line 97

ryan osītis’s picture

ryan osītis commented
StatusFileSize
new invite-list-wsod-2996758-6.patch2.07 KB

Re-rolling patch with additional work.

ryan osītis’s picture

ryan osītis commented
Status: Needs work » Needs review
paulocs’s picture

paulocs
Primary language Portuguese, Brazil
Location Belo Horizonte
commented
Status: Needs review » Reviewed & tested by the community
StatusFileSize
new Screenshot from 2020-05-05 14-19-24.png22.16 KB

RTBC. I reviewed your patch @rositis and it is working good. I just had a problem with git apply patch so I replaced the code manually.
I think something from your code is different from the code from repository.

socialnicheguru’s picture

socialnicheguru commented

should it be needs work until the patch applies correctly?

ryan osītis’s picture

ryan osītis commented
StatusFileSize
new invite-list-wsod-2996758-10.patch1.5 KB

Good catch on that. That patch accidentally incorporated a patch for a different Invite issue, specifically Issue #3130479. I re-rolled it again, this time without the extra.

ryan osītis’s picture

ryan osītis commented
Status: Reviewed & tested by the community » Needs review
paulocs’s picture

paulocs
Primary language Portuguese, Brazil
Location Belo Horizonte
commented
Status: Needs review » Needs work
StatusFileSize
new Screenshot from 2020-05-08 11-21-59.png13.95 KB

@rositis, I tested your patch again. The feature is working but the patch didn't apply correctly. Follow the image.

socialnicheguru’s picture

socialnicheguru commented
StatusFileSize
new 2996758-invite-list-gives-wsod.patch1.04 KB

Updated the patch to use the latest dev version of invite

socialnicheguru’s picture

socialnicheguru commented
Status: Needs work » Needs review
paulocs’s picture

paulocs
Primary language Portuguese, Brazil
Location Belo Horizonte
commented
Status: Needs review » Reviewed & tested by the community

RTBC. The patch applied good and the bug was fixed.

vj’s picture

vj commented
Status: Reviewed & tested by the community » Needs review
StatusFileSize
new invite_list_wsod-2996758-16.patch2.31 KB

injecting the module_handler and attaching new patch

dale42’s picture

dale42
he/him
Primary language English
Location Vancouver, Canada
commented
Status: Needs review » Reviewed & tested by the community

The patch in #16 (invite_list_wsod-2996758-16.patch) applied cleanly and there was no longer a Database Exception on the Invite List page.

renatog’s picture

renatog commented

I applied the patch and the route invite.invite_list (invite/list) is really working fine. +1 to this

  • RenatoG committed 575e638 on 8.x-1.x authored by Vj 
    Issue #2996758 by Ryan Osītis, Vj, SocialNicheGuru, paulocs, dwkitchen,...

  • RenatoG committed a7d72f9 on 2.0.x authored by Vj 
    Issue #2996758 by Ryan Osītis, Vj, SocialNicheGuru, paulocs, dwkitchen,...
renatog’s picture

renatog commented
Status: Reviewed & tested by the community » Fixed

Committed to the 8.x-1.x and 2.0.x branches. Thank you so much everyone for your contribution.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.