설치 질문입니다..
페이지 정보
본문
1.3.3. 설치하고 글을 쓰려니까
1054 : Unknown 칼럼 'wr_last' in 'field list'
error file : /gnu4_test3/bbs/write_update.php
에러가 나는데
설치는 최초 설치입니다..
DB내에 필드를 살펴보아도 wr_last는 없던데...
혹시나 해서 업그래이드 눌러보아도..
UPDATE `g4_write_guest` set wr_last = wr_datetime WHERE wr_is_comment = 0
1054 : Unknown 칼럼 'wr_last' in 'field list'
error file : /gnu4_test2/adm/upgrade.php
에러입니다...
뭐가 문제인가요?
댓글목록
울랄라님의 댓글
울랄라쪽지보내기 메일보내기 자기소개 아이디로 검색 전체게시물 작성일
혹시 utf-8으로 설치를 하시나요?
저는 ECU-KR로 설치를 합니다.
제가 다운로드 받은 화일을 살펴본 결과 빠진게 있더군요..
sql_gnuboard4.sql 중에 일부입니다
--
-- `$g4[write_prefix]z1_1`
--
DROP TABLE IF EXISTS $g4[write_prefix]z1_1;
CREATE TABLE $g4[write_prefix]z1_1 (
wr_id int(11) NOT NULL auto_increment,
wr_num int(11) NOT NULL default '0',
wr_reply varchar(10) collate utf8_general_ci NOT NULL default '',
wr_parent int(11) NOT NULL default '0',
wr_is_comment tinyint(4) NOT NULL default '0',
wr_comment int(11) NOT NULL default '0',
wr_comment_reply varchar(5) NOT NULL default '',
ca_name varchar(255) collate utf8_general_ci NOT NULL default '',
wr_option set('html1','html2','secret','mail') NOT NULL default '',
wr_subject varchar(255) collate utf8_general_ci NOT NULL default '',
wr_content text collate utf8_general_ci NOT NULL,
wr_link1 text collate utf8_general_ci NOT NULL,
wr_link2 text collate utf8_general_ci NOT NULL,
wr_link1_hit int(11) NOT NULL default '0',
wr_link2_hit int(11) NOT NULL default '0',
wr_trackback varchar(255) collate utf8_general_ci NOT NULL default '',
wr_hit int(11) NOT NULL default '0',
wr_good int(11) NOT NULL default '0',
wr_nogood int(11) NOT NULL default '0',
mb_id varchar(255) collate utf8_general_ci NOT NULL default '',
wr_password varchar(255) collate utf8_general_ci NOT NULL default '',
wr_name varchar(255) collate utf8_general_ci NOT NULL default '',
wr_email varchar(255) collate utf8_general_ci NOT NULL default '',
wr_homepage varchar(255) collate utf8_general_ci NOT NULL default '',
wr_datetime datetime NOT NULL default '0000-00-00 00:00:00',
wr_ip varchar(255) collate utf8_general_ci NOT NULL default '',
wr_1 varchar(255) collate utf8_general_ci NOT NULL default '',
wr_2 varchar(255) collate utf8_general_ci NOT NULL default '',
wr_3 varchar(255) collate utf8_general_ci NOT NULL default '',
wr_4 varchar(255) collate utf8_general_ci NOT NULL default '',
wr_5 varchar(255) collate utf8_general_ci NOT NULL default '',
wr_6 varchar(255) collate utf8_general_ci NOT NULL default '',
wr_7 varchar(255) collate utf8_general_ci NOT NULL default '',
wr_8 varchar(255) collate utf8_general_ci NOT NULL default '',
wr_9 varchar(255) collate utf8_general_ci NOT NULL default '',
wr_10 varchar(255) collate utf8_general_ci NOT NULL default '',
PRIMARY KEY (wr_id),
KEY wr_num_reply_parent (wr_num,wr_reply,wr_parent),
KEY wr_is_comment (wr_is_comment,wr_id)
) TYPE=MyISAM;
wr_last 부분이 빠져있네요...
저만 그런건 아닌듯......