Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-11146

Tag library - argument of WHERE must be type boolean, not type bigint

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.9
    • Fix Version/s: 1.9
    • Component/s: Blocks, Database SQL/XMLDB
    • Labels:
      None
    • Database:
      PostgreSQL
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      Tracked error to, tag/lib.php "popular_tags_count" function about line 1164, revision 1.33/ HEAD.

      I get this error, when I add a the new "Tags block - the $tag_type function parametr is unused, so that may be the missing bit, not sure:

      "" ERROR: argument of WHERE must be type boolean, not type bigint

      SELECT tg.rawname, tg.id, tg.name, COUNT(ti.id) AS count, tg.flag FROM headmdl_tag_instance ti INNER JOIN headmdl_tag tg ON tg.id = ti.tagid WHERE ti.tagid GROUP BY tagid ORDER BY count DESC

      • line 677 of lib/dmllib.php: call to debugging()
      • line 918 of lib/dmllib.php: call to get_recordset_sql()
      • line 1176 of tag/lib.php: call to get_records_sql()
      • line 64 of blocks/tags/block_tags.php: call to popular_tags_count()
      • line 210 of blocks/moodleblock.class.php: call to block_tags->get_content()
      • line 234 of blocks/moodleblock.class.php: call to block_base->is_empty()
      • line 338 of lib/blocklib.php: call to block_base->_print_block()
      • line 263 of index.php: call to blocks_print_group()
        ""

      Let me know if I can help. Many thanks,
      Nick

        Attachments

          Activity

            People

            Assignee:
            dougiamas Martin Dougiamas
            Reporter:
            nfreear Nick Freear
            Tester:
            Nobody
            Participants:
            Component watchers:
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan, Andrew Nicols, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              3/Mar/08