https://bugzilla.wikimedia.org/show_bug.cgi?id=66624
--- Comment #15 from Andrew Green <[email protected]> --- Thanks again everyone for helping with this! There is one more place in the DB that needs to be fixed: a blob in the course_students column in one row of the ep_courses table. (from Labs replica) MariaDB [enwiki_p]> select * from ep_courses where course_id=359 \G *************************** 1. row *************************** course_id: 359 course_org_id: 6 course_title: Simmons College/Intellectual Freedom - LIS 493 (Summer 2014) course_name: Intellectual Freedom - LIS 493 <snip/> course_students: a:4:{i:0;s:0:"";i:1;i:6404;i:2;i:21613420;i:3;i:21613446;} <snip/> This is a serialized array of the user IDs of students in the course. $ php -r "var_dump( unserialize( 'a:4:{i:0;s:0:\"\";i:1;i:6404;i:2;i:21613420;i:3;i:21613446;}' ) );" array(4) { [0]=> string(0) "" [1]=> int(6404) [2]=> int(21613420) [3]=> int(21613446) } I think that string could be replaced with "a:3:{i:0;i:6404;i:1;i:21613420;i:2;i:21613446;}", which is the serialized version of the correct array of students in the course. After that's done, the number of students shown on the course page [1] and the related institution page will be corrected the next time students are added to or removed from the course. I tried this locally and it seemed to work. :) P.S. A fix is in the works for the EducationProgram extension issue that caused this. [1] At the bottom of https://en.wikipedia.org/wiki/Education_Program:Simmons_College/Intellectual_Freedom_-_LIS_493_%28Summer_2014%29 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
