Topic on Project:Support desk

So earlier I was trying to install SocialProfile as an extension to my wiki, and when I unzipped it and put it in extensions and did their require command on the LocalSettings, running the update script, the website wouldn't respond. It was only after I ran the update script that it basically shut down. So I tried immediately deleting the files and code from LocalSettings, didn't do anything, and then tried to delete whatever I could from the database tables, gift, and then the user tables. I am pretty sure I got all of them out, but it still didn't work. Maybe Mediawiki is looking for the extension in some way? Maybe SocialProfile is still marked on some file somewhere thats causing the problem?

I have no ide and would greatly accept help, Thanks

@Awrigh01~mediawikiwiki, UltrasonicNXT, and Jack Phoenix: Are any of you able to help here (you're listed as maintainers of SocialProfile).

@Guillaume Taillefer: I'd suggest never modifying the database directly. You mention deleting info from the user table — do you mean the actual 'user' table, or one for SocialProfile? If it's the former, I'd recommend restoring from backup as you might have lost data!

No I didn't delete user or user autocreate serial tables because I looked and saw that they were original MediaWiki tables, but deleted all the other user ones because it was obvious, and partially from the info from the SocialProfile page but they don't list all of the tables, that they were from SocialProfile.

I also reran update.php after deleting the tables (with SocialProfile deleted) to maybe restore anything I deleted that I shouldn't have. I don't know if it worked though

Ok so I think I figured it out at least partially. I am looking at error_log and it is constantly complaining of the fact that it can't find certain database tables. It is specifically user_newtalk and user_properties. Although I was confused about it since as I said it shut down without me deleting some of those tables in the first place. Maybe the extension deletes them when you run update.php?

@Samwilson Now I need to find out how to add in back those tables, although thankfully by their description pages they don't seem to be super important so a little sigh of relief.

Edit: I am perfectly capable of accessing phpMyAdmin and downloading the whole database, would it be worth a try downloading it and then updating MediaWiki to 1.41? I can also download it and then try to manually add back in the lost tables.

I fixed it! I just needed to add back in user_newtalk, user_properties, user_groups, and user_former_groups (fortunately I had MediaWiki installed somewhere else so I could just copy how the tables were set up to the new tables)

The other problem was the PageProperties extension, its pageproperties_pageproperties table was deleted somehow and so it was complaining about that too. After taking that extension off the website now works again!

User_properties, user_newtalk, user_groups and user_former_groups are all MediaWiki core tables. You should not have deleted them.

I didn't know it at the time unfortunately, but again I don't know whether I exactly deleted some of them or not because the site went down after I had installed and ran the update script for SocialProfile. Even after I deleted it first as well as the line to call it it was still down, to which I proceeded to look in the database

SocialProfile works just fine with MediaWiki 1.39 (the current LTS version); as per social tools/MediaWiki compatibility, SocialProfile and other social tools support "officially" only LTS versions; support for newer non-LTS versions is coincidental and not guaranteed.

On MW 1.41+ SocialProfile probably doesn't run currently due to phab:T152865; see my latest comment (from October '23) there for more info and context.