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

            Ascending order - Click to sort in descending order
            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