Uploaded image for project: 'Blesta Core'
  1. Blesta Core
  2. CORE-1571

Adding a new company leads to an error regarding staff groups

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.4.0, 3.4.1
    • Fix Version/s: 3.4.2, 3.5.0-b1
    • Component/s: Staff Interface
    • Labels:
      None

      Description

      When adding a new company in Blesta, an error is encountered before the action completes:

      SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'staff_group_id' cannot be null on line 124 in path/to/blesta/lib/model.php

      Printing Stack Trace:
      #0 path/to/blesta/lib/model.php(124): PDOStatement->execute(Array)
      #1 path/to/blesta/components/record/record.php(225): Model->query('INSERT INTO `st...', Array)
      #2 path/to/blesta/app/models/staff.php(108): Record->insert('staff_group')
      #3 path/to/blesta/public_html/app/controllers/admin_system_companies.php(87): Staff->assignGroup('1', NULL)
      #4 path/to/blesta/public_html/lib/dispatcher.php(111): AdminSystemCompanies->add()
      #5 path/to/blesta/public_html/index.php(21): Dispatcher::dispatch('path/to/blesta/...')
      #6

      {main}

      See http://www.blesta.com/forums/index.php?/topic/4040-addon-company-sql-error-modelphp/

        Activity

        tyson Tyson Phillips (Inactive) created issue -
        tyson Tyson Phillips (Inactive) made changes -
        Field Original Value New Value
        Rank Ranked higher
        tyson Tyson Phillips (Inactive) made changes -
        Fix Version/s 3.5.0 [ 10401 ]
        tyson Tyson Phillips (Inactive) made changes -
        Link This issue relates to CORE-1430 [ CORE-1430 ]
        tyson Tyson Phillips (Inactive) made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        tyson Tyson Phillips (Inactive) made changes -
        Affects Version/s 3.4.1 [ 10611 ]
        tyson Tyson Phillips (Inactive) made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            tyson Tyson Phillips (Inactive)
            Reporter:
            tyson Tyson Phillips (Inactive)
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Fix Release Date:
              25/Feb/15