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

If searching by score in desc way gives SQL error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Invalid
    • Ideas
    • None

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: