Issue: Special Page: MostContributions fails MySQL error

Issue Tools
- View Changes

February 9, 2014 12:39 PM

Delfi_r1

Junior Member

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

Issue Details

Issue Number 3581

Issue Type Bug

Project VaultWiki 4.x Series

Category Special Pages

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 Gamma 1

Fixed Version 4.0.0 Gamma 3

Milestone VaultWiki 4 Gamma X

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

February 10, 2014 12:50 AM

pegasus

VaultWiki Team

This is fixed in the next release. usercount.contribs was renamed as usercount.vw_contribs since Special:MostContributions was written. The fix is to update the referenced name in the controller for MostContributions.

Reply
February 13, 2014 5:28 PM

Delfi_r1

Junior Member

I'll wait, I understand that there are changes in vW in the meantime. Every release brings some improvements.

Reply

+ Reply

All times are GMT -4. The time now is 9:53 PM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Special Page: MostContributions fails MySQL error

Issue Tools