Topic on Extension talk:SocialProfile

Bug fixed in this patch, which has been now merged.

Hi,

SocialProfile has been giving me Database errors lately which I have tried to diagnose but cannot fix. I've run the database updater and checked that extensions related to SocialProfile have been updated. Here's what the error has been giving me:

[da519ceb5a3f3a2f0d65b752] /wiki/User_profile:Therofl98 Wikimedia\Rdbms\DBQueryError from line 1603 of /var/www/html/wiki/w/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT q_id,q_text,q_date FROM `quizgame_questions` WHERE q_user_id = '58' AND q_flag = '0' ORDER BY q_id DESC LIMIT 3

Function: UserProfilePage::getUserQuiz

Error: 1054 Unknown column 'q_user_id' in 'where clause' (localhost)

Backtrace:

#0 /var/www/html/wiki/w/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)

#1 /var/www/html/wiki/w/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#2 /var/www/html/wiki/w/includes/libs/rdbms/database/Database.php(1807): Wikimedia\Rdbms\Database->query(string, string)

#3 /var/www/html/wiki/w/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select(string, array, array, string, array)

#4 /var/www/html/wiki/w/includes/libs/rdbms/database/DBConnRef.php(315): Wikimedia\Rdbms\DBConnRef->__call(string, array)

#5 /var/www/html/wiki/w/extensions/SocialProfile/UserProfile/includes/UserProfilePage.php(368): Wikimedia\Rdbms\DBConnRef->select(string, array, array, string, array)

#6 /var/www/html/wiki/w/extensions/SocialProfile/UserProfile/includes/UserProfilePage.php(463): UserProfilePage->getUserQuiz()

#7 /var/www/html/wiki/w/extensions/SocialProfile/UserProfile/includes/UserProfilePage.php(181): UserProfilePage->getCasualGames()

#8 /var/www/html/wiki/w/includes/actions/ViewAction.php(63): UserProfilePage->view()

#9 /var/www/html/wiki/w/includes/MediaWiki.php(511): ViewAction->show()

#10 /var/www/html/wiki/w/includes/MediaWiki.php(302): MediaWiki->performAction(UserProfilePage, Title)

#11 /var/www/html/wiki/w/includes/MediaWiki.php(900): MediaWiki->performRequest()

#12 /var/www/html/wiki/w/includes/MediaWiki.php(527): MediaWiki->main()

#13 /var/www/html/wiki/w/index.php(44): MediaWiki->run()

#14 {main}

Looks like the part about games is broken. You can disable it by setting

$wgUserProfileDisplay['games'] = false;

That did it! Thank you! Do you know if a fix will be available soon?

I don't see it reported. Best you can do is bugreport it, so devs are aware of the problem.

Now fixed in this patch, which just landed on master. Thanks for reporting the issue! (But as Ciencia mentioned, using Phabricator is a better way to ensure that your report certainly is seen and prioritized.)