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.

Sign up for GitHub

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

Jump to bottom

Bug : sql injection + 테이블관련 #63

Open

Yoowatney opened this issue Jun 18, 2022 · 0 comments

Assignees

Collaborator

Yoowatney commented Jun 18, 2022 •

edited

Loading

📝 DESCRIPTION

sql injection에 취약한 코드 개선
schema collation과 table의 field collation이 다름

2번 문제로 인해 intraId에 emoji 대입시 서버가 터지네요
schema collation : utf8
table collation : utf8-general-ci
field collation : utf8-general-ci

일단은 DB 변경없이 코드 차원에서 막아두겠습니다

Yoowatney self-assigned this

Yoowatney added a commit that referenced this issue


          🐛 Bug : sql injection, collation 문제#63

a75137e

Yoowatney changed the title ~~Bug : sql injection~~ Bug : sql injection + 테이블관련

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment