jorani icon indicating copy to clipboard operation
jorani copied to clipboard

Published 20 hours ago • verified publisher icon bbalet

SQL Error

Open 0clickjacking0 opened this issue 3 years ago • 1 comments

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

0clickjacking0 avatar Aug 05 '22 03:08 0clickjacking0

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

autohausnielsen avatar Feb 01 '24 09:02 autohausnielsen