Uploaded image for project: 'VCL'
  1. VCL
  2. VCL-69

Unknown column 'af.shibonly' in 'field list'

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.1
    • 2.1
    • database
    • None
    • When installing the VCL front-end and connecting it to a database populated from the VCL.sql file

    Description

      The front-end complains with an error message. The e-mail error message provides the following about the error:

      Unknown column 'af.shibonly' in 'field list'

      SELECT u.unityid AS unityid, u.affiliationid, af.name AS affiliation, c.name AS curriculum, u.firstname AS firstname, u.middlename AS middlename, u.lastname AS lastname, u.preferredname AS preferredname, u.email AS email, u.emailnotices, i.name AS IMtype, u.IMid AS IMid, u.id AS id, a.name AS adminlevel, a.id AS adminlevelid, u.width AS width, u.height AS height, u.bpp AS bpp, u.audiomode AS audiomode, u.mapdrives AS mapdrives, u.mapprinters AS mapprinters, u.mapserial AS mapserial, u.showallgroups, u.lastupdated AS lastupdated, af.shibonly FROM user u, curriculum c, IMtype i, affiliation af, adminlevel a WHERE u.curriculumid = c.id AND u.IMtypeid = i.id AND u.adminlevelid = a.id AND u.affiliationid = af.id AND u.unityid = 'admin' AND af.id = 1
      ERROR(105): Failed to execute query 1 in getUserInfo
      Logged in user was
      Mode was main

      Backtrace:
      ===========-=
      Call#:1 => index.php:initGlobals() (line#:53)
      Call#:2 => utils.php:getUserInfo() (line#:227)
      Call#:3 => utils.php:doQuery() (line#:3145)

      Backtrace with Arguments:
      ===========-=
      Call#:1 => index.php:initGlobals() (line#:53)
      Arguments(none):
      -----------------------
      Call#:2 => utils.php:getUserInfo() (line#:227)
      Arguments(1)

      Argument#: 1 => admin@local
      -----------------------
      Call#:3 => utils.php:doQuery() (line#:3145)
      Arguments(2)

      Argument#: 1 => SELECT u.unityid AS unityid, u.affiliationid, af.name AS affiliation, c.name AS curriculum, u.firstname AS firstname, u.middlename AS middlename, u.lastname AS lastname, u.preferredname AS preferredname, u.email AS email, u.emailnotices, i.name AS IMtype, u.IMid AS IMid, u.id AS id, a.name AS adminlevel, a.id AS adminlevelid, u.width AS width, u.height AS height, u.bpp AS bpp, u.audiomode AS audiomode, u.mapdrives AS mapdrives, u.mapprinters AS mapprinters, u.mapserial AS mapserial, u.showallgroups, u.lastupdated AS lastupdated, af.shibonly FROM user u, curriculum c, IMtype i, affiliation af, adminlevel a WHERE u.curriculumid = c.id AND u.IMtypeid = i.id AND u.adminlevelid = a.id AND u.affiliationid = af.id AND u.unityid = 'admin' AND af.id = 1
      Argument#: 2 => 105
      -----------------------

      Attachments

        Activity

          People

            jfthomps Josh Thompson
            bmbouter Brian Bouterse
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 2h
                2h
                Remaining:
                Remaining Estimate - 2h
                2h
                Logged:
                Time Spent - Not Specified
                Not Specified