Special Page: MostContributions fails MySQL error
All Special Pages links go to a page, except MostContributions
I have tested all Special Pages and all them produce a Page except MostContributions that produces MySQL error:
Code:
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS `user`.`userid` AS `itemid`,24 AS `itemtypeid` FROM `vBull_vw_usercount` `usercount` LEFT JOIN `vBull_user` `user` ON (`user`.`userid` = `usercount`.`userid`) WHERE 0 < `usercount`.`contribs` ORDER BY `usercount`.`contribs` DESC, `user`.`username` ASC LIMIT 0,50;
MySQL Error : Unknown column 'usercount.contribs' in 'where clause'
Error Number : 1054
Request Date : Sunday, February 9th 2014 @ 06:36:25 PM
Error Date : Sunday, February 9th 2014 @ 06:36:25 PM
Script : http://www.leicaeme.com/wiki_index.php?title=Special:MostContributions
Referrer : http://www.leicaeme.com/wiki_index.php?title=Special:SpecialPages
IP Address : 88.10.206.252
Username : Delfi_r
Classname : vB_Database
MySQL Version : 5.1.63-0ubuntu0.10.04.1
I'll pay a new installation to get Gamma 2 running, but perhaps there is something missing in the database