Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-10290

Who's online broken due to malformed SQL

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 3.1.0-a1
    • 3.1.0-dev
    • Other
    • None
    • xampp 1.7.3
      php 5.3.1
      MySQL(i) 5.1.41
      apache 2.2.14
      Internet Explorer 9

      was checking out 3.1.0-dev from the svn yesterday and came across this error when trying to view viewonline.php

      SQL ERROR [ mysqli ]

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '> 0 ORDER BY group_legend ASC' at line 3 [1064]

      SQL

      SELECT group_id, group_name, group_colour, group_type, group_legend FROM phpbb_groups WHERE group_legend = > 0 ORDER BY group_legend ASC

      BACKTRACE

      FILE: includes/db/mysqli.php
      LINE: 182
      CALL: dbal->sql_error()

      FILE: viewonline.php
      LINE: 397
      CALL: dbal_mysqli->sql_query()

            Oleg Oleg [X] (Inactive)
            bprsk8r4272 bprsk8r4272 [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: