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

Mediasite plugin issue with Oracle db backend

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 2.9.9
    • None
    • 2016072200
    • MOODLE_29_STABLE

      It looks like the plugin isn't compatible with an Oracle database backend; one of the columns in the "mediasite" table is named "mode" which is a reserved Oracle keyword : http://docs.oracle.com/cd/A58617_01/server.804/a58225/ap_keywd.htm

      So when the plugin tries to do, for example:

      INSERT INTO m_mediasite(mode,name,description,openaspopup,course,siteid,resourcetype,resourceid,recorddateutc,presenters,tags,launchurl)
      VALUES ('PlayerOnly','Test','fred','1','2144',1,'Presentation','78859151dff54eaeaa483b7af91eb1d21d','1464238800','Default Presenter','', 'undefined')

      it errors out with the message "ORA-00928: missing SELECT keyword"

      But if you remove the "mode" column and value, it inserts successfully.

            Unassigned Unassigned
            smily03 Chris Myers
            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.