From UBC Wiki
Jump to: navigation, search

Nicholas Hu

Hello world! My name is Nicholas Hu. I joined the MER Wiki team in the fall of 2014 and since then I have been seeking to share my experience and knowledge by contributing to the MER wiki.

As of September 2015, Hyunju and I have been managing this wiki! If you have any questions about the wiki or are interested in contributing to it, please contact me.

Recent modifications Exams I'm working on
The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.

The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, SUM( ABS( rc.rc_new_len - rc.rc_old_len ) ) AS contribution, rc.rc_user_text AS contributor, `page`.page_len AS page_len, rev_user, rev_user_text, rev_comment, rev_timestamp FROM `revision` AS rev, `revision` AS change_rev, `recentchanges` AS rc, `page` WHERE 1=1 AND page.page_id=rc.rc_cur_id AND `page`.page_namespace IN ('130') AND (`page`.page_title LIKE 'Math_Exam_Resources/%') AND `page`.page_is_redirect=0 AND `page`.page_id=rev.rev_page AND rev.rev_timestamp=( SELECT MAX(rev_aux.rev_timestamp) FROM `revision` AS rev_aux WHERE rev_aux.rev_page=rev.rev_page ) AND = change_rev.rev_user_text AND change_rev.rev_page = page_id GROUP BY rc.rc_cur_id ORDER BY rev_timestamp DESC LIMIT 5 OFFSET 0

Error message is:
Column 'rev_user' in field list is ambiguous (wiki-prod-extdb)

Number of pages I have edited in the wiki: 0