看板FreeBSD
標 題Re: 有沒有人用BSD架plog呢?
發信站無名小站 (Mon Mar 7 00:09:05 2005)
轉信站ptt!ctu-reader!ctu-peer!news.nctu!netnews.csie.nctu!wretch
補充一下 :
一但我把config_key varchar(200) NOT NULL default '',
從255改到 200後....一切都沒有問題了~ 正常執行..
但是我...還是很納悶...為什麼..原先的255會不行呢!?
問題
> 使用wizard.php 時step 3 遇到 Error creating table: Specified key was too long. Max key length is 500
> 的問題 (如下)
> Table Articles created successfully.
> Table Article categories created successfully.
> Table Comments created successfully.
> Table Notifications created successfully.
> Table Blogs created successfully.
> Table MyLinks created successfully.
> Table MyLinks Categories created successfully.
> Table MyRecent created successfully.
> Table MyRecent categories created successfully.
> Table Permissions created successfully.
> Table Referers created successfully.
> Table Trackbacks created successfully.
> Table Users created successfully.
> Table Permissions created successfully.
> Error creating table: Specified key was too long. Max key length is 500
> //^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> Table Blocked hosts created successfully.
> Table Blocked content created successfully.
> Table Gallery Resources created successfully.
> Table Gallery Albums created successfully.
> Table Bayesian Filter data table created successfully.
> Table Bayesian Filter Information created successfully.
> 所以我看了看 wizard 的原始檔案
> 發現是這一段落出的Error (如下)
> $Tables[14]["desc"] = "Configuration";
> $Tables[14]["code"] = "CREATE TABLE {dbprefix}config (
> id int(10) NOT NULL auto_increment,
> config_key varchar(255) NOT NULL default '',
> config_value text NOT NULL,
> value_type int(3) default '0',
> PRIMARY KEY (id,config_key)
> ) TYPE=MyISAM;";
> 可是看了看 primary key 並沒有超過500 呀...所以覺得很納悶~~
> 不知到底是哪裡的問題呢!?
> 謝謝解答 : )
> ※ 引述《YuppieJer ([ Yuppie Jer])》之銘言：
> > 有支援
> > 你可以利用http://plog-url/summary.php
> > 去作為你plog的主畫面
> > 裡面可以看到最新文章等等
> > 上方有個register可以去註冊新增
> > 當然如果不要讓人註冊
> > 可以移除summary.php和register.php
> > 現在有名的pixnet新推出的blog
> > 應該就是利用plog去修改的吧
--
夫兵者不祥之器物或惡之故有道者不處君子居則貴左用兵則貴右兵者不祥之器非君子
之器不得已BBS telnet://bbs.wretch.cc 開個人板 超快 不用連署不可得志於天下
矣吉事尚左凶事尚右偏將軍居左上將軍居右言以喪禮處之殺人之眾以哀悲泣之戰勝以
喪禮處之道常無名樸雖小天下莫能臣侯王若能守之萬物將自賓天地相合以降甘露民莫
之令而自均始制有名名亦既有夫亦將知止知止可以不殆 ccsun6.csie.nctu.edu.tw海