Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects versions: 0.6
    • Fix versions: 0.6
    • Components: Database/schema
    • Labels:
      None
    • Environment:
      MySQL 5.1.37-1ubuntu5 (Ubuntu)

      Description

      Loading the schema version as of revision 2637 makes mysql quit with errno 150 while creating ca_object_events:

      stefan@peter:~/Arbeit/collectiveaccess/trunk/install/inc$ mysql -u root -p trunk < schema_mysql.sql
      Enter password:
      ERROR 1005 (HY000) at line 549: Can't create table 'trunk.ca_object_events' (errno: 150)

      I suppose something is wrong with the object_id foreign key but I couldnt figure out what it is yet.... usually it's something silly like the foreign key being signed while the primary key that is referenced is unsigned that causes errno 150 ...

        Attachments

          Activity

            People

            • Assignee:
              Former user (Inactive)
              Reporter:
              Stefan Keidel
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: