I just see Kanboard yesterday and I want to test it for my association, it looks great !
I’ve install it quickly (zip) on Wampserver for testing on my computer. A problem occure when I create a project. I’ve delete all and reinstall this morning but same error :
I can create a subtask but I can’t look and modify it after :
Internal Error: SQL Error: SQLSTATE[HY000]: General error: 1 no such table: main.task_has_subtasks
I just look in the db.sqlite and there’s no table name ‘task_has_subtasks’. This error it’s because of my too quick installation on a “false server” or somebody have the same problem ?
Thanks !
Version de l'application : master.938d62aec70a3f4d76b51d503a84a68711535a28
Version de PHP : 7.2.14
PHP SAPI : apache2handler
Client HTTP : cURL
Version du système d'exploitation : Windows NT 10.0
Type de base de données : sqlite
Version de la base de donnée : 3.20.1
Navigateur web : Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0
Yes, perhaps I don’t take the last version, I’m a beginner with github…
I’ve take the zip from here : https://github.com/kanboard/kanboard → the 7 first characters (master.938d62a) don’t mean the commit ?
Just a bump. I have tried this again today. Deleted the data/db.sqlite and web.config. Uploaded the web.config from your 1.2.18 zip file to redo the db. The db was re-done and I get the error:
Internal Error: SQL Error: SQLSTATE[HY000]: General error: 1 no such table: main.task_has_subtasks
Could you install this via ftp and zip file instead of docker?
You need to create a mysql db with phpmyadmin and then edit the config-default.php file… rename it to config.php.
Then edit the file and look for the mysql entries… insert your db name, db username and db password for that user.
// Database driver: sqlite, mysql or postgres (sqlite by default)
define(‘DB_DRIVER’, ‘mysql’);
I found that in SQLITE the subtask_time_tracking table has a wrong foreign key constraint. The constraints references the no-longer-existing table task_has_subtasks. If I understood it correctly, this was changed to table “subtasks” a while ago.
The contraints can’t be changed, but the table can be cloned with a new contraint:
ALTER TABLE subtask_time_tracking RENAME TO subtask_time_tracking_old;
CREATE TABLE subtask_time_tracking (
"id" INTEGER,
"user_id" INTEGER NOT NULL,
"subtask_id" INTEGER NOT NULL,
"start" INTEGER DEFAULT 0,
"end" INTEGER DEFAULT 0,
"time_spent" REAL DEFAULT 0,
FOREIGN KEY("user_id") REFERENCES "users"("id") ON DELETE CASCADE,
FOREIGN KEY("subtask_id") REFERENCES "subtasks"("id") ON DELETE CASCADE
);
INSERT INTO subtask_time_tracking SELECT * FROM subtask_time_tracking_old;
This worked in my tests and I could then update the subtask status.
I recommend doing backups of the database before playing around with it.
I‘m new to Kanboard, installed v 1.2.20 using it with sqlite (running on a synology nas)
create a task
create 1 or more subtasks in it
get the same error when clicking a subtask or when clicking the done-checkbox or when trying to start the timer
→ Internal Error: SQL Error: SQLSTATE[HY000]: General error: 1 no such table: main.task_has_subtasks
Things I can not reproduce (yet):
for one task I remember to have created several subtasks at once (“add subtask“->enter multiple lines) and strangely they appeared all initially as done in the task-summary view → there I was able to uncheck all the checkboxes without getting the error.
