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

Sort by score sql error on ideas page

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Resolution: Duplicate
    • Ideas
    • None

    Description

      QL 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]

      SQL

      SELECT * FROM community_ideas_ideas WHERE idea_status != 4 AND idea_status != 3 AND idea_status != 5 ORDER BY idea_votes_up - idea_votes_down DESC LIMIT 18446744073709551615

      BACKTRACE

      FILE: (not given by php)
      LINE: (not given by php)
      CALL: msg_handler()

      FILE: [ROOT]/includes/db/dbal.php
      LINE: 757
      CALL: trigger_error()

      FILE: [ROOT]/includes/db/mysqli.php
      LINE: 189
      CALL: dbal->sql_error()

      FILE: [ROOT]/includes/db/mysqli.php
      LINE: 231
      CALL: dbal_mysqli->sql_query()

      FILE: [ROOT]/includes/db/dbal.php
      LINE: 170
      CALL: dbal_mysqli->_sql_query_limit()

      FILE: /var/www/phpbb.com/website-current/old/ideas/includes/ideas.php
      LINE: 92
      CALL: dbal->sql_query_limit()

      FILE: /var/www/phpbb.com/website-current/old/ideas/list.php
      LINE: 35
      CALL: Ideas->get_ideas()

      Attachments

        Issue Links

          Activity

            People

              MichaelC Michael Cullum
              master412160 Max Pen [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: