Project

General

Profile

Bug(バグ) #255

key length of name_UNIQUE_idx on member_application_setting is too long

Added by Shogo Kawahara about 13 years ago. Updated about 13 years ago.

Status:
Fixed(完了)
Priority:
High(高め)
Target version:
Start date:
2009-11-24
Due date:
% Done:

100%

3.6 で発生するか:
Unknown (未調査)
[QA]バグ通知済:
No
3.8 で発生するか:
Unknown (未調査)

Description

Overview

インストール時に問題が発生します。

# cp config/ProjectConfiguration.class.php.sample config/ProjectCo
nfiguration.class.php
# ./symfony openpne:install
  |
  |
Is it OK to start this task? (y/n)
y
>> plugin installing plugin "opAuthMailAddressPlugin" 
>> sfPearFrontendPlugin Attempting to discover channel "plugins.openpne.jp"...
  |
  |
  |
  |
>> doctrine created tables successfully

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes. Failing Query: CREATE TABLE member_application_setting (id BIGINT AUTO_INCREMENT, member_application_id BIGINT NOT NULL, type VARCHAR(255) DEFAULT 'application' NOT NULL, name VARCHAR(255) NOT NULL, value TEXT, UNIQUE INDEX name_UNIQUE_idx (member_application_id, type, name), INDEX member_application_id_idx (member_application_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 ENGINE = INNODB 

via http://sns.openpne.jp/?m=pc&a=page_fh_diary&target_c_diary_id=22537

Cause

member_application_setting上のname_UNIQUE_idxが長過ぎるために、環境によってインストールに失敗します。

History

#1 Updated by Shogo Kawahara about 13 years ago

  • Status changed from Accepted(着手) to Fixed(完了)

Also available in: Atom PDF