Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-8384

Postgres Error found when executing clean_local_reminders_logs()

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 3.9.4
    • None
    • 2021010800
    • MOODLE_39_STABLE

      Postgres logs show an error when executing count function on character data.

      ERROR: operator does not exist: character varying >= integer at character 55
      HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
      STATEMENT: SELECT COUNT('x') FROM mdl_local_reminders WHERE time >= 1611850862

       

      This comes from clean_local_reminders_logs function  around line 520
      $recordcount = $DB->count_records_select(REMINDERS_CLEAN_TABLE, "time >= $cutofftime");

            isuru89 Isuru Madushanka Weerarathna
            katcher Eric Katchan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.