餱ȥƥȤͫݵ

⤷ƤȤɽεϿøȽ񤯡

Movable Type

褦䤯MT3.35ˤƤߤ(DBUpgradeǼꤳ)

ޤ칹

3.3˥åץ졼ɤƱݤˤʤä

 failed to execute statement alter table mt_session modify session_id varchar(80) not null primary key: Multiple primary key defined at lib/MT/Upgrade.pm line 1190.

Ȥ顼˿ʤʤMySQLʤɡMySQLοͤϤߤǺޤƤΤ顩

ad hocбȤơȤꤢmt_sessionprimary keyöƤߤ

 mysql> show fields from mt_session;
 +---------------+----------------+------+-----+---------+-------+
 | Field         | Type           | Null | Key | Default | Extra |
 +---------------+----------------+------+-----+---------+-------+
 | session_data  | mediumblob     | YES  |     | NULL    |       |
 | session_email | varbinary(255) | YES  |     | NULL    |       |
 | session_id    | varbinary(80)  |      | PRI |         |       |
 | session_kind  | binary(2)      | YES  | MUL | NULL    |       |
 | session_name  | varbinary(255) | YES  |     | NULL    |       |
 | session_start | int(11)        |      | MUL | 0       |       |
 +---------------+----------------+------+-----+---------+-------+
 6 rows in set (0.00 sec)

session_idPKʤΤˡUpgrade.pmǤPKꤷ褦ȤƤǤ礦

 alter table mt_session drop primary key;

Ȥơsession_idKeyPRIäƤΤǧ

 mysql> show fields from mt_session;
 +---------------+----------------+------+-----+---------+-------+
 | Field         | Type           | Null | Key | Default | Extra |
 +---------------+----------------+------+-----+---------+-------+
 | session_data  | mediumblob     | YES  |     | NULL    |       |
 | session_email | varbinary(255) | YES  |     | NULL    |       |
 | session_id    | varbinary(80)  |      |     |         |       |
 | session_kind  | binary(2)      | YES  | MUL | NULL    |       |
 | session_name  | varbinary(255) | YES  |     | NULL    |       |
 | session_start | int(11)        |      | MUL | 0       |       |
 +---------------+----------------+------+-----+---------+-------+
 6 rows in set (0.00 sec)

ξ֤ǡ٥åץ졼Ѥcgi¹ԤȺ٤Ϥޤä⤦äfields򸫤Ƥߤ롣

 mysql> show fields from mt_session;
 +---------------+----------------+------+-----+---------+-------+
 | Field         | Type           | Null | Key | Default | Extra |
 +---------------+----------------+------+-----+---------+-------+
 | session_data  | mediumblob     | YES  |     | NULL    |       |
 | session_email | varbinary(255) | YES  |     | NULL    |       |
 | session_id    | varbinary(80)  |      | PRI |         |       |
 | session_kind  | binary(2)      | YES  | MUL | NULL    |       |
 | session_name  | varbinary(255) | YES  |     | NULL    |       |
 | session_start | int(11)        |      | MUL | 0       |       |
 +---------------+----------------+------+-----+---------+-------+
 6 rows in set (0.00 sec)

̤ꡣ褫ä褫ä(Τ?)

Movable Type 3.3˥åץ졼

3.2-ja-2Υåץ졼ɤ˼ԡ

MySQLΥ顼ʤɡ֤󤳤졢ե¦걾ǤɤʤǤϤʤƥåѡȤ̤ƤäƤޤûŪˡ顼Фʤʤޤǥơ֥빽¤ѤꤹФɡܲˤϤʤʤΤǡ

ɤ褦ʤΤǡȤꤢ3.2-ja-2ڤᤷmysqldumpΥdbƹۤ⡢ȥɲûid0ޤǴäƤϿ褦ȤȤޤMySQL顼Ǥ٤ϤɤǤɤƧǤޤäΤ顦ľˤʤꥤ󥹥ȡ뤷ƤϤʤɤʤ

ڤᤷƻäͻҤ򸫤Ƥߤ褦ʤƻפäƤޤԶǤä餷礦ʤƥץ졼ȤΥХåå׼äơȥν񤭽Фơ3.2Ķ3.3󥹥ȡ뢪ޥޥꥹȥޤ

줿Τǿޤ䤹ߤʤ

mt-sukeroku-plus.plǽ񤤤ȥΥեԶ

¤mt-sukeroku-plus.plץ饰Ĥ꤬ärssatomΥեǡdescriptioncontenthtmlѴξ֤ǵҤƤ롣RSS꡼ʤɤǸWikiäν񼰤ΤޤɽƤޤ

ˤϡindex.xml, atom.xmlΥƥץ졼ǡ

<$MTEntryBody encode_xml="1" convert_breaks="0"$>

<$MTEntryMore encode_xml="1" convert_breaks="0"$>

ȤʤäƤʬ򡢤줾졢

<$MTEntryBody encode_xml="1"$>

<$MTEntryMore encode_xml="1"$>

ѹɤ

PukiWikiʽ񼰤Ϥ

ʤblockquote̯preˤbr䴰ƤȤˤʤ뤷ȤäǤΤɤǺǤȤޤ衢mt-sukeroku-plus.plȤȤƤĤʤʥץ饰󤬡͡ˤ꤬Ȥޤ

ȡǽΤ⤢ޤʤΤǡäȤ­Ǥ⡣ƳMTΥС󤬸Ť(2.661)ᡢ3.2-ja-2Ȥɽ㤦ʬ롣Ǥϡ''ƥȥեޥå''פȤʤäƤϡ3.2-ja-2Ǥϡ''''פʸѤäƤΤ(ĤޤǤȤ)

TypeKey˶

TypeKeyϿƤͤϥȽ񤭹߻ˤ虜虜̾Ȥ᡼륢ɥ쥹ȤϤʤƤɤǤäƤ͡

ʤΤǻȤäƤߤ顦

TypeKeyΥ̾᡼륢ɥ쥹ϿޤäƤ顢TypeKeyץեڡؤΥ󥯤ǥ᡼륢ɥ쥹ʬǤ餱ȡ

ݡȤ䤤碌Ƥߤ顢̾ѹϽʤΤǿTypeKeyϿƤȤΤ(®б꤬Ȥޤ)

Ǥ⡢Ŀͥ饤󥹤ϺTypeKeyɳդƤ͡

餪䤹ʤȤϤTypeKeyѤˤ⤦1饤㤤ľϲȷפǷ⡢Υ˥塼ʲʤ礤Ǥ衣ȤäƤƥ󤹤ΤɥΤΥ󥰥륵󥪥狼ޤ衪Ȥ硣

äҤȤΤɴ⾵Τǡ³䤤碌Ǥ
ۥȤʤ

ĤŤ
³ɤ

Movable Type

󥹥ȡ뤷Ƥߤޤ

Ƥ줹͡
ӤǼĤȤCGIʤΤƤɡ

Ф餯webȤäƤʤ֤Ϥɤɤ⤷ƤǤʤ
ܥܥȤäƤޤޤ