Uploaded image for project: 'Poulpe'
  1. Poulpe
  2. POULPE-477

Error "Foreign key constraint is incorrectly formed" when trying to restore backup created using Poulpe UI

VotersWatchers
    XMLWordPrintable

    Details

    • Sprint:
      1.2 Swallows

      Description

      How to reproduce:
      1. Go to Poulpe -> Components -> Components -> Admin Panel
      2. Right click Admin Panel and select Backup Database

      3. Create new empty DB (I used My SQL 5.5.25a)
      4. Extract and run backup versus new DB

      AR:
      The SQL error appears when script runs the row "CREATE TABLE `BRANCHES` ("
      [Error]
      SQL Error (1005): Can't create table 'b.branches' (errno: 150)
      Foreign key constraint is incorrectly formed
      [OK]

      ER:
      The backup run till the end without errors

      Example of backup file attached (taken this morning from uat)

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  varro Artem R
                  Reporter:
                  kitsune Polina
                • Votes:
                  2 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

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

                      Structure Helper Panel