Bug（バグ） #255

key length of name_UNIQUE_idx on member_application_setting is too long

Added by Shogo Kawahara over 2 years ago. Updated over 2 years ago.

Status:Fixed（完了） Start date:2009-11-24
Priority:High（高め） Due date:
Assignee:Shogo Kawahara % Done:

100%
Category:-
Target version:0.9.2
3.6 で発生するか: ［QA］バグ通知済:

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 over 2 years ago

  • Status changed from Accepted（着手） to Fixed（完了）

Also available in: Atom PDF