설치 후 로그인 및 회원가입이 되지 않는 문제.. 제발 도와주세요 정보
설치 후 로그인 및 회원가입이 되지 않는 문제.. 제발 도와주세요본문
에이치H님께서 말씀하신대로
my.ini파일
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
>>
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
이렇게 바꾸었구요
register_form_update.php파일의 214열에 mb_memo = '' 문을 추가했습니다.
그런데..또 오류가 뜹니다..
Warning: Cannot modify header information - headers already sent by (output started at D:\gnuboard4\bbs\register_form_update.php:1) in D:\gnuboard4\common.php on line 8
insert into g4_member set mb_id = 'asdasd', mb_password = '*E56A114692FE0DE073F9A1DD68A00EEB9703F3F1', mb_name = '유넷시스', mb_jumin = '', mb_sex = 'F', mb_birth = '19930707', mb_nick = '유넷시스', mb_nick_date = '2013-07-19', mb_password_q = '', mb_password_a = '', mb_email = '*** 개인정보보호를 위한 이메일주소 노출방지 ***', mb_homepage = '', mb_tel = '', mb_hp = '', mb_zip1 = '', mb_zip2 = '', mb_addr1 = '', mb_addr2 = '', mb_signature = '', mb_profile = '', mb_today_login = '2013-07-19 09:49:47', mb_datetime = '2013-07-19 09:49:47', mb_ip = '::1', mb_level = '2', mb_recommend = '', mb_login_ip = '::1', mb_mailling = '1', mb_sms = '1', mb_open = '1', mb_open_date = '2013-07-19', mb_1 = '', mb_2 = '', mb_3 = '', mb_4 = '', mb_5 = '', mb_6 = '', mb_7 = '', mb_8 = '', mb_9 = '', mb_10 = '' mb_memo = '' , mb_email_certify = '2013-07-19 09:49:47'
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mb_memo = '' , mb_email_certify = '2013-07-19 09:49:47'' at line 41
error file : /bbs/register_form_update.php
이렇게뜨는데.. 도와주세요..ㅠㅠ
my.ini파일
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
>>
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
이렇게 바꾸었구요
register_form_update.php파일의 214열에 mb_memo = '' 문을 추가했습니다.
그런데..또 오류가 뜹니다..
Warning: Cannot modify header information - headers already sent by (output started at D:\gnuboard4\bbs\register_form_update.php:1) in D:\gnuboard4\common.php on line 8
insert into g4_member set mb_id = 'asdasd', mb_password = '*E56A114692FE0DE073F9A1DD68A00EEB9703F3F1', mb_name = '유넷시스', mb_jumin = '', mb_sex = 'F', mb_birth = '19930707', mb_nick = '유넷시스', mb_nick_date = '2013-07-19', mb_password_q = '', mb_password_a = '', mb_email = '*** 개인정보보호를 위한 이메일주소 노출방지 ***', mb_homepage = '', mb_tel = '', mb_hp = '', mb_zip1 = '', mb_zip2 = '', mb_addr1 = '', mb_addr2 = '', mb_signature = '', mb_profile = '', mb_today_login = '2013-07-19 09:49:47', mb_datetime = '2013-07-19 09:49:47', mb_ip = '::1', mb_level = '2', mb_recommend = '', mb_login_ip = '::1', mb_mailling = '1', mb_sms = '1', mb_open = '1', mb_open_date = '2013-07-19', mb_1 = '', mb_2 = '', mb_3 = '', mb_4 = '', mb_5 = '', mb_6 = '', mb_7 = '', mb_8 = '', mb_9 = '', mb_10 = '' mb_memo = '' , mb_email_certify = '2013-07-19 09:49:47'
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mb_memo = '' , mb_email_certify = '2013-07-19 09:49:47'' at line 41
error file : /bbs/register_form_update.php
이렇게뜨는데.. 도와주세요..ㅠㅠ
댓글 전체
mb_9 = '',
mb_10 = '', ← register_form_update.php 파일 열기 ,(컴마) 추가
mb_memo = '' ,
mb_10 = '', ← register_form_update.php 파일 열기 ,(컴마) 추가
mb_memo = '' ,
Warning: Cannot modify header information - headers already sent by (output started at D:\gnuboard4\bbs\register_form_update.php:1) in D:\gnuboard4\common.php on line 8
insert into g4_member set mb_id = 'qweqweqwee', mb_password = '*0B0A8BA0BB47561FA5C1FE726FFDFFC56F3FF585', mb_name = '유넷시스', mb_jumin = '', mb_sex = 'F', mb_birth = '19890705', mb_nick = '유넷시스', mb_nick_date = '2013-07-19', mb_password_q = '', mb_password_a = '', mb_email = '*** 개인정보보호를 위한 이메일주소 노출방지 ***', mb_homepage = '', mb_tel = '', mb_hp = '', mb_zip1 = '', mb_zip2 = '', mb_addr1 = '', mb_addr2 = '', mb_signature = '', mb_profile = '', mb_today_login = '2013-07-19 10:15:41', mb_datetime = '2013-07-19 10:15:41', mb_ip = '211.212.238.210', mb_level = '2', mb_recommend = '', mb_login_ip = '211.212.238.210', mb_mailling = '1', mb_sms = '1', mb_open = '1', mb_open_date = '2013-07-19', mb_1 = '', mb_2 = '', mb_3 = '', mb_4 = '', mb_5 = '', mb_6 = '', mb_7 = '', mb_8 = '', mb_9 = '', mb_10 = '', mb_memo = '' , mb_email_certify = '2013-07-19 10:15:41'
1364 : Field 'mb_lost_certify' doesn't have a default value
error file : /bbs/register_form_update.php
이제 이렇게 뜹니다..ㅠㅠ
insert into g4_member set mb_id = 'qweqweqwee', mb_password = '*0B0A8BA0BB47561FA5C1FE726FFDFFC56F3FF585', mb_name = '유넷시스', mb_jumin = '', mb_sex = 'F', mb_birth = '19890705', mb_nick = '유넷시스', mb_nick_date = '2013-07-19', mb_password_q = '', mb_password_a = '', mb_email = '*** 개인정보보호를 위한 이메일주소 노출방지 ***', mb_homepage = '', mb_tel = '', mb_hp = '', mb_zip1 = '', mb_zip2 = '', mb_addr1 = '', mb_addr2 = '', mb_signature = '', mb_profile = '', mb_today_login = '2013-07-19 10:15:41', mb_datetime = '2013-07-19 10:15:41', mb_ip = '211.212.238.210', mb_level = '2', mb_recommend = '', mb_login_ip = '211.212.238.210', mb_mailling = '1', mb_sms = '1', mb_open = '1', mb_open_date = '2013-07-19', mb_1 = '', mb_2 = '', mb_3 = '', mb_4 = '', mb_5 = '', mb_6 = '', mb_7 = '', mb_8 = '', mb_9 = '', mb_10 = '', mb_memo = '' , mb_email_certify = '2013-07-19 10:15:41'
1364 : Field 'mb_lost_certify' doesn't have a default value
error file : /bbs/register_form_update.php
이제 이렇게 뜹니다..ㅠㅠ
mb_memo = '',
mb_lost_certify = '', // 추가 후 확인
.
.
아래 내용도 참고 해 보세요.
http://dryad.kr/bbs/board.php?bo_table=rboard01&wr_id=292
mb_lost_certify = '', // 추가 후 확인
.
.
아래 내용도 참고 해 보세요.
http://dryad.kr/bbs/board.php?bo_table=rboard01&wr_id=292
감사합니다!!!!! 이제 회원가입은 되는데 관리자가 안되네요 ㅠㅠㅠ