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

Sort by score sql error on ideas page

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Ideas
    • None

      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()

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

              Created:
              Updated:
              Resolved: