Uploaded image for project: 'JCommune'
  1. JCommune
  2. JC-2145

sample-forum.sql fails under certain conditions if run against clean JC+POUPLE deployment

VotersWatchers
    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.0 Larks
    • Fix Version/s: 3.1 Larks
    • Labels:
    • Environment:

      Windows XP SP3, jcommune-3.0.2779.6a56770, poulpe-2.1.343.e62d084, sample-forum.sql version of Feb 12, 2015

    • Sprint:
      3.0 Larks, 3.1 Larks

      Description

      Preconditions:
      Empty <database>.
      Steps to reproduce:
      1. Deploy JC and configure it to use <database>.
      2. Log in to JC as admin/admin and do not any changes.
      3. Deploy POULPE and configure it to use the same <database>.
      4. Log in to POULPE as admin/admin and Open Personal permissions mode (this will create erroneous records as described in POULPE-528).
      5. Run sample-forum.sql against <database>.
      Actual result: Error SQL (1452) at line 209: Cannot add or update a child row: a foreign key constraint fails (`jtalks`.`acl_entry`, CONSTRAINT `fk_acl_entry_obj_id` FOREIGN KEY (`acl_object_identity`) REFERENCES `acl_object_identity` (`id`)). With newer version of sample-forum.sql it may be another error at line 161.
      Expected result: Script runs without errors.

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  baranov.r.p Roman Baranov
                  Reporter:
                  begemosha Anton Barkov
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  8 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel