PennMUSH Community

Ticket #7542 (new incoming)

Opened 6 months ago

Last modified 6 months ago

WEBSITE BUG: ordering the mushlist results in SQL error

Reported by: Boris Assigned to:
Priority: minor Milestone:
Keywords: Cc:
Visibility: Public

Description

Clicking on the column headers to sort the mushlist list results in an error. It only seems to happen when sorting genre, purpose and status. The other sorts seems to work well.

1) http://community.pennmush.org/mushlist?sort=asc&order=Genre%28s%29 2) http://community.pennmush.org/mushlist?sort=asc&order=Purpose 3) http://community.pennmush.org/mushlist?sort=asc&order=Status

If I should be posting this elswhere, please let me know (email: boris@moderncommand dot com)

Change History

01/26/08 13:36:07 changed by Alan Schwartz

Quoting Penndev (pennmush-bugs@pennmush.org):
> #7542: WEBSITE BUG: ordering the mushlist results in SQL error
> ------------------+---------------------------------------------------------
> Reporter:  Boris  |         Type:  incoming
>   Status:  new    |     Priority:  minor   
> Keywords:         |   Visibility:  Public  
> ------------------+---------------------------------------------------------
>  Clicking on the column headers to sort the mushlist list results in an
>  error.  It only seems to happen when sorting genre, purpose and status.
>  The other sorts seems to work well.
> 
>  1) http://community.pennmush.org/mushlist?sort=asc&order=Genre%28s%29
>  2) http://community.pennmush.org/mushlist?sort=asc&order=Purpose
>  3) http://community.pennmush.org/mushlist?sort=asc&order=Status
> 
>  If I should be posting this elswhere, please let me know (email:
>  boris@moderncommand dot com)

cpo stuff should go just to me (javelin@pennmush.org)

The penn devs can't do anything about it.

In this case, theproblem is that those fields take multiple
values so they're not really sortable. I've disabled sorting
on them.

 - Alan


-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Javelin@M*U*S*H, once Paul@DuneMUSH | Alan Schwartz <dunemush@pennmush.org>
   (mush.pennmush.org 4201)         |     
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-