Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[bug] FCM 토큰 등록 오류 #208

Closed
yonghwankim-dev opened this issue Feb 8, 2024 · 0 comments · Fixed by #209
Closed

[bug] FCM 토큰 등록 오류 #208

yonghwankim-dev opened this issue Feb 8, 2024 · 0 comments · Fixed by #209
Assignees
Labels
bug Something isn't working

Comments

@yonghwankim-dev
Copy link
Member

yonghwankim-dev commented Feb 8, 2024

상황

FCM 토큰 등록 API가 작동하지 않습니다.
image

원인

배포 서버에 테이블 생성시 FcmToken 테이블 생성시 PK 컬럼에 auto_increment를 설정하지 않았습니다.

해결방법

FcmToken 테이블을 제거하고 auto_increment가 추가된 create table SQL문을 다시 적용합니다.

create table if not exists fineAnts.fcm_token
(
id bigint auto_increment
primary key,
create_at datetime(6) null,
modified_at datetime(6) null,
latest_activation_time datetime(6) null,
token varchar(255) null,
member_id bigint null,
constraint token_member_id_unique
unique (token, member_id),
constraint FKf1rbjf8lle4r2in6ovkcgl0w8
foreign key (member_id) references fineAnts.member (id)
);

@yonghwankim-dev yonghwankim-dev added the bug Something isn't working label Feb 8, 2024
@yonghwankim-dev yonghwankim-dev added this to the [BE] Sprint #17 milestone Feb 8, 2024
@yonghwankim-dev yonghwankim-dev self-assigned this Feb 8, 2024
@yonghwankim-dev yonghwankim-dev linked a pull request Feb 8, 2024 that will close this issue
yonghwankim-dev added a commit that referenced this issue Feb 8, 2024
* #208 fix: FcmToken 테이블 생성 쿼리 오타 수정

* #208 fix: FcmToken 테이블 생성 쿼리 오타 수정
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
Status: Done
Development

Successfully merging a pull request may close this issue.

1 participant