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

Error when creating many configurable options

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 5.0.4, 5.1.0-b2
    • Fix Version/s: 5.0.5, 5.1.0
    • Component/s: Staff Interface
    • Labels:
      None

      Description

      When creating many configurable options a database error occurs:

      [2021-06-22T19:49:04.921860+00:00] general.ERROR: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'period' cannot be null in /home/demo/public_html/vendors/minphp/db/src/PdoConnection.php:196 Stack trace: #0 /home/demo/public_html/vendors/minphp/db/src/PdoConnection.php(196): PDOStatement->execute(Array) #1 /home/demo/public_html/vendors/minphp/record/src/Record.php(328): Minphp\Db\PdoConnection->query('UPDATE `pricing...', Array) #2 /home/demo/public_html/app/models/pricings.php(132): Minphp\Record\Record->update('pricings', Array, Array) #3 /home/demo/public_html/app/models/package_options.php(707): Pricings->edit('123', Array) #4 /home/demo/public_html/app/models/package_options.php(673): PackageOptions->addOptionPricing('16', '1', Array) #5 /home/demo/public_html/app/models/package_options.php(466): PackageOptions->addOptionValues('1', '1', Array, 'select') #6 /home/demo/public_html/app/controllers/admin_package_options.php(243): PackageOptions->edit('1', Array) #7 /home/demo/public_html/vendors/minphp/bridge/src/Lib/Dispatcher.php(142): AdminPackageOptions->edit() #8 /home/demo/public_html/index.php(21): Dispatcher::dispatch('/admin/package_...') #9

      {main}

      I did not test this on 5.1.0-b2, but I suspect it will still be an issue.

      To reproduce, create a config option of the type drop-down. In our testing, the issue occurs at the 17th drop down option. See attached screenshot for configuration, it shows the first option, just do the same thing for each item incrementing the value of the option for each one. Save after 16, then try adding a 17th, the error then occurs.

        Activity

          People

          • Assignee:
            Unassigned
            Reporter:
            admin Paul Phillips
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Fix Release Date:
              6/Jul/21