Uploaded image for project: 'Website'
  1. Website
  2. WEBSITE-1053

If searching by score in desc way gives SQL error

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Invalid
    • Icon: Blocker Blocker
    • Ideas
    • None

      If searching by score in a descending way, for example,
      https://www.phpbb.com/ideas/list.php?status=0&sort=score&sd=d
      It gives an SQL error. Here's a quote of it:

      SQL ERROR [ mysqli ]

      BIGINT UNSIGNED value is out of range in '(`phpbb`.`community_ideas_ideas`.`idea_votes_up` - `phpbb`.`community_ideas_ideas`.`idea_votes_down`)' [1690]

      An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

            callumacrae Callum Macrae [X] (Inactive)
            brunoais brunoais
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: