Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-1861

Database binary store schema is incompatible with MySQL 5.5

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Blocker
    • 3.2.0.Final
    • 3.1.3.Final
    • Storage
    • None

    Description

      The DatabaseBinaryStore attempts to create a table with the following statement:

      CREATE TABLE CONTENT_STORE (
        cid VARCHAR(255) NOT NULL,
        mime_type VARCHAR(255),
        ext_text VARCHAR(1000),
        usage INTEGER,
        usage_time TIMESTAMP,
        payload BLOB,
        primary key(cid)
      )
      

      However, "usage" is a reserved word in MySQL5, and therefore the table cannot be created. Additionally, no error message appears to be recorded in the log.

      Attachments

        Activity

          People

            rhauch Randall Hauch (Inactive)
            rhauch Randall Hauch (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: