search

bbalet / jorani

Leave and Overtime Management System
http://jorani.org/
GNU Affero General Public License v3.0
384 stars 272 forks source link

SQL Error #372

Open 0clickjacking0 opened 2 years ago

0clickjacking0 commented 2 years ago

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 commented 7 months ago

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 https://github.com/bbalet/jorani/issues/338#issuecomment-929973581

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