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

SQL Error #372

Open
0clickjacking0 opened this issue Aug 5, 2022 · 1 comment
Open

SQL Error #372

0clickjacking0 opened this issue Aug 5, 2022 · 1 comment

Comments

@0clickjacking0
Copy link

What is the version of Jorani?

1.0.0

Expected behavior

Normal import database data

Actual behavior

When using mysql8.0 and 5.7 to import /jorani/sql/jorani.sql, an error occurs

Steps to reproduce the behavior

image

When using mysql8.0 and 5.7 to import /jorani/sql/jorani.sql, an error occurs
image

@autohausnielsen
Copy link
Contributor

I had the same mysql error #1064 (Ubuntu 18.04.6 LTS, mysql 5.7) when I wanted to upgrade Jorani's datatabase to 1.0.0. I solved it with help of #338 (comment)

In file jorani/sql/patch_to_1.0.0.sql:
Line 216 and 220 change INT to UNSIGNED

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

No branches or pull requests

3 participants