Error with v1.2.15 - Githubissues

oliviermaridat / kanboard-sqlite2mysql

Guidelines to migrate a Kanboard SQLite database to a MySQL database

44 stars 11 forks source link

Error with v1.2.15 #24

Open nutzl opened 4 years ago

nutzl commented 4 years ago

Trying to migrate with Version 1.2.15 fails. All Plugins are up to date.

Steps:

(backup)
run kanboard-sqlite2mysql.sh to create db-mysql.sql
create db and import schema app/Schema/Sql/mysql.sq
import db-mysql.sql → fails

Error: ERROR 1054 (42S22) at line 22: Unknown column 'per_swimlane_task_limits' in 'field list'

Migrating directly into newly created database also fails.

minhhieple97 commented 1 year ago

HI i'm using Kanboard v1.2.15 also, I'm migrating kanboard from sqlite to mysql, i have created db-mysql.sql and run command souce db-mysql.sql. But it seem that file db-mysql.sql has not created tables like users, tasks....look like i'm missing schema of all the tables The error shows up like this https://user-images.githubusercontent.com/42188983/193984534-cfbbe2a6-05a0-4cbc-9aa5-869fa74eb28a.png Do you have any suggestion ? Thank you so much ^^